Ò»¡¢·µ»Ø¶à¸öÊý¾Ý¼¯
¼ì²éÄãµÄ·ÃÎÊÊý¾Ý¿âµÄ´úÂ룬¿´ÊÇ·ñ´æÔÚ×ÅÒª·µ»Ø¶à´ÎµÄÇëÇó¡£Ã¿´ÎÍù·µ½µµÍÁËÄãµÄÓ¦ÓóÌÐòµÄÿÃëÄܹ»ÏìÓ¦ÇëÇóµÄ´ÎÊý¡£Í¨¹ýÔÚµ¥¸öÊý¾Ý¿âÇëÇóÖзµ»Ø¶à¸ö½á¹û
¼¯£¬¿ÉÒÔ¼õÉÙÓëÊý¾Ý¿âͨÐŵÄʱ¼ä£¬Ê¹ÄãµÄϵͳ¾ßÓÐÀ©Õ¹ÐÔ£¬Ò²¿ÉÒÔ¼õÉÙÊý¾Ý¿â·þÎñÆ÷ÏìÓ¦ÇëÇóµÄ¹¤×÷Á¿¡£
Èç¹ûÄãÊÇÓö¯Ì¬µÄSQLÓï¾äÀ´·µ»Ø¶à¸öÊý¾Ý¼¯£¬ÄÇÎÒ½¨ÒéÄãÓô洢¹ý³ÌÀ´Ìæ´ú¶¯Ì¬µÄSQLÓï¾ä¡£ÊÇ·ñ°ÑÒµÎñÂ߼дµ½´æ´¢¹ý³ÌÖУ¬Õâ¸öÓеãÕùÒé¡£µ«ÊÇÎÒÈÏΪ£¬
°ÑÒµÎñÂ߼дµ½´æ´¢¹ý³ÌÀïÃæ¿ÉÒÔÏÞÖÆ·µ»Ø½á¹û¼¯µÄ´óС£¬¼õÐ¡ÍøÂçÊý¾ÝµÄÁ÷Á¿£¬ÔÚÂß¼²ãÒ²²»ÓÃÔÚ¹ýÂËÊý¾Ý£¬ÕâÊÇÒ»¸öºÃÊÂÇé¡£
ÓÃSqlCommand¶ÔÏóµÄExecuteReader·½·¨·µ»ØÒ»¸öÇ¿ÀàÐ͵ÄÒµÎñ¶ÔÏó£¬ÔÙµ÷ÓÃNextResult·½·¨À´Òƶ¯Êý¾Ý¼¯Ö¸ÕëÀ´¶¨Î»Êý¾Ý¼¯¡£
ʾÀýÒ»ÑÝʾÁËÒ»¸ö·µ»Ø¶à¸öArrayListÇ¿ÀàÐͶÔÏóµÄÀý×Ó¡£Ö»´ÓÊý¾Ý¿âÖзµ»ØÄãÐèÒªµÄÊý¾Ý¿ÉÒÔ´ó´óµÄ¼õСÄãµÄ·þÎñÆ÷ËùºÄÓõÄÄÚ´æ¡£
¶þ¡¢¶ÔÊý¾Ý½øÐзÖÒ³
ASP¡£NETµÄDataGridÓÐÒ» ......
¹ØÓÚÊý¾Ý´¦ÀíÏà¹ØµÄÓÅ»¯
Ò»¡¢ SqlDataReadºÍDatasetµÄÑ¡Ôñ
SqldatareadÓŵ㣺¶ÁÈ¡Êý¾Ý·Ç³£¿ì¡£Èç¹û¶Ô·µ»ØµÄÊý¾Ý²»Ðè×ö´óÁ¿´¦ÀíµÄÇé¿öÏ£¬½¨ÒéʹÓÃSqlDataReader£¬ÆäÐÔÄÜÒª±ÈdatsetºÃºÜ¶à¡£È±µã£ºÖ±µ½Êý¾Ý¶ÁÍê²Å¿ÉcloseµôÓÚÊý¾Ý¿âµÄÁ¬½Ó
(SqlDataReader ¶ÁÊý¾ÝÊÇ¿ìËÙÏòǰµÄ¡£SqlDataReader ÀàÌṩÁËÒ»ÖÖ¶ÁÈ¡´Ó SQL Server
Êý¾Ý¿â¼ìË÷µÄÖ»½øÊý¾ÝÁ÷µÄ·½·¨¡£ËüʹÓà SQL Server
µÄ±¾»úÍøÂçÊý¾Ý´«Êä¸ñʽ´ÓÊý¾Ý¿âÁ¬½ÓÖ±½Ó¶ÁÈ¡Êý¾Ý¡£DataReaderÐ輰ʱÏÔʽµÄclose¡£¿É¼°Ê±µÄÊͷŶÔÊý¾ÝµÄÁ¬½Ó¡£)
DatasetÊǰÑÊý¾Ý¶Á³ö£¬»º´æÔÚÄÚ´æÖС£È±µã£º¶ÔÄÚ´æµÄÕ¼Óýϸߡ£Èç¹û¶Ô·µ»ØµÄÊý¾ÝÐè×ö´óÁ¿µÄ´¦ÀíÓÃDataset±È½ÏºÃЩ¿ÉÒÔ¼õÉÙ¶ÔÊý¾Ý¿âµÄÁ¬½Ó²Ù×÷¡£Óŵ㣺ֻÐèÁ¬½ÓÒ»´Î¾Í¿ÉcloseÓÚÊý¾Ý¿âµÄÁ¬½Ó
*Ò»°ãÇé¿öÏÂ,¶ÁÈ¡´óÁ¿Êý¾Ý,¶Ô·µ»ØÊý¾Ý²»× ......
1.
ClientScript.RegisterStartupScript(this.GetType(), "js1", "alert('ɾ³ý³É¹¦');window.location='QuerySortList.aspx';", true);
2.
this.cmdSave.Attributes.Add("onclick", "return f_StringCheck()"); ......
/// <summary>
/// Ìṩ¾³£ÐèҪʹÓõÄһЩÑéÖ¤Âß¼¡£ ±ÈÈç ÓÊÏäÊÇ·ñºÏ·¨
/// </summary>
public class Validator
{
/// <summary>
/// ¼ì²éÒ»¸ö×Ö·û´®ÊÇ·ñ¿ÉÒÔת»¯ÎªÈÕÆÚ£¬Ò»°ãÓÃÓÚÑéÖ¤Óû§ÊäÈëÈÕÆÚµÄºÏ·¨ÐÔ¡£
/// </summary>
/// <param name="_value">ÐèÑéÖ¤µÄ×Ö·û´®¡£</param>
/// <returns>ÊÇ·ñ¿ÉÒÔת»¯ÎªÈÕÆÚµÄboolÖµ¡£</returns>
public static bool IsStringDate(string _value)
{
DateTime dTime;
try
&nb ......
¸øÒ³ÃæµÄTextBoxÉèÖÃReadOnly="True"ʱ,ÔÚºǫ́´úÂëÖв»Äܸ³ÖµÈ¡Öµ,ϱ߼¸ÖÖ·½·¨¿ÉÒÔ±ÜÃâ:
1¡¢²»ÉèÖÃReadOnly,ÉèÖÃonfocus=this.blur()
C#´úÂë
<asp:TextBox ID="TextBox1" runat="server" onfocus=this.blur()></asp:TextBox>
<asp:TextBox ID="TextBox1" runat="server" onfocus=this.blur()></asp:TextBox>
Îı¾¿ò²»±ä»ÒÉ«,µ«Ò²ÎÞ·¨ÊÖ¶¯ÐÞ¸ÄÄÚÈÝ,¿ÉÒÔÔÚºǫ́ͨ¹ýTextÊôÐÔÕý³£¸³ÖµÈ¡Öµ
2¡¢ÉèÖÃÁËReadOnlyÊôÐÔºó£¬Í¨¹ýRequestÀ´È¡Öµ£¬ÈçÏ£º
ǰ̨´úÂë:
C#´úÂë
<asp:TextBox ID="TextBox1" runat="server" ReadOnly="True" ></asp:TextBox>
<asp:TextBox ID="TextBox1" runat="server" ReadOnly="True" ></asp:TextBox>
ºǫ́´úÂ룺
C#´úÂë
string Text = Request.Form["TextBox1"].Trim();
string Text = Request.Form["TextBox1"].Trim();
3¡¢ÔÚPage_Load()ÕýÉèÖÃÎı¾¿òµÄÖ»¶ÁÊôÐÔ£¬ÄÜÕý³£¶ÁÈ¡£¬ÈçÏ£º
C#´úÂë
protected void Page_Load(object sender, EventArgs e) ......
ÎÒÃÇÔÚASP.NET³ÌÐòµÄ¿ª·¢¹ý³ÌÖУ¬³£³£ÐèÒªÏòÓû§¸ø³öÌáʾÐÅÏ¢£¬±ÈÈçÊÇ·ñ“²Ù×÷³É¹¦”£¬“È·¶¨”»¹ÊǓȡÏû”²Ù×÷¡£
(1) µã»÷Ò³ÃæÉϵİ´Å¥£¬µ¯³öÒ»¸ö¶Ô»°¿òÌáʾÊǓȷ¶¨”»¹ÊǓȡÏû”²Ù×÷£¬ÎÒÃDzÉÓÃÔÚ°´Å¥ÖÐÌí¼ÓÊôÐÔÀ´Íê³É£º
Àý£º
public System.Web.UI.WebControls.Button btnDelRow;
btnDelRow.Attributes.Add("onclick", "return confirm('È·¶¨ÒªÉ¾Âð?');");
¡¡(2)µã»÷Ò³ÃæÉϵÄÁ´½Ó£¬µ¯³öÒ»¸ö¶Ô»°¿òÌáʾÊǓȷ¶¨”»¹ÊǓȡÏû”²Ù×÷£¬¿ÉÔÚPage_Load()ʼþÖУ¬¸øÏ£Íû¸ø³öÈ·ÈÏÌáʾµÄ°´Å¥Ôö¼ÓÊôÐÔ£º
Àý£º
Link.Attributes.Add("onclick", "return confirm('ÄãÒªÖ´ÐÐÕâ¸ö²Ù×÷Âð£¿');");
(3) ¶ÔÓÚÒ³ÃæÍê³ÉÒ»¸ö²Ù×÷ºó£¬µ¯³öÒ»¸ö¶Ô»°¿òÌáʾÊÇ·ñ“²Ù×÷³É¹¦”¡£
Àý£º
Response.Write("<script>alert('ɾ³ý³É¹¦!')</script>");
(4)ÔÊÐí ASP.NET ·þÎ ......