Example #1
0
        //test
        private void btnProductSave_Click(object sender, EventArgs e)
        {
            bool x = SqlGetData.InsertData("Insert into tblproduct values( '" + txtProductName.Text + "','" + txtUnitPrice.Text + "')");

            if (x == true)
            {
                MessageBox.Show("Data Successfully inserted.");
                txtProductName.Text = null;
                txtUnitPrice.Text   = null;
            }
            else
            {
                MessageBox.Show("Error occurred while inserting data.");
            }
        }
Example #2
0
        //hello world!!
        private void btnSave_Click(object sender, EventArgs e)
        {
            bool x = SqlGetData.InsertData("Insert into tblcustomer values( '" + Nametxt.Text + "','" + Addresstxt.Text + "','" + Phonetxt + "')");

            if (x == true)
            {
                MessageBox.Show("Data Successfully inserted.");
                Nametxt.Text    = null;
                Addresstxt.Text = null;
                Phonetxt.Text   = null;
            }
            else
            {
                MessageBox.Show("Error occurred while inserting data.");
            }
        }
Example #3
0
        private void btnOrderSave_Click(object sender, EventArgs e)
        {
            bool x;

            x = SqlGetData.InsertData("Insert into tblorder values('" + textBoxTotalAmount.Text + "','" + comboBoxCustomer.SelectedItem + "','" + comboBoxProduct.SelectedItem + "')");
            if (x == true)
            {
                MessageBox.Show("Data Successfully inserted.");

                comboBoxCustomer.SelectedItem = null;
                comboBoxProduct.SelectedItem  = null;
                textBoxProductName.Text       = null;
                textBoxCustomerName.Text      = null;

                /* textBoxUnitPrice.Text = null;
                 * textBoxQuantity.Text = null;
                 * textBoxTotalAmount.Text = null;
                 */
            }
            else
            {
                MessageBox.Show("Error occurred while inserting data.");
            }
        }