how to validate with Sql database?

Question

Hello, i developed a webpage which validate each textbox with Sql Server database. i dont know how to validate each textbox which is given by user with database. if its validate, it should navigate or redirect to respected page else message box should be displayed

Yuvraj Ganesan · Answer

yes sir

Munesh Sharma · Answer

Validate a textbox.. private bool is_validate() { bool no_error = true; if (textBox1.Text == string.Empty) { errorProvider1.SetError(textBox1,""); no_error = false; } else { // Clear all Error Messages try { int i = Convert.ToInt32(textBox3.Text); } catch { errorProvider1.Clear(); // Clear all Error Messages errorProvider1.SetError(textBox3, "enter velid Age"); return false; } if (textBox2.Text == string.Empty) { errorProvider1.SetError(textBox2, "Father name missing"); no_error = false; } if (id_txt.Text == string.Empty) { errorProvider1.SetError(id_txt, "ID missing"); no_error = false; } if (usn_txt.Text == string.Empty) { errorProvider1.SetError(usn_txt, "usn number missing"); no_error = false; } if (clg_txt.Text == string.Empty) { errorProvider1.SetError(clg_txt, "collage name missing"); no_error = false; } if (cource_txt.Text == string.Empty) { errorProvider1.SetError(cource_txt, "source name missing"); no_error = false; } if (result_txt.Text == string.Empty) { errorProvider1.SetError(result_txt, "result missing"); no_error = false; } if (dateTimePicker1.Text == string.Empty) { errorProvider1.SetError(dateTimePicker1, "Date Missing"); no_error = false; } if (checkBox1.Checked == false && checkBox2.Checked == false) { errorProvider1.SetError(checkBox1, "select user or admin"); errorProvider1.SetError(checkBox2, "select user or admin"); no_error = false; } } return no_error; }

Abhay Shanker · Answer

Do you want to validate TextBoxes with Database Table column...?

how to validate with Sql database?

Answers (3)