ASP.NETÊý¾Ý°ó¶¨_µÚÈýƪ_ÓÃObjectDataSource¿Ø¼þ°ó¶¨
+++ Ò³Ãæ´úÂëÈçÏ£º
<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1"
AutoGenerateColumns="true" DataKeyNames="EMPNO">
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetEmp" TypeName="OraEmp">
</asp:ObjectDataSource>
+++ ºǫ́´úÂëÈçÏ£º
// ×Ô¶¨ÒåÀࣺ
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;
using System.ComponentModel;
public class OraEmp
{
public OraEmp()
{ }
[DataObjectMethod(DataObjectMethodType.Select, true)]
public DataTable GetEmp()
{
string connStr = "Data Source=ora9; uid=scott; pwd=tiger; unicode=true";
string sqlStr = "SELECT * from EMP";
OracleDataAdapter da = new OracleDataAdapter(sqlStr, connStr);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
+++ ˵Ã÷£º
(1) ±¾ÀýʹÓÃObjectDataSource¿Ø¼þ½øÐа󶨣¬Õâ¸ö¿Ø¼þ±ÈSqlDataSource¿Ø¼þ¸ü¼Ó³éÏó£»
(2) Ê×ÏÈ×Ô¶¨ÒåÒ»¸öÀàOraEmp£¬Ìí¼Ópublic DataTable GetEmp()·½·¨£¬×¢Òâ·µ»ØÀàÐÍΪDataTable£»
(3) ÁíÍâÔÚÀàOraEmpÖУ¬ÎªÁËʹÓÃObjectDataSource£¬ÐèÒªÌí¼Ó[DataObjectMethod(DataObjectMethodType.Select, true)]Óï¾ä£¬´ËÓï¾äÐèÒªSystem.ComponentModelÃüÃû¿Ø¼þ£»
(4) ×îºóÉèÖÃObjectDataSource¿Ø¼þµÄSelectMethod="GetEmp"ºÍTypeName="OraEmp"ÊôÐÔ¡£
Ïà¹ØÎĵµ£º
Ëæ×ÅÍøÂç¼¼ÊõµÄ·¢Õ¹£¬Ä¿Ç°¹úÄÚCMSµÄ¿ª·¢ÉÌÔ½À´Ô½¶à£¬¸÷×Ô¶¼ÓÐÆä¶ÀÌصÄÓÅÊÆ£¬´ó¼ÒÔÚÑ¡ÔñµÄʱºò¾õµÃÑÛ»¨çÔÂÒ£¬²»ÖªµÀÑ¡ÔñÄĸö±È½ÏºÃ£¬ÎÒ¸öÈËÈÏΪ¿ªÔ´µÄCMS»¹ÊÇÊʺÏÎÒÃÇѧϰ¼°Ñо¿Ê¹Óã¬Ï±߾ͼ¸¸ö¹úÄÚµÄasp.net¿ªÔ´CMS½øÐмòµ¥½éÉÜ¡£
1.We7 CMS
We7 CMSÊÇÓÉÎ÷²¿¶¯Á¦¿ª·¢µÄÒ»¿î³ä·Ö·¢¾ò»¥ÁªÍøWeb2.0£¨È粩¿Í¡¢RSSµÈ£©µÄÐÅÏ¢× ......
ËäÈ»Õâ¸ö¶«Î÷ºÜ»ù±¾£¬µ«ÊÇ×Ô¼ºÓÐʱºò»¹ÊǺܻìÂÒ£¬ËùÒÔ½ñÌì¾ÍССµÄÕûÀíÁËÏ£¬Ïȸø´ó¼Ò´øÀ´µÄÊÇÒ³ÃæµÄÌøתÎÊÌâ¡£
ÒÔÏÂÊÇËÄÖÖ ´ò¿ªÐÂÒ³ÃæµÄ·½·¨.
1. Ö±½ÓתÏòÐÂÒ³Ãæ,ÔÒ³Ãæ²»±£Áô
Response.Redirect("Webform6.aspx?id=1");
2. Ö±½ÓתÏòÐÂÒ³Ãæ,ÔÒ³Ãæ²»±£Áô
nServer.Transfer("Webform6.aspx?id=1",true);
3. ´ò¿ª ......
дÁËÒ»¸ö´´½¨ÐéÄâĿ¼µÄ WebService ³ÌÐò£¬ÔÚ²âÊÔÔËÐÐʱ¿ÉÒԳɹ¦´´½¨£¬µ«ÆäËü³ÌÐòµ÷ÓÃʱ£¬ÌáʾûÓÐȨÏÞ´´½¨¡£
²éÁËһЩ×ÊÁÏ£¬ÔÚweb.configÀïÃæµÄ<system.web>ºó¼ÓÉÏÅäÖãº
<identity impersonate="true" userName="²Ù×÷ϵͳÓû§Ãû" password="Óû§¶ÔÓ¦µÄÃÜÂë" />
ÎÊÌâ½â¾ö¡£Ìش˼Ǽ£¬È¨ ......
ÏîÄ¿Öо³£»áÓõ½°ÑexcelµÄÎļþÄÚÈݵ¼Èëµ½Êý¾Ý¿âÖеÄ,¸Õ¸Õ»¨Á˵ãʱ¼ä,×öÁ˸öÀý×Ó,»ù±¾ÉÏÄÜʵÏÖµ¼ÈëExcelºóÏÔʾµÄ¹¦ÄÜ°É,µ¼ÈëµÄexcelÎļþµÃÊÇxls,¼´ÊÇ2003µÄ.
´úÂë˼·ÈçÏÂ:Òª¶ÁÈ¡µÄexcelÎļþ±ØµÃµÃÊÇÔÚ±¾µØÓ²ÅÌ,ËùÒÔÒ»°ãÀ´Ëµ¶¼ÊÇÈÃÔ¶³ÌÓû§Ñ¡Ôñ×Ô¼ºÓ²ÅÌÉϵÄExcelÎļþ,È»ºó°ÑÓû§Ñ¡ÔñµÄÎļþÉÏ´«µ½±¾µØ· ......
+++ ¹æ¶¨»º´æÏîµÄ¼üÖµ¾Í¿ÉÒÔ´Ó»º´æÖмìË÷»º´æÏîµÄÊý¾Ý¡£È»¶ø£¬ÒòΪ±£´æÔÚ»º´æÖеÄÊý¾ÝÊDz»Îȶ¨µÄ£¬¿ÉÄܻᱻASP.NETÒƳý£¬ËùÒÔ£¬ÍƼöµÄ¿ª·¢·½Ê½ÎªÓ¦¸ÃÏÈÈ·¶¨»º´æÏîÊÇ·ñ´æÔÚ£¬Èç¹û²»´æÔÚ£¬Ó¦¸ÃÏÈÌí¼Ó¸Ã»º´æÏîµ½»º´æ£¬È»ºóÔÙ¼ìË÷¸Ã»º´æÏî¡£
+++ ¼ìË÷»º´æÏî
ÏÂÃæµÄÀý×ÓÑÝʾ£¬È·¶¨ÃûΪ“CacheItem”µÄ»º´æÏîÊÇ·ñ´æÔÚ ......