>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?
>
>
Without Parameters statement it would not work. Your values @xyz and @abc mean nothing.