C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Insert multiple records using single command


Posted Date: 10 Sep 2008    Resource Type: Code Snippets    Category: ADO.NET

Posted By: Ramesh       Member Level: Silver
Rating:     Points: 10



This VB.NET sample code will demonstrate how to insert multiple records using a single command object.



Dim BulkInsert As New StringBuilder("")

For i As Integer = 1 To 10
Dim InsQry As String
InsQry = "INSERT INTO tblSample(ID) VALUES('" & i.ToString & "')"
BulkInsert.Append(InsQry)
BulkInsert.Append("; ")
Next

If BulkInsert.ToString() <> "" Then 'Check if Built query has some value
Dim conn As New SqlClient.SqlConnection("Your Connection String")
Dim cmd As New SqlClient.SqlCommand(BulkInsert.ToString(), conn)
cmd.ExecuteNonQuery() 'Execute the Query
End If





Responses


No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Multiple Insert Statement  .  Insert multiple records using single command in VB.NET  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Common database class for .Net application (VB.Net)
Previous Resource: ID Auto Generation
Return to Discussion Resource Index
Post New Resource
Category: ADO.NET


Post resources and earn money!
 
Related Resources



dotNet Slackers   BizTalk Adaptors    Web Design

doors in nj

Contact Us    Privacy Policy    Terms Of Use