VB.NET & MySql.Data.MySQLClient - DataAdapter() - How to learn Connector/NET ADO.NET component MySql.Data.MySqlClient namespace is the .NET Framework Data Provider for MySql data source, Using the MySqlDataAdapter set of data commands and a database connection that are used to fill the DataSet and update the data source. (MySQL Server Database)
ShotDev Focus:
- VB.NET & MySql.Data.MySQLClient - DataAdapter()
Example
DataAdapter.aspx
- <%@ Import Namespace="System.Data"%>
- <%@ Import Namespace="MySql.Data.MySqlClient"%>
- <%@ Page Language="VB" %>
- <script runat="server">
- Dim objConn As MySql.Data.MySqlClient.MySqlConnection
- Dim objCmd As MySql.Data.MySqlClient.MySqlCommand
- Sub Page_Load(sender As Object, e As EventArgs)
- Dim strConnString As String
- strConnString = "Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false"
- objConn = New MySql.Data.MySqlClient.MySqlConnection(strConnString)
- objConn.Open()
- BindData()
- End Sub
- Sub BindData()
- '*** DataAdapter & DataTable ***'
- 'myRepeater.DataSource = CreateDataTable()
- 'myRepeater.DataBind()
- '*** DataAdapter & DataSet ***'
- myRepeater.DataSource = CreateDataSet.Tables(0).DefaultView
- myRepeater.DataBind()
- End Sub
- '*** DataAdapter & DataTable ***'
- Function CreateDataTable() As DataTable
- Dim objConn As New MySql.Data.MySqlClient.MySqlConnection
- Dim dtAdapter As MySql.Data.MySqlClient.MySqlDataAdapter
- Dim dt As New DataTable
- Dim strConnString As String
- strConnString = "Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false"
- objConn = New MySql.Data.MySqlClient.MySqlConnection(strConnString)
- objConn.Open()
- Dim strSQL As String
- strSQL = "SELECT * FROM customer"
- dtAdapter = New MySql.Data.MySqlClient.MySqlDataAdapter(strSQL, objConn)
- dtAdapter.Fill(dt)
- dtAdapter = Nothing
- Return dt '*** Return DataTable ***'
- End Function
- '*** DataAdapter & DataSet ***'
- Function CreateDataSet() As DataSet
- Dim objConn As New MySql.Data.MySqlClient.MySqlConnection
- Dim objCmd As New MySql.Data.MySqlClient.MySqlCommand
- Dim dtAdapter As New MySql.Data.MySqlClient.MySqlDataAdapter
- Dim ds As New DataSet
- Dim strConnString,strSQL As String
- strConnString = "Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false"
- strSQL = "SELECT * FROM customer"
- objConn.ConnectionString = strConnString
- With objCmd
- .Connection = objConn
- .CommandText = strSQL
- .CommandType = CommandType.Text
- End With
- dtAdapter.SelectCommand = objCmd
- dtAdapter.Fill(ds)
- dtAdapter = Nothing
- Return ds '*** Return DataSet ***'
- End Function
- Sub Page_UnLoad()
- objConn.Close()
- objConn = Nothing
- End Sub
- </script>
- <html>
- <head>
- <title>ShotDev.Com Tutorial</title>
- </head>
- <body>
- <form id="form1" runat="server">
- <asp:Repeater id="myRepeater" runat="server">
- <HeaderTemplate>
- <table border="1">
- <tr>
- <th>CustomerID</th>
- <th>Name</th>
- <th>Email</th>
- <th>CountryCode</th>
- <th>Budget</th>
- <th>Used</th>
- </tr>
- </HeaderTemplate>
- <ItemTemplate>
- <tr>
- <td align="center"><%#Container.DataItem("CustomerID") %></td>
- <td><%#Container.DataItem("Name") %></td>
- <td><%#Container.DataItem("Email") %></td>
- <td align="center"><%#Container.DataItem("CountryCode") %></td>
- <td align="right"><%#Container.DataItem("Budget") %></td>
- <td align="right"><%#Container.DataItem("Used") %></td>
- </tr>
- </ItemTemplate>
- </asp:Repeater>
- </form>
- </body>
- </html>
Screenshot