How to connect to MySQL database using ASP.NET hosting

Many developers use ASP.NET with MySQL with their applicaions. If you use ASP.NET hosting services and some of ASP.NET languages as VB.NET or C# then you could connect to the MySQL databse using ODBC .net data provider.

Connect to MysQL database using C# on 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 […]

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.

[…]

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” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<html xmlns=”http://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

How to use session state in ASP.NET using VB.NET

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 […]

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:

http://www.google.com?q=look+for+aspnet+code

Software developer can store information in the query string […]

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 […]

How to store custom objects in a View state using VB.NET

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 […]

How to set focus on control in VB.NET

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 […]

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. […]

Recommended ASP.NET Examples