Mga master patulong naman po ako nito bakit lagi may error na ganito ano po ba mali dito sa ss ko po? Maraming salamat po
Attachments
-
You do not have permission to view the full content of this post. Log in or register now.
Last edited:
Salamat master try kohindi nyo po naiprepare yung command. Try nyo po lagyan ng command.Prepare() bago mag add ng parameter
pwede rin ito gamitin mo sa pag prepare para di gaano mahaba command.Parameters.AddWithValue("@paramname",value)
Ganon padin hay
Salamat po mastertry mo gumamit ng DataReader instead of DataTable para mas madali
public conn as new mysqlConnection("Server; User ID; Password; Database;")
dim str as string
str = "select * from useracct WHERE username = '" & txtUname.Text & "' and password = '" & txtPassword.Text & "'"
conn.Open()
Dim mysC As New MySqlCommand(str, conn)
Dim mysDR As MySqlDataReader
mysDR = mysC.ExecuteReader
If mysDR.HasRows Then
conn.Close()
MessageBox.Show("Welcome to MY PROGRAM!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Information)
frmMain.Show()
Me.Hide()
Else
MessageBox.Show("Username and Password did not match!", "Unable to login", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
conn.Close()
txtPassword.Clear()
txtUname.Clear()
txtUname.Focus()
End If
Sana makatulong!
Ok na po master salamat po sa tulongoh? pwede po patiningin ng bagong codes
try nyo din po yung kay arpjhe143
Salamat po master
Salamat po master
Nag adust lang po ako kunti kc 2017 gamit ko po pero same lng din may dagdag lng kuntinga pala, VB.NET 2008 user po ako TS.. Baka may konting conflict sa code..
Nag adust lang po ako kunti kc 2017 gamit ko po pero same lng din may dagdag lng kunti