跪求大佬!!帮忙,vb编程连接到数据库,adapter.fill为什么会出错???

MCOLF MCOLF 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
代码如下
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
...全文

相关推荐

评论 4
收藏 已收藏
分享
返回顶部
MCOLF
VB基础类 7,788 成员 197,583 内容