/SQL/Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+

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));

Similar codes

0 vote367 views1 answer
Carbon mysql d m y to y-m-d
SQL
13 votes315 views2 answers
Sqlite rename column
SQL
3 votes353 views1 answer
Sql add two values together
SQL
0 vote341 views1 answer
Replace content value from old to new sql
SQL
0 vote328 views1 answer
Insert thai language sql server
SQL
3 votes331 views1 answer
Oracle revoke
SQL
1 vote259 views1 answer
Convert money to varchar sql server
SQL
11 votes345 views1 answer
Sql query to find duplicates in column
SQL
0 vote325 views1 answer
Add SuperUser MySQL
SQL
0 vote385 views1 answer
Drop a view in sqlite
SQL