Tuesday, 19 February 2013

How to bind dropdownlinst from database (Sqlserver 2005)

    public void fill()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["EatProject"].ToString());
        SqlCommand cmd = new SqlCommand("Select * from ImagesPath", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DropDownList2.DataTextField = "Status";
        DropDownList2.DataValueField = "Status";
        DropDownList2.DataSource = ds.Tables[0];
        DropDownList2.DataBind();

    }

1 comment :