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
Ïà¹ØÎĵµ£º
C# ASP.NETÀï@µÄÃîÓÃ
ASP.NET C# string ×Ö·û´®µÄÇ°Ãæ¿ÉÒÔ¼Ó @ ¿ÉÒÔ½«×ªÒå×Ö·û£¨\£©µ±×÷ÆÕͨ×Ö·û¶Ô´ý¡£
±ÈÈ磺string str = @"C:\Windows";
Èç¹ûÎÒÃDz»Óà @ µÄ»°£¬Ó¦¸ÃÊÇ£ºstring str = "C:\\Windows";
@ ×Ö·û´®ÖУ¬ÎÒÃÇÓÃÁ½¸öÁ¬ÐøÓ¢ÎÄË«ÒýºÅ±íʾһ¸öÓ¢ÎÄË«ÒýºÅ£¬ÈçÏÂ×Ö·û´®µÄʵ¼ÊÄÚÈÝΪ£º="=£¬×Ö·û´®³¤¶ÈΪ 3 ......
ÐèÇó£º
AÓòÓÐÒ³Ãæa.html£¬ÆäÖÐÓÐiframe°üº¬BÓòµÄÒ³Ãæb.html£¬ÏÖÔÚҪͨ¹ýa.htmlÉϵÄÒ»¸ö°´Å¥£¬À´°Ña.htmlÒ³ÃæÉÏÒ»¸öÎı¾¿òµÄÖµ´«µÝµ½b.htmlÒ³ÃæµÄÎı¾¿ò¡£
×¢£ºÕâÀïb.htmlÊÇhtmlÍøÒ³£¬²»ÄܽÓÊÕÆäËûÍøÕ¾post¹ýÀ´µÄÖµ£¬ËùÒÔ²»ÄÜÓÃÖ±½ÓpostµÄ·½·¨À´´«Öµ£¬µ«ÊÇ£¬Èç¹û½ÓÊÕÒ³ÃæÊÇb.aspx»òÕßb.asp ÄØ£¬ÄDz»ÊÇ¿ÉÒÔÖ±½ÓpostÁËô£¿´ð ......
Javascript ÔÚASP.net ĸ°åҳϷÃÎÊ ¿Ø¼þID£º
¶ÔÓÚ html control : Ö±½Ó·ÃÎÊID
document.getElementById("hfRespondID");
¶ÔÓÚ Web control :
document.getElementById("<%= this.hfRespondID.ClientID %>") [×¢Òâ´óСд
]
&nb ......
public bool SaveExcel(GridView paramGridView)
{
if (paramGridView.Rows.Count == 0)
{
return false;
}
//´´½¨Excel¶ÔÏó
Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Appl ......
µÚÒ»²½£ºÀýÈçÓû§¿Ø¼þ·ÅÔÚMyList.Ascx£¬È»ºóÆäControlÖ¸ÁîÊÇ£º
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ViewComment.ascx.cs" Inherits="Control_ViewComment"%>
ÕâʱºòÒѾÓÐÁËInherits£¬×Ô´øÁËClassName¾ÍÊÇÆäÃû³Æ£¬Èç¹ûûÓУ¬Ôò±ØÐë´´½¨ClassNameÊôÐÔ¡£
¼ÙÉèÆäÓй«¹²ÊôÐÔID¡£
µÚ¶þ²½£ ......