Click here to Skip to main content
15,908,841 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all

I have a dbase.txt file with some data in it. i.e -

Institution Course StudentID
XZY ABC 2010-1111111 "the spaces between columns is one tab space"
XYZ ABC 2010-1222222
XYZ ABC 2010-1333333

I want to perform simple SQL like operation - i.e -

SELECT * FROM dbase.txt or
SELECT Institution FROM dbase.txt WHERE StudentID=2010-1111111 and an insert operation like -
INSERT dbase.txt VALUES(XYZ ABC 2010-1444444)

I have written some code which is not even closer to what I mentioned above. My program can read only the whole text file. There is a menu, but not functioning well, as well as my write function which is not working at all.

So, can anyone help me with this problem. Any link to any web site would also be helpful. Below is my code -

Thanks in advance.
Posted

Well, you know, developing a database engine is a daunting task...
:)
 
Share this answer
 
First, you're going to have to load the data into a list. At that point, you can use Linq to perform sql-like queries on the list.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900