Hi ,
Check this
string RValue = "1233,frrrr,rrrryy";
string[] VExist = RValue.Split(',');
foreach (string item in VExist)
{
using (
SqlConnection con =
new SqlConnection(""))
{
using (SqlCommand cmd = new SqlCommand("usp_test", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tst", VExist[0]);
cmd.Parameters.AddWithValue("@tst2", VExist[1]);
cmd.Parameters.AddWithValue("@tst2", VExist[2]);
cmd.ExecuteNonQuery();
}
}
}
Best Regards
M.Mitwalli