private void ddlDiarySortBind()
{
try
{
ddlDiarySort.Items.Clear();
ddlDiarySort.Items.Add(new ListItem("-请选择文章类别-", "0"));
sqlConn mySqlConn = new sqlConn(); //数据库连接
string str_QSL = "Select * From 表";
SqlConnection MyConn = new SqlConnection(mySqlConn.MyConnection);
SqlCommand MyComm = new SqlCommand(str_QSL, MyConn);
MyConn.Open();
SqlDataReader ds = MyComm.ExecuteReader();
while (ds.Read())
{
ddlDiarySort.Items.Add(new ListItem(ds["Title"].ToString(), ds["ID"].ToString()));
}
ds.Close();
MyConn.Close();
}
catch (Exception ee)
{
Response.Write(ee.Message);
Response.End();
}
}
{
try
{
ddlDiarySort.Items.Clear();
ddlDiarySort.Items.Add(new ListItem("-请选择文章类别-", "0"));
sqlConn mySqlConn = new sqlConn(); //数据库连接
string str_QSL = "Select * From 表";
SqlConnection MyConn = new SqlConnection(mySqlConn.MyConnection);
SqlCommand MyComm = new SqlCommand(str_QSL, MyConn);
MyConn.Open();
SqlDataReader ds = MyComm.ExecuteReader();
while (ds.Read())
{
ddlDiarySort.Items.Add(new ListItem(ds["Title"].ToString(), ds["ID"].ToString()));
}
ds.Close();
MyConn.Close();
}
catch (Exception ee)
{
Response.Write(ee.Message);
Response.End();
}
}
需要绑定的控件是:listMyCtrlwhile(reader.Read())
{
ListItem oItem = new ListItem();
oItem.Text = dr["Name"].ToString();
oItem.Value = dr["ID"].ToString();
listCtrl.Items.Add(oItem);
}
reader.Close();
{
DropDownList1.DataSource = null;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
}
reader.Close();
也可以使用楼上方法
利用DropDownList.DataSource = DataTable;
DropDownList.DataTextField = "Name";
DropDownList.DataValueField = "ID";
DropDownList.DataBind();
来实现2个绑定
如果两个DropDownList绑定的是相同的字段,可以用DataSet
<asp:ListItem Selected="true" Text="请选择" Value="-1"></asp:ListItem>
</asp:DropDownList>
<asp:RangeValidator ID="rv1" runat="server" ControlToValidate="categoryselect" ErrorMessage="请正确选择分类" MinimumValue="0" MaximumValue="999" Type="Integer" SetFocusOnError="true" ></asp:RangeValidator>
<asp:ObjectDataSource ID="TCategoryBLL" runat="server" SelectMethod="GetAllCategory" TypeName="TemplateCategory"></asp:ObjectDataSource>
直接给DropDownList的SelectedValue绑定到字段上就行了,这个属性不在智能提示里,但可以这样用