Replied 8 September 2017, 1:30 pm EST
I have though solved this problem for the moment.
I have done the same asa you have shown me.
the only difference was that i had a spread in which i had designed the columns.
So i had to databind the columns individually.
I would like to add for other people here who are using LINQ or are going to use LINQ as long as you are including all the columns from the table that you are
inserting data there is no problem.But if you don't include all the columns from the table(things which can be null or are populated from other tables) and try to insert the data then it is going to give the users a problem