C #Working with Dropdown lists

Dear
Please write the following code in appropriate handlers :
protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
            BindGrid();
    }
public void BindGrid()
    {
        string constr=@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=true;User Instance=true";
        string cmdstr = "select * from statustable";
        SqlDataAdapter daStatus=new SqlDataAdapter(cmdstr,constr);
        DataSet dsStatus=new DataSet();
        daStatus.Fill(dsStatus,"table1");
        DropDownList1.DataSource=dsStatus;
        DropDownList1.DataTextField="Status";
        DropDownList1.DataValueField="Status";
        DropDownList1.DataBind();
     }
protected void  DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    lstStatus.Text = DropDownList1.Text;
}

Points to note:
1. Set the AutoPostback property of DropDownlist box to true.
2. Here, lstStatus is the name of the label control.
3. DropDownList1 is the name of the dropdownlist box.
4. Database.mdf is the name of the database file with a table named StatusTable.

If you want the zipped project, mail me at [email protected]
Happy Coding.