SqlBulkCopy Tutorial - Knowledge Base (KB)

How to add gridview rows to a datatable?

I have a gridview which will contain some 'n' number of rows.... Now i want to add all rows of the gridview to a datatable which will be used for bulkcopy operation......I have found this ...http://www.codeproject.com/KB/aspnet/GridView_To_DataTable.aspx...

sqlBulkCopy: The given value of type String from the data source cannot be converted to type int of the specified target column

I am trying to store values from grid rows to data column and then using the sqlBulkCopy to insert the data into my database....My gridview design sets as per following:... <asp:GridView ID="gvDCR" runat="server" Width="100%" AutoGenerateColumns="false...