/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

6 votes169 views2 answers
Difference between join vs union
SQL
36 votes166 views3 answers
Add column in mysq
SQL
0 vote143 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
29 votes149 views6 answers
Delete all rows from table mysql
SQL
5 votes139 views2 answers
Sql conn
SQL
0 vote164 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote155 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote158 views1 answer
Mysql check if lowercase
SQL
0 vote147 views1 answer
Select in select sql
SQL
0 vote119 views1 answer
Sql table to store status
SQL