Hello, the following is a routine for connecting Asp.net to the SQL Server2000 Database,
I would like to share with you the following:
Asp.net connection SQL Server2000 data warehouse routine details:
<% @ 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] (10) Collate chinese_prc_ci_as null, [sex] [char] (10) 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 ', 'male ')",
Myconnection)
Mycommand. executenonquery ()
La3.text = "New Record inserted! "
'3 update data
Mycommand = new sqlcommand ("Update [test] Set Name = 'Smith 'Where name = 'lilim'", myconnection)
Mycommand. executenonquery ()
La4.text = "record updated! "
'4 deleting data
Mycommand = new sqlcommand ("delete from [test] Where name = 'Smith '", myconnection)
Mycommand. executenonquery ()
La5.text = "record deleted! "
'5 display data with DataGrid
Mycommand = new sqlcommand ("select * from [test]", myconnection)
Mydatagrid. datasource = mycommand. executereader ()
Mydatagrid. databind ()
End sub
</SCRIPT>
<HTML>
<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>
</Html>
