……
DataSet ds=newDataSet()
adt.Fill(ds, "link")
DropDownList1.DataSource =ds.Tables[0].DefaultView;
DropDownList1.DataTextField=ds.Tables[0].Columns[0].Tostring();
DropDownList1.DataValueField=ds.Tables[0].Columns[1].Tostring();
DropDownList1.DataBind();