How To Push A Dataset Into The DB?

Dear all,,

I used a code that import data from an excel file into a dataset,

 now I want to insert the dataset into a table in my database(SQLserver database) using a VB.NET code

Could you help me?

Thanks in advance,,

Here is my code:

Imports System.Data.OleDbPartial Class _DefaultInherits System.Web.UI.Page

 

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.ClickDim connString As String = ConfigurationManager.ConnectionStrings("xls").ConnectionString

' Create the connection object Dim oledbConn As OleDbConnection = New OleDbConnection(connString)

Try

' Open connection

oledbConn.Open()

' Create OleDbCommand object and select data from worksheet Sheet1Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn)

' Create new OleDbDataAdapter Dim oleda As OleDbDataAdapter = New OleDbDataAdapter()

oleda.SelectCommand = cmd

' Create a DataSet which will hold the data extracted from the worksheet.Dim ds As Data.DataSet = New Data.DataSet()

' Fill the DataSet from the data extracted from the worksheet.oleda.Fill(ds, "Sheet1")

' Bind the data to the GridView

GridView1.DataSource = ds.Tables(0).DefaultView

GridView1.DataBind()

Catch

Finally

' Close connection

oledbConn.Close()

End TryEnd Sub

End Class