private void btn_view_Click(object sender, EventArgs e) { cbxFindItemCategory.Text = ""; cbxFindItemSubCategory.Text = ""; pnl_Rpot_sales.Controls.Clear(); Rpot_Sales1 rsale = new Rpot_Sales1(); rsale.TopLevel = false; rsale.Visible = true; pnl_Rpot_sales.Controls.Add(rsale); }
private void Rpot_Sales_Load(object sender, EventArgs e) { DateTime tdy = DateTime.Now.AddDays(1); dateTimePicker_to.Text = tdy.ToShortDateString(); dtpFrom = dateTimePicker_From; dtpTo = dateTimePicker_to; cb_ctogy = cbxFindItemCategory; cb_Subctogy = cbxFindItemSubCategory; String csql = "SELECT*FROM tbl_catogory"; SqlDataAdapter cget = new SqlDataAdapter(csql, ConnectionDB.Connection()); DataTable cdt = new DataTable(); cget.Fill(cdt); for (int i = 0; i < cdt.Rows.Count; i++) { cbxFindItemCategory.Items.Add(cdt.Rows[i]["catogory"]); } cbxFindItemCategory.Text = ""; cbxFindItemSubCategory.Text = ""; pnl_Rpot_sales.Controls.Clear(); Rpot_Sales1 rsale = new Rpot_Sales1(); rsale.TopLevel = false; rsale.Visible = true; pnl_Rpot_sales.Controls.Add(rsale); cbxFindItemCategory.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown; cbxFindItemCategory.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbxFindItemCategory.AutoCompleteSource = AutoCompleteSource.ListItems; }