what is the problem with this?

[m.a]

Hello,

I am newbie and I am following this tutorial:

http://www.asp.net/learn/data-access...ial-01-cs.aspx

I am using MSVC 2008 and Access database.

I have my own database which is very similar to the database which is used
in this tutorial.

everything seems to be working till I am getting to step 3: Adding
Parameterized Methods to the Data Access Layer.

I cannot create an sql with parameterized data. my sql is as follow:

SELECT ID_Item, Title, [Desc], [image], User_ID
FROM Items
WHERE User_ID = @User_ID

but the system cannot detect that I used a parameter for where clause. it
complains that it can parse code after @ sign.

What is the problem and How can I fix it?

Best regards

[rhaazy]

On Aug 1, 12:28*pm, "m.a" <[e-mail]:

Hello,

* I am newbie and I am following this tutorial:

http://www.asp.net/learn/data-access...ial-01-cs.aspx

I am using MSVC 2008 and Access database.

I have my own database which is very similar to the database which is used
in this tutorial.

everything seems to be working till I am getting to step 3: Adding
Parameterized Methods to the Data Access Layer.

I cannot create an sql with parameterized data. my sql is as follow:

SELECT * * ID_Item, Title, [Desc], [image], User_ID
FROM * * * * Items
WHERE * * User_ID = @User_ID

but the system cannot detect that I used a parameter for where clause. it
complains that it can parse code after @ sign.

What is the problem and How can I fix it?

Best regards

You need code to tell it what to replace the parameter with. For
example in C#:
SqlConnection con = GetConnection();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 500;
cmd.CommandText = "SELECT something FROM somewhere WHERE something =
@yourParam";
cmd.CommandText = cmd.CommandText.Replace("@yourParam", actualValue);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);