姹備釜锛欳#鐧婚檰楠岃瘉浠ｇ爜 - 宸茶В鍐?- 鎼滄悳闂棶

鍦ㄧ櫥闄嗛獙璇佷唬鐮佷腑锛岀敤杈撳叆鏂囨湰妗嗙殑鐢ㄦ埛鍚嶅拰瀵嗙爜鍘婚獙璇佹暟鎹簱淇濆瓨鐨勭敤鎴峰悕涓庡瘑鐮佹€庝箞楠岃瘉锛?/p>

答案：鍙互鐢ˋjax楠岃瘉锛屼篃灏辨槸杩欐牱鐨勬晥鏋滐細褰撴枃鏈涓㈠け鐒︾偣鐨勬椂鍊欎粬浼氶獙璇佹暟鎹簱浣垮緱鏄惁鍞竴銆?/p>
浠ヤ笅闄勯儴鍒嗕唬鐮侊細
JS浠ｇ爜锛?/strong>
<script language="javascript" type="text/javascript">
        var xmlHttp = false; //瀹氫箟涓€涓彉閲忕敤鏉ュ瓨鏀綳MLHttpRequest瀵硅薄
        //妫€娴嬬敤鎴峰悕鏄惁鍞竴鐨勮姹?br>        function checkName()
        {
            if(window.ActiveXObject)
            { 
                xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); 
            } 
            else if(window.XMLHttpRequest)
            { 
                xmlHttp = new XMLHttpRequest(); 
            } 
            if(!xmlHttp && typeof XMLHttpRequest != 'undefined')
            {
                xmlHttp = new XMLHttpRequest();
            } 
            var name = document.getElementById("VIPID").value;
             // 鍙湁褰撹〃鍗曟帶浠剁殑鍊奸兘涓嶄负绌烘椂绋嬪簭鎵嶇户缁繍琛?br>            if (name == null) 
            {
                alert(鐢ㄦ埛鍚嶄笉鑳戒负绌猴紒);
                return;
            }
       
            // 澹版槑瑕佽繛鎺ョ殑URL鍦板潃涓?br>            var URL = "ServerPage.aspx?name=" + escape(name);
            // 鎯虫湇鍔″櫒璇锋眰杩炴帴
            xmlHttp.open("GET", URL, true);
            // 涓烘湇鍔″櫒鍒涘缓涓€涓杩愯鐨勫嚱鏁?br>            xmlHttp.onreadystatechange = updatePageName;
            // 鍙戦€佽姹?br>            xmlHttp.send(null);
     
        }
        //鏍规嵁鏈嶅姟鍣ㄧ殑鍙嶆槧鏉ユ洿鏂扮浉鍏冲唴瀹?br>        function updatePageName() 
        {
         if (xmlHttp.readyState == 4) 
         {
       
          var response = xmlHttp.responseText;
                //alert(response);
                if(response != "")
                {
                   alert(response); 
                }
                else
                { 
                }
         }
        }
    </script>
鏈嶅姟鍣ㄧ澶勭悊鐨勪唬鐮侊細
string name = Request["name"];
            if (name.Length != 0)
            {
                ExecuteSql exec = new ExecuteSql();
                DataTable table = new DataTable();
                string sqlText = "select * from users where username='" + name + "'";
                exec.run(table, sqlText);
                if (table.Rows.Count > 0)
                {
                    Response.Write("宸茬粡瀛樺湪璇ョ敤鎴峰悕~~");
                }
                else
                {
                    Response.Write("");
                }
            }
            else
            {
                Response.Write("鐢ㄦ埛鍚嶄笉鑳戒负绌猴紒");
            }
 
鍏蜂綋鎯呭喌鍙互鍔燪Q,鍗曠嫭鍙戦€佷唬鐮佷綘銆傝阿璋㈤噰绾炽€?/p>
鎴戦敊浜嗭紝鐪嬮敊闂浜嗭紝浠ヤ笂鏄敞鍐岄獙璇佹槸鍚﹀敮涓€鐨勩€傚叾瀹炵櫥闄嗗緢绠€鍗曪細
杩欐槸鎴戣嚜宸卞啓鐨勬祴璇曢」鐩殑涓€涓櫥闄嗙墖娈碉細
if (Page.IsPostBack && Request.Form.Get("AdminID") != "")
            {
                ExecuteSql exec = new ExecuteSql();
                string sql = string.Format("select * from {0} where username = '{1}' and password = '{2}' and status = 1",
                            "users",AdminID.Text.ToString(),AdminPwd.Text.ToString());
                DataTable table = new DataTable();
                int flag = exec.run(table, sql);
                if (flag == 1)//鎵ц鎴愬姛
                {
                    if (table.Rows.Count > 0)//鍒ゆ柇琛ㄤ腑鏄惁鏈夋暟鎹?br>                    {
                        Session["UserName"] = Request["AdminID"];
                        Session["popedom"] = table.Rows[0]["popedom"].ToString();
                        Response.Redirect("Admin/index.aspx");
                    }
                    else
                    {
                        Response.Write("<script type='text/javascript'>alert('璐﹀彿鎴栧瘑鐮侀敊璇瘇~');</script>");
                    }
                }
                else
                {
                    Response.Write("<script type='text/javascript'>alert('鏁版嵁杩炴帴寮傚父~~');</script>");
                }
            }
            else
            {
                Response.Write("<script type='text/javascript'>alert('璇疯緭鍏ヨ处鍙穨~');</script>");
            }
鍐嶆鎶辨瓑
杩滅▼ 鎴戝府浣犲啓 
252941879
select * from 琛ㄥ悕 where username='+textbox1.text+' and password='+textbox2.text+'
 

上一个：C#中TreeView与数据库绑定?
下一个：C#窗体自动关闭后自动打开？