asp.net|server| Data | All right, here's a routine about ASP.net connection to the SQL Server2000 database.
Here to share with you:
asp.net connection SQL Server2000 database routines Detailed:
<%@ 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>
