private void button1_Click(object sender, EventArgs e)
{
mc = new myconnection();
mc.conn.Open();
OleDbCommand cmd = new OleDbCommand("insert into Vendor(VID,Vname,VCode,VCity,VAddress,PH1,PH2,CPName,CPPH,VEmail,VFax,VGroup,VStatus) values(@VID,@Vname,@VCode,@VCity,@VAddress,@PH1,@PH2,@CPName,@CPPH,@VEmail,@VFax,@VGroup,@VStatus)", mc.conn);
cmd.Parameters.AddWithValue("@VID", textBox1.Text);
cmd.Parameters.AddWithValue("@Vname", textBox2.Text);
cmd.Parameters.AddWithValue("@VCode", textBox3.Text);
cmd.Parameters.AddWithValue("@VCity", textBox4.Text);
cmd.Parameters.AddWithValue("@VAddress", textBox5.Text);
cmd.Parameters.AddWithValue("@PH1", textBox6.Text);
cmd.Parameters.AddWithValue("@PH2", textBox7.Text);
cmd.Parameters.AddWithValue("@CPName", textBox8.Text);
cmd.Parameters.AddWithValue("@CPPH", textBox9.Text);
cmd.Parameters.AddWithValue("@VEmail", textBox10.Text);
cmd.Parameters.AddWithValue("@VFax", textBox11.Text);
cmd.Parameters.AddWithValue("@VGroup", comboBox2.Text);
cmd.Parameters.AddWithValue("@VStatus", comboBox3.Text);
cmd.ExecuteNonQuery();
mc.conn.Close();
MessageBox.Show("Record has been added !");
}
private void button1_Click(object sender, EventArgs e)
{
mc = new myconnection();
mc.conn.Open();
OleDbCommand cmd = new OleDbCommand("insert into Customer(CID,Cname,CAddress,City,PH1,PH2,ContectPerson,CPPH,CEmail,CreditLimit,CStatus,CGroup) values(@CID,@Cname,@Address,@City,@PH1,@PH2,@ContectPerson,@CPPH,@CEmail,@CreditLimit,@CStatus,@CGroup)", mc.conn);
cmd.Parameters.AddWithValue("@CID", textBox1.Text);
cmd.Parameters.AddWithValue("@Cname", textBox2.Text);
cmd.Parameters.AddWithValue("@Caddress", textBox3.Text);
cmd.Parameters.AddWithValue("@City", textBox4.Text);
cmd.Parameters.AddWithValue("@PH1", textBox5.Text);
cmd.Parameters.AddWithValue("@PH2", textBox6.Text);
cmd.Parameters.AddWithValue("@ContectPerson", textBox7.Text);
cmd.Parameters.AddWithValue("@CPPH", textBox8.Text);
cmd.Parameters.AddWithValue("@CEmail", textBox9.Text);
cmd.Parameters.AddWithValue("@CCreditLimit", textBox10.Text);
cmd.Parameters.AddWithValue("@CStatus", comboBox2.Text);
cmd.Parameters.AddWithValue("@CGroup", comboBox1.Text);
cmd.ExecuteNonQuery();
mc.conn.Close();
MessageBox.Show("Record has been added !");
}
