Can you guys please tell me whats wrong on my code. Im trying to get the data of Title, Author, Price, Stock from DB and output it on my textboxes.
Code:Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load connstring = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Csrp2_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" conn.ConnectionString = connstring If TextBox6.Text = form1.TextBox6.Text Then sql = "SELECT from Csrp2_table1 (Title, Author, Price, Stock) Values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "')" MsgBox("BZZ") Else MsgBox("FAILs") End If Dim da As New SqlDataAdapter(sql, conn) conn.Open() da.Fill(ds) conn.Close() End Sub
Or do you guys think im missing this code
but where should i put it???Code:" WHERE RFID = '" textbox6.text " ' "


Reply With Quote