| 编程中国 | 业界新闻 | 技术文章 | 视频教程 | 下载频道 | 程序源码 | 个人空间 | 编程论坛
全能ASP/PHP/ASP.NET主机,支持月付专业 MSSQL 数据库空间,支持月付专业 MySQL 数据库空间,支持月付买域名,送MP3、MP4
高端软件开发 = 年薪十万不是梦赛孚耐:软件保护加密专家身份认证令牌USB KEY买空间,免费送域名(厦门中资源)
共有 332 人关注过本帖
标题:求助:设计遇到个问题,请高手们帮下忙!
收藏  订阅  推荐  打印 
freedomGD
Rank: 1
等级:新手上路
帖子:1
积分:114
注册:2008-6-4
求助:设计遇到个问题,请高手们帮下忙!

我做了个模糊查询,但运行时总出现"未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。"光标总停在 objda.Fill(objds, "xs"),请高手们告诉我出了什么问题,谢谢!


代码如下:
Public Sub bindgridview(ByVal strXH As String)
        Dim objconn As New OleDb.OleDbConnection
        Dim objda As New OleDb.OleDbDataAdapter
        Dim objcomm As New OleDb.OleDbCommand
        Dim objds As New DataSet
        Dim wherestr As String

objconn.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;data source='C:\Documents and Settings\Administrator\桌面\学生成绩管理系统\XSCJ.mdb'"

objcomm.Connection = objconn
        objda.SelectCommand = objcomm
        Dim builder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(objda)

        objconn.Open()
        objda.Fill(objds, "xs")                   ( 绿光标停在此处)

        objconn.Close()
        DataGrid1.DataSource = objds.Tables("xs")
End Sub


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim wherestr As String
        Dim objds As New DataSet
        wherestr = ""
        If Trim(txtxh.Text) <> "" Then
            wherestr = "Select * form xs where xh like % & Trim(txtxh.Text) & %"
            MsgBox(wherestr)
        End If

        objds.Tables.Clear()           
        bindgridview(WhereStr)

End Sub
搜索更多相关主题的帖子: Microsoft  Dim  New  OleDb  
2008-6-6 14:40
关于我们 | 广告合作 | 编程中国 | 清除Cookies | Archiver | WAP | TOP

编程中国 版权所有,并保留所有权利。鲁ICP备08000592号
Powered by Discuz, Processed in 0.042804 second(s), 9 queries.
Copyright©2004-2008, BCCN.NET, All Rights Reserved