C sharp project including source code
Develop a c# class to handle csv (; delimited with carriage return) based databases:
Derive new class CsvDataTable from System.Data.DataTable.
OPEN(string SqlString)
Add method [login to view URL](string SqlString)
(SqlString) is an object of [login to view URL]
SqlString could adress one or more csv lists like:
SqlString = “SELECT * FROM c:\directory\[login to view URL]”
Or for more than one csv list:
SqlString = “SELECT * FROM c:\directory\[login to view URL] AS TB1 INNER JOIN c:\directory\[login to view URL] AS TB2 ON TB2.Index=[login to view URL] WHERE Information=?;"
After invoking DataTableFromCsv should contain the .NET DataTable data including column information.
STORE()
Add method [login to view URL]()
Store all new data in DataTable to appropiate csv lists. Because storing could take some time it has to work in asynchonous own thread.
DISPOSE()
Add method [login to view URL] for storing and releasing.
Test
CsvDataTable cdt = new CsvDataTable();
[login to view URL](“SELECT * FROM c:\directory\[login to view URL] AS TB1 INNER JOIN c:\directory\[login to view URL] AS TB2 ON TB2.Index=[login to view URL] WHERE Information=?;");
Then want I to modify some data like:
[login to view URL](3)(4)=¨XXX¨;
[login to view URL](5)(2)=¨YYY¨;
//Finally I want to store the whole table to c:\directory\[login to view URL] and/or c:\directory\[login to view URL] .
[login to view URL]();