>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?"Insert into bob (xyz, abc) VALUES ( @xyz, @abc )";
when @xyz and @abc aren't defined as anything?!?!?sc.Parameters.Clear(); sc.Parameters.Add("@xyz", Row["xyz"]); sc.Parameters.Add("@abc", Row["abc"]);~~Bonnie