incorrect syntax asp

Question

0.00/5 (No votes)

See more:

hello programmers, see im new here. I know my syntax is error. here is my code

<pre lang="vb">Dim strSQL As String
        Dim connection As SqlClient.SqlConnection = New SqlClient.SqlConnection("Data Source=ML0003135586;Integrated Security=SSPI;" & "Initial Catalog=TestSQL")
        strSQL = "SELECT * from tblTrainingPlan Where WHERE ([Category] = @Category)"
        connection.Open()
        Dim myCommand As SqlClient.SqlCommand = New SqlClient.SqlCommand(strSQL, connection)
        myCommand.Parameters.AddWithValue("@Category", 1)
        gee.DataSource = myCommand.ExecuteReader()
        gee.DataBind()
        connection.Close()

may error is Incorrect syntax near the keyword 'WHERE'.

thanks

Posted 9-May-11 20:42pm

chaosgray

Add a Solution

6 solutions

Solution 4

Take the multiple "WHERE" clauses out:

strSQL = "SELECT * from tblTrainingPlan Where WHERE ([Category] = @Category)"

becomes

strSQL = "SELECT * from tblTrainingPlan WHERE ([Category] = @Category)"

Posted 9-May-11 20:50pm

OriginalGriff

Comments

[no name] 10-May-11 3:02am

my 5 for this answer

Solution 5

Dim strSQL As String
        Dim connection As SqlClient.SqlConnection = New SqlClient.SqlConnection("Data Source=ML0003135586;Integrated Security=SSPI;" & "Initial Catalog=TestSQL")
        strSQL = "SELECT * from tblTrainingPlan Where WHERE ([Category] = " + "1" + ")"
        connection.Open()
        Dim myCommand As SqlClient.SqlCommand = New SqlClient.SqlCommand(strSQL, connection)
        gee.DataSource = myCommand.ExecuteReader()
        gee.DataBind()
        connection.Close()

Posted 9-May-11 20:50pm

MaulikDusara

Solution 7

Why you use double where in select command....Just delete one

Posted 10-May-11 0:03am

rahul dev123

Solution 2

Change your query like this

strSQL = "SELECT * from tblTrainingPlan Where WHERE [Category] = " + @Category

Posted 9-May-11 20:46pm

nit_singh

Comments

OriginalGriff 10-May-11 3:12am

Reason for my vote of one: Do you really think that would compile?

Solution 3

try to find out in the following way

string   strSQL = "(SELECT * from yourtable  WHERE Category  =" + @Category+ ")";

Posted 9-May-11 20:48pm

Mahendra.p25

Updated 9-May-11 21:40pm

v3

Comments

OriginalGriff 10-May-11 3:13am

Reason for my vote of one: Do you really think that would compile? It's even worse than the one you copied it from!

janwel 10-May-11 3:17am

hehehehe

Mahendra.p25 10-May-11 3:29am

what is the Problem in this Query ? can You please elaborate ...........Mr Original griff.

Mahendra.p25 10-May-11 3:39am

i have tried this and its working Properly
int @k = 25;
string Query = "(Select * from MyTable where Id=" +@k+")" ;
Cmd = new SqlCommand(Query, Con);
dt = new SqlDataAdapter(Cmd);
DataSet ds = new DataSet();
dt.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
Con.Close();

i think I dont need to explain that to you.....

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

janwel · Accepted Answer · 2011-05-09T21:07:00

Solution 6

Your query has double where

strSQL = "SELECT * from tblTrainingPlan  Where WHERE [Category] = "'+@Category+'""

i thinks that is the error since the says syntax on Error

Posted 9-May-11 21:07pm

janwel

Comments

chaosgray 10-May-11 3:09am

thank you sir