Exemplo n.º 1
0
        private void btngeneratereceipt_Click(object sender, EventArgs e)
        {
            try
            {
                using (SqlConnection con1 = new SqlConnection(cs))
                {
                    con1.Open();
                    SqlCommand    cmd = new SqlCommand("Select * from DonationDetails Where ReceiptNo = " + txtRno.Text + "", con1);
                    SqlDataReader dr  = cmd.ExecuteReader();
                    DataTable     dt  = new DataTable();
                    dt.Load(dr);
                    CrystalReport  cr = new CrystalReport();
                    CrystalReport1 c  = new CrystalReport1();
                    c.SetDataSource(dt);
                    cr.crystalReportViewer1.ReportSource = c;
                    cr.crystalReportViewer1.Refresh();

                    cr.ShowDialog();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemplo n.º 2
0
 private void btnreceipt_Click(object sender, EventArgs e)
 {
     if (validate())
     {
         string cs = ConfigurationManager.ConnectionStrings["dbc"].ConnectionString;
         using (SqlConnection con = new SqlConnection(cs))
         {
             try
             {
                 con.Open();
                 string     query = "Insert into DonationDetails values(@ReceiptNo,@Name,@Date,@Amount,@DonatedIN,@PANCardNo,@Address,@Email,@Description)";
                 SqlCommand cmd   = new SqlCommand(query, con);
                 cmd.Parameters.Add("@ReceiptNo", SqlDbType.Int, 0, "ReceiptNo").Value             = int.Parse(txtreceiptno.Text);
                 cmd.Parameters.Add("@Name", SqlDbType.VarChar, 250, "Name").Value                 = txtname.Text;
                 cmd.Parameters.Add("@Date", SqlDbType.Date, 0, "ReceiptDate").Value               = dateTimePicker1.Value;
                 cmd.Parameters.Add("@Amount", SqlDbType.Money, 0, "Amount").Value                 = double.Parse(txtamount.Text);
                 cmd.Parameters.Add("@DonatedIN", SqlDbType.VarChar, 100, "DonationIN").Value      = comboBox1.SelectedItem.ToString();
                 cmd.Parameters.Add("@PANCardNo", SqlDbType.NVarChar, 100, "PANCardNo").Value      = txtCardNo.Text;
                 cmd.Parameters.Add("@Address", SqlDbType.NVarChar, 500, "Address").Value          = txtaddress.Text;
                 cmd.Parameters.Add("@Email", SqlDbType.NVarChar, 100, "emailID").Value            = txtemail.Text;
                 cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 500, "Descripetion").Value = txtdiscreption.Text;
                 cmd.ExecuteNonQuery();
                 con.Close();
                 MessageBox.Show("Donor Details has been stored");
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.Message);
             }
         }
         using (SqlConnection con1 = new SqlConnection(cs))
         {
             try
             {
                 con1.Open();
                 SqlCommand    cmd = new SqlCommand("Select * from DonationDetails Where ReceiptNo = " + txtreceiptno.Text + "", con1);
                 SqlDataReader dr  = cmd.ExecuteReader();
                 DataTable     dt  = new DataTable();
                 dt.Load(dr);
                 CrystalReport  cr = new CrystalReport();
                 CrystalReport1 c  = new CrystalReport1();
                 c.SetDataSource(dt);
                 cr.crystalReportViewer1.ReportSource = c;
                 cr.crystalReportViewer1.Refresh();
                 cr.ShowDialog();
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.Message);
             }
         }
     }
 }