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
Ïà¹ØÎĵµ£º
ItemTemplate:ÏîÄ£°æ£¬±ê¼ÇÁËÿÐÐÏÔʾµÄÄÚÈÝ
AlternatingItemTemplate:½»ÌæÏîÄ£°æ£¬¿ÉÉèÖý»ÌæÐÐÏÔʾ²»Í¬µÄ·ç¸ñ£¬²»ÉèÖÃʱ£¬ÓëÏîÄ£°æÏàͬ
SelectedItemTemplate:Ñ¡ÖÐÄ£°æ£¬ÉèÖÃÑ¡ÖкóµÄÌØÊâÑùʽ
EditItemTemplate:±à¼ÏîÄ£°æ
HeaderTemplateºÍFooterTemplate£ºÒ³Ã¼ºÍÒ³½ÅµÄÄ£°æ
SeparatorTemplate£º·Ö¸ô·ûÄ£°æ£¬Ò»°ãÓà ......
½ÓÉÏһƪ
ɾ³ýÔgenreÊôÐÔ£¬É¾³ýleixing=loveµÄËùÓнáµã¡£
1 ÔxmlÎļþ bookstore.xml
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="love" ISBN="1234123">
<title>who am i </title>
<author>who</aut ......
RowÄÚÕÒLabel¿Ø¼þ
//ÄÚ²¿¿Ø¼þʼþ
protected void LinkButton11_Click1(object sender, EventArgs e)
{
//ɾ³ý¶ÔÓ¦µÄÊÂÎñ
int ......
1¡¢ÔÚcompilation Ï£¬ÇëÉèÖÃdebug=false £¬ÈçÏ£º
default Language="c#" debug="false">
2¡¢ÇëʹÓÃServer.Transfer´úÌæResponse.Redirect¡£
3¡¢Ê¹ÓÃValidator¿Ø¼þ£¬ÇëÒª¾³£¼ì²éPage.IsValid¡£
4¡¢ÇëʹÓÃforeachÑ»·£¬¶ø²»ÊÇΪ×Ö·û´®µü´úÑ»·¡£
5¡¢ÇëʹÓÿͻ§¶ËÑéÖ¤·½Ê½(²»ÒªÃ¿´Î¶¼ÔÚ·þÎñ¶ËÑéÖ¤)¡£
6¡ ......
»¶ÓÅÄש£¬¹²Í¬½ø²½£¡£¡£¡
1¡¢ÔÚcompilation Ï£¬ÇëÉèÖÃdebug=false £¬ÈçÏ£º
default Language="c#" debug="false">
2¡¢ÇëʹÓÃServer.Transfer´úÌæResponse.Redirect¡£
3¡¢Ê¹ÓÃValidator¿Ø¼þ£¬ÇëÒª¾³£¼ì²éPage.IsValid¡£
4¡¢ÇëʹÓÃforeachÑ»·£¬¶ø²»ÊÇΪ×Ö·û´®µü´úÑ»·¡£
5¡¢ÇëʹÓÿͻ§¶ËÑéÖ¤ ......