Member Avatar for san_gwapo19

anyone here knows how to create a bank simulation
deposit and withdraw..tnx a lot guys!!!

  • 2 Contributors
  • 1 Reply
  • 68 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by prasannapower
Member Avatar for prasannapower

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 :-)

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.