Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP.NET·þÎñÆ÷¿Ø¼þʹÓÃÖ®GridView

1         ASP.NET ·þÎñÆ÷¿Ø¼þGridViewʹÓÃ
±¾½Ì³Ì²»½éÉÜ·þÎñÆ÷¶Ë¿Ø¼þµÄ³ÊÏÖ£¬Ê¼þ´¦Àí£¬×´Ì¬µÈÀíÂÛ֪ʶ£¬Ö»½éÉÜ·þÎñÆ÷¶Ë¿Ø¼þµÄʹÓòÙ×÷£¬Èç¹ûÄú¶Ô·þÎñÆ÷¿Ø¼þµÄ֪ʶ¸ÐÐËȤ£¬Çë²ÎÔÄ¡¶ASP.NET·þÎñÆ÷¿Ø¼þ¸ß¼¶±à³Ì¡·
ÔĶÁ±¾ÎÄʱ×îºÃºÍ Îĵµ ¡¶ASP.NET·þÎñÆ÷¿Ø¼þʹÓÃÖ®GridViewÊý¾ÝÔ´ObjectDataSource¡·http://blog.csdn.net/huc87/archive/2009/03/17/3998185.aspxÒ»ÆðÔĶÁ¡£
 
 
1.1         GridView¸ÅÊö
ÏÔʾ±í¸ñÊý¾ÝÊÇÈí¼þ¿ª·¢ÖеÄÒ»¸öÖÜÆÚÐÔÈÎÎñ¡£ASP.NET ÌṩÁËÐí¶à¹¤¾ßÀ´ÔÚÍø¸ñÖÐÏÔʾ±í¸ñÊý¾Ý£¬ÀýÈç GridView ¿Ø¼þ¡£Í¨¹ýʹÓàGridView ¿Ø¼þ£¬Äú¿ÉÒÔÏÔʾ¡¢±à¼­ºÍɾ³ý¶àÖÖ²»Í¬µÄÊý¾ÝÔ´£¨ÀýÈçÊý¾Ý¿â¡¢XML ÎļþºÍ¹«¿ªÊý¾ÝµÄÒµÎñ¶ÔÏó£©ÖеÄÊý¾Ý¡£
¿ÉÒÔʹÓàGridView À´Íê³ÉÒÔϲÙ×÷£º
·       Í¨¹ýÊý¾ÝÔ´¿Ø¼þ×Ô¶¯°ó¶¨ºÍÏÔʾÊý¾Ý¡£
·       Í¨¹ýÊý¾ÝÔ´¿Ø¼þ¶ÔÊý¾Ý½øÐÐÑ¡Ôñ¡¢ÅÅÐò¡¢·ÖÒ³¡¢±à¼­ºÍɾ³ý¡£
ÁíÍ⣬»¹¿ÉÒÔͨ¹ýÒÔÏ·½Ê½×Ô¶¨Òå GridView ¿Ø¼þµÄÍâ¹ÛºÍÐÐΪ£º
·       Ö¸¶¨×Ô¶¨ÒåÁкÍÑùʽ¡£
·       ÀûÓÃÄ£°å´´½¨×Ô¶¨ÒåÓû§½çÃæ (UI) ÔªËØ¡£
·       Í¨¹ý´¦Àíʼþ½«×Ô¼ºµÄ´úÂëÌí¼Óµ½ GridView ¿Ø¼þµÄ¹¦ÄÜÖС£
 
1.2         GridViewÊý¾Ý°ó¶¨
1.2.1  ¸ÅÊö
GridView ¿Ø¼þÌṩÁËÁ½¸öÓÃÓڰ󶨵½Êý¾ÝµÄÑ¡Ï
·         Ê¹ÓàDataSourceID ÊôÐÔ½øÐÐÊý¾Ý°ó¶¨£¬´ËÑ¡ÏîÈÃÄúÄܹ»½« GridView ¿Ø¼þ°ó¶¨µ½Êý¾ÝÔ´¿Ø¼þ¡£½¨ÒéʹÓô˷½·¨£¬ÒòΪËüÔÊÐí GridView ¿Ø¼þÀûÓÃÊý¾ÝÔ´¿Ø¼þµÄ¹¦Äܲ¢ÌṩÁËÄÚÖõÄÅÅÐò¡¢·ÖÒ³ºÍ¸üй¦ÄÜ¡£
·         Ê¹ÓàDataSource ÊôÐÔ½øÐÐÊý¾Ý°ó¶¨£¬´ËÑ¡ÏîʹÄúÄܹ»°ó¶¨µ½°üÀ¨ ADO.NET Êý¾Ý¼¯ºÍÊý¾Ý¶ÁÈ¡Æ÷ÔÚÄڵĸ÷ÖÖ¶ÔÏó¡£´Ë·½·¨ÐèҪΪËùÓи½¼Ó¹¦ÄÜ£¨ÈçÅÅÐò¡¢·ÖÒ³ºÍ¸üУ©±à


Ïà¹ØÎĵµ£º

ASP.NETµÄACCESSÊý¾Ý¿â²Ù×÷Àà

//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ· 
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ· 
/// 
/// È¡µÃdataset 
// 
/// ²éѯÓï¾ä 
/// 
public DataSet GetDataSet(string Commandtext) 
{&nbs ......

ASPxTreeList ´úÂë°ó¶¨Êý¾Ý£¨ASP.NETµÚÈý·½¿Ø¼þ£©

 public void MyGetDepart()
    {
        string sSql = @"select DepartId,DepartName as 'Ç廪¸½ÖÐ',ParentId from sDepart";
        DataTable table = CommClass.GetDataTable(sSql);//BoolDAL.DbHelper.GetDataTabl ......

asp.netÓï¾ä

   1¡¢¿ØÖÆGridView¿Ø¼þÖÐÄÚÈݵĻ»ÐÐ
GridView1.Attributes.Add("style","word-break:keep-all;word-wrap:normal");//Õý³£»»ÐÐ
GridView1.Attributes.Add("style","word-break:break-all;word-wrap:break-word");//×Ô¶¯»»ÐÐ
2¡¢É¾³ýGridView¿Ø¼þÐÐÐÅÏ¢µ¯³öÈ·ÈÏÌáʾ¿ò
ÔÚGridViewµÄRowDataBound()ʼþÖÐÌ ......

ASP.NET 2.0Á¬½ÓOracle 10g

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;//ÒýÈëÃüÃû¿Õ¼ä ......

ASP.NETÅäÖÃOracleµÄÏà¹ØËµÃ÷

²        Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
²        Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
²      ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ