汉潮
Post By：2013-2-28 14:26:00 [只看该作者]
你好，我是EM9000的用户，我在使用过程中出现了些问题，想请教一下
下面的代码是在VB.net2005平台上开发的程序中的一部分，当软件在运行时，会随机出错，开发平台弹出
“未处理的System.Data.SqlServerCe.SqlCeException类型的异常出现在System.Data.SqlServerCe.dll 中”
请问是怎么回事，谢谢
Dim connString As String
c
Dim int_auto_id As Integer
int_auto_id = 1
Dim Sl_di_query As String = "SELECT * FROM directory_inquiries"
Dim Sl_di_conn As New Data.SqlServerCe.SqlCeConnection(connString)
Dim Sl_di_cmd As New Data.SqlServerCe.SqlCeCommand(Sl_di_query, Sl_di_conn)
Sl_di_conn.Open()
Dim Sl_di_rdr As Data.SqlServerCe.SqlCeDataReader = Sl_di_cmd.ExecuteReader()
Try
While Sl_di_rdr.Read()
str_auto_id = CStr(int_auto_id)
int_auto_id = int_auto_id + 1
str_address = CStr(Sl_di_rdr.Item("address"))
str_address_id = CStr(Sl_di_rdr.Item("address_id"))
load_listviewitem = New ListViewItem()
load_listviewitem.Text = str_auto_id
load_listviewitem.SubItems.Add(str_address)
load_listviewitem.SubItems.Add(str_address_id)
address_listview.Items.Add(load_listviewitem)
End While
Catch ex As Data.SqlServerCe.SqlCeException
MessageBox.Show(ex.ToString)
Finally
Sl_di_rdr.Close()
Sl_di_conn.Close()
End Try
下面的代码是在VB.net2005平台上开发的程序中的一部分，当软件在运行时，会随机出错，开发平台弹出
“未处理的System.Data.SqlServerCe.SqlCeException类型的异常出现在System.Data.SqlServerCe.dll 中”
请问是怎么回事，谢谢
Dim connString As String
c
Dim int_auto_id As Integer
int_auto_id = 1
Dim Sl_di_query As String = "SELECT * FROM directory_inquiries"
Dim Sl_di_conn As New Data.SqlServerCe.SqlCeConnection(connString)
Dim Sl_di_cmd As New Data.SqlServerCe.SqlCeCommand(Sl_di_query, Sl_di_conn)
Sl_di_conn.Open()
Dim Sl_di_rdr As Data.SqlServerCe.SqlCeDataReader = Sl_di_cmd.ExecuteReader()
Try
While Sl_di_rdr.Read()
str_auto_id = CStr(int_auto_id)
int_auto_id = int_auto_id + 1
str_address = CStr(Sl_di_rdr.Item("address"))
str_address_id = CStr(Sl_di_rdr.Item("address_id"))
load_listviewitem = New ListViewItem()
load_listviewitem.Text = str_auto_id
load_listviewitem.SubItems.Add(str_address)
load_listviewitem.SubItems.Add(str_address_id)
address_listview.Items.Add(load_listviewitem)
End While
Catch ex As Data.SqlServerCe.SqlCeException
MessageBox.Show(ex.ToString)
Finally
Sl_di_rdr.Close()
Sl_di_conn.Close()
End Try
