asp.netÖÐDBHelperÀà ¸ßÊÖ½ø - .NET¼¼Êõ / ASP.NET
ÎÒÔÚ±±´óÇàÄñѧϰ±à³Ì
ÒòΪ»¹Ã»¿ªÊ¼½ÌAsp¡£netµÄ֪ʶ ËùÒÔÎÒ¾ÍÄÃÊé×Ôѧ
ÔÚÈý²ãµÄʱºò ·¢ÏÖ ÊéÉÏ Êý¾Ý·ÃÎʲ㠶¼ÓÐÕâÑùÒ»¸ö·½·¨——DBHelper.GetReader()
µ«ÊÇÊéÉÏÓÖû¸ø³öµÄ·½·¨ÄÚÈÝÊÇʲô ÎÒºÜÄÉÃÆÕâ¸ö·½·¨ÀïÃæÐ´µÄÊÇʲô
¸ßÊÖÇó¾È°¡
DBHelperÕâ¸ö·½·¨ÀïдÊý¾Ý¿âÁ¬½ÓµÈ²Ù×÷
²»Í¬µÄ¹«Ë¾Óõͼ²»Ò»Ñù
Äã¿ÉÒÔÎÊÄãÃÇÀÏʦҪ
Ò»°ãÊéºóÃæÓ¦¸Ã¶¼ÓеÄ
·½·¨ÀïÃæ¿Ï¶¨ÊÇ´´½¨Êý¾Ý¿âÁ¬½Ó£¬´ò¿ªÁ¬½Ó£¬Ö´ÐÐSQL£¬·µ»ØSqlDataReader¶ÔÏó¡£
Õâ¸öÓ¦¸ÃÓÐËæÊé¹âÅ̵İɣ¬ÄÇÀïÃæÓ¦¸ÃÓУ¬»òÕ߸ù¾ÝÊéÉÏÌṩµÄ´úÂëÏÂÔØÍøÖ·È¥ÏÂÔØ
public static class DBHelper{
public static SqlDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection(connectionString);
try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return rdr;
}
catch
{
conn.Close();
conn.Dispose();
throw;
}
}
private static void
Ïà¹ØÎÊ´ð£º
aspÐéÄâÖ÷»úʵÏÖα¾²Ì¬µÄ·½·¨£º
1¡¢ ÖØÐ´url²ÎÊý
Step1: ½¨Á¢Ç°Ì¨Îļþindex.asp£¬ÐÞ¸Äurl²ÎÊýÐÎʽ¡£ÓÉÓÚ¶ÁÈ¡Êý¾Ý¿âÖеļǼ²»ÊÇרÌâµÄÖØµã£¬¹ÊÖ±½Ó¸ø³ö:
<!--#include file="config.asp" -->
&l ......
asp.netÅúÁ¿ÉÏ´«Í¼Æ¬×îºÃÓÐÔ´Â룬ÔÚÏߵȣ¡£¡£¡£¡£¡£¡£¡
Ô´ÂëºÜ³¤µÄ¡£
²Î¿¼
C# code:
HttpFileCollection files = HttpContext.Current.Request.Files;
if (files.Count <= 1)
{
......
Microsoft JET Database Engine '80040e07'
±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£
\wwwroot\update.asp, line 20
--------------------------------------------------------------------------------
Ho ......
ÎÒÏëʵÏÖÒ»¸öЧ¹ûÊÇ£ºÄܰÑÒ³Ãæ·Ö³É¼¸¸ö´ó¿é£¬µãÏ´ó¿éÉϵÄ+±ãÕ¹¿ª£¬µãÏÂ-±ãÕÛµþ¡£
Õâ¸öÓÐʲô¿Ø¼þ¿ÉÒÔÓò»£¬Çë¸ßÊÖ²»Áߴͽ̣¡
ÓÃjs´úÂëÀ´ ¿ØÖÆ divµÄ¶¯×÷´Ó¶øÄÜʵÏÖ
js¿ØÖÆdivÏÔʾ/Òþ²ØÁË
VS2008×Ô´ø·â×°Á ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......