txt文本导入到sql server数据库

protected void Button1_Click(object sender, EventArgs e)
        {
           StreamReader sr = new StreamReader(new FileStream(@"D:\test.txt", FileMode.Open, FileAccess.Read), System.Text.Encoding.Default);
            SqlConnection sqlcon = new SqlConnection("server=.;database=TM_pos;uid=sa;pwd=123");
            string sql = "insert into PFormula(product_id,p_name,material,number) values(@product_id,@p_name,@material,@number)";
            string strTemp = sr.ReadLine();
            while (strTemp != null)
            {
                string[] strArrTemp = strTemp.Split(',');　　　　//以逗号为分隔符

                SqlCommand sqlcmd = new SqlCommand(sql, sqlcon);
                sqlcmd.Parameters.Add("@product_id", SqlDbType.VarChar).Value = strArrTemp[0];
                sqlcmd.Parameters.Add("@p_name", SqlDbType.VarChar).Value = strArrTemp[1];
                sqlcmd.Parameters.Add("@material", SqlDbType.VarChar).Value = strArrTemp[2];
                sqlcmd.Parameters.Add("@number", SqlDbType.VarChar).Value = strArrTemp[3];
                sqlcon.Open();
                try
                {
                    sqlcmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {

                }
                sqlcon.Close();
                strTemp = sr.ReadLine();
            }
            sr.Close();

            MessageBox.Show("导入数据库成功！！！", "友情提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

        }