Ò»°ã´î½¨Èý²ã¿ò¼ÜÏîÄ¿ÊÇÕâÑùµÄ:
1¡¢´´½¨Ò»¸ö¿ÕµÄ½â¾ö·½°¸
2¡¢´´½¨Àà¿âÏîÄ¿
3¡¢´´½¨ÍøÕ¾ÏîÄ¿
4¡¢Ìí¼ÓÏîĿ֮¼äµÄÒýÓã¬ÐèҪעÒâµÄÊDZíʾ²ã£¨ÍøÕ¾ÏîÄ¿²ã£©ÊDz»ÐèÒªÌí¼ÓÆäËü²ãÒýÓõģ¬ÒòΪÔËÐк󣬻á×Ô¶¯²úÉú¶ÔÆäËüÏîÄ¿µÄÒýÓÃ
Èý²ã½á¹¹£º
Êý¾Ý·ÃÎʲ㣺Ö÷ҪʵÏÖÊý¾ÝµÄ±£´æºÍ¶ÁÈ¡²Ù×÷¡£
ÒµÎñÂß¼²ã£º³ýÁ˰üº¬ÒµÎñÂß¼Í⣬»¹×÷Ϊ±íʾ²ãºÍÊý¾Ý·ÃÎʲãÖ®¼äͨÐŵÄÇÅÁº£¬¸ºÔðÊý¾ÝµÄ´«µÝºÍ´¦Àí¡£
±íʾ²ã£»ÓÃÓÚÏÔʾÊý¾ÝºÍ½ÓÊÕÓû§ÊäÈëµÄÊý¾Ý£¬ÎªÓû§ÌṩһÖÖ½»»¥Ê½²Ù×÷½çÃæ¡£
Èý²ã½á¹¹µÄÓÅÊÆ£º
ÊÊÓ¦±ä»¯£¬ÀûÓÚά»¤¡£
ÊÊÓÃÓÚÐ×÷¿ª·¢¡£
Ö÷Á÷Ç÷ÊÆ¡£
Ä£ÐͲ㣺
Ä£ÐͲã°üº¬ËùÓÐÓëÊý¾Ý¿âÖеıíÏà¶ÔÓ¦µÄʵÌåÀࡣģÐͲãÌṩÁËÒ»¸ö±ê×¼¹æ·¶£¬Èý²ãÖ®¼äµÄÊý¾Ý´«µÝ¾ÍÊÇͨ¹ý´«ÊäʵÌå¶ÔÏóÀ´´ïµ½Ä¿µÄ¡£ Ò» ......
////½ñÌìÔÚÐ޸ijÌÐòµÄʱºò·¢ÏÖÒ»¸öСµÄÎÊÌâÌØ¼Ç¼ÈçÏÂ:
//////ÓÐʱºòdatetimeÎÞ·¨×ª³Éstring£¬¿ÉÒÔÓÃgetdate()Ö±½Ó²åÈë¾Í¿ÉÒÔÁË
string str = "update adaddress set shenhe=" + ck + " ,shentime=getDate() where id=" + uid + "";
/////////////////////////////////////////
ÒÔϾßÌå½éÉÜÈÕÆÚÔõÑùת»»
DateTime.Now.ToLocalTime().ToString(); // 2009-9-5 20:12:12
//»ñÈ¡ÈÕÆÚ
DateTime.Now.ToLongDateString().ToString(); // 2009Äê9ÔÂ5ÈÕ
DateTime.Now.ToShortDateString().ToString(); // 2009-9-5
DateTime.Now.ToString("yyyy-MM-dd"); // 2009-09-05
DateTime.Now.ToString("yyyyMMddhhmmss"); // 20090905120000¡¡
DateTime.Now.Date.ToString(); // 2009-9-5 0:0 ......
¿ÉÒÔʹÓà SqlDataSource ¿Ø¼þÐÞ¸ÄÊý¾Ý¿âÖеÄÊý¾Ý¡£Ê¹Óøüз½°¸ÖÐµÄ SqlDataSource ¿Ø¼þµÄ×î³£Ó÷½·¨ÊǼìË÷Êý¾Ý²¢Ê¹ÓÃÊý¾Ý°ó¶¨ Web ·þÎñÆ÷¿Ø¼þ£¨Èç GridView¡¢DetailsView »ò FormView ¿Ø¼þ£©ÏÔʾÊý¾Ý¡£¿ÉÒÔÅäÖÃÊý¾Ý°ó¶¨¿Ø¼þºÍ SqlDataSource ÒÔ¸üÐÂÊý¾Ý¡£´ó¶àÊýÊý¾Ý°ó¶¨¿Ø¼þ¶¼ÔÊÐíÄú½«ÆäÅäÖÃΪ֧³Ö²åÈë¡¢¸üм°É¾³ý²Ù×÷£¬²¢ÇÒËüÃǻὫҪ¸üеÄÖµ´«µÝ¸øÊý¾ÝÔ´¿Ø¼þ¡£È»ºó£¬Êý¾ÝÔ´¿Ø¼þ»áʹÓà SQL Óï¾ä»ò´æ´¢¹ý³Ì½«¸üкóµÄÖµÌá½»µ½Êý¾Ý¿â¡£
SqlDataSource ¿Ø¼þ±»Éè¼ÆÎªÒÔÒ»´Î¸üÐÂÒ»¸ö¼Ç¼µÄ·½Ê½¸üÐÂÊý¾Ý¡£Èç¹ûÐèÒªÖ´ÐÐÅú´¦Àí¸üУ¬Ôò±ØÐëÔÚ ASP.NET Ó¦ÓóÌÐòÖбàдÏÔʽѻ·Âß¼¡£
Ò»¡¢»ù±¾²Ù×÷
ÈôҪʹÓà SqlDataSource ¿Ø¼þÐÞ¸ÄÊý¾Ý¿âÖеÄÊý¾Ý£¬ÐèÒªÖÁÉÙÉèÖÃÒÔÏÂÊôÐÔ£º
·ProviderName: ÉèÖÃΪ ADO.NET Ìṩ³ÌÐòµÄÃû³Æ£¬¸ÃÌṩ³ÌÐò±íʾÄúÕýÔÚʹÓõÄÊý¾Ý¿â¡£
·ConnectionString: ÉèÖÃΪÓÃÓÚÊý¾Ý¿âµÄÁ¬½Ó×Ö·û´®¡£
·SqlDataSource ÃüÁîÊôÐÔ£º ÉèÖÃΪÐÞ¸ÄÊý¾Ý¿âÖеÄÊý¾ÝµÄ SQL Óï¾ä¡£
¶þ¡¢Ìṩ³ÌÐòÃû³Æ
½« ProviderName ÊôÐÔÉèÖÃΪ´æ´¢Êý¾ÝµÄÊý¾Ý¿âÀàÐ굀 ADO.NET Ìṩ³ÌÐòÃû³Æ£¬¸Ã²Ù×÷¿ÉÒÔ°üÀ¨ÒÔÏ ......
1¡¢ÔÚÒ³Ãæ¶¯Ì¬Ìí¼ÓÒ»¸ö¿Ø¼þµÄ·½·¨¡£ ÔÚÒ³ÃæµÄ HTML ´úÂëÉÏÉèÖÃÒ»¸ö asp:PlaceHolder վλ¿Ø¼þ£¬µ±Ò³Ãæ±»¼ÓÔØµÄʱºò£¬ÔÚÕâ¸ö PlaceHolder ¿Ø¼þÉÏÌí¼ÓËùÐèÒªµÄÆäËû¿Ø¼þ¡£
<asp:PlaceHolder runat="server" id="PutLabelHere" /> Sub Page_Load(sender as Object, e as EventArgs) sub Page_Load(sender as Object, e as EventArgs) Dim lblMessage as New Label() lblMessage.Text = "Hello, World!" lblMessage.Font.Bold = True PutLabelHere.Controls.Add(lblMessage) end sub End Sub
2¡¢±éÀú¿Ø¼þµÄ·½·¨¡£ Ò³Ãæ¿ÉÒÔ±»¿´³É¸÷Öֿؼþ×é³ÉµÄÒ»¸ö¼¯ºÏ¡£ÔÚÒ³Ãæ±»³õʼ»¯ºÍ¼ÓÔØ¹ý³ÌÖУ¬¿ÉÒÔ±éÀúÕâЩ¿Ø¼þ£¬ÕÒµ½Ìض¨µÄ¿Ø¼þ£¬»òÕ߸ıäijЩ¿Ø¼þµÄÊôÐÔ¡£ ÏÈ¿´ÏÂÃæµÄÒ»¸öÀý×Ó£º
script runat="ser ......
SqlDataSource ¿Ø¼þ¿É¶ÔËü¼ìË÷¹ýµÄÊý¾Ý½øÐлº´æ£¬ÕâÑù¿ÉÒÔ±ÜÃâÔÙ´ÎÔËÐÐ×ÊÔ´ÏûºÄÁ¿½Ï´óµÄ²éѯ£¬´Ó¶øÌá¸ßÓ¦ÓóÌÐòµÄÐÔÄÜ¡£»º´æÖ÷ÒªÓÃÓÚÊý¾Ý±ä»¯²»Æµ·±µÄÇé¿ö¡£
´ËÍ⣬µ±Í¨¹ý System.Data.SqlClient Ìṩ³ÌÐòʹÓà SqlDataSource ¿Ø¼þʱ£¬¿ÉÒÔʹÓà SqlCacheDependency ¶ÔÏó¡£ÕâÑù¿Éʹ SqlDataSource ¿Ø¼þ½öÔÚ SelectCommand ·µ»ØµÄÊý¾ÝÔÚÊý¾Ý¿âÖб»ÐÞ¸Äʱ²Åˢлº´æ¡£
Ò»¡¢Í¨¹ý SqlDataSource ¿Ø¼þÆôÓûº´æ
µ± SqlDataSource ¿Ø¼þµÄ DataSourceMode ÊôÐÔÉèÖÃΪ DataSet ʱ£¬¸Ã¿Ø¼þ¿É¶ÔÊý¾Ý½øÐлº´æ¡£Ä¬ÈÏÇé¿öϲ¢Î´ÆôÓûº´æ£¬µ«¿ÉÒÔͨ¹ý½« EnableCaching ÊôÐÔÉèÖÃΪ true À´ÆôÓûº´æ¡£
½«»ùÓÚÒ»¸öʱ¼ä¼ä¸ô¶Ô»º´æÊý¾Ý½øÐÐˢС£¿ÉÒÔ½« CacheDuration ÊôÐÔÉèÖÃΪˢлº´æÖ®Ç°ÒªµÈ´ýµÄÃëÊý¡£SqlDataSource ¿Ø¼þΪÿ¸ö ConnectionString¡¢SelectCommand ºÍ SelectParameters ÖµµÄ×éºÏά»¤Ò»¸öµ¥¶ÀµÄ»º´æÏî¡£
ͨ¹ýÉèÖà CacheExpirationPolicy ÊôÐÔ£¬¿ÉÒÔ½øÒ»²½¿ØÖÆ SqlDataSource »º´æµÄÐÐΪ¡£Absolute Öµ»áÔÚ³¬¹ý CacheDuration ÖµÊ±Ç¿ÖÆË¢Ð»º´æ¡£½« CacheExpirationPolicy ÊôÐÔÉèÖÃΪ Sliding£¬Ôò½öÔÚ´Ó×îºóÒ»´Î·ÃÎÊ»º´æÏîÆð³¬¹ý Ca ......
ObjectDataSource ¿Ø¼þ»ùÓÚ SelectMethod¡¢InsertMethod¡¢UpdateMethod »ò DeleteMethod ÊôÐÔÖÐËù±êʶµÄ·½·¨Ãû³ÆÒÔ¼°×é³ÉÒµÎñ¶ÔÏó·½·¨Ç©ÃûµÄ²ÎÊýÃûÀ´µ÷ÓÃÒµÎñ¶ÔÏó·½·¨¡£ÔÚÒµÎñ¶ÔÏóÖд´½¨·½·¨Ê±£¬±ØÐëÈ·±£ÒµÎñ¶ÔÏó·½·¨Ëù½ÓÊܵIJÎÊýÃûºÍÀàÐÍÓë ObjectDataSource ¿Ø¼þ´«µÝµÄ²ÎÊýÃûºÍÀàÐÍÆ¥Åä¡££¨²ÎÊý˳Ðò²¢²»ÖØÒª¡££©
Ò»¡¢Ê¹ÓòÎÊý
ͬËùÓеÄÊý¾ÝÔ´¿Ø¼þÒ»Ñù£¬ObjectDataSource ¿Ø¼þÔÚÔËÐÐʱ½ÓÊÜÊäÈë²ÎÊý£¬²¢ÔÚ²ÎÊý¼¯ºÏÖжԲÎÊý½øÐйÜÀí¡£Ã¿Ò»ÏîÊý¾Ý²Ù×÷¶¼ÓÐÒ»¸öÏà¹ØµÄ²ÎÊý¼¯ºÏ¡£¶ÔÓÚÑ¡Ôñ²Ù×÷£¬¿ÉÒÔʹÓà SelectParameters ¼¯ºÏ£»¶ÔÓÚ¸üвÙ×÷£¬¿ÉÒÔʹÓà UpdateParameters ¼¯ºÏ£¬ÒÀ´ËÀàÍÆ¡£
¿ÉÒÔΪÿ¸ö²ÎÊýÖ¸¶¨Ãû³Æ¡¢ÀàÐÍ¡¢·½ÏòºÍĬÈÏÖµ¡£¶ÔÓÚ´ÓÌØ¶¨¶ÔÏó£¨ÀýÈ磬¿Ø¼þ¡¢»á»°±äÁ¿»òÓû§ÅäÖÃÎļþ£©»ñȡֵµÄ²ÎÊý£¬ÐèÒªÉèÖÃÆäËûÊôÐÔ¡£ÀýÈ磬¶ÔÓÚ ControlParameter ¶ÔÏó£¬ÐèÒªÉèÖà ControlID ÊôÐÔÒÔ±êʶҪ»ñÈ¡²ÎÊýÖµµÄ¿Ø¼þ£¬ÒÔ¼°ÉèÖà PropertyName ÊôÐÔÒÔ±êʶ°üº¬²ÎÊýÖµµÄÊôÐÔ¡£
ÏÂÃæµÄ´úÂëʾÀýÑÝʾһ¸ö¿ÉÒÔͨ¹ý ObjectDataSource ¿Ø¼þµ÷ÓÃµÄ Select ·½·¨¡£¸Ã·½·¨´ÓÊý¾ÝÔ´»ñÈ¡²ÎÊý²¢Ñ¡Ôñµ¥¸ö¼Ç¼¡£
[DataObjectMethod(DataObjectMethodType.Select)]
public static DataT ......