我在一个页面的load事件中这样写到(加载数据库中的员工编号,员工姓名到此combobox中)
Dim mConn As New Connection
Dim conn As SqlConnection = mConn.SqlConnection
Dim comm As SqlCommand = conn.CreateCommand
Dim sqlDbReader As SqlDataReader
Try
conn.Open()
comm.CommandText = "select hr_EmployeeID,hr_EngName,hr_ChiName,hr_DepartmentEngName,hr_TeamName from v_EmployeeInfo order by hr_EmployeeID " 'where hr_CompanyID in (" & MDIPmain.sysCompanyID & ") and hr_DepartmentID in (" & MDIPmain.sysDepartmentID & ")"
sqlDbReader = comm.ExecuteReader
Dim DBTable As New DataTable
DBTable.Load(sqlDbReader)
Cbb_Employee.DataSource = DBTable
Cbb_Employee.DisplayMember = "hr_EmployeeID"
Cbb_Employee.ValueMember = "hr_EngName"
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.OkOnly, "錯誤")
Finally
comm.Dispose()
conn.Dispose()
conn.Close()
End Try
If Cbb_Employee.Items.Count > 0 Then
Cbb_Employee.SelectedIndex = 0
End If
Private Sub Cbb_Employee_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Cbb_Employee.TextChanged
txt_EmpName.Text = Cbb_Employee.SelectedValue.ToString
btn_AddToChecked.Enabled = True
End Sub结果txt_EmpName.text=System.Data.DataRowView
第二次正常,请问应该如何改?
Dim mConn As New Connection
Dim conn As SqlConnection = mConn.SqlConnection
Dim comm As SqlCommand = conn.CreateCommand
Dim sqlDbReader As SqlDataReader
Try
conn.Open()
comm.CommandText = "select hr_EmployeeID,hr_EngName,hr_ChiName,hr_DepartmentEngName,hr_TeamName from v_EmployeeInfo order by hr_EmployeeID " 'where hr_CompanyID in (" & MDIPmain.sysCompanyID & ") and hr_DepartmentID in (" & MDIPmain.sysDepartmentID & ")"
sqlDbReader = comm.ExecuteReader
Dim DBTable As New DataTable
DBTable.Load(sqlDbReader)
Cbb_Employee.DataSource = DBTable
Cbb_Employee.DisplayMember = "hr_EmployeeID"
Cbb_Employee.ValueMember = "hr_EngName"
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.OkOnly, "錯誤")
Finally
comm.Dispose()
conn.Dispose()
conn.Close()
End Try
If Cbb_Employee.Items.Count > 0 Then
Cbb_Employee.SelectedIndex = 0
End If
Private Sub Cbb_Employee_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Cbb_Employee.TextChanged
txt_EmpName.Text = Cbb_Employee.SelectedValue.ToString
btn_AddToChecked.Enabled = True
End Sub结果txt_EmpName.text=System.Data.DataRowView
第二次正常,请问应该如何改?
解决方案 »
- vb MSHFlexGrid 如何放入Command???
- EXCEL导出问题,请教
- VB中Clipboard问题
- vb 打开SQL函数返回的表时 RecordCount返回-1
- 已有写好的程序,怎么改成生成器
- 高报酬寻VB高手做个PARTIME项目 (需要C#知识)
- 200分求高手解决一个难题,在Activex DLL中使用doEvents函数时不知出了原因,造成死锁状况.....
- 怎样使VB执行保存在数据库里的vb语句?
- 动态加载用户控件后不能调用其属性方法的问题。如解决可以用2G的代码做为报答。
- 怎么让数据库里的数据在一个WORD模板的指定位置显示?
- 问一个函数
- 实时错误-1“ffffffff"产生是什么原因
Cbb_Employee.ValueMember = "hr_EngName"
写反了吧
Dim conn As SqlConnection = mConn.SqlConnection
Dim comm As SqlCommand = conn.CreateCommand
Dim sqlDbReader As SqlDataReader
Try
conn.Open()
comm.CommandText = "select hr_EmployeeID,hr_EngName,hr_ChiName,hr_DepartmentEngName,hr_TeamName from v_EmployeeInfo order by hr_EmployeeID " 'where hr_CompanyID in (" & MDIPmain.sysCompanyID & ") and hr_DepartmentID in (" & MDIPmain.sysDepartmentID & ")"
sqlDbReader = comm.ExecuteReader
Dim DBTable As New DataTable
DBTable.Load(sqlDbReader)
Cbb_Employee.DataSource = DBTable
Cbb_Employee.DisplayMember = "hr_EmployeeID"
Cbb_Employee.ValueMember = "hr_EngName"
txt_EmpName.Text = Cbb_Employee.SelectedValue.ToString
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.OkOnly, "錯誤")
Finally
comm.Dispose()
conn.Dispose()
conn.Close()
End Try
If Cbb_Employee.Items.Count > 0 Then
Cbb_Employee.SelectedIndex = 0
End If
下面正常
这样就OK了
Dim conn As SqlConnection = mConn.SqlConnection
Dim comm As SqlCommand = conn.CreateCommand
Dim sqlDbReader As SqlDataReader
Try
conn.Open()
comm.CommandText = "select hr_EmployeeID,hr_EngName,hr_ChiName,hr_DepartmentEngName,hr_TeamName from v_EmployeeInfo order by hr_EmployeeID " 'where hr_CompanyID in (" & MDIPmain.sysCompanyID & ") and hr_DepartmentID in (" & MDIPmain.sysDepartmentID & ")"
sqlDbReader = comm.ExecuteReader
Dim DBTable As New DataTable
DBTable.Load(sqlDbReader)
Cbb_Employee.DataSource = DBTable
Cbb_Employee.DisplayMember = "hr_EmployeeID"
Cbb_Employee.ValueMember = "hr_EngName"
txt_EmpName.Text = Cbb_Employee.SelectedValue.ToString
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.OkOnly, "錯誤")
Finally
comm.Dispose()
conn.Dispose()
conn.Close()
End Try
If Cbb_Employee.Items.Count > 0 Then
Cbb_Employee.SelectedIndex = 0
End If
下面正常
这样就OK了
Dim conn As SqlConnection = mConn.SqlConnection
Dim comm As SqlCommand = conn.CreateCommand
Dim sqlDbReader As SqlDataReader
Try
conn.Open()
comm.CommandText = "select hr_EmployeeID,hr_EngName,hr_ChiName,hr_DepartmentEngName,hr_TeamName from v_EmployeeInfo order by hr_EmployeeID " 'where hr_CompanyID in (" & MDIPmain.sysCompanyID & ") and hr_DepartmentID in (" & MDIPmain.sysDepartmentID & ")"
sqlDbReader = comm.ExecuteReader
Dim DBTable As New DataTable
DBTable.Load(sqlDbReader)
Cbb_Employee.DataSource = DBTable
Cbb_Employee.DisplayMember = "hr_EmployeeID"
Cbb_Employee.ValueMember = "hr_EngName"
txt_EmpName.Text = Cbb_Employee.SelectedValue.ToString
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.OkOnly, "錯誤")
Finally
comm.Dispose()
conn.Dispose()
conn.Close()
End Try
If Cbb_Employee.Items.Count > 0 Then
Cbb_Employee.SelectedIndex = 0
End If
Private Sub Cbb_Employee_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Cbb_Employee.TextChanged
txt_EmpName.Text = Cbb_Employee.SelectedValue.ToString
btn_AddToChecked.Enabled = True
End Sub 这样就OK了