How to insert data table to database

Question

How to insert datatable values into sql. please help me

Sam Hobbs · Answer

There are many ways to do it. I recommend using the Entity Framework. Another option is using a TableAdapter. Another option is to use the SqlDataAdapter class directly. Or you can create a SqlCommand and issue it using the SqlCommand.ExecuteNonQuery Method. So it will be beneficial to look at the articles in this web site.

Naeem Khan · Answer

hello sajid for insert data table into Database.. create table table_name ( column1 datatype column2 datatype ......... ) // for inserting data into table INSERT INTO table_name VALUES (value1 value2 value3...) reagds Naeem Khan