/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

3 votes170 views1 answer
Pl sql check if variable is empty
SQL
0 vote206 views2 answers
Insert data mysql with cmd
SQL
0 vote269 views1 answer
Delet all record statment sql
SQL
0 vote166 views2 answers
Influxdb delete measurement based on date
SQL
0 vote198 views1 answer
Compression of dabatase mysqldumo
SQL
3 votes185 views2 answers
Truncate all tables
SQL
6 votes199 views2 answers
Foreign key sqlite3 python
SQL
3 votes260 views6 answers
Jwt laravel
SQL
0 vote282 views3 answers
CONTACT FORM SQL
SQL
4 votes196 views4 answers
Check constraint in ms sql
SQL