How to load dropdownlist(drpBusinessUnit)

How to load dropdownlist(drpBusinessUnit)

----------write code on aspx.cs file-----------------------------

private void A_LoadBusinessUnit()

{

try

{

drpBusinessUnit.DataSource = objdt.GetBusinessUnit();

drpBusinessUnit.DataValueField = "BusinessUnit_ID";

drpBusinessUnit.DataTextField = "BusinessUnit_Name";

drpBusinessUnit.DataBind();

//ddlproduct.Items.Insert(0, "-Select-");

System.Web.UI.WebControls.ListItem cmbItem;

cmbItem = new System.Web.UI.WebControls.ListItem("-Select-", "0");

drpBusinessUnit.Items.Insert(0, cmbItem);

}

------------------------------------------write code on class file

public SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["Constr"]);

public DataSet GetBusinessUnit()

{

DataSet dsGetProduct = new DataSet();

try

{

if (sqlconn.State == ConnectionState.Closed)

{

sqlconn.Open();

}

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "PMP_GetBusinessUnit";

cmd.CommandType = CommandType.StoredProcedure;

cmd.Connection = sqlconn;

SqlDataAdapter sqlda = new SqlDataAdapter();

sqlda.SelectCommand = cmd;

sqlda.Fill(dsGetProduct);

}

catch (Exception ex)

{

}

finally

{

sqlconn.Close();

}

return dsGetProduct;

}

-------------------write procedure---------------------------------------------

create procedure [dbo].[PMP_GetBusinessUnit]

as

select BusinessUnit_ID, BusinessUnit_Name

from PMP_BusinessUnit