Can someone tell me what i'm doing wrong

[MarcusCarcus]

I'm trying to get this coding to work, I'm new to c# and programming, but I can't seem to get much further than this and this code will not build.

SqlParameter wellName = new SqlParameter("@wellName", SqlDbType.NVarChar, 50, "wellName").Value = Convert.ToString(cmbWellName);

 

[TipGiver]

Try this:
(i dint try it)

SqlParameter wellName = new SqlParameter("@wellName", SqlDbType.NVarChar, 50, "wellName")

wellName.Value() = Convert.ToString(cmbWellName);

 

[jmeckley]

parameter.Value = someValue; is a void method [_SetValue(object value) or something like this in the IL]. there for you cannot declare the variable and set the value in the same instruction.
TipGiver's code will work because your first declaring the variable and then setting the value.



Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[AlexCuse]

If you already have a command, and don't need to use this parameter elsewhere, you can also use

myCommand.Parameters.Add("@wellName", SqlDbType.NVarChar, 50, "wellName").Value = Convert.ToString(cmbWellName);

I've never used the overload with the "source column" parameter but I don't see why it wouldn't work with that in there.

Hope this helps,

Alex

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[shaddow]

You should use it like this

SqlParameter wellName = new SqlParameter("@wellName", SqlDbType.NVarChar, 50, ParameterDirection.Input, true, 0, 0, "wellName", DataRowVersion.Current, cmbWellName.Value);

________
George, M
Searches(faq333-4906),Carts(faq333-4911)