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;
}
