string query = "select Store_id,Store_name from StoresTBL"; SqlDataAdapter da = new SqlDataAdapter(query, con); con.Open(); DataSet ds = new DataSet(); da.Fill(ds, "StoresTBL"); comboBoxInvoice.DisplayMember = "Store_name"; comboBoxInvoice.ValueMember = "Store_id"; comboBoxInvoice.DataSource = ds.Tables["StoresTBL"]; DataTable dt5 = new DataTable(); string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { string sqlstr5 = "select rnh.ReceiptNote_id as 'Receipt Note Id', rnh.Customer_id as'Customer Id' on pt.Product_id=rnd.Product_Id where rnh.Receipt_Date=CONVERT(VARCHAR(10),GETDATE(),110) and st.Store_id= @Store_id"; using (SqlDataAdapter dr7 = new SqlDataAdapter(sqlstr5, CS)) { dr7.SelectCommand.Parameters.AddWithValue("@Store_id", comboBoxInvoice.ValueMember); dr7.Fill(dt5); dataGridView1.DataSource = dt5; }
dr7.SelectCommand.Parameters.AddWithValue("@Store_id", int.Parse(comboBoxInvoice.SelectedValue.ToString()));
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)