《VBnet连接MySQL数据库方法》由会员分享,可在线阅读,更多相关《VBnet连接MySQL数据库方法(2页珍藏版)》请在金锄头文库上搜索。
1、VB.net操作MySQ数据库方法1.连接数据库1下载 Connector/Net: :/dev.mysql /downloads/connector/net/2安装 Connector/Net.3在 VB.net 工程中,选择 Project-Add Reference 菜单,添力口 MySQl.data 引用,如下列图所示:4在需要连接数据的文件中添加一行,以翻开 namespaceImports MySql.data.MySqlClient5创立一个数据库连接m_strConnection =server=127.0.0.1;uid=root;pwd=12345;database=com
2、puter; pooling=false m_SqlConn = New MySqlConnectionm_strConnection2. 显示数据1) 创立一个数据库适配器Dim strQuery As String = select * from ProductDim daAdapter As MySqlDataAdapter = New MySqlDataAdapter(strQuery, m_SqlConn)2) 创立一个Datatable ,用数据库适配器来填充datatableDim dsTable As DataTable = New DataTable(strDataset)
3、daAdapter.Fill(dsTable)3) 绑定 datatable 到 DataGrid 控件dbGridShow.SetDataBinding(dsTable, )dbGridShow.Visible = True3. 获取表中的某一行某一列 获得指定行Dim CurRow As Integer CurRow = dbGridShow.CurrentRowIndexDim tbl As DataTable = dbGridShow.DataSourceDim Row As DataRow = tbl.DefaultView(CurRow).Row根据当前选定的行得到 Delete操
4、作的SQL语句 Dim strDelete As StringstrDelete = delete from T_Bars where name = + Row(name) + 4. 修改或删除数据 定义操作的SQL 语句Dim strSql As StringstrSql = insert into Product(maker,model,type) values。) 创立SqlCommand 对象Dim myCommand As MySqlCommand = New MySqlCommand(strInsertCommand, m_SqlConn) 执行操作m_SqlConn.Open()nRows = myCommand.ExecuteNonQuery()