mssql导入mysql中文乱码_mssqlserver导入到数据库中插入文字乱码问题解决方法

private void btninsert_Click(object sender, EventArgs e)

{

if (odimport.ShowDialog() == DialogResult.OK)//准备接收文件；

{

using (FileStream filestream = File.OpenRead(odimport.FileName))

{

using (StreamReader streamreader = new StreamReader(filestream))

{

//创建连接字符串及建立通道；

string connstr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

using (SqlConnection conn = new SqlConnection(connstr))

{

conn.Open();

using (SqlCommand cmd = conn.CreateCommand())

{

cmd.CommandText = "insert into Phonenumber(Phone,LocalID,LocalAddress,Phonestyle) values(@Phone,@LocalID,@LocalAddress,@Phonestyle)";

string line = null;

while ((line = streamreader.ReadLine()) != null)

{

//转化每一行数据为数组并用split分割字符串，获取个字段信息；

string[] strs = line.Split(' ');

string Phone = strs[0];

int LocalID = Convert.ToInt32(strs[1]);

string LocalAddress = strs[2];

string Phonestyle = strs[3];

cmd.Parameters.Clear();

cmd.Parameters.Add(new SqlParameter("Phone", Phone));

cmd.Parameters.Add(new SqlParameter("LocalID", LocalID));

cmd.Parameters.Add(new SqlParameter("LocalAddress", LocalAddress));

cmd.Parameters.Add(new SqlParameter("Phonestyle", Phonestyle));

cmd.ExecuteNonQuery();

}

}

}

}

}

MessageBox.Show("导入成功");

}