Many developers use ASP.NET with MySQL with their applications. If you use ASP.NET hosting services and some of the .NET stack as VB.NET or C# then you could connect to the MySQL database using ODBC .net data provider.
Connect to MysQL database using C# using ASP.NET hosting
OdbcConnection cn = new OdbcConnection(“Driver={MySQL ODBC ODBC 5.2a Driver};Server=localhost or remote;Database=test;User=user;Password=pass;Option=3;”);
OdbcCommand cmd …
How to programmatically set the TextBox value and get the TextBox value in ASP.NET in VB.NET
The next example uses a test.aspx page named SetAndGetTextBox.aspx which has two asp:Label controls and one asp:TextBox control. In the code behind the local string variable value is use to read in it the system date and time by using:
Value = DateTime.Now.ToString
The rows in bold show how value is used to set the TextBox and how …
How to apply CSS style in the Label control from code-behind in ASP.NET in VB.NET
You can apply CSS style from code behind by accessing the properties of the control with the help of its Id. Most of the CSS styles can be applied using the Font property and its sub properties of the Label control. However you can use ForeColor and BackColor directly from the Label control.
TestApplyCSS.aspx
<%@ Page …
How to change the text of the Label control from the code-behind in VB.NET
TestPage (.aspx)
<%@ Page Language=”vb” AutoEventWireup=”false” CodeBehind=”TestPage.aspx.vb” Inherits=”TestChange.TestPage” %>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=”https://www.w3.org/1999/xhtml”>
<head runat=”server”>
<title>Change the text of the Label control from the code-behind</title>
</head>
<body>
<form id=”form1″ runat=”server”>
<div>
<asp:Label ID=”LabelTest” runat=”server” Text=”My test label”></asp:Label>
</div>
</form>
</body>
</html>
Test page code-behind (.vb)
‘
‘TestPage.apsx.vb
‘
Public Class TestPage
Inherits System.Web.UI.Page
Protected Sub …
Software developer can interact with session state using the System.Web.SessionState.HttpSessionState class, which is provided in an ASP.NET web page as the built-in Session object. Items can be added to the collection and retrieved after in the same manner as items can be added to a page’s view state:
For example, software developer might store a …
How to transfer information between pages in ASP.NET using a query string in VB.NET.
Software developer can use this approach for information that don’t need to be hidden or made tamper-prof. Unlike view state information passed through the query string is clearly visible and unencrypted. The query string is the portion of the URL after the question mark in the following example:
https://www.google.com?q=look+for+aspnet+code
Software developer can store information in the query string himself using …
How to transfer information between pages in ASP.NET using cross-page posting in VB.NET
Software developer can transfer information between pages with technique named cross-page posting. If he wants to do use it he has to define specific, limited methods that extract just the information he need it. Let’s for example he have a page with text boxes as controls for credit card. In this case software developer might decide to add …
Software developer can store custom objects in a view state just as easily as regular types. However, to store an item in a view state, ASP.NET must be able to convert it into a stream of bytes. This process is called serialization. If developer’s objects aren’t serializable, he will receive an error message when he attempts to place …
You can put the focus on the following types of ASP.NET controls: Button, LinkButton, and ImageButton controls, CheckBox control, DropDownList control, FileUpload control, HyperLink control, ListBox control, RadioButton control, TextBox control.
The following VB.NET code example shows how to set the focus on the control with the ID TextBox1:
Protected Sub Page_Load(ByVal sender As Object, _ ByVal e As System.EventArgs) …
How to preserve member variables for an ASP.NET page in VB.NET
Software developers can follow the next basic principle. They can save all member variables to view state when the Page.PreRender event occurs and retrieve them when the Page.Load event occurs. The Page.Load event happens every time the page is created. In case of a postback, the Load event occurs first, followed by any other control events. The next …