ASP.NET
ObjectDataSource ¿Ø¼þ»ùÓÚ SelectMethod¡¢InsertMethod¡¢UpdateMethod »ò DeleteMethod ÊôÐÔÖÐËù±êʶµÄ·½·¨Ãû³ÆÒÔ¼°×é³ÉÒµÎñ¶ÔÏó·½·¨Ç©ÃûµÄ²ÎÊýÃûÀ´µ÷ÓÃÒµÎñ¶ÔÏó·½·¨¡£ÔÚÒµÎñ¶ÔÏóÖд´½¨·½·¨Ê±£¬±ØÐëÈ·±£ÒµÎñ¶ÔÏó·½·¨Ëù½ÓÊܵIJÎÊýÃûºÍÀàÐÍÓë ObjectDataSource ¿Ø¼þ´«µÝµÄ²ÎÊýÃûºÍÀàÐÍÆ¥Åä¡££¨²ÎÊý˳Ðò²¢²»ÖØÒª¡££©
Ò»¡¢Ê¹ÓòÎÊý
ͬËùÓеÄÊý¾ÝÔ´¿Ø¼þÒ»Ñù£¬ObjectDataSource ¿Ø¼þÔÚÔËÐÐʱ½ÓÊÜÊäÈë²ÎÊý£¬²¢ÔÚ²ÎÊý¼¯ºÏÖжԲÎÊý½øÐйÜÀí¡£Ã¿Ò»ÏîÊý¾Ý²Ù×÷¶¼ÓÐÒ»¸öÏà¹ØµÄ²ÎÊý¼¯ºÏ¡£¶ÔÓÚÑ¡Ôñ²Ù×÷£¬¿ÉÒÔʹÓà SelectParameters ¼¯ºÏ£»¶ÔÓÚ¸üвÙ×÷£¬¿ÉÒÔʹÓà UpdateParameters ¼¯ºÏ£¬ÒÀ´ËÀàÍÆ¡£
¿ÉÒÔΪÿ¸ö²ÎÊýÖ¸¶¨Ãû³Æ¡¢ÀàÐÍ¡¢·½ÏòºÍĬÈÏÖµ¡£¶ÔÓÚ´ÓÌØ¶¨¶ÔÏó£¨ÀýÈ磬¿Ø¼þ¡¢»á»°±äÁ¿»òÓû§ÅäÖÃÎļþ£©»ñȡֵµÄ²ÎÊý£¬ÐèÒªÉèÖÃÆäËûÊôÐÔ¡£ÀýÈ磬¶ÔÓÚ ControlParameter ¶ÔÏó£¬ÐèÒªÉèÖà ControlID ÊôÐÔÒÔ±êʶҪ»ñÈ¡²ÎÊýÖµµÄ¿Ø¼þ£¬ÒÔ¼°ÉèÖà PropertyName ÊôÐÔÒÔ±êʶ°üº¬²ÎÊýÖµµÄÊôÐÔ¡£
ÏÂÃæµÄ´úÂëʾÀýÑÝʾһ¸ö¿ÉÒÔͨ¹ý ObjectDataSource ¿Ø¼þµ÷ÓÃµÄ Select ·½·¨¡£¸Ã·½·¨´ÓÊý¾ÝÔ´»ñÈ¡²ÎÊý²¢Ñ¡Ôñµ¥¸ö¼Ç¼¡£
[DataObjectMethod(DataObjectMethodType.Select)]
public static DataTable GetEmployee(int EmployeeID)
{
if (!_initialized) { Initialize(); }
SqlConnection conn = new SqlConnection(_connectionString);
SqlDataAdapter da =
new SqlDataAdapter("SELECT EmployeeID, LastName, FirstName, Address, City, Region, PostalCode from Employees WHERE EmployeeID = @EmployeeID", conn);
da.SelectCommand.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = EmployeeID;
DataSet ds = new DataSet();
try
{
conn.Open();
da.Fill(ds, "Employees");
}
catch (SqlException e)
{
// Handle exception.
}
finally
{
conn.Close();
}
if (ds.Tables["Employees"] != null)
return ds.Tables["Employees"];
return null;
}
¶þ¡¢Îª Insert¡¢Update ºÍ Delete ·½·¨´«µÝ²ÎÊý
ObjectDataSource ¿Ø¼þ»ùÓÚ
Ïà¹ØÎĵµ£º
ÖÚËùÖÜÖªASP.NET 2.0Àï¶Ô±¾µØ»¯£¨Localization£©×öÁ˺ܶ๤×÷£¬´ó´ó¼ò»¯ÁË¿ª·¢¹ý³Ì¡£½ñÌìÖÕÓÚÄܳé³öʱ¼äÑо¿Ò»ÏÂÕâ¸ö¼¼ÊõÁË£¬×ÊÁϺܶ࣬µ«´ó¶à´ø×ÅÒ»¹ÉÒ§ÎĽÀ×ֵķÒëζµÀ£¬So......×Ô¼ºÐ´Ò»Æª¡£
1.ʹÓù¤¾ß×Ô¶¯Éú³É±¾µØ»¯×ÊÔ´£¨LocalResources£©
2.ÔÀ´Localizable AttributePropertyÊÇÕâô»ØÊÂѽ
3.ÊÖ¹¤Ìí¼Ó±¾µ ......
×î½ü·¢ÏÖÓïÒôÑéÖ¤ÂëÔ½À´Ô½Á÷ÐУ¬±ÈÈçÓдÎÔÚ×¢²ágmailÓÊÏä¿´µ½¹ý£¬»¹ÓÐmsnÒ³ÃæÒ²ÓÐÓïÒôÑéÖ¤Â룬»¹ÓйúÍâÒ»Ð©ÍøÕ¾µÈ¡£
»¨Ê±¼äÑо¿ÁËÏ£¬ÓïÒôÑéÖ¤ÂëÖ÷Òª¸úÒ»°ãÑéÖ¤ÂëµÄÇø±ð¾ÍÔÚÓÚÈçºÎÈÃÑéÖ¤Âë²¥·Å¡£±¾ÎÄÓïÒôÑéÖ¤ÂëÔÀí£º´Ó·þÎñÆ÷Éú³ÉÑéÖ¤Â룬
²¢±£´æµ½cookieÖУ¨getcode.aspx.cs£©,µ±µãÊÕÌýÑéÖ¤ÂëµÄʱºò£¬µ÷ÓÃjavascirpt²Ù×÷ ......
ÔÚGlobal.asaxÆô¶¯Ò»ÌõÏ߳̾ÍokÁË£¬ÏÂÃæÊÇÆô¶¯Ï̶߳¨Ê±Ð´ÎļþµÄÀý×Ó
¡¡¡¡Global.asax
¡¡¡¡C# code
¡¡¡¡Code
¡¡¡¡1<%@ Application Language="C#" %>
¡¡¡¡2<%@ Import Namespace="System.IO" %>
¡¡¡¡3<%@ Import Namespace="System.Threading" %>
¡¡¡¡4<script runat="server">
¡¡¡¡5 ......
ͨ¹ý SqlDataSource ¿Ø¼þ£¬¿ÉÒÔʹÓà Web ·þÎñÆ÷¿Ø¼þ·ÃÎÊλÓÚ¹ØÏµÊý¾Ý¿âÖеÄÊý¾Ý¡£ÆäÖпÉÒÔ°üÀ¨ Microsoft SQL Server ºÍ Oracle Êý¾Ý¿âÒÔ¼° OLE DB ºÍ ODBC Êý¾ÝÔ´¡£Äú¿ÉÒÔ½« SqlDataSource ¿Ø¼þÓëÊý¾Ý°ó¶¨¿Ø¼þ£¨Èç GridView¡¢FormView ºÍ DetailsView ¿Ø¼þ£©Ò»ÆðʹÓã¬Óü«ÉÙ´úÂë»òÉõÖÁ² ......
1. BinÎļþ¼Ð
BinÎļþ¼Ð°üº¬Ó¦ÓóÌÐòËùÐèµÄ£¬ÓÃÓڿؼþ¡¢×é¼þ»òÕßÐèÒªÒýÓõÄÈÎºÎÆäËû´úÂëµÄ¿É²¿Êð³ÌÐò¼¯¡£¸ÃĿ¼ÖдæÔÚµÄÈκÎ.dllÎÄ ¼þ½«×Ô¶¯µØÁ´½Óµ½Ó¦ÓóÌÐò¡£
2. App_BrowserÎļþ¼Ð
¸Ã¿ÉÑ¡µÄÎļþ¼Ð°üº¬.browserÎļþ¡£.browserÎļþÃèÊöä¯ÀÀÆ÷(²»¹ÜÊÇÒÆ¶¯É豸ä¯ÀÀÆ÷£¬»¹ÊÇ̨ʽ»úä¯ÀÀÆ÷)µÄÌØ Õ÷ºÍ¹¦ÄÜ¡£
3. ......