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
Ïà¹ØÎÊ´ð£º
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
aspÐéÄâÖ÷»úʵÏÖα¾²Ì¬µÄ·½·¨£º
1¡¢ ÖØÐ´url²ÎÊý
Step1: ½¨Á¢Ç°Ì¨Îļþindex.asp£¬ÐÞ¸Äurl²ÎÊýÐÎʽ¡£ÓÉÓÚ¶ÁÈ¡Êý¾Ý¿âÖеļǼ²»ÊÇרÌâµÄÖØµã£¬¹ÊÖ±½Ó¸ø³ö:
<!--#include file="config.asp" -->
&l ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
ÎÒÏëʵÏÖÒ»¸öЧ¹ûÊÇ£ºÄܰÑÒ³Ãæ·Ö³É¼¸¸ö´ó¿é£¬µãÏ´ó¿éÉϵÄ+±ãÕ¹¿ª£¬µãÏÂ-±ãÕÛµþ¡£
Õâ¸öÓÐʲô¿Ø¼þ¿ÉÒÔÓò»£¬Çë¸ßÊÖ²»Áߴͽ̣¡
ÓÃjs´úÂëÀ´ ¿ØÖÆ divµÄ¶¯×÷´Ó¶øÄÜʵÏÖ
js¿ØÖÆdivÏÔʾ/Òþ²ØÁË
VS2008×Ô´ø·â×°Á ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......