C # Insert Database

 private void Button1_Click (object sender, EventArgs e) {OpenFileDialog ofd = new OpenFileDialog (); Ofd.            Filter = "text file |*.txt"; if (OFD.            ShowDialog ()!=dialogresult.ok) {return; } string filename = Ofd.            FileName;            Ienumerable<string> lines = File.readlines (Filename,encoding.default); String[] lines = File.readlines (Filename,encoding.default).            ToArray ();            DateTime starttime = DateTime.Now;            DataTable table = new DataTable (); Table.            Columns.Add ("Start"); Table.            Columns.Add ("Telarea"); Table.            Columns.Add ("Teltype"); Table.            Columns.Add ("Areanum"); for (int i = 1; i < lines. Length; i++) {//string line = lines.                ElementAt (i);                String Line=lines[i]; string[] Segs = line.                Split (' \ t ');                String Starttelnum=segs[0]; String Telarea= Segs[1];                Telarea = Telarea.trim (' "');                String teltype = Segs[2];                Teltype = Teltype.trim (' "');                String areanum = Segs[3];                Areanum = Areanum.trim (' "'); DataRow row = table.                NewRow ();                row["Start"]=starttelnum;                row["Telarea"]=telarea;                row["Teltype"]=teltype;                row["Areanum"] = Areanum; Table.            Rows.Add (row); } using (SqlBulkCopy bulkcopy=new SqlBulkCopy (connstr)) {bulkcopy.                DestinationTableName = "Telnum"; BulkCopy.                Columnmappings.add ("Start", "Starttelnum"); BulkCopy.                Columnmappings.add ("Telarea", "Telarea"); BulkCopy.                Columnmappings.add ("Teltype", "Teltype"); BulkCopy.                Columnmappings.add ("Areanum", "Areanum"); BulkCopy.            WriteToServer (table);            } TimeSpan time = Datetime.now-starttime; MeSsagebox.show (time.            ToString ()); using (SqlConnection conn = new SqlConnection (CONNSTR))//{//for (int i = 1; i < lines. Count (); i++)//{//String line = lines.            ElementAt (i);            String Line=lines[i]; string[] Segs = line.            Split (' \ t ');            String starttelnum = Segs[0];            String telarea = Segs[1];            Telarea = Telarea.trim (' "');            String teltype = Segs[2];            Teltype = Teltype.trim (' "');            String areanum = Segs[3];            Areanum = Areanum.trim (' "'); using (SqlCommand cmd=conn. CreateCommand ())///{//cmd.            CommandText = "INSERT into Telnum (starttelnum,telarea,teltype,areanum) VALUES (@s,@a,@t,@u)"; Cmd.            Parameters.Add (New SqlParameter ("@s", Starttelnum));   //         Cmd.            Parameters.Add (New SqlParameter ("@a", Telarea)); Cmd.            Parameters.Add (New SqlParameter ("@t", Teltype)); Cmd.            Parameters.Add (New SqlParameter ("@u", Areanum)); Cmd.            ExecuteNonQuery (); }////sqlhelper.executenonquery ("INSERT into Telnum (starttelnum,telarea,teltype,areanum) Valu ES (@s,@a,@t,@u) ", New SqlParameter (" @s ", Starttelnum), New SqlParameter (" @a ", Telarea), New SqlParameter (" @t ", Teltype)            , New SqlParameter ("@u", Areanum)); }//}//foreach (string line in lines)//{//string[] Segs = line.            Split (' \ t ');            String Starttelnum=segs[0];            String telarea=segs[1];            String teltype=segs[2];            String areanum=segs[3]; Sqlhelper.executenonquery ("INSERT into Telnum (starttelnum,telarea,teltype,areanum) VALUES (@s,@a,@t,@u)", New SqlparameteR ("@s", Starttelnum), New SqlParameter ("@a", Telarea), New SqlParameter ("@t", Teltype), New SqlParameter ("@u", Areanum))            ; }//messagebox.show ("inserted altogether" +lines.        Count () + "bar data"); }

C # Insert Database