建议你对每个SqlCommand使用单独的操作
cmdEmpName.connection.open()
cboName.DataSource = cmdEmpName.ExecuteReader
cboName.DataBind()
cmdEmpName.connection.close()
cmdEmpName.connection.open()
cboName.DataSource = cmdEmpName.ExecuteReader
cboName.DataBind()
cmdEmpName.connection.close()
cmdEmpList.Close();
显示出错!
将connection关掉代价不是很大的
dr = cmdEmpList.ExecuteReader()
dgEmpList.DataSource = dr
dgEmpList.DataBind()
dr.Close()
cmdEmpName = New SqlCommand("SELECT DISTINCT OFFICIAL_NAME FROM EMPLOYEE", Connection)
drEmp = cmdEmpName.ExecuteReader()
ddlEmpName.DataSource = drEmp
ddlEmpName.DataBind()
drEmp.Close()但怎么ddlEmpName(DropDownList) 中显示的全是以下信息:System.Data.Common.DbDataRecord但同样的数据在datagrid中绑定就没有问题。请各位指教!