private void loadDataTable() { //SqlCommand cmd = new SqlCommand(); //cmd.CommandType = CommandType.StoredProcedure; //cmd.CommandText = "sp_SelectProduct"; //cmd.Parameters.AddWithValue("@company_id", c_id); //cmd.Parameters.AddWithValue("@branch_id", b_id); //cmd.Connection = con; try { //con.Open(); //DataSet ds = new DataSet(); //SqlDataAdapter da = new SqlDataAdapter(cmd); //da.Fill(ds); GridView1.DataSource = context.sp_SelectProduct(companyId, branchId); //ds.Tables[0]; GridView1.DataBind(); } catch (Exception ex) { ErrorLog.saveerror(ex); } finally { con.Close(); con.Dispose(); } }
public void ddlproductbind() { //context.tbl_product.Where(x => x.status == true && x.company_id == c_id).ToList(); ddlproduct.DataTextField = "product_name"; ddlproduct.DataValueField = "product_id"; ddlproduct.DataSource = context.sp_SelectProduct(companyId, branchId); ddlproduct.DataBind(); ddlproduct.Items.Insert(0, new ListItem("--Select Product--", "0")); }