填充dropDownList......................

Sorry,打错了dropDownList.textdataField=name
dropDownList.valuedataField=id

dropDownList.dataSourse=sqldataadapter1
dropDownList.textdataField=name
dropDownList.valuedataField=id
dropDownList.databind
混点分，哈哈！

将DataTextField属性绑定到name字段
DataValueField属性绑定到id字段

1、指定数据源
2、指定数据字段
3、绑定DropDownList

string _StrSql = "select id, name from t_1";
sqldataadapter1 = new SqlDataAdapter( _StrSql, sqlconnection1 );
DataSet asp_11 = new DataSet();
sqldataadapter1.Fill( asp_11 );
m_DataView = new DataView( asp_11.Tables[0] );
dropDownList.dataSourse=m_DataView;
dropDownList.databind();

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>

<script language="C#" runat="server">
    SqlConnection  myConnection;
//SqlDataReader read;
    public void Page_Load(Object Src, EventArgs E)
    {    myConnection = new SqlConnection("server=(local);database=pubs;uid=sa;pwd=;");
    if (!Page.IsPostBack)
{ //SqlCommand mycom=new SqlCommand("select au_id,state from authors",myConnection);
//read=mycom.ExecuteReader();
     BindGrid();
// while (read.Read())
// {
//dropdownlist1.items.Add(new ListItem(read.GetValue(1).ToString(),read.GetValue(0).ToString()));
// }
// read.Close();
//}}
    }
}
    public void BindGrid()
    {
        SqlDataAdapter myCommand = new SqlDataAdapter("select distinct state from authors", myConnection);        DataSet ds = new DataSet();
        myCommand.Fill(ds, "员工");         Cy.DataSource=ds.Tables["员工"].DefaultView;
         Cy.DataBind();
    }
    public void GetAuthors_Click(Object sender, EventArgs E)
    {
        String selectCmd = "select * from Authors where state = @State and contract=@Contract";        SqlConnection myConnection = new SqlConnection("server=(local);database=pubs;uid=sa;pwd=;");
        SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd, myConnection);        myCommand.SelectCommand.Parameters.Add(new SqlParameter("@State", SqlDbType.NVarChar, 2));
        myCommand.SelectCommand.Parameters["@State"].Value = Cy.SelectedItem.Value;
        myCommand.SelectCommand.Parameters.Add(new SqlParameter("@Contract", SqlDbType.NVarChar, 1));
myCommand.SelectCommand.Parameters["@Contract"].Value=Con.Value;
        DataSet ds = new DataSet();
        myCommand.Fill(ds, "作者");        MyDataGrid.DataSource= ds.Tables["作者"].DefaultView;
        MyDataGrid.DataBind();
    }
</script><body style="font: 10.5pt 宋体">  <form runat="server">    <h3><font face="宋体">对 DataGrid 控件的参数化选择</font></h3>    选择州:
<ASP:DropDownList id="Cy"  datatextfield="state" DataValueField="state" runat="server"/>    <select id="Con" runat="server">
      <option>0</option>
      <option>1</option>
   </select>
    <input type="submit" OnServerClick="GetAuthors_Click" Value="获取作者" runat="server"/><p>    <ASP:DataGrid id="MyDataGrid" runat="server"
      Width="700"
      BackColor="#ccccff"
      BorderColor="black"
      ShowFooter="false"
      CellPadding=3
      CellSpacing="0"
      Font-Name="宋体"
      Font-Size="8pt"
      HeaderStyle-BackColor="#aaaadd"
      EnableViewState="false"
    />  </form></body>
</html>

dim dt as new datatable
sqldataadapter1.fill(dt)
dropDownList.dataSourse=dt
dropDownList.textdataField="name"
dropDownList.valuedataField="id"
dropDownList.databind()
也就是上面老兄说的：
DataTextField属性绑定到name字段
DataValueField属性绑定到id字段

dropDownList.dataSourse=sqldataadapter1
dropDownList.textdataField=name
dropDownList.valuedataField=id

不会吧，你的sqldataadapter1哪来得？？是在代码中解的么？
SqlConnection myConnection = new SqlConnection("server=(local);database=pubs;uid=sa;pwd=;");
SqlCommand mycom=new SqlCommand("select au_id,state from authors",myConnection);
SqlDataReader read=mycom.ExecuteReader();dropDownList.DataSourse=read；
dropDownList.TextDataField="name";
dropDownList.TextValueField="name";
dropDownList.DataBindBindGrid();

最后两行打错了
dropDownList.TextValueField="id";
dropDownList.DataBind();
//BindGrid();

我的。sqldataadapter1
是在工具箱里的数据边添加的

for (int i=0 ;i<myTable1.Rows.Count ;i++)
{
  ListItem myli = new ListItem();
  DataRow dr = myTable1.Rows[i];
  myli.Text = dr["type"].ToString();
  myli.Value = dr["xh"].ToString();
  this.dd_sbcplb.Items.Add(myli);}
i为数据表的行数,
先定义LISTITEM,再把表中的两个字段的值分别作为text,value,
最后add.

你试试在Page_load 中加入以上的代码。可能是你什么属性没有设对

// Head
using System;
using System.Configuration;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;// Member
protected System.Web.UI.WebControls.DropDownList infor_type;
protected System.Data.SqlClient.SqlConnection conn;
// Page Load
private void Page_Load(object sender, System.EventArgs e)
{conn = new SqlConnection("server=localhost;uid=sa;pwd=;database=.net");
string sql = "select * from dep_global_module_list where 信息=1 order by id";
// Create a new SqlDataAdapter instance
SqlDataAdapter sqladp = new SqlDataAdapter(sql, conn);
// Create a new DataSet instance
DataSet ds = new DataSet();
// SqlDataAdapter fill DataSet
sqladp.Fill(ds, "Info");
// Define the DataSource of the datagrid
infor_type.DataSource = ds.Tables["Info"].DefaultView;
infor_type.DataTextField = "名称";
infor_type.DataValueField = "id";
// Bind data
infor_type.DataBind();
}

大家为什么都这样填充啊？
小弟我刚刚填完一个，是这样的：
string strConn = ConfigurationSettings.AppSettings"SQLConnectionString"];
string strSQL="select * from table";
SqlConnection objConnection = new SqlConnection(strConnection);
SqlCommand objCommand = new SqlCommand(strSQL,objConnection);
objConnection.Open();
SqlDataReader objDataReader = null;
objDataReader = objCommand.ExecuteReader();
while(objDataReader.Read())
dropdownlist.Items.Add(objDataReader["MajorName"].ToString());
objDataReader.Close();保证没有问题！

给你一个那么好的DATABIND功能你不用，用这个DATAREADER方法？

for (int i=0 ;i<T_District.Rows.Count ;i++)
{
ListItem myli = new ListItem();
DataRow dr = T_District.Rows[i];
myli.Text = dr["name"].ToString();
myli.Value = dr["DistrictID"].ToString();
this.List.Items.Add(myli); }
D:\call\web_DL\Webinsert1\Webinsert1.aspx.cs(60): 找不到类型或命名空间名称“T_District”（是否缺少 using 指令或程序集引用？）
怎么解决呢？谢谢

'strSQL 是 SQL 语句
'isNewRow 是增加一个空值
'strDef 要选中的默认值    Public Sub deal_Combo(ByVal Temp As dropdownlist, ByVal strSQL As String, ByVal strDisplay As String, ByVal strVal As String, Optional ByVal isNewRow As Boolean = False, Optional ByVal strDef As Object = "")
        Dim i, rCount, intIndex As Integer
        Dim tabTmp As DataTable
        Dim myData As New DataCls()
        tabTmp = myData.ConnRS(strSQL)
        With Temp
            If isNewRow Then
                Dim myRow As DataRow
                myRow = tabTmp.NewRow()
                myRow(strDisplay) = ""
                tabTmp.Rows.Add(myRow)
                tabTmp.DefaultView.Sort = strDisplay
            End If
            .DataSource = tabTmp
            .TextDataField = strDisplay
            .valuedataField = strVal
            rCount = tabTmp.Rows.Count - 1
            For i = 0 To rCount
                If (tabTmp.Rows(i)(strVal).ToString.Trim <> "") And (strDef).ToString.Trim <> "") Then
                    If tabTmp.Rows(i)(strVal)).ToString.Trim  = strDef).ToString.Trim  Then
                        .SelectedIndex = i
                        Exit For
                    End If
                End If
            Next
        End With
    End Sub

gengwei80(gengwei) 的是可以用,你自己看看吧,如果不喜欢在属性里设置DataTextField和DataValueField,可以在DataSource下面加上这两句.DropDownList1.DataTextField=".."和DropDownList1.DataValueField="..."就行了.

调试易

填充dropDownList......................

解决方案 »