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

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 ¿Ø¼þ»ùÓÚ


Ïà¹ØÎĵµ£º

dz̸ASP.net°²È«±à³Ì

ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔǰµÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕß¶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......

ÑÝÁ·£ºÊ¹Óà XCOPY ²¿Êð ASP.NET Web Ó¦ÓóÌÐò

ÑÝÁ·£ºÊ¹Óà XCOPY ²¿Êð ASP.NET Web Ó¦ÓóÌÐò
²¿Êð ASP.NET Ó¦ÓóÌÐò·Ç³£¼òµ¥¡£ÄúÐèÒª½«Ëù´´½¨µÄÓ¦ÓóÌÐòÎļþ´Ó¿ª·¢¼ÆËã»ú¸´ÖƵ½½«³ÐÔØÓ¦ÓóÌÐòµÄ³ÉÆ· Web ·þÎñÆ÷¡£¿ÉÒÔʹÓà XCOPY ÃüÁîÐй¤¾ß»òϲ»¶µÄ FTP Ó¦ÓóÌÐò£¬½«Îļþ´ÓÒ»¸öλÖø´ÖƵ½ÁíÒ»¸öλÖá£Óйس£¹æ²¿ÊðµÄ¸ü¶àÐÅÏ¢£¬Çë²Î¼û .NET Framework ²¿Êð»ù´¡¡£
×¢Òâ ......

ASP.NET


      ͨ¹ý SqlDataSource ¿Ø¼þ£¬¿ÉÒÔʹÓà Web ·þÎñÆ÷¿Ø¼þ·ÃÎÊλÓÚ¹ØÏµÊý¾Ý¿âÖеÄÊý¾Ý¡£ÆäÖпÉÒÔ°üÀ¨ Microsoft SQL Server ºÍ Oracle Êý¾Ý¿âÒÔ¼° OLE DB ºÍ ODBC Êý¾ÝÔ´¡£Äú¿ÉÒÔ½« SqlDataSource ¿Ø¼þÓëÊý¾Ý°ó¶¨¿Ø¼þ£¨Èç GridView¡¢FormView ºÍ DetailsView ¿Ø¼þ£©Ò»ÆðʹÓã¬Óü«ÉÙ´úÂë»òÉõÖÁ² ......

ASP.NET


      ͨ³££¬SQL Óï¾äºÍ´æ´¢¹ý³Ì°üÀ¨ÔËÐÐʱ¼ÆËãµÄ²ÎÊý¡£Ê¹ÓòÎÊý±àдµÄ SQL Óï¾ä³Æ×÷²ÎÊý»¯ SQL Óï¾ä¡£
ʹÓà SqlDataSource ¿Ø¼þʱ£¬¿ÉÒÔÖ¸¶¨Ê¹ÓòÎÊýµÄ SQL ²éѯºÍÓï¾ä¡£Í¨¹ý¸ù¾ÝÔËÐÐʱ¼ÆËãµÄÖµ¶ÁдÊý¾Ý¿âÐÅÏ¢£¬ÕâÓÐÖúÓÚÌáÉýÊý¾Ý°ó¶¨»·¾³µÄÁé»îÐÔ¡£¿ÉÒÔ´Ó¸÷ÖÖÔ´»ñÈ¡²ÎÊýÖµ¡£ÕâЩԴ°üÀ¨ ASP.N ......

asp.net±éÀú¿Ø¼þ

1¡¢ÔÚÒ³Ãæ¶¯Ì¬Ìí¼ÓÒ»¸ö¿Ø¼þµÄ·½·¨¡£       ÔÚÒ³ÃæµÄ HTML ´úÂëÉÏÉèÖÃÒ»¸ö asp:PlaceHolder  վλ¿Ø¼þ£¬µ±Ò³Ãæ±»¼ÓÔØµÄʱºò£¬ÔÚÕâ¸ö PlaceHolder ¿Ø¼þÉÏÌí¼ÓËùÐèÒªµÄÆäËû¿Ø¼þ¡£
<asp:PlaceHolder runat="server" id="PutLabelHere" />  Sub Page_Load(sender as Object, e ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ