Want to update @parameter in select

[Mike]

I have a dataadapter that has "where field_name = @parameter". I need to
replace the @parameter and then call fillschema and then fill. I've looked
too long in the help files and haven't been able to find the code.

[Mike]

Found it. I was using ( instead of [. Darn I hate when I'm scanning the
code and I am reading the VB and not the C#.

sqlDataAdapter1.SelectCommand.Parameters["@tracking_cd"].Value = myKey;

"Mike" <md*****@nospambennettcompany.com> wrote in message
news:OC*************@tk2msftngp13.phx.gbl...

I have a dataadapter that has "where field_name = @parameter". I need to
replace the @parameter and then call fillschema and then fill. I've looked too long in the help files and haven't been able to find the code.

[William Ryan eMVP]

Hi Mike:

I'm not sure I understand the problem for sure but I'll take a stab. To set
the value of @parameter you need to reference it in the command's paramaters
collection (assuming it's been added, if not, you'll need to add it)

myCommand.Parameters.Add("@parameter", SqlDbType.Varchar, 50).Value =
"Whatever";

//I'm assuming this is SQL Server b/c the @ symbol, but the same logic holds
for other providers. Moreover, there are multiple constructors for adding
params, you don't necessarily need to use this one.

If it's already added, all you need to do is
myCommand.Parameters("@parameter").Value = "whatever";

If this isn't what you need, can you tell me a little more about the end
game and hopefully I can be of more help.

Cheers,

Bill
"Mike" <md*****@nospambennettcompany.com> wrote in message
news:OC*************@tk2msftngp13.phx.gbl...

I have a dataadapter that has "where field_name = @parameter". I need to
replace the @parameter and then call fillschema and then fill. I've looked too long in the help files and haven't been able to find the code.