SqlConnection con=new SqlConnection("server=servername;integrated security=true;database=databasename");
string[]Values=txtname.Text.Split(',');
SqlCommand cmd;
for(int i=0;i<values.length;i++)>
{
cmd=new SqlCommand("Insert into employee(Name) Values(@Name)",con);
cmd.Parameters.Add("@Name",SqlDbType.Varchar(30)).Value=Values[i];
if(con.State==ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
cmd.Dispose();
}
regards
Sajid Ahmed Shahsroha