system.data.dll附加信息中出现未处理的'system.data.oledb.oledbexception'类型的异常:没有给出一个或多个必需参数的值。 [英] An unhandled exception of type 'system.data.oledb.oledbexception' occurred in system.data.dll additional information: no value given for one or more required parameters.
问题描述
Private Sub Admissionrecord_Load(sender As Object,e As EventArgs)处理MyBase.Load
'TODO:这行代码将数据加载到'ButhdatabaseDataSet.Admission'表中。您可以根据需要移动或移除它。
OpenConnection()
Dim da As OleDbDataAdapter
Dim dt As DataTable
da =新OleDbDataAdapter(选择医院否,患者姓名,出诊日期,退休者,顾问,病房,出院日期,出院时间,出院情况,入院时出院情况,连接)
dt =新数据表
da.Fill(dt)
AdmissionDataGridView.DataSource = dt
AdmissionDataGridView.Refresh()
Connection.Close()
da.Dispose()
我尝试过:
请帮助我。谢谢
Private Sub Admissionrecord_Load(sender As Object, e As EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'ButhdatabaseDataSet.Admission' table. You can move, or remove it, as needed.
OpenConnection()
Dim da As OleDbDataAdapter
Dim dt As DataTable
da = New OleDbDataAdapter("SELECT Hospital No,Patient's Name,Date Attended,Reffered By,Consultant,Ward,Date Discharged,Discharged To,Condition On Discharge,Discharge Summary FROM Admission", Connection)
dt = New DataTable
da.Fill(dt)
AdmissionDataGridView.DataSource = dt
AdmissionDataGridView.Refresh()
Connection.Close()
da.Dispose()
What I have tried:
please kindly help me with this. thank you
推荐答案
Spaces,我的朋友,空格:
改变这个:
Spaces, my friend, spaces:
Change this:
SELECT Hospital No,Patient's Name,Date Attended,Reffered By,Consultant,Ward,Date Discharged,Discharged To,Condition On Discharge,Discharge Summary FROM Admission
至此:
To this:
SELECT [Hospital No],[Patient's Name],[Date Attended],[Reffered By],[Consultant],[Ward],[Date Discharged],[Discharged To],[Condition On Discharge],[Discharge Summary] FROM Admission
并删除列名中的引号字符......
And remove the quote character from the column name as well...
这篇关于system.data.dll附加信息中出现未处理的'system.data.oledb.oledbexception'类型的异常:没有给出一个或多个必需参数的值。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!