ÊÖ°ÑÊÖ½ÌÄã×öASP.NETÁôÑÔ±¾
ûÓÐÏëµ½ÕæµÄÕâô·½±ã!¸ü¼Ó¼á¶¨ÎÒѧϰASP.NETµÄ¾öÐÄ! ÏÖÔÚÎÒÃÇÒ»ÆðÀ´¿´¿´°É
1,ÇëÈ·¶¨ÄãµÄµçÄÔ°²×°ÁËÒÔϵÄÈí¼þ£¡
1.1£¬ WINDWOS 2000ÒÔÉÏ°æ±¾(±Ø×°)
1.2£¬ .NET Framework(±Ø×°)
1.3£¬ Visual Studio .NET 2005(±Ø×°)
2,½¨Á¢Ò»¸öACCESSÊý¾Ý¿â,
3,Í϶¯VS2005 µÄGRIDVIEW µ½Éè¼ÆÒ³Ãæ
4.¸ÄÔ´´úÂë
4.1 ÔÚASPX´úÂëÎļþµÄÍ·²¿£¬Ìí¼Ó²Ù×÷Êý¾Ý¿âÒªÓõ½µÄÃüÃû¿Õ¼ä£º
using System.Data.OleDb;
4.2 ÔÚaspxµÄ[Éè¼Æ]ÊÓͼÖУ¬ÉùÃ÷³ÉÔ±myConnection£º
[¸´ÖƵ½¼ôÌù°å]
CODE:
protected OleDbConnection myConnection=new OleDbConnection ();
4.3 µÚÒ»²½£¬½øÐÐÊý¾Ý¿âµÄÁ´½Ó
[¸´ÖƵ½¼ôÌù°å]
CODE:
string strConn= "Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+Server.MapPath("SOCUT.mdb");
OleDbConnection myConnection=new OleDbConnection ();
myConnection.ConnectionString =strConn;
µÚ¶þ²½£¬Ö´ÐÐSQLÖ¸Áѡ³ö¼Ç¼¼¯ºÏ
[¸´ÖƵ½¼ôÌù°å]
CODE:
string strCommand="Select * from Socut_Guest ORDER BY time DESC";
OleDbDataAdapter da=new OleDbDataAdapter(strCommand,myConnection);
DataSet ds=new DataSet();
da.Fill(ds,"scores");
µÚÈý²½£¬½«Êý¾Ý¼¯ºÏͬDataGrid½áºÏÔÚÒ»Æð
[¸´ÖƵ½¼ôÌù°å]
CODE:
GridView1.DataSource=ds.Tables["scores"].DefaultView ;
GridView1.DataBind ();
5. ÏÖÔÚä¯ÀÀÒ»ÏÂÕâ¸öÎļþ¿´¿´,ÊDz»ÊÇ¿ÉÒÔ¶Á³öÊý¾Ý¿âµÄÄÚÈÝÁË.? µ±È». ¹þ¹þ Ì«¼òµ¥ÁË.
6. ʵÏÖÁôÑÔ¹¦ÄÜ
6.1 н¨Ò»¸öÎļþ ¼ÓÈë4.1 & 4.2µÄ´úÂëÔÚÎļþÏàÓ¦µÄλÖÃ!
6.2Ë«»÷“ÁôÑÔ”°´Å¥£¡
Ìí¼ÓÒÔϲåÈëÊý¾ÝʱÐèÒªµ÷ÓõĴúÂë
[¸´ÖƵ½¼ôÌù°å]
CODE:
String SQL,ConnStr;
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+Server.MapPath("SOCUT.mdb");
SQL = "Insert I
Ïà¹ØÎĵµ£º
101.ÔÚ.net£¨c# or vb.net£©ÖÐÈçºÎÈ¡ÏûÒ»¸ö´°ÌåµÄ¹Ø±Õ¡£
´ð£ºprivate void form1_closing(object sender, system.componentmodel.canceleventargs e)
{
e.cancel=true;
}
......
CheckBoxÑ¡Ôñ×é¼þÊÇÒ»¸ö³ÌÐòÖж¼¾³£µÄ×é¼þ¡£ÔÚ³ÌÐòÉè¼ÆÖÐʹÓõ½¸Ã×é¼þ£¬Ò»°ã¶¼²»»áֻʹÓõ½Ò»¸ö£¬ÍùÍùÊÇÒÔ¶à¸ö´ËÀà×é¼þµÄÐÎʽ³öÏֵġ£ÔÚASP.NETÒ³ÃæÖÐÈç¹ûҪʹÓõ½¶à¸öCheckBox×é¼þ£¬³ýÁËÌí¼Ó¶à¸öCheckBox×é¼þÔÚÒ³ÃæÖÐÖ®Í⣬»¹ÓÐÒ»ÖֱȽϷ½±ãµÄ·½·¨£¬¾ÍÊÇʹÓÃCheckBoxList ×é¼þ¡£CheckBoxList×é¼þÊÇÓÉÒ»×éµÄCheckBox×é¼þ×é ......
[±à¼±¾¶Î]
ʲôÊÇ ASP£¿
¡¡¡¡ASP ÊÇÒ»ÖÖʹǶÈëÍøÒ³ÖеĽű¾¿ÉÓÉÒòÌØÍø·þÎñÆ÷Ö´ÐеķþÎñÆ÷¶Ë½Å±¾¼¼Êõ¡£
¡¡¡¡ASP ÊÇÒ»Ïî΢Èí¹«Ë¾µÄ¼¼Êõ
¡¡¡¡ASP Ö¸ Active Server Pages£¨¶¯Ì¬·þÎñÆ÷Ò³Ã棩
¡¡¡¡ASP ÊÇÔËÐÐÓÚ IIS Ö®ÖеijÌÐò
¡¡¡¡IIS Ö¸ Internet Information Services£¨ÒòÌØÍøÐÅÏ¢·þÎñ£©
¡¡¡¡IIS ÊÇ Windows 2000 À ......
ÕâÁ½ÌìÊìϤ¹«Ë¾µÄÍøվǰ̨ºÍºǫ́µÄÊý¾Ý½á¹¹ºÍÒµÎñÂß¼£¬¿´µ½Ðí¶à¹¤³Ì϶¼ÓÐÒ»¸ö½Ð“Base”µÄÎļþ¼Ð£¬ÀïÃæÓÐһϵÁдø“***.Generated.cs”µÄÎļþ£¨±ÈÈçBulletin.Generated.cs£©¡£¶®µã±à³Ì֪ʶºÍÓ¢ÓïµÄÈ˶¼Ó¦¸Ã»áÏëµ½ÕâÊÇÓÃʲô¹¤¾ß×Ô¶¯Éú³ÉµÄ°É£¿ÒÔÇ°ÎÒÒ²ÖªµÀC#Óиù¾ÝÄ£°å×Ô¶¯ ......
----´´½¨Ò»¸öÖ»ÓÐÊäÈë²ÎÊýµÄ´æ´¢¹ý³Ì
create procedure proc_user
@name varchar(20),
@Password varchar(100)
as
select * from loginuser
where name like @name
---´´½¨Ò»¸öÓÐÊäÈëºÍÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì
create procedure proc_usertext
@name varchar(20),
@blog varchar(100) output
as
select @blog = ......