漢潮
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
