private void btnBROWSE_Click(object sender, System.EventArgs e) { txtFilePath.Text = ""; this.lvVBRKP.Items.Clear(); if (openFileDialog.ShowDialog() == DialogResult.OK) txtFilePath.Text = openFileDialog.FileName; if (txtFilePath.Text == "") { MessageBox.Show("Please Choose Your Upload File First!"); return; } else AssignToArray(); } private void AssignToArray() { ArrayList arrFileData = new ArrayList(); ArrayList arrInv = new ArrayList(); string[] arrLine = null; SqlCommand Comm = new SqlCommand(); lvVBRKP.Items.Clear(); StreamReader srData = File.OpenText(txtFilePath.Text.ToString()); while (srData.Peek() != -1) arrFileData.Add(srData.ReadLine()); srData.Close(); int intIndex=0; clsGlobalVar.objSQLAccess.ExecSQL("DELETE from tmpSINF "); while (intIndex < arrFileData.Count) { try { arrLine = Convert.ToString(arrFileData[intIndex++].ToString()).Split(new char[] { '\t' }); if (arrLine[0].Equals("Shipment(delivery)#") || arrLine[5].Equals("Ship quantity")) continue; lvVBRKP.Items.Add((intIndex - 1).ToString()); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[0]); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[1]); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[2]); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[3]); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[4]); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[5]); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[6]); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[7]); lvVBRKP.Items[(intIndex - 2)].SubItems.Add(arrLine[8]); string strSQL = "insert into tmpsinf(SHPNUM,ORDNUM,ITMNUM,CLIMAT,QCIMAT,SHPQTY,INVNUM,SHPCOO,ADDRES) values('" + arrLine[0] + "','" + arrLine[1] + "','" + arrLine[2] + "','" + arrLine[3] + "','" + arrLine[4] + "'," + arrLine[5] + ",'" + arrLine[6] + "','" + arrLine[7] + "','" + arrLine[8] + "')"; clsGlobalVar.objSQLAccess.ExecSQL(strSQL); arrInv.Add(arrLine[1]); } catch (Exception ex) { MessageBox.Show("File format error!!"); lvVBRKP.Clear(); return; } } GC.Collect(); }
c# 读取txt文本内容
精选 翻译下一篇:我的友情链接
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
C# 读取Word文档中的文本内容
这篇文章将介绍如何使用C#读取Word文档中的全部或指定段落的文本内容
C# word 读取文本内容 Word 加载 -
C#读取EXCEL
C#读取EXCEL
C#读取EXCEL -
读取多个CheckBox控件选中的Text文本
读取多个CheckBox控件选中的Text文本
读取 多个 CheckBox 控件