| | |
can you help me pls
Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Aug 2008
Posts: 20
Reputation:
Solved Threads: 0
Hi Everyone ,
Whats the conectionstring Vb.net2003 with Sql2000..?
Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click
Dim constr As String
Dim Sql As String
Dim red As String
Sql = "Select * from Sample"
Dim con As SqlClient.SqlConnection =_ _NewSqlClient.SqlConnection_
("DataSource=QB;uid=sa;Pwd=pisces;persi _st security info=False;initialcatalog=Sample")
MsgBox("Test")
Try
con.Open()
MsgBox("Connection opened successfully.")
constr = "Insert Sample where Name='" & txtname.Text & "' and Number='" & txtnumber.Text & "'"
Dim com As New System.Data.SqlClient.SqlCommand(constr, con)
Finally
con.Close()
End Try
End Sub
I m Used this coding but it says Error
Can u help meeee :-)
Whats the conectionstring Vb.net2003 with Sql2000..?
Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click
Dim constr As String
Dim Sql As String
Dim red As String
Sql = "Select * from Sample"
Dim con As SqlClient.SqlConnection =_ _NewSqlClient.SqlConnection_
("DataSource=QB;uid=sa;Pwd=pisces;persi _st security info=False;initialcatalog=Sample")
MsgBox("Test")
Try
con.Open()
MsgBox("Connection opened successfully.")
constr = "Insert Sample where Name='" & txtname.Text & "' and Number='" & txtnumber.Text & "'"
Dim com As New System.Data.SqlClient.SqlCommand(constr, con)
Finally
con.Close()
End Try
End Sub
I m Used this coding but it says Error
Can u help meeee :-)
![]() |
Similar Threads
- windows xp installation error!! pls help! (Troubleshooting Dead Machines)
- Help me remove Online Poker Pop up pls (Viruses, Spyware and other Nasties)
- hi friends pls help me out (C++)
- pls.help me im begging you!!! (C)
- pls... i need help!!! (C)
- Pls Hlp me with Hijackthis log file. (Viruses, Spyware and other Nasties)
- Pls help with my HJT log (Viruses, Spyware and other Nasties)
- can somebody pls. help me out with my HJT log.. (Viruses, Spyware and other Nasties)
Other Threads in the VB.NET Forum
Views: 283 | Replies: 1
| Thread Tools | Search this Thread |
Tag cloud for VB.NET
"crystal .net .net2005 2008 access add application array assignment basic box button buttons center class click code combo convert cpu data database datagrid datagridview design designer dissertation dissertations dissertationthesis dosconsolevb.net editvb.net employees error excel exists firewall function image images isnumericfuntioncall listview login map math memory mobile module msaccess mssqlbackend mysql navigate net opacity page pan picturebox port print printing printpreview problem record refresh regex reports" reuse right-to-left save savedialog search serial socket sorting sql sqldatbase storedprocedure string structures studio temp textbox timer txttoxmlconverter upload useraccounts usercontol usercontrol vb vb.net vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet vista visual visualbasic visualbasic.net visualstudio2008 web wpf xml





