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
}
