private void btn_Search_Click(object sender, EventArgs e) { try { if (tb_Category.Text != "" && tb_search.Text != "") { if (tb_Category.Text == "Name") { con.Open(); SqlDataReader dr; DataTable dt = new DataTable(); cmd = new SqlCommand(); cmd.Connection = con; cmd = new SqlCommand("select * from Customer_Master where Name = '" + tb_search.Text + "' ", con); dr = cmd.ExecuteReader(); if (dr.Read()) { tempid = (int)dr["Customer_ID"]; } dr.Close(); cmd = new SqlCommand("select * from Customer_Master where Name = '" + tb_search.Text + "' ", con); SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(dt); // obj.cmd.Dispose();hold DataTable dt1 = new DataTable(); cmd = new SqlCommand("select * from Customer_Purchase_Detail where Customer_ID = " + tempid + " ", con); adp = new SqlDataAdapter(cmd); adp.Fill(dt1); Report.rpt_1 rpt = new Report.rpt_1(); rpt.Database.Tables["Customer_Master"].SetDataSource(dt); rpt.Database.Tables["Customer_Purchase_Detail"].SetDataSource(dt1); crv_bill_history_Cust.ReportSource = null; crv_bill_history_Cust.ReportSource = rpt; obj.cmd.Dispose(); adp.Dispose(); } } if (tb_Category.Text == "Mobile_No") { con.Open(); SqlDataReader dr; DataTable dt = new DataTable(); cmd = new SqlCommand(); cmd.Connection = con; cmd = new SqlCommand("select * from Customer_Master where Mobile_No = " + tb_search.Text + " ", con); dr = cmd.ExecuteReader(); if (dr.Read()) { tempid = (int)dr["Customer_ID"]; } dr.Close(); cmd = new SqlCommand("select * from Customer_Master where Mobile_No = " + tb_search.Text + " ", con); SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(dt); // obj.cmd.Dispose();hold DataTable dt1 = new DataTable(); cmd = new SqlCommand("select * from Customer_Purchase_Detail where Customer_ID = " + tempid + " ", con); adp = new SqlDataAdapter(cmd); adp.Fill(dt1); Report.rpt_1 rpt = new Report.rpt_1(); rpt.Database.Tables["Customer_Master"].SetDataSource(dt); rpt.Database.Tables["Customer_Purchase_Detail"].SetDataSource(dt1); crv_bill_history_Cust.ReportSource = null; crv_bill_history_Cust.ReportSource = rpt; obj.cmd.Dispose(); adp.Dispose(); } con.Close(); } catch (Exception ex) { // Block of code to handle errors MessageBox.Show(ex.Message); } }
private void frm_Bill_History_by_Cust_Name_Load(object sender, EventArgs e) { try { int iFormLoad = obj.globalVal_FormLoad(1); if (iFormLoad == -1) { goto nxt; } int temp; temp = obj.globalVal_Custid(1, 0); tb_search.Text = Convert.ToString(temp); if (tb_search.Text != "") //when user come through new invice { lbl.Visible = false; tb_Category.Visible = false; btn_Search.Visible = false; con.Open(); DataTable dt = new DataTable(); DataTable dt1 = new DataTable(); cmd.Connection = con; cmd = new SqlCommand("select * from Customer_Master where Customer_ID = " + tb_search.Text + " ", con); SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(dt); // obj.cmd.Dispose(); cmd = new SqlCommand("select * from Customer_Purchase_Detail where Customer_ID = " + tb_search.Text + " ", con); adp = new SqlDataAdapter(cmd); adp.Fill(dt1); Report.rpt_1 rpt = new Report.rpt_1(); rpt.Database.Tables["Customer_Master"].SetDataSource(dt); rpt.Database.Tables["Customer_Purchase_Detail"].SetDataSource(dt1); crv_bill_history_Cust.ReportSource = null; crv_bill_history_Cust.ReportSource = rpt; obj.cmd.Dispose(); } else { MessageBox.Show("Please fill the All Fields..."); } nxt :; // this.crv_bill_history_Cust.RefreshReport(); } catch (Exception ex) { // Block of code to handle errors MessageBox.Show(ex.Message); } }