Asp.netÁ¬½ÓÊý¾Ý¿â½Ì³Ì£¨vb.net£©
Asp.netÁ¬½ÓSQL Server2000Êý¾Ý¿âÀý³ÌÏê½â:
<%@ 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 Ìí¼Ó¼Í¼
myCommand = New SqlCommand( "Insert into [test] (name,sex) values( '»ÆÖ¾ÎÄ','ÄÐ' )", myConnection )
myCommand.ExecuteNonQuery()
la3.text="New Record Inserted!"
'3 ¸üÐÂÊý¾Ý
myCommand = New SqlCommand( "UPDATE [test] SET name='Smith' where name='ÀîÃ÷'", myConnection )
myCommand.ExecuteNonQuery()
la4.text="Record Updated!"
'4 ɾ³ýÊý¾Ý
myCommand = New SqlCommand( "delete from [test] where name='Smith'", myConnection )
myCommand.ExecuteNonQuery()
la5.text="Record Deleted!"
'5 ÓÃDataGridÏÔʾÊý¾Ý
myComma
Ïà¹ØÎĵµ£º
WebÀï¼ÓÈë<sessionState cookieless="false" mode="StateServer" timeout="60" stateNetworkTimeout="3600" sqlCommandTimeout="3600"/>ºó±ØÐ루cmdÀïÔËÐÐ:Net Start aspnet_state£©²Å¿ÉÒÔÉèÖÃsessionÖµ¡£
ÕâÒ»¶Î¾ÍÊÇÅäÖÃÓ¦ÓóÌÐòÊÇÈçºÎ´æ´¢SessionÐÅÏ¢µÄÁË¡£ÎÒÃÇÒÔϵĸ÷ÖÖ²Ù×÷Ö÷ÒªÊÇÕë¶ÔÕâÒ»¶ÎÅäÖÃÕ¹ ......
SQL½Å±¾£º
CREATE TABLE tblBooksUpload
(
¡¡DocID int NOT NULL IDENTITY Primary Key ,
¡¡DocTitle varchar (200) ,
¡¡Doc image,
¡¡DocType varchar (50) ,
¡¡Entrydate datetime Default GetDate()
)
Ê×ÏÈÎÒÃÇҪʵÏÖÓû§ÔÚä¯ÀÀÆ÷¶Ë×ÔÓÉÑ¡ÔñÎļþ£¬È»ºóÉÏ´«£¬ÕâÀïÓû§Ñ¡ÔñÎļþ£¬µ±È»ÊÇÒªÇó±ê×¼µÄWindows·½Ê½£ ......
ÔÚasp.net ʹÓÃÊý¾Ý¼¯Éè¼ÆÆ÷ ·ÃÎÊÊý¾ÝÖÐ˵¹ý£¬ÒªÊ¹Insert,Update,Delete²éѯ¿ÉÓ㬱ØÐëɾ³ýObjectDataSource¶ÔÏó
ÊôÐÔDataObjectTypeNameµÄÖµ¡£ÏÂÃæҪ˵µÄÊÇ£¬ÔÚ²»É¾³ý¸ÃÖµÏÂʹ²éѯ¿ÉÓõķ½·¨¡££¨ÓÉÓÚ֮ǰÔÚɾ³ý
DataObjectTypeNameºóInsert,Update,Delete²éѯһֱµ÷ÊÔ²»³É¹¦£¬ÓÚÊǵ®ÉúÁËÈçÏÂʹÓ÷½·¨¡££©
Óëasp.net Ê¹Ó ......