command parameters in one statement

  • Thread starter Thread starter tshad
  • Start date Start date
T

tshad

Is there a way to the following in one statement?

parameter = new SqlParameter("@" + "SortOrder",
SqlDbType.TinyInt);
parameter.Value = Convert.ToInt32(tf.SectionNumber);
cmd.Parameters.Add(parameter);

If the parameter is a string I can just do:

cmd.Parameters.Add(new SqlParameter("@FormName",
formName));

Thanks,

Tom
 
cmd.Parameters.Add("@"+ SortOrder, SqlDbtype.TinyInt).Value =
Convert.toIn32(tf.SectionNumber);
 
tshad said:
Is there a way to the following in one statement?

parameter = new SqlParameter("@" + "SortOrder",
SqlDbType.TinyInt);
parameter.Value = Convert.ToInt32(tf.SectionNumber);
cmd.Parameters.Add(parameter);

If the parameter is a string I can just do:

cmd.Parameters.Add(new SqlParameter("@FormName",
formName));
Click to expand...

You can do that for integer types as well.

But I will recommend you to also specify type even
if set value immediately.

Arne
 
Is there a way to the following in one statement?

                    parameter = new SqlParameter("@" + "SortOrder",
SqlDbType.TinyInt);
                    parameter.Value = Convert.ToInt32(tf.SectionNumber);
                    cmd.Parameters.Add(parameter);

If the parameter is a string I can just do:

                    cmd.Parameters.Add(new SqlParameter("@FormName",
formName));

Thanks,

Tom
Click to expand...

I will do this:

string userName = txtUserName.Text.Trim().ToLower();
mySqlCommand.Parameters.AddWithValue("@userName", userName);

HTH.
 
Mel Weaver said:
cmd.Parameters.Add("@"+ SortOrder, SqlDbtype.TinyInt).Value =
Convert.toIn32(tf.SectionNumber);
Click to expand...
That looks like what I was looking for.

Thanks,

Tom
 
Back
Top