asp.net C#ÃüÃû²ÎÊýSqlParameterÏê½â
DBHelper:
/// <summary>
/// Ö´Ðвéѯ
/// </summary>
/// <param name="sql">ÓÐЧµÄselectÓï¾ä</param>
/// <returns>·µ»ØSqlDataReader</returns>
public static SqlDataReader ExecuteReader(string sql)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
/// <summary>
/// Ö´Ðвéѯ´ø²ÎÊý
/// </summary>
/// <param name="sql">ÓÐЧµÄselectÓï¾ä</param>
/// <returns>·µ»ØSqlDataReader</returns>
public static SqlDataReader ExecuteReader(string sql,SqlParameter parameter)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.Add(parameter);
&nbs
Ïà¹ØÎĵµ£º
1¡¢ÔÚcompilation Ï£¬ÇëÉèÖÃdebug=false £¬ÈçÏ£º
default Language="c#" debug="false">
2¡¢ÇëʹÓÃServer.Transfer´úÌæResponse.Redirect¡£
3¡¢Ê¹ÓÃValidator¿Ø¼þ£¬ÇëÒª¾³£¼ì²éPage.IsValid¡£
4¡¢ÇëʹÓÃforeachÑ»·£¬¶ø²»ÊÇΪ×Ö·û´®µü´úÑ»·¡£
5¡¢ÇëʹÓÿͻ§¶ËÑéÖ¤·½Ê½(²»ÒªÃ¿´Î¶¼ÔÚ·þÎñ¶ËÑéÖ¤)¡£
6¡ ......
½ñÌìÓöµ½Ò»¸öÍ·ÌÛµÄÎÊÌ⣬Ð޸ıðÈËдµÄasp.netÒ³ÃæµÄÑùʽ£¬ÎÒ°ÑÔÚÒ³ÃæµÄÑùʽ´úÂë¼ôÇе½cssÎļþÖУ¬°¦£¬³ö´íÁË¡£Ñùʽ³ö²»À´¡£ÕÒÁ˰ëÌì´í£¬Â·¾¶Ò²¶Ô°¡£¬¾ÍÊǵÚÒ»´Î¼ÓÔØÒ³ÃæÊ±ÎÒÉèÖõı³¾°Í¼Æ¬³ö²»À´£¬ÔÙË¢Ò»´ÎÒ³Ãæ¾Í³öÀ´ÁË£¬²»ÖªµÀΪʲô£¬°ÑËû¿¼µ½Ò³ÃæÉϾÍOK¡£×îÖÕ»¹ÊÇÕÒ³ö´íÁË¡£×Ô¼ºÌ«Âí»¢ÁË£¬´úÂëÔõôÄÜËæ±ãcopyµÄ£¬backgr ......
2.4 µ¼º½ÌõÉè¼Æ·½°¸
Ò»¸öWebÕ¾µã£¬ÓÈÆäÊÇÐÅÏ¢Á¿´óµÄ´óÖÐÐÍWebÕ¾µã£¬Ó¦ÎªÓû§Ìṩվµãµ¼º½¡£Õ¾µãµ¼º½ÊÇÿ¸öÍøÕ¾±Ø²»¿ÉÉٵģ¬ËüÏ൱ÓÚ³ÇÊй«Â·µÄ·±ê¡£Í¨¹ýµ¼º½ÌõÉè¼Æ·½°¸£¬¿ÉÒÔÊ¹ÍøÕ¾ä¯ÀÀÕßÕÒµ½×Ô¼ºÏëÒªµÄÄÚÈÝ¡£
2.4.1 Ê÷Ð͵¼º½ÌõÉè¼Æ·½°¸
Ê÷Ð͵¼º½ÌõÉè¼ÆÖ÷ÒªÓ¦ÓÃTreeView¿Ø¼þ£¬TreeView¿Ø¼þ¶ÔÊý¾ÝÓÐ×ÅÁ¼ºÃµÄÖ§³Ö£¬Í¨¹ýÏÔ ......
´°Ìå´úÂë:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using AgentObjects;
using SpeechLib;
using System.Web;
using System.Threading;
using System.Text.RegularExpressio ......