how to insert data from dataset into database

Expand Post »

Hi,

I have a requirement to insert data from dataset into a table in the database. Actually i have records in the excel sheet that has to be inserted into the database. I have populated them in a dataset. Now this dataset has to be validated against some conditions. After accepting the changes in the dataset . This table in the database has no records. Records in the dataset have to be inserted to that table. i dont know how to insert all the records in the dataset at one go... Please advice.

Thanks

Similar Threads

How to insert data into database? in JSP
a blank form to insert data???? in Visual Basic 4 / 5 / 6
How to insert data into a db in Java
Extracting data from large SINGLE-table database to MULT-table relational database in MySQL
Insert Data in to Db from the Dynamic Rows in HTML and CSS

unknownunknown

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2007

Permalink

Feb 26th, 2007

Re: how to insert data from dataset into database

Hello there: I have used this code in my application and it works. It is about populating the database with the information within a present form

(Toggle Plain Text)

 
Dim a As String = Me.ComboBox1.SelectedItem
Dim b As Integer = Me.txtDeel1.Text
Dim c As Integer = Me.txtDeel2.Text
Try
selectStr = "SELECT TbStukIDRegCD,TbStukIDDeel1,TbStukIDDeel2,TbStukCodeAanbieder," + _
"TbStukTijdInschrijving, TbStukCodeRectificatie, TbStukDatumVerlijden,TbStukAardStuk,TbStukDatumDoorhalingStuk," + _
"TbStukIndGeheelVerwerkt,TbStukReferentie,TbStukBedrag,TbStukCodeMeten,TbStukStukTekst FROM TbStuk"
da = New SqlDataAdapter(selectStr, conn)
da.Fill(Ds1, "TbStuk")
 
 
 
Dim TbStukRow As DataRow = Ds1.Tables("TbStuk").NewRow
''TbStukRow("TbStukDatumID") = Me.tdpdatum.Text
TbStukRow("TbStukIDRegCD") = Me.ComboBox1.SelectedItem
TbStukRow("TbStukIDDeel1") = Me.txtDeel1.Text
TbStukRow("TbStukIDDeel2") = Me.txtDeel2.Text
TbStukRow("TbStukCodeAanbieder") = Me.TextBox7.Text
TbStukRow("TbStukTijdInschrijving") = Me.TextBox6.Text
TbStukRow("TbStukCodeRectificatie") = Me.TextBox5.Text
TbStukRow("TbStukDatumVerlijden") = Me.DateTimePicker1.Text
TbStukRow("TbStukAardStuk") = Me.TextBox3.Text
TbStukRow("TbStukDatumDoorhalingStuk") = Me.DateTimePicker2.Text
TbStukRow("TbStukIndGeheelVerwerkt") = Me.TextBox1.Text
TbStukRow("TbStukReferentie") = Me.TextBox11.Text
TbStukRow("TbStukBedrag") = Me.TextBox10.Text
TbStukRow("TbStukCodeMeten") = Me.TextBox9.Text
TbStukRow("TbStukStukTekst") = Me.TextBox2.Text
Ds1.Tables("TbStuk").Rows.Add(TbStukRow)
Dim cmd As New SqlCommandBuilder(da)
da.Update(Ds1, "TbStuk")
'conn.Close()
Catch
Finally
MessageBox.Show("successfully inserted into database", "success info", MessageBoxButtons.OK, MessageBoxIcon.Information)
End Try

I do hope this can help you.

luisofo

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Feb 2007

Permalink

Feb 27th, 2007

Re: how to insert data from dataset into database

Use have to use the SqlCommandBuilder to update the table in a database through dataset

Use this it may help:

VB.NET Syntax (Toggle Plain Text)
Dim object name as SqlCommandBuilder(DataAdapter's Name)
DataAdapter's Name.Update(Datasetname, "Table Name")
Dim object name as SqlCommandBuilder(DataAdapter's Name)
DataAdapter's Name.Update(Datasetname, "Table Name")

arjunsasidharan

Reputation Points: 347

Solved Threads: 13

Practically a Posting Shark

Offline

812 posts
since Aug 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: How to store multiple selection?

Next Thread in VB.NET Forum Timeline: Can u add Opacity to a PictureBox in VS 2003

DaniWeb Message

Cancel Changes

User Name
Password