data bind into dropdownlist

hi,

Try following code

public SqlConnection conn = new SqlConnection("connection string");
conn.Open();
SqlCommand cmd = new SqlCommand("Select * from tableName", conn);
SqlDataReader dr = cmd.ExecuteReader();
DDList1.DataSource = dr;
DDList1.DataTextField = "TextField";
DDList1.DataValueField = "ValueField";
DDList1.DataBind();
conn.Close();

or

SqlConnection con = new SqlConnection("connection string");
con.Open();
SqlCommand cmd = new SqlCommand(sqlQ, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

DDList1.DataSource = dt;
DDList1.DataTextField = "TextField";
DDList1.DataValueField = "ValueField";
DDList1.DataBind();
con.Close();

hope this will help you.