private void button2_Click(object sender, EventArgs e)
{
string strSQL = "";
if (CName.Text != "" && CNIC.Text != "")
{
strSQL = "INSERT INTO Customer(CustomerName,CNIC,Phone) VALUES ('" + CName.Text + "','" + CNIC.Text + "','" + Phone.Text + "')";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbCommand command = new OleDbCommand(strSQL, connection);
try
{
connection.Open();
command.ExecuteReader();
connection.Close();
MessageBox.Show("New Renter Added");
CName.Clear();
CNIC.Clear();
Phone.Clear();
DataRecordBind("Select * from Customer");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
public void clearAll()
{
employeeFatherName.Clear();
employeeName.Clear();
age.Clear();
CNIC.Clear();
primaryContact.Clear();
qualification.Clear();
HomeAddressText.Clear();
subject.Clear();
secondaryContact.Clear();
MaleRadioButton.IsChecked = false;
FemaleRadioButton.IsChecked = false;
nextAdmission();
}
