我使用SQLSERVER,代码照书上写:
Dim cnn As OleDb.OleDbConnection
Dim cmd As OleDb.OleDbCommand
Dim da As OleDb.OleDbDataAdapter
cnn.ConnectionString = "..."
cnn.Open()
cmd.Connection = cnn
cmd.CommandText = "SELECT name FROM department"
da.SelectCommand = cmd
Dim dt As New DataTable
da.Fill(dt)
DropDownList1.DataSource = dt.DefaultView
DropDownList1.DataBind()
结果DropDownList不是显示表里面的东西,只是一行行“System.Data.DataRowView”
怎么回事啊?我用的是SQLSERVER
Dim cnn As OleDb.OleDbConnection
Dim cmd As OleDb.OleDbCommand
Dim da As OleDb.OleDbDataAdapter
cnn.ConnectionString = "..."
cnn.Open()
cmd.Connection = cnn
cmd.CommandText = "SELECT name FROM department"
da.SelectCommand = cmd
Dim dt As New DataTable
da.Fill(dt)
DropDownList1.DataSource = dt.DefaultView
DropDownList1.DataBind()
结果DropDownList不是显示表里面的东西,只是一行行“System.Data.DataRowView”
怎么回事啊?我用的是SQLSERVER
DropDownList1.DataValueField = "name";DropDownList1.DataBind();
DropDownList1.DataValueField = "b";数据库查询的语句
cmd.CommandText = "SELECT a,b FROM department"