you can read data row by row and try to add them in parameter of your
sqlCommand
Insert command and then try to execute your command.
you can use a
dataadapter
to connect to your database and then can fill data to dataset and then add new data your dataset. then after that try simply use
yourdataadapter.update().
Reference link:-
Pulling Data from Gridview and Insert to Database[
^]