net制作超简单浏览器代码 »

« 只允许上一个网，禁止QQ和其他网络视频

 txt导入SQL

 

1. private void ImportDataCsv_Txt(string lineReceive)//导入csv，txt 格式
2.         {
3.             string[] strData = lineReceive.Split(' ');
4.             if (strData.Length == 6)
5.             {
6.                 string strProc = "sxau_importdata";
7.                 string conn = DBUtility.SqlHelper.connString;
8.                 CommandType comType = CommandType.StoredProcedure;
9.                 SqlParameter[] paras = {
10.                                                new SqlParameter("@dat",SqlDbType.VarChar,50),
11.                                                new SqlParameter("@tim",SqlDbType.VarChar,50),
12.                                                new SqlParameter("@tem",SqlDbType.VarChar,50),
13.                                                new SqlParameter("@hum",SqlDbType.VarChar,50),
14.                                                new SqlParameter("@sun",SqlDbType.VarChar,50),
15.                                                new SqlParameter("@num",SqlDbType.VarChar,50)};
16.                                                
17.                 paras[0].Value = strData[0];
18.                 paras[1].Value = strData[1];
19.                 paras[2].Value = strData[2];
20.                 paras[3].Value = strData[3];
21.                 paras[4].Value = strData[4];
22.                 paras[5].Value = strData[5];
23.                 int val = DBUtility.SqlHelper.ExecuteNonQuery(conn, comType, strProc, paras);
24.                 if (val == 1)
25.                 {
26.                     //MessageBox.Show("导入成功","提示",MessageBoxButtons.OK,MessageBoxIcon.None);
27.  
28.                     tbLook.Text = "";
29.                     LoadData();
30.                    
31.                 }
32.             }
33.         }