ASP.NET(vb.net) & SQL Server Connect to Database - This how to learn use ASP.NET web application connect to SQL Server database and using System.Data.SqlClient
ShotDev Focus:
- ASP.NET(vb.net) & SQL Server Connect to Database
Example
AspNetSQLServerConnect.aspx
- <%@ Import Namespace="System.Data"%>
- <%@ Import Namespace="System.Data.SqlClient"%>
- <%@ Page Language="VB" %>
- <script runat="server">
- Dim objConn As SqlConnection
- Dim objCmd As SqlCommand
- Sub Page_Load(sender As Object, e As EventArgs)
- Dim strConnString As String
- strConnString = "Server=localhost;Uid=sa;PASSWORD=;database=mydatabase;Max Pool Size=400;Connect Timeout=600;"
- objConn = New SqlConnection(strConnString)
- objConn.Open()
- If objConn.State = ConnectionState.Open Then
- Me.lblText.Text = "SQL Server Connected"
- Else
- Me.lblText.Text = "SQL Server Connect Failed"
- End IF
- End Sub
- 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:Label id="lblText" runat="server"></asp:Label>
- </form>
- </body>
- </html>
Screenshot
3oriented…
…