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();
        }