Ok, I see.
But could you not just do:
sc.CommandText = "Insert into bob (xyz, abc) VALUES ( '" + sValue1 + "','" + sValue2 + "' )";
sc.ExecuteNonQuery();
once for each new row in the DS?
>
>Now I'm confused.
>>
>>You have:
>
>>>sc.CommandText = "Insert into bob (xyz, abc) VALUES ( @xyz, @abc )";
>>sc.Parameters.Clear();
>>sc.Parameters.Add("@xyz", Row["xyz"]);
>>sc.Parameters.Add("@abc", Row["abc"]);
>>sc.ExecuteNonQuery();
>>
>>You could just as easily do:
>>>sc.CommandText = "Insert into bob (xyz, abc) VALUES ( @xyz, @abc )";
>>sc.ExecuteNonQuery();
>
>
>>So what do the parameters do?>
>
>
>Think about what you just wrote Kevin. What good is
>
>"Insert into bob (xyz, abc) VALUES ( @xyz, @abc )";
>
>
>when @xyz and @abc aren't defined as anything?!?!?
>
>That's what this does, defines and adds the parameters to the Command object:
>
>
>sc.Parameters.Clear();
>sc.Parameters.Add("@xyz", Row["xyz"]);
>sc.Parameters.Add("@abc", Row["abc"]);
>>
>~~Bonnie
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
