asp.net connect SQL database instance Basics Tutorial

Asp.net| Basic Tutorials | Tutorials |sql Database

The following code demonstrates how to use ASP.net to connect to a SQL server2000 database and manipulate code instances to share with asp.net beginners.

asp.net basic tutorial, connecting SQL Server2000 database Instance Code analysis:

The following is the code content: <%@ Import namespace= "System.Data"%> <%@ Import namespace= "System.Data.SqlClient"%> <script laguage= "VB" runat= "Server" > Sub Page_Load (sender as object,e as EventArgs) Dim MyConnection as SqlConnection Dim MyCommand as SqlCommand Dim DS as DataSet ' 1.connect to SQL Server MyConnection = New SqlConnection ("Server=localhost;database=pubs;uid=ueytjdf;pwd=doekdf") Myconnection.open () la1.text= "Connection opened!" ' 2.Create a table mycommand = New SqlCommand ("CREATE TABLE [test] ([ID] [int] IDENTITY (1, 1) not NULL, [name] [Char] (a) COLLATE chinese_prc_ci_as null, [sex] [char] (a) COLLATE chinese_prc_ci_as null ) ", MyConnection) Mycommand.executenonquery () la2.text= "New table created!" ' 2 Add record mycommand = New SqlCommand ("Insert into [test] (Name,sex) VALUES (' Huang Zhiwen ', ' Men ')", MyConnection) Mycommand.executenonquery () la3.text= "New record inserted!" ' 3 Update data mycommand = New SqlCommand ("UPDATE [test] SET name= ' Smith ' where Name= ' Li Ming '", MyConnection) Mycommand.executenonquery () la4.text= "Record updated!" ' 4 Delete data mycommand = New SqlCommand ("delete from [test] where name= ' Smith '", MyConnection) Mycommand.executenonquery () la5.text= "Record deleted!" ' 5 displaying Data in a DataGrid mycommand = New SqlCommand ("SELECT * FROM [Test]", MyConnection) Mydatagrid.datasource=mycommand.executereader () Mydatagrid.databind () End Sub </script> <body> <asp:label id= "LA1" runat= "Server"/><br> <asp:label id= "LA2" runat= "Server"/><br> <asp:label id= "LA3" runat= "Server"/><br> <asp:label id= "LA4" runat= "Server"/><br> <asp:label id= "LA5" runat= "Server"/><br> <asp:datagrid id= "Mydatagrid" runat= "Server" Bordercolor= "BLACK" Borderwidth= "1" Gridlines= "Both" Cellpadding= "3" cellspacing= "0" Font-name= "Verdana" Font-size= "10pt" Headerstyle-backcolor= "#aaaadd" Alternatingitemstyle-backcolor= "#eeeeee" > </asp:DataGrid> </body> -->