private void button1_Click(object sender, EventArgs e) { try { string addquery = string.Format("insert into DISTRIBUTOR (NAME,CONTACTNUMBER,TRADEMARKID,EMAIL)values ('{0}','{1}','{2}','{3}')", vendornametextbox.Text, maskedTextBox1.Text, Convert.ToInt32(textBox1.Text), emailtextbox.Text); EventMangementSystemClass.Add(addquery); var query = string.Format("SELECT * FROM DISTRIBUTOR"); EventMangementSystemClass.RecordShow(query, dataGridView2); Vendoridtextbox.Clear(); vendornametextbox.Clear(); maskedTextBox1.Clear(); emailtextbox.Clear(); comboBox1.Text = ""; textBox1.Clear(); companyaddresstextbox.Clear(); contactnumbertextbox.Clear(); emailaddresstextbox.Clear(); VENDOR_INFORMATION_Load(sender, e); dataGridView2.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button2_Click(object sender, EventArgs e) { try { string updatequery = string.Format("delete from DISTRIBUTOR where DISTRIBUTORID = ('{0}')", Convert.ToInt32(Vendoridtextbox.Text)); EventMangementSystemClass.Update(updatequery); var query = string.Format("SELECT * FROM DISTRIBUTOR"); EventMangementSystemClass.RecordShow(query, dataGridView2); Vendoridtextbox.Clear(); vendornametextbox.Clear(); maskedTextBox1.Clear(); emailtextbox.Clear(); comboBox1.Text = ""; textBox1.Clear(); companyaddresstextbox.Clear(); contactnumbertextbox.Clear(); emailaddresstextbox.Clear(); VENDOR_INFORMATION_Load(sender, e); dataGridView2.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button4_Click(object sender, EventArgs e) { //try //{ string updatequery = string.Format("UPDATE DISTRIBUTOR SET NAME = ('{0}'), CONTACTNUMBER = ('{1}'),TRADEMARKID = ('{2}'), EMAIL = ('{3}') where DISTRIBUTORID=('{4}')", vendornametextbox.Text, maskedTextBox1.Text, Convert.ToInt32(textBox1.Text), emailtextbox.Text, Convert.ToInt32(Vendoridtextbox.Text)); EventMangementSystemClass.Update(updatequery); var query = string.Format("SELECT * FROM DISTRIBUTOR"); EventMangementSystemClass.RecordShow(query, dataGridView2); Vendoridtextbox.Clear(); vendornametextbox.Clear(); maskedTextBox1.Clear(); emailtextbox.Clear(); comboBox1.SelectedValue = "";; textBox1.Clear(); companyaddresstextbox.Clear(); contactnumbertextbox.Clear(); emailaddresstextbox.Clear(); VENDOR_INFORMATION_Load(sender, e); dataGridView2.Refresh(); // } //catch (Exception ex) //{ // MessageBox.Show(ex.Message); //} }