跪求大佬!!帮忙,vb编程连接到数据库,adapter.fill为什么会出错???
代码如下
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myconn As SqlConnection = New SqlConnection("database = 网上书店数据库;data source =.;integrated security=true;")
Dim mysql As String = "select customercode as 顾客编号,name as 姓名,sex as 性别 ,job as 职业,birthday as 出生日期,hometown as 籍贯,email as 邮箱,telephone as 手机号码,vipclass as 客户等级,loyaltyclass as 客户忠诚度 from customer where name like '%" & TextBox1.Text & "%'"
Dim myadapter As New SqlDataAdapter(mysql, myconn)
Dim mydataset As New DataSet
myadapter.Fill(mydataset, "customer")
DataGridView1.DataSource = mydataset.Tables(0)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myconn As SqlConnection = New SqlConnection("database = 网上书店数据库;data source =.;integrated security=true;")
Dim mysql As String = "select customercode as 顾客编号,name as 姓名,sex as 性别 ,job as 职业,birthday as 出生日期,hometown as 籍贯,email as 邮箱,telephone as 手机号码,vipclass as 客户等级,loyaltyclass as 客户忠诚度 from customer where name like '%" & TextBox1.Text & "%'"
Dim myadapter As New SqlDataAdapter(mysql, myconn)
Dim mydataset As New DataSet
myadapter.Fill(mydataset, "customer")
DataGridView1.DataSource = mydataset.Tables(0)
End Sub
...全文
相关推荐
vb.net连接数据库并对数据库进行常用操作示例
在VB.NET编程环境中,连接和操作数据库是常见的任务,这对于开发任何数据驱动的应用程序都是至关重要的。
vb.net连接SQLServer数据库
在VB.NET编程环境中,连接和操作SQL Server数据库是一项常见的任务,尤其在开发企业级应用程序时。
VB.NET数据库编程基础教程.doc
VB.NET数据库编程主要依赖于.NET Framework SDK中的ADO.NET框架,这是一个强大的数据访问接口,用于连接和操作各种数据库,包括SQL Server和通过OLE DB兼容的数据源。
VB.net数据库编程基础
VB.NET数据库编程主要依赖于ADO.NET,这是一个在.NET Framework SDK中的关键组件,专门用于处理数据库交互。
VB.NET读写ACCESS数据库类
使用这个类,你可以轻松地在VB.NET项目中读写ACCESS数据库,例如:```vbnetDim db As New AccessDatabase("C:\path\to\your\db.mdb")Dim


VB基础类
