Read Tab Delimited Txt And Insert Database(SQL)

Question

C#.net Web Applications:
i have text file like this.

Employees.txt

Name: Prakash Age: 23
Post: Engineer Exp: NO

Name: Chirag Age: 26
Post: Doctor Exp: NO

And So On....

here i need to get the values and store into database .
sqltable is like this

id      Name          Age     Post Exp
1      Prakash        23         Engineer NO
2      Chirag 26         Doctor NO

Searching for solution since too long but everywhere i got disappointed so please help me out from this please...

Thank You

Jignesh Trivedi · Answer

hi In the case file format remain same but file also contain some junk character then you can use string.startWith method to identify whether the line is valid of not if (line.StartsWith(Name:)) { // code here }

chiraag metaliya · Answer

Hi sir; It's not like that but file format will be the same as shown above but superwiser mean to say that file can contain some of unusual line so you'l have to neglect those line so just wants logic for that sir.. thank you sir.

Jignesh Trivedi · Answer

hi i think you cannot write dynamic program that support all type format that you think. I means to file format may vary from mind to mind so it is very difficult to write program that support all file format. how can we identify which type of file is imported by use?

chiraag metaliya · Answer

suppose my text format is like.. chirag ch@gmail.com 12wd prakash fhg@yahoo.com fdfe nikhil dfr@gmail.com we34e then i know the way to insert data into database but aint used stream reader and read file by readAllLine but my superviser says that what if... chirag ch@gmail.com 12wd prakash fhg@yahoo.com fdfe ------------------------ sdsjd dfr@gmail.com we34e then does your code work??? i said simply NO. So now i just wants to change my answer from NO to Yes.

Jaganathan Bantheswaran · Answer

Hi I tried something to help you.... It wont work perfectly if the text file format changes. DataTable table = new DataTable(); table.Columns.Add(Name); table.Columns.Add(Post); table.Columns.Add(Age); table.Columns.Add(Exp); var lines = File.ReadAllLines(FilePathHere).ToList(); int i = 0; var sb = new StringBuilder(); foreach (var line in lines) { if (i != 0 && i % 2 == 0) { var sbStr = sb.ToString(); var r = table.NewRow(); var columns = sbStr.Split((char)9); foreach (var values in columns.Select(column => column.Split(':'))) { if (values.Length > 1) { r[values.First()] = values.Last(); } } table.Rows.Add(r); i = 0; } else { if (!string.IsNullOrEmpty(line)) { sb.Append((char) 9); sb.Append(line); } } i++; } You will get the table with four columns with values.

Jignesh Trivedi · Answer

hi try... public class EmpData { public string Name { get; set; } public string Age { get; set; } public string Post { get; set; } public string Exp { get; set; } } static void Main(string[] args) { string filefullPath = @E:	est.txt; string[] lines = System.IO.File.ReadAllLines(filefullPath); bool isFirstLine = true; List data = new List (); for (int l = 0; l { data.Add(new EmpData()); } int i = 0; foreach (string line in lines) { if (isFirstLine) { string[] internalData = line.Split(new string[] { Age: } StringSplitOptions.None); data[i].Name = internalData[0].Replace(Name: ).Trim(); data[i].Age = internalData[1].Trim(); isFirstLine = false; } else { string[] internalData = line.Split(new string[] { Exp: } StringSplitOptions.None); data[i].Post = internalData[0].Replace(Post: ).Trim(); data[i].Exp = internalData[1].Trim(); isFirstLine = true; i = i + 1; } } foreach (var d in data) { // write here insert opration Console.WriteLine(d.Name + 	 + d.Age + 	 + d.Post + 	 + d.Exp); } } hope this will help you.

chiraag metaliya · Answer

It's not possible to change format of my text file because it contains thounsands of line that's why i need the logic. thanks for your opiniona nd effort sir :)

Jaganathan Bantheswaran · Answer

I suggest you to save data in the text file in your format like id Name Age Post Exp 1 Prakash 23 Engineer NO 2 Chirag 26 Doctor NO Then it will be easy to parse the text file.