fill drop down list

How do i fill radio button list and dro开发者_如何学Cp downlist from database.

---

See http://msdn.microsoft.com/en-us/library/31723w77(v=VS.85).aspx

---

have a look at DataBinding and data boundable controls in MSDN. Your question like that it's so generic...

---

Get the record from datasource in datatable or dataset and bind with dropdownlist. For example:

DataTable dt = new DataTable();
dt = your query to return data as datatable;

dropdownlist.DataSource = dt;
dropdownlist.DataBind();

or create a common function like:

public static void BindDropDownList(DataTable _dt, System.Web.UI.WebControls.DropDownList _ddl, bool IsDIndex,string text)
{
    try
    {
        _ddl.DataSource = _dt;
        _ddl.DataBind();

        if (IsDIndex == true)
        {
            _ddl.Items.Insert(0, new ListItem(text, "0"));
        }
    }
    catch (Exception ex)
    {
        General.ErrorLog(ex.Message + " Stack Trace: " + ex.StackTrace, System.Diagnostics.EventLogEntryType.Error, "General - BindDropDownList()");
    }
}