private void BindDropDowns()
{
DataSet dsDLLData = SqlHelper.ExecuteDataset(Global.PFCERPConnectionString, "[pWhseShipListFrm]",
new SqlParameter("@source", "getdropdowns"),
new SqlParameter("@searchFilter", ""));
if (dsDLLData != null)
{
ddlBind _ddlBind = new ddlBind();
_ddlBind.ddlBindControl(ddlLocation, dsDLLData.Tables[0], "LocID", "Name", "", "");
ddlLocation.Items.Insert(0, new ListItem("ALL", ""));
_ddlBind.ddlBindControl(ddlUserId, dsDLLData.Tables[1], "UserId", "Name", "", "");
ddlUserId.Items.Insert(0, new ListItem("ALL", ""));
}
}