コード例 #1
0
        private void btnSumit_Click(object sender, EventArgs e)
        {
            if (txtRollNo.Text == "" || txtAmount.Text == "" || cmbMonth.Text == "")

            {
                MessageBox.Show("Something is missing Select Month ,RollNo and fee Amount ", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Hand);
            }
            else
            {
                try
                {
                    con = new SqlConnection(c);
                    con.Open();
                    cmd = new SqlCommand("INSERT into Fees (Id,Month,AmountFee,date)VALUES('" + txtRollNo.Text + "','" + cmbMonth.Text + "','" + txtAmount.Text + "','" + dateTimePicker1.Text + "')", con);
                    cmd.ExecuteNonQuery();
                    cmd.Parameters.Clear();
                    cmd2 = new SqlCommand("delete from Defaulters where Id =" + txtRollNo.Text + "", con);



                    cmd2.ExecuteNonQuery();
                    cmd2.Parameters.Clear();
                    MessageBox.Show("Data Has Been Save", "S A V E", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    con.Close();
                    this.Hide();
                    frmDefaulters m = new frmDefaulters();
                    m.Show();
                }


                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
コード例 #2
0
ファイル: Menu.cs プロジェクト: BadarMadni/Gym-Management
        private void btnDefaulters_Click(object sender, EventArgs e)
        {
            frmDefaulters df = new frmDefaulters();

            df.Show();
        }