dim temp as string
dim conn as new oledb.oledbconnection
conn.connectionstring="你的连接字段"
conn.open()
dim com as new oledb.oledbcommand("select 你要的字段 from 你的表 ",conn)
dim dr as oledb.oledbdatareader
dr=com.excutereader
while dr.read
temp=dr.getsting(0)
dropdownlisp.items.add(temp)
end while注:以上使用的是vb.net连接oracle数据库。
dim conn as new oledb.oledbconnection
conn.connectionstring="你的连接字段"
conn.open()
dim com as new oledb.oledbcommand("select 你要的字段 from 你的表 ",conn)
dim dr as oledb.oledbdatareader
dr=com.excutereader
while dr.read
temp=dr.getsting(0)
dropdownlisp.items.add(temp)
end while注:以上使用的是vb.net连接oracle数据库。
解决方案 »
- cms生成静态列表分页
- 在BoundField中使用FindControl如何查找ID?
- 如何修改上传文件的名称
- 一个关于FtpWebRequest的问题
- IIS配置问题,请教大家
- [馨郁星愿]关于datalist绑定图片的问题,希望哪个有空进来看看
- 急,在不使用HtmlInputFile这个类的方式下,怎么将客户端的图片上传到服务器指定的目录中.
- 在winform窗体中如何设置字体并获取字体,在线等!
- winform程序打包的时候,如何把.net也一起打包?
- 很急,请各位帮忙,谢谢了!!!!!!!!!!!!
- 放100分,请思归或类似高手解答.Net报表怎样才能打印在客户端?????
- 求助!顺祝大家圣诞快乐!来者有分!
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim strcon As String = "provider=microsoft.Jet.OLedb.4.0; data source=" & Server.MapPath("data_x7bbs/x7bbs247.mdb")
Dim conn As New OleDbConnection(strcon)
Dim sql As String = "select NclassId,NclassName from bbsclass"
Dim cmd As New OleDbCommand(sql, conn)
Dim dr As OleDbDataReader
conn.open()
dr = cmd.ExecuteReader
While dr.Read()
Dim testlist As ListItem = New ListItem(dr.GetString(1), dr.GetInt32(0))
boardList.Items.Add(testlist)
End While
End Sub
{
string mySQL = "SELECT fieldvalue,fieldtext FROM mytable";
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(mySQL,myConnection);
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet,"mytable");
return myDataSet.Tables["mytable"].DefaultView;
}private void BindList()
{
myList.DataSource = CreateDataSource();
myList.DataValueField = "valuefield";//对应DropDownList值的字段
myList.DataTextField = "textfield";//对应DropDownList文本的字段
myList.DataBind();
}
{
ssyx=(string)Session["ssyx"];
//生成实验室下拉列表
DDLsysmc.Items.Add(new ListItem("<-请选择实验室->",""));
string sql_sel_sysmc="select sysb.bh,sysb.mc from sysb where sysb.ssdw='"+ssyx+"'" ;
System.Data.SqlClient.SqlDataReader dr_sysmc;
dr_sysmc=SqlHelper.ExecuteReader(strConn1,CommandType.Text,sql_sel_sysmc);
while(dr_sysmc.Read())
DDLsysmc.Items.Add(new ListItem(dr_sysmc[1].ToString(),dr_sysmc[0].ToString().Trim()));
dr_sysmc.Close();}
Items.Add以后不需要在绑顶那个控件了就可以吗
可是VS。NET提示我控件没绑定