jonbinsdesu
Honorary Poster
- Joined
- May 23, 2018
- Posts
- 506
- Reaction
- 110
- Points
- 198
- Age
- 28
so meron akong form eto yung form
gusto ko po sanang lagyan ng validation sa pagsave na di pwede ang duplicate record pero ibebase ko sana sa firstname, lastname, middlename, contactno, at email
pero di talaga gumagana eh
gusto ko po sanang lagyan ng validation sa pagsave na di pwede ang duplicate record pero ibebase ko sana sa firstname, lastname, middlename, contactno, at email
C#:
con.Close();
con.Open();
command = new MySqlCommand("SELECT * FROM participants_tbl WHERE email= '" + txtFName.Text.Trim() + "'AND lastname='"+ txtLName.Text.Trim() + "'AND middlename='"+ txtMName.Text.Trim() + "'AND email='" + txtEmail.Text.Trim() + "'", con);
reader = command.ExecuteReader();
int x = 0;
con);
reader = command.ExecuteReader();
int x = 0;
while (reader.Read())
{
x++;
}
con.Close();
if (x >= 1)
{
MessageBox.Show("Participant already exists.", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtFName.Focus();
}
pero di talaga gumagana eh
Attachments
-
You do not have permission to view the full content of this post. Log in or register now.