Hi,

Does anyone have some good examples of ADO.NET code that demonstrates a coded connection to SQL Server such that bound controls bind to retrieve and update data.

Thanks

http://msdn.microsoft.com/msdnmag/is...s/default.aspx
http://www.vbdotnetheaven.com/Upload...rolsVBNET.aspx
http://www.developer.com/net/csharp/article.php/3670531

Try this

"Mod Alert" - Move the thread to VB.NET Forum.

try this:
Dim SQLConn As SqlConnection = New SqlConnection
SQLConn.ConnectionString = "Data Source=servername;" & _
"Initial Catalog=databasename;" & _
"User ID=username;" & _
"Password=userpassword;"

the easy and best way to get connected with sql server is given below:-

"declare this in the code window on a form. this should be first line in the the code window, import the library class."

import system.data.sqlclient

"then declare these publically"

dim con as sqlconnection
dim cmd as sqlcommand
dim rs as recordset
dim da as sqldataadaptor

"on form load make the connection:"

con= new sqlconnection("connection string")
con.open
msgbox"ok"

"you are connected with sql server"

still you have any query pls mention.

connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
connection = New SqlConnection(connetionString)

http://vb.net-informations.com/dataa...-sqlserver.htm

First you must buy a Book, i think every .NET Books that i have ever read they cover that part .

http://www.codeproject.com/KB/cs/NTier.aspx

http://www.codeproject.com/KB/cs/N-Tier22.aspx

http://www.codeproject.com/KB/vb/N-T...cation_VB.aspx

Thank you

A simple code on how to connect sql server from VB.Net via SQL connection string, and the use of ExecuteNonQuery() method to execute the command and the try and catch to catch errors during runtime.

Example information:

SQL data:

Database name: user

Table name: user_t

Columns: user_id,lname,fname,username,password,usertype


Controls:

textboxes:

textID= for Id

textlname = for last name

textfname = for first name

textusername = for user name

textpassword = for password

combobox:

comboUsertype = for user type


Code:

Dim con As New SqlClient.SqlConnection

Dim strCon as string = "Data Source=servername;Initial Catalog=user;Integrated Security=True"

Dim strCommand As String = "Insert into user_t (user_id, lname, fname, username, password, usertype) values ('" & Me.textID.text & "','" & Me.textlname.text & "', '" & Me.fname.text & "', '" & Me.textusername.text & "','" & Me.textpassword.text & "','" & Me.comboUsertype.text & "')"

Sub insert()

Try

con.ConnectionString = strCon

Dim cm As New SqlClient.SqlCommand(strCommand, con)

con.Open()

cm.ExecuteNonQuery()

MsgBox("Succesfully saved…")

Catch ex As Exception

MessageBox.Show(ex.Message, "Error")

Finally

If con.State = ConnectionState.Open Then

con.Close()

End If

End Try

End sub

Hi, im trying to save,update and delete records from access database using vb 2005, Please help wit the ciding

http://www.go4expert.com/forums/showthread.php?t=8601

hope it will help u.