ExtJs连接数据库及动态与.net交互

//前台页面

   <script type="text/javascript">
   
    //登陆窗体
    var loginPanel=new Ext.form.FormPanel({
        id:"loginPanel",lablelPad:0,labelWidth:40,frame:true,
        items:
        [
            {xtype:"field",id:"UserName",fieldLabel:"用户名"},
            {xtype:"field",id:"PassWord",fieldLabel:"密&nbsp;&nbsp;码"}
        ]
    });
    var loginWindow;
    if(!loginWindow){
        loginWindow=new Ext.Window({
            id:"loginWindow",
            title:"登陆窗口",
            width:200,
            height:127,
            resizable:false,
            closable:false,
            items:
            [
                loginPanel
            ],        
            buttons:
            [
                {xtype:"button",text:"确定",handler:validatorData},
                {xtype:"button",text:"取消",handler:function(){loginWindow.hide();}}
            ]
        });
    }
    loginWindow.show();
    document.body.οnkeydοwn=function(){loginWindow.show();};
    //连接数据库
    function validatorData()
    {
        var UserName=Ext.getCmp("UserName").getValue();
        var Password=Ext.getCmp("PassWord").getValue();
        if(Ext.util.Format.trim(UserName)==""||Ext.util.Format.trim(Password)==""){
            Ext.Msg.alert("警告","请正确输入数据,用户名和密码都不能为空!");
            return;
        }
        Ext.Ajax.request({
            url:"ValidatorData.aspx",
            params:{ParamValue:"1",ParamUserName:UserName,ParamPassword:Password}
        
        });
        
    }
    
    
   </script>

//后台代码

protected void Page_Load(object sender, EventArgs e)
    {
        string ParamValue = Request["ParamValue"];
        if (ParamValue == "1")
        {
            string UserName = Request.QueryString["ParamUserName"];
            string Password = Request.QueryString["ParamPassword"];
            //连接数据库
            #region 连接数据库
           // /*
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "连接字符串;";
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = string.Format(" select UserID from 表 where UserName = '{0}' and Password = '{1}'", UserName, Password);
            object obj = cmd.ExecuteScalar();
            if (obj != null)
            {
                if (Convert.ToString(obj) != "")
                {
                    Response.Write("{success:true}");
                }
                else
                {
                    Response.Write("{success:false}");
                }
            }
            else
            {
                Response.Write("{success:false}");
            }
            //*/
            #endregion
            Response.Write("{success:true}");
        }

    }

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值