write dataset to sql table using asp.net

Question

I've successfully imported a tab-delimited file into a dataset in asp.net (C#). I can bind the dataset to a gridview, and see my data (that part works fine).

Now I want to insert that dataset table (the only table in the dataset) into a sql table using an INSERT command - I don't know enough about datasets to figure it out.

Make an attempt at the issue! Start by reading the DataSet documentation. — mason
– mason, Commented Oct 14, 2015 at 17:17

Community · Accepted Answer · 2017-05-23 12:14:33Z

0

Actually you won't use the INSERT command, to insert a new table you're going to need this query:

string query = "CREATE TABLE myTable (column1 INT, column2 NVARCHAR(10))";

Source: Creating Databases and tables using c#

Where 'column1' is your column's name and INT the type. You can see more about the types here: http://www.w3schools.com/sql/sql_datatypes_general.asp and you can also see more SQL commands here: http://www.w3schools.com/sql/sql_syntax.asp

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Oct 14, 2015 at 17:32

Thadeu Fernandes

5051 gold badge7 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

write dataset to sql table using asp.net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related