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...?