Assalam o Alikum
CS619-Test Phase 2(VOTING SYSTEM)
Please help me How to write Search & Button Code in VB.Net for SQL Database Connection?
I have Successfuly Connected my Database with VB & Delete Button is working properly. But i don't know how to write code for update and search button.
Please Help me.
I am writing code in VB.net (Class).
plz help me.
I am writing this code for update (Student Info Database).
Private Sub cmdUpdate_Click(sender As Object, e As EventArgs) Handles cmdUpdate.Click
If txtUpdateRN.Text <> " " Then
Dim Updatecmd As String = "UPDATE Std_Info " & _
"SET Std_Name = '" & txtUpdateSN.Text & " 'Std_Study_Program = '" & txtUpdSP.Text & "' 'City = '" & txtCity.Text & "''Cell_No = '" & txtCellNo.Text & "'" & _
"WHERE Std_Roll_No = '" & txtUpdateRN.Text & "' "
If SQL.DataUpdate(Updatecmd) = 0 Then
MsgBox("Specified User Not found.")
MsgBox("Data Updated Successfuly" & txtUpdateRN.Text & ".")
MsgBox("You must Provide Information")
But getting this msg.
Specified user not found.
plz help me.
its ok at least ap ny reply to kia.
Sis group main add krti to is subject waly help kr dety :)
group my to koi ata hi nai hy isi wja sy to yaha post kia. kal last date hy.
Finally i have done my test phase 2 by myself.
wawo Ma Sha Allah
now un logo ko thanks bolo jinho ny apki help ni or apko is qabil bnaya k apny khud krli :P
best of luck dear
You are right.
Rabia could you plz help me in test phase 2
No need to write any class in this code.
Simply link up ur database and use requested commands.