storing text files to data base

Hi @suresh-reddy40,

you want to read data from notepad to table structure database. in this case, you must  have all notepad file in common format. can you provide me notepad file?

That's great.

 

There is no magical solution as the pattern is not guaranteed to be the same.

 

You will need to read the text file line by line (in C# code) and have it parsed logically, for example, if the line starts with ----, then ignore it because you know you don't want anything from that line. But that line also tells you that next section is now starting. Again, if it contains a string '(TOTAL)' that means your previous section is over and new section will start. 

 

You will need boolean variables line  inAddress, inItem, etc, which will keep track where you currently are. As soon as --- is found, you know that that section is over, so you can stored parsed information in a list or something like that. 

 

Hope you already know reading from text file and string functios like, IndexOf, Substring, etc. 

 

Hope you get the point. If not, please do let me know.