注册 登录
编程论坛 VB.NET论坛

VB.net已知图书数据库,表名为book,编程实现按书名查询的应用程序

伊水流云 发布于 2013-06-14 11:11, 685 次点击
求大神帮忙
1 回复
#2
琴瑟萧弦2013-06-17 18:46
ACCESS数据库 的代码如下:   

        Dim xm1 As String
        xm1 = TextBox1.Text
        Dim strcon As String
        strcon = "provider=microsoft.jet.oledb.4.0;data source=" & Server.MapPath("数据库名称")
        Dim conn As New OleDbConnection(strcon)
        Dim cmd As New OleDbCommand("select * from book where 此处为书名在数据库表中的字段名 = '%" & xm1 & "%' ", conn)
        conn.Open()

        Dim dr As OleDbDataReader = cmd.ExecuteReader()
        GridView1.DataSource = dr
        GridView1.DataBind()
        conn.Close()
1