private void button1_Click(object sender, EventArgs e)
{
using (db = new DataClasses1DataContext())
{
CustomerDetail cc = new CustomerDetail()
{
Cus_id = textBox1.Text,
Cus_Name = textBox2.Text,
Cus_Address = textBox3.Text,
Cus_Phone = textBox4.Text,
Cus_dateofbirth = maskedTextBox1.Text,
Cus_Email = textBox6.Text
};
//db.CustomerDetails.InsertOnSubmit(cc);
}
//record();
try
{
int id = Convert.ToInt32(textBox1.Text);
string name = textBox2.Text;
string address = textBox3.Text;
string phone = textBox4.Text;
string dob = maskedTextBox1.Text;
string email = textBox6.Text;
SqlConnection conn = new SqlConnection(connection);
string query = string.Format("insert into customer1 values({0},'{1}','{2}','{3}','{4}','{5}')", id, name, address, phone, dob, email);
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Sucessfully Ragestered");
clear();
}
catch (Exception)
{
MessageBox.Show("Field Required Fill the form ");
clear();
}
}
partial void DeleteCustomerDetail(CustomerDetail instance);
partial void UpdateCustomerDetail(CustomerDetail instance);
partial void InsertCustomerDetail(CustomerDetail instance);