how to validate with Sql database?

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

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;

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Yuvraj Ganesan12y ago
yes sir
0
Munesh Sharma12y ago
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;
}
0
Abhay Shanker12y ago
Do you want to validate TextBoxes with Database Table column...?
0