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
edcaryl 0 Newbie Poster
arjunsasidharan 297 Practically a Posting Shark
vinod_javas commented: Good work man!! +2
MarianaM 0 Newbie Poster
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
try this:
Dim SQLConn As SqlConnection = New SqlConnection
SQLConn.ConnectionString = "Data Source=servername;" & _
"Initial Catalog=databasename;" & _
"User ID=username;" & _
"Password=userpassword;"
kap_sharma 0 Newbie Poster
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.
bruce2424 0 Newbie Poster
connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
connection = New SqlConnection(connetionString)
http://vb.net-informations.com/dataadapter/dataadapter-dataset-sqlserver.htm
vuyiswamb 17 Posting Whiz
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-Tier_Application_VB.aspx
Thank you
sierrainfo 0 Junior Poster
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
Tseli 0 Newbie Poster
Hi, im trying to save,update and delete records from access database using vb 2005, Please help wit the ciding
sierrainfo 0 Junior Poster
xcorpionxting 0 Newbie Poster
I am having a similiar problem... I can connect to a local MySql Database using:
SQLConn.ConnectionString = "Data Source=servername;" & _
"Initial Catalog=databasename;" & _
"User ID=username;" & _
"Password=userpassword;"Where servername is "localhost". I need to make a connection to an online database (same data structure). What should I put at the servername in that case?
vuyiswamb 17 Posting Whiz
The Server name cant be localhost. The Server name is the instance of SQL not the name of the Computer. a lot of people confuses this. There is a Difference between Data Source and servername. The Data Source is the SQL instance and the Servername is the name of the computer. in the Data Source should be the servername display when you try to connect to the sql server using SQl management studio. Copy that and put it here and it will work.
Kind Regards
Vuyiswa Maseko
yunvic 0 Newbie Poster
cul stuff
Netcode 33 Veteran Poster
dim con as sqlconnection = new sqlconnection( _
"server= server name; database= d-basename; user id = server id; password= server password;") kvprajapati commented: N/A -2
kvprajapati 1,826 Posting Genius Team Colleague
We are glad you got it helpful.Please do not resurrect old threads. If you have any questions please ask. You are welcome to start your own threads. Please read the rules before posting again - http://www.daniweb.com/forums/thread78223.html and rules.
Thread Locked.
vinod_10 0 Newbie Poster
i want connection to database through web.confug file how i can write a code in web.config file please help me.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.