Choke OnThis

Choke OnThis

  • NA
  • 1
  • 705

How do I validate textboxes in a datasource, windows form c#

Jul 6 2015 6:32 AM

What is the easiest way to validate textboxes that need to be checked before they go through. I have 2 tables I have to insert my data into as well and that's just for one group, in total I have 3 groups but just a helpful tip towards the one will be fine.

It needs to be checked before it runs so how would I do it before the try/catch block and still just use the one button click.

I have the main table which is 'Person' and then 3 sub tables; 'Student', 'Teacher', 'Administration'.

Not all the textboxes need to be validated. sAdd2.Text and StudentType.Text.

My normal code is

private void sNew_Click(object sender, EventArgs e)
{
try
{
personTableAdapter.Insert(sFirstName.Text, sSurname.Text,
Convert.ToDateTime(sDoB.Text), sPhone.Text, sAdd1.Text, sAdd2.Text,
sSuburb.Text, sState.Text, sPostcode.Text, StudentType.Text);

studentTableAdapter.Insert(Convert.ToInt32(sSID.Text),
Convert.ToDateTime(sSDate.Text), sQCode.Text);

MessageBox.Show(sFirstName.Text + " " + sSurname.Text + " has been added");

this.personTableAdapter.Fill(this._30002195DataSet.Person);
this.studentTableAdapter.Fill(this._30002195DataSet.Student);
this.Hide();
Admin f1 = new Admin();
f1.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
I have tried to use errorProvider and it doesn't stop to check, it just runs and checks and still submits into the database.