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"ÊôÐÔ¡£
Ïà¹ØÎĵµ£º
ÔÚÒ³Ãæ¼äÌø×ª,»áÉæ¼°µ½ÖµºÍÊý¾ÝµÄ´«µÝÎÊÌâ.ÌØÓñ¾ÎĽ«ÎÒÖªµÀµÄһЩ·½·¨¹éÄÉÒ»ÏÂ.
1.´ø²ÎÊý´«µÝ
Óŵã:ʹÓ÷½±ã
ȱµã:°²È«ÐÔµÍ,Êʺϴ«µÝ¼òµ¥ÀàÐ͵ĶÔÏó,±ÈÈçÊý×Ö.×Ö·û.µ«¶Ô¶ÔÏó.Êý×éµÈ²»ºÏÊÊ´«µÝ.
Ó¦ÓÃ:
a.°²È«ÐÔ²»¸ß,Ó¦¶Ô·½Ê½:¶Ô´«µÝµÄÖµ½øÐмÓÃÜ.
b.´«µÝ¼òµ¥ÀàÐ͵ĶÔÏó.Ó¦¶Ô·½Ê½:ÔÚ´«µÝҳͨ¹ý¼òµ¥ÀàÐͶÔÏó¸ø³ö±êʶ,ÔÚ ......
1¡¢aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TransferMoney.aspx.cs" Inherits="BtmsWebApp.report.TransferMoney" MasterPageFile="~/ReportPage.master" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d5 ......
+++ ¹æ¶¨»º´æÏîµÄ¼üÖµ¾Í¿ÉÒÔ´Ó»º´æÖмìË÷»º´æÏîµÄÊý¾Ý¡£È»¶ø£¬ÒòΪ±£´æÔÚ»º´æÖеÄÊý¾ÝÊDz»Îȶ¨µÄ£¬¿ÉÄܻᱻASP.NETÒÆ³ý£¬ËùÒÔ£¬ÍƼöµÄ¿ª·¢·½Ê½ÎªÓ¦¸ÃÏÈÈ·¶¨»º´æÏîÊÇ·ñ´æÔÚ£¬Èç¹û²»´æÔÚ£¬Ó¦¸ÃÏÈÌí¼Ó¸Ã»º´æÏîµ½»º´æ£¬È»ºóÔÙ¼ìË÷¸Ã»º´æÏî¡£
+++ ¼ìË÷»º´æÏî
ÏÂÃæµÄÀý×ÓÑÝʾ£¬È·¶¨ÃûΪ“CacheItem”µÄ»º´æÏîÊÇ·ñ´æÔÚ ......
+++ ASP.NET»º´æÖеÄÊý¾ÝÊDz»Îȶ¨µÄ£¬²»»á±»ÓÀ¾ÃµØ´æ´¢£¬¿ÉÄÜ»áÓÉÓÚÒÔÏÂÔÒòÖ®Ò»¶ø´Ó»º´æÖб»×Ô¶¯ÒƳý£º
1) »º´æÂúÁË
2) »º´æÏîÒѾ¹ýÆÚ
3) »º´æÒÀÀµµÄÏî¸Ä±äÁË
+++ ³ýÁË¿ÉÒÔ×Ô¶¯ÒƳý»º´æÏîÍ⣬Äã¿ÉÒÔÏÔÊ¾ÒÆ³ý»º´æÏî¡£ÁíÍ⣬µ±ÄãÓÃInsert·½·¨ºÍAdd·½·¨Ïò»º´æÖÐÌí¼ÓµÄ»º´æÏîÒѾ´æÔÚʱ£¬ÄÇô£¬ÔÀ´µÄ»º´æÏ±»×Ô¶¯É¾³ý¡ ......
+++ ÊÂʵÉÏ£¬½«Êý¾Ý¼¯°ó¶¨µ½.NET¿Ø¼þ£¬¾ÍÊǽ«Êý¾Ý¿âµÄ±í»ò±íÖÐij¸ö×ֶζÁµ½ÄÚ´æµÄij¸ö½á¹¹À±ÈÈçDataTable£¬È»ºó°ÑÕâ¸öÊý¾Ý½á¹¹°ó¶¨µ½.NET¿Ø¼þ¡£
+++ Èç¹ûÄãÒÔǰʹÓùýC++ Builder»òÊÇDelphi£¬ÄÇôÄãÒ»¶¨¼ÇµÃ£¬°ó¶¨Êý¾Ý¿â¿Ø¼þÓëÒ»°ã¿Ø¼þÊÇ·Ö¿ªµÄ£¬ÕâÁ½ÖֿؼþÔÚ²»Í¬µÄ°üÖС£¶øÏÖÔÚµÄ.NET¿Ø¼þ¾Í·Ç³£Áé»î£¬Ëü¼È¿ÉÒÔ×÷Ϊһ°ã ......