那要看你从哪里读取数据了 你要是用数据库里面的数据那就是 cmd = New OleDbCommand(strcity, conn) Try If conn.State = ConnectionState.Closed Then conn.Open() End If Catch ex As Exception End Try read = cmd.ExecuteReader() If read.Read() Then 'DropDownList的item属性的ADD吧 End If read.Close()手头上没有web +C# 的代码 不过原理是一样的 用datareader读取数据的一条,加入downlist 再读 再加入不知道楼主要的是不是这样的结果
if(!Page.IsPostBack) { commandAdp=new SqlDataAdapter (); Conn=new SqlConnection(StrConn); command = new SqlCommand(); command.CommandText = "select Client_Name from Pub_Client_Data"; command.Connection = Conn; commandAdp.SelectCommand = command; data = new DataSet(); commandAdp.Fill(data); Conn.Open (); for(int i=0;i<data.Tables[0].Rows.Count;i++) { ... } }如用data.Tables[0].Rows[i].ToString()取不出来
{
for(int i=0;i<10;i++)
{
ListItem item=new ListItem();
item.Text="name"+i.ToString();
item.Value=i.ToString();
this.DropDownList1.Items.Add(item);
}
}
你要是用数据库里面的数据那就是
cmd = New OleDbCommand(strcity, conn)
Try
If conn.State = ConnectionState.Closed Then
conn.Open()
End If
Catch ex As Exception End Try
read = cmd.ExecuteReader()
If read.Read() Then
'DropDownList的item属性的ADD吧
End If
read.Close()手头上没有web +C# 的代码
不过原理是一样的
用datareader读取数据的一条,加入downlist
再读
再加入不知道楼主要的是不是这样的结果
{
commandAdp=new SqlDataAdapter ();
Conn=new SqlConnection(StrConn);
command = new SqlCommand();
command.CommandText = "select Client_Name from Pub_Client_Data";
command.Connection = Conn; commandAdp.SelectCommand = command; data = new DataSet();
commandAdp.Fill(data);
Conn.Open (); for(int i=0;i<data.Tables[0].Rows.Count;i++)
{
... }
}如用data.Tables[0].Rows[i].ToString()取不出来
myOPW_BZDZ.QueryByDMLB(CodeTypes.ctFM1);
for (int i = 0; i < DVdroFM1.Count; i++)
{
ListItem myitem = new ListItem();
myitem.Text = DVdroFM1.Table.Rows[i][Table_BZDZ.COLUMN_MC].ToString();
myitem.Value = DVdroFM1.Table.Rows[i][Table_BZDZ.COLUMN_DM].ToString();
droFM1.Items.Add(myitem);
}
{
DropDownList.items.Add(new listItems(i));
}
{
for( int i = 0 ; i < data.Tables[0].Rows.Count ; i++)
{
Partno_select:
for(int m = 0 ; m < data.Tables[0].Rows.Count ; m++)
{
if( m != i )
if(data.Tables[0].Rows[i][colum_name].ToString().Equals(data.Tables[0].Rows[m][colum_name].ToString()))
{
data.Tables[0].Rows.Remove(data.Tables[0].Rows[m]);
goto Partno_select;
}
}
cmb.Items.Add(data.Tables[0].Rows[i][colum_name].ToString());
}
}