Hi all
I have to upload a csv file, perform some validations (No of coloumn must be 8, if any cell in Coloumn 2 contains a text "Answer" it must be followed by a "Question" above in same coloum) and then insert the values into database as following
1. worksheet name should be inserted into "tblSection" table database.
2. The rows those contain text "Question" in 2nd coloumn of CSV file will goes into "tblQuestion" table.
3. The rows those contains text "Answer" in 2nd Coloumn should be inserted into "tblAnswer" table of db. Please help me in this problem. It would be better if you direct me to sample code (in C# or VB.net).
...
Go to the complete details ...