کد به این شکله :
SqlConnection con = new SqlConnection();
con.ConnectionString = "server=(local);uid=sa;pwd=123456;database=mai n";
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandText = "delete from table1";
con.Open();
com.ExecuteNonQuery();
con.Close();
com.Parameters.Add("@name", SqlDbType.NVarChar, 50);
com.Parameters.Add("@family", SqlDbType.NVarChar, 50);
com.Parameters.Add("@num", SqlDbType.Char, 20);
using (StreamReader reader = File.OpenText(@"c:\test.txt"))
{
while ((line = reader.ReadLine()) != null)
{
string[] Split = line.Split(new Char[] { ';' });
com.Parameters["@name"].Value = Convert.ToString(Split[0]);
com.Parameters["@family"].Value = Convert.ToString(Split[1]);
com.Parameters["@num"].Value = Convert.ToString(Split[2]);
com.CommandText = "insert into table1(name,family,num) values(@name,@family,@num)";
con.Open();
com.ExecuteNonQuery();
con.Close();
}