whenever i'm passing data from datatable to sql table for large number in table it is storing with e+ code example

Example 1: whenever i'm passing data from datatable to sql table for large number in table it is storing with e+

change the datatype for every column of datatable and on sql side by using 
convert or cast function you can change it to another type
DataTable dt = new DataTable();
dt.columns.Add(1, typeof(string));
dt.columns.Add(2, typeof(string));

Example 2: whenever i'm passing data from datatable to sql table for large number in table it is storing with e+

change the datatype for every column of datatable and on sql side by using 
convert or cast function you can change it to another type
DataTable dt = new DataTable();
dt.columns.Add(1, typeof(string));
dt.columns.Add(2, typeof(string));

Tags:

Misc Example