web 2.0

ASP.NET(vb.net) & MySQL Random Rows Record

ASP.NET(vb.net) & MySQL Random Rows Record - This isĀ  example scripts how to use ASP.NET random rows data or record from MySQL database.

ShotDev Focus:
- ASP.NET(vb.net) & MySQL Random Rows Record



<%@ import Namespace="System.Data" %>
<%@ import Namespace="MySql.Data.MySqlClient" %>
<%@ Page Language="VB" %>
<script runat="server">

Dim objConn As MySqlConnection
Dim objCmd As 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 MySqlConnection(strConnString)

End Sub

Sub BindData()
Dim strSQL As String
strSQL = "SELECT * FROM customer ORDER BY RAND() LIMIT 0,2"

Dim dtReader As MySqlDataReader
objCmd = New MySqlCommand(strSQL, objConn)
dtReader = objCmd.ExecuteReader()

'*** BindData to Repeater ***'
myRepeater.DataSource = dtReader

dtReader = Nothing

End Sub

Sub Page_UnLoad()
objConn = Nothing
End Sub

<title>ShotDev.Com Tutorial</title>
<form id="form1" runat="server">
<asp:Repeater id="myRepeater" runat="server">
<table border="1">
<td align="center"><asp:Label id="lblCustomerID" runat="server" Text='<%#Container.DataItem("CustomerID") %>'></asp:Label></td>
<td><asp:Label id="lblName" runat="server" Text='<%#Container.DataItem("Name") %>'></asp:Label></td>
<td><asp:Label id="lblEmail" runat="server" Text='<%#Container.DataItem("Email") %>'></asp:Label></td>
<td align="center"><asp:Label id="lblCountryCode" runat="server" Text='<%#Container.DataItem("CountryCode") %>'></asp:Label></td>
<td align="right"><asp:Label id="lblBudget" runat="server" Text='<%#Container.DataItem("Budget") %>'></asp:Label></td>
<td align="right"><asp:Label id="lblUsed" runat="server" Text='<%#Container.DataItem("Used") %>'></asp:Label></td>


ASP.NET(vb.net) & MySQL Random Rows Record
Download this script.

1 Star2 Stars3 Stars4 Stars5 Stars6 Stars7 Stars8 Stars9 Stars10 Stars (No Ratings Yet)
Loading ... Loading ...

Leave a Reply

You must be logged in to post a comment.