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"ÊôÐÔ¡£
Ïà¹ØÎĵµ£º
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb; //µ¼ÈëÃüÃû¿Õ¼ä
using System.IO;
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;
using System.Data;
usi ......
ËäÈ»Õâ¸ö¶«Î÷ºÜ»ù±¾£¬µ«ÊÇ×Ô¼ºÓÐʱºò»¹ÊǺܻìÂÒ£¬ËùÒÔ½ñÌì¾ÍССµÄÕûÀíÁËÏ£¬Ïȸø´ó¼Ò´øÀ´µÄÊÇÒ³ÃæµÄÌø×ªÎÊÌâ¡£
ÒÔÏÂÊÇËÄÖÖ ´ò¿ªÐÂÒ³ÃæµÄ·½·¨.
1. Ö±½ÓתÏòÐÂÒ³Ãæ,ÔÒ³Ãæ²»±£Áô
Response.Redirect("Webform6.aspx?id=1");
2. Ö±½ÓתÏòÐÂÒ³Ãæ,ÔÒ³Ãæ²»±£Áô
nServer.Transfer("Webform6.aspx?id=1",true);
3. ´ò¿ª ......
+++ ASP.NET»º´æÖеÄÊý¾ÝÊDz»Îȶ¨µÄ£¬²»»á±»ÓÀ¾ÃµØ´æ´¢£¬¿ÉÄÜ»áÓÉÓÚÒÔÏÂÔÒòÖ®Ò»¶ø´Ó»º´æÖб»×Ô¶¯ÒƳý£º
1) »º´æÂúÁË
2) »º´æÏîÒѾ¹ýÆÚ
3) »º´æÒÀÀµµÄÏî¸Ä±äÁË
+++ ³ýÁË¿ÉÒÔ×Ô¶¯ÒƳý»º´æÏîÍ⣬Äã¿ÉÒÔÏÔÊ¾ÒÆ³ý»º´æÏî¡£ÁíÍ⣬µ±ÄãÓÃInsert·½·¨ºÍAdd·½·¨Ïò»º´æÖÐÌí¼ÓµÄ»º´æÏîÒѾ´æÔÚʱ£¬ÄÇô£¬ÔÀ´µÄ»º´æÏ±»×Ô¶¯É¾³ý¡ ......
ÔÚASP.NETÏÂʹÓûº´æ¼¼Êõ£¬ÎÒ¸öÈ˾õµÃÓÐÒÔϼ¸µã£º
1) Ìá¸ßÓ¦ÓóÌÐòÐÔÄܵÄÊÖ¶ÎÔÚÓ¦ÓóÌÐò¿ª·¢µÄ¸÷¸ö½×¶Î¶¼ÄÜÌåÏÖ³öÀ´£¬¼ÈÓÐСϸ½Ú£¬ÓÖÓдó·½Ïò¡£±ÈÈ磬±£Ö¤Éè¼ÆÒ»¸öºÃµÄÈí¼þÂß¼½á¹¹£»±£Ö¤Ê¹ÓÃÒ»¸öºÏÊʵÄÊý¾Ý½á¹¹£¬ÊǼ¯ºÏ¡¢Ê÷Ðνṹ£¬»¹ÊÇÁ´±í¡£·²ÊdzÌÐò¶¼ÊÇÓÉÊý¾Ý½á¹¹×é³ÉµÄ£¬Ò»Ì¸µ½Êý¾Ý½á¹¹¾ÍÒ»¶¨»áÉæ¼°µ½Êý¾ÝµÄ²åÈ롢ɾ ......
+++ ÊÂʵÉÏ£¬½«Êý¾Ý¼¯°ó¶¨µ½.NET¿Ø¼þ£¬¾ÍÊǽ«Êý¾Ý¿âµÄ±í»ò±íÖÐij¸ö×ֶζÁµ½ÄÚ´æµÄij¸ö½á¹¹À±ÈÈçDataTable£¬È»ºó°ÑÕâ¸öÊý¾Ý½á¹¹°ó¶¨µ½.NET¿Ø¼þ¡£
+++ Èç¹ûÄãÒÔǰʹÓùýC++ Builder»òÊÇDelphi£¬ÄÇôÄãÒ»¶¨¼ÇµÃ£¬°ó¶¨Êý¾Ý¿â¿Ø¼þÓëÒ»°ã¿Ø¼þÊÇ·Ö¿ªµÄ£¬ÕâÁ½ÖֿؼþÔÚ²»Í¬µÄ°üÖС£¶øÏÖÔÚµÄ.NET¿Ø¼þ¾Í·Ç³£Áé»î£¬Ëü¼È¿ÉÒÔ×÷Ϊһ°ã ......