private void bindValues() { try { //sys ddl action is set true; connection.Open(); SqlCommand command = new SqlCommand("Sp_GetSystems_ByRoles", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@p_RoleName", Session["SysToAdd"].ToString()); DataSet ds = new DataSet(); SqlDataAdapter sA = new SqlDataAdapter(command); sA.Fill(ds); SysDDL.DataSource = null; SysDDL.DataSource = ds.Tables[0]; SysDDL.DataBind(); SysDDL.DataTextField = "SystemName"; SysDDL.DataValueField = "SystemID"; SysDDL.DataBind(); // if (SysDDL != null) { SysDDL.Items.Insert(0, "Select System"); SysDDL.SelectedIndex = 0; } } catch (Exception exp) { } finally { connection.Close(); } }
public void PopulateDropDown(String Text) { #region Populating Product Name Dropdown try { connection.Open(); Text = Text + "%"; SqlCommand command = new SqlCommand("SELECT ProductID,Product_Name From tbl_ProductMaster Where tbl_ProductMaster.Product_Name LIKE '" + Text + "' AND tbl_ProductMaster.Product_Id_Org LIKE '444%' AND Status = 1", connection); DataSet ds = new DataSet(); SqlDataAdapter sA = new SqlDataAdapter(command); sA.Fill(ds); if (SysDDL.DataSource != null) { SysDDL.DataSource = null; } SysDDL.DataSource = ds.Tables[0]; SysDDL.DataTextField = "Product_Name"; SysDDL.DataValueField = "ProductID"; SysDDL.DataBind(); } catch (Exception ex) { } finally { connection.Close(); } #endregion }