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
Ïà¹ØÎĵµ£º
ÔÚÔçÆÚµÄASP.NET¿ò¼ÜÖУ¬Èç¹ûÄã·ÅÖÃÒ»¸ö¿Ø¼þÔÚÒ»¸öÈÝÆ÷ÖУ¬ÈçGridViewÄ£°åÁС¢µÇ¼ģ°å¡¢ÆäËü£¬ÔÚÔËÐÐʱÕâЩ¿Ø¼þµÄID½«±»Ìæ»»ÓÉASP.NET×ÔÉí²úÉúµÄËæ»úΨһID¡£
Ϊ¿ª·¢ÕßÌṩ·þÎñ·½·ÃÎʿؼþµÄPage.FindControl("controlid")ÒÔ¼°JavaScriptÖÐʹÓà µÄdocument ......
ǰǰºóºóÊÕµ½¹ýһЩѧÉúµÄÀ´ÐÅ£¬Ñ¯ÎÊASP.NETµÄѧϰ˳ÐòÎÊÌ⣬Ôڴ˾ÍÏò´òËãϵͳѧϰASP.NET¼¼ÊõµÄ³õѧÕß̸̸ÎҵĽ¨Òé¡£
Èç¹ûÄãÒѾÓн϶àµÄÃæÏò¶ÔÏ󿪷¢¾Ñé£¬Ìø¹ýÒÔÏÂÕâÁ½²½£º
µÚÒ»²½¡¡ÕÆÎÕÒ»ÃÅ.NETÃæÏò¶ÔÏóÓïÑÔ£¬C££»òVB.NET¡£
ÎÒÇ¿ÁÒ·´¶ÔÔÚûϵͳѧ¹ýÒ»ÃÅÃæÏò¶ÔÏó£¨OO£© ......
SQL½Å±¾£º
CREATE TABLE tblBooksUpload
(
¡¡DocID int NOT NULL IDENTITY Primary Key ,
¡¡DocTitle varchar (200) ,
¡¡Doc image,
¡¡DocType varchar (50) ,
¡¡Entrydate datetime Default GetDate()
)
Ê×ÏÈÎÒÃÇҪʵÏÖÓû§ÔÚä¯ÀÀÆ÷¶Ë×ÔÓÉÑ¡ÔñÎļþ£¬È»ºóÉÏ´«£¬ÕâÀïÓû§Ñ¡ÔñÎļþ£¬µ±È»ÊÇÒªÇó±ê×¼µÄWindows·½Ê½£ ......
C# ASP.NETÀï@µÄÃîÓÃ
ASP.NET C# string ×Ö·û´®µÄÇ°Ãæ¿ÉÒÔ¼Ó @ ¿ÉÒÔ½«×ªÒå×Ö·û£¨\£©µ±×÷ÆÕͨ×Ö·û¶Ô´ý¡£
±ÈÈ磺string str = @"C:\Windows";
Èç¹ûÎÒÃDz»Óà @ µÄ»°£¬Ó¦¸ÃÊÇ£ºstring str = "C:\\Windows";
@ ×Ö·û´®ÖУ¬ÎÒÃÇÓÃÁ½¸öÁ¬ÐøÓ¢ÎÄË«ÒýºÅ±íʾһ¸öÓ¢ÎÄË«ÒýºÅ£¬ÈçÏÂ×Ö·û´®µÄʵ¼ÊÄÚÈÝΪ£º="=£¬×Ö·û´®³¤¶ÈΪ 3 ......