>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
