示例#1
0
        private void metroButton1_Click_1(object sender, EventArgs e)
        {
            int    tmp = MembersFee.CustomerId();
            string q   = "INSERT INTO subscriptions(customer_id,start_date,end_date,package,cost,paid) VALUES(" + tmp + ",'" + startDate.Value.ToString() + "','" + endDate.Value.ToString() + "','" + monthTB.Text + "','" + double.Parse(costTB.Text) + "','" + payTB.Text + "')";

            executeQuery(q);
            rerfeshGrid();
        }
示例#2
0
 private void rerfeshGrid()
 {
     try
     {
         String q2 = "select * from subscriptions";
         q2 += " where customer_id='";
         q2 += MembersFee.CustomerId().ToString() + "'";
         da2 = new MySqlDataAdapter(q2, MainForm.connection);
         ds2.Clear();
         da2.Fill(ds2, "Subscriptions");
         dataGridView1.DataSource = ds2.Tables["Subscriptions"];
     }
     catch (Exception ex)
     {
         MetroMessageBox.Show(this, "Error", ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }