| | |
Insert Dataset into SQL Database.
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Dec 2004
Posts: 4
Reputation:
Solved Threads: 0
Okay heres the dilemna....
I have a Dataset("LineItems") that Stores information about so many records.
To source to this DataSet("LineItems") is not its intended ouput.
Meaning I pull this info in from one database and output to another.
My problem is i have no idea on how to write an insert statement that will insert multiple records into a SQL table. Does anyone have any pointers????
PLEASE HELP ASAP. THANKS!
I have a Dataset("LineItems") that Stores information about so many records.
To source to this DataSet("LineItems") is not its intended ouput.
Meaning I pull this info in from one database and output to another.
My problem is i have no idea on how to write an insert statement that will insert multiple records into a SQL table. Does anyone have any pointers????
PLEASE HELP ASAP. THANKS!
•
•
Join Date: Jun 2008
Posts: 23
Reputation:
Solved Threads: 0
for int i=0 to dataset.tables(0).rows.count -1
adapter.InsertCommand = New SqlCommand(insertSQL, connection)
adapter.InsertCommand.ExecuteNonQuery()
next i
http://vb.net-informations.com/dataa...-sqlserver.htm
http://vb.net-informations.com/datas...et-dataset.htm
bruce
adapter.InsertCommand = New SqlCommand(insertSQL, connection)
adapter.InsertCommand.ExecuteNonQuery()
next i
http://vb.net-informations.com/dataa...-sqlserver.htm
http://vb.net-informations.com/datas...et-dataset.htm
bruce
•
•
Join Date: May 2008
Posts: 144
Reputation:
Solved Threads: 9
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim connection As SqlConnection
Dim adapter As New SqlDataAdapter
Dim sql As String
connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
connection = New SqlConnection(connetionString)
sql = "insert into product (Product_id,Product_name,Product_price) values(7,'Product7',700)"
Try
connection.Open()
adapter.InsertCommand = New SqlCommand(sql, connection)
adapter.InsertCommand.ExecuteNonQuery()
MsgBox("Row inserted !! ")
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
End Class
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim connection As SqlConnection
Dim adapter As New SqlDataAdapter
Dim sql As String
connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
connection = New SqlConnection(connetionString)
sql = "insert into product (Product_id,Product_name,Product_price) values(7,'Product7',700)"
Try
connection.Open()
adapter.InsertCommand = New SqlCommand(sql, connection)
adapter.InsertCommand.ExecuteNonQuery()
MsgBox("Row inserted !! ")
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
End Class
![]() |
Similar Threads
- SQL database stores data twice (ASP.NET)
- Can't insert dropdownlist into SQL (VB.NET)
- Insert into sql database (ASP.NET)
- Beginner: Insert, Update, Delete & Search records from/to sql database (ASP.NET)
- Unable to insert data into SQL Database (ASP)
Other Threads in the VB.NET Forum
- Previous Thread: Installation help
- Next Thread: connect vb.net to ms access
| Thread Tools | Search this Thread |
.net .net2008 2008 access account add advanced application array basic beginner browser button buttons click code combo cpu cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic employees excel exists fade filter forms generatetags html images input intel internet listview mobile module monitor mysql net number objects open panel pdf picturebox picturebox2 port position print printing printpreview problem regex reuse right-to-left save search searchvb.net select serial settings shutdown socket sqldatbase sqlserver storedprocedure survey temperature textbox timer timespan transparency txttoxmlconverter update user usercontol vb vb.net vb.netformclosing()eventpictureboxmessagebox vba vbnet vista visual visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode xml year





