private int CheckUserAndPwd(string usercode, string userpwd)

        {

            SqlConnection objConn = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);

            objConn.Open();

            //调用usp_CheckUserLogin

            SqlCommand objComm = new SqlCommand("usp_CheckUserLogin", objConn);

            objComm.CommandType = CommandType.StoredProcedure;

            //添加usp参数

            objComm.Parameters.Add(new SqlParameter("@usercode", usercode));

            objComm.Parameters.Add(new SqlParameter("@pwd", userpwd));

            //接收usp返回值

            objComm.Parameters.Add(new SqlParameter("retvalue", SqlDbType.Int, 4, ParameterDirection.ReturnValue,

                                   false, 0, 0, string.Empty, DataRowVersion.Default, null));

            objComm.ExecuteNonQuery();

            int uspReturnValue = (int)objComm.Parameters["retvalue"].Value;

            objConn.Close();

            return uspReturnValue;

        }

        //登陆处理

        private void Login_Click(object sender, System.Web.UI.ImageClickEventArgs e)

        {

            int uspReturnValue = CheckUserAndPwd(usercode.Text, password.Text);

            if(uspReturnValue == -1)

            {

                Response.Write(@"<script language=javascript>alert('该用户不存在，请先注册！');</script>");

                usercode.Text = string.Empty;

                Session["usercode"] = string.Empty;

            }

            else if(uspReturnValue == -2)

            {

                Response.Write(@"<script language=javascript>alert('该用户对应口令有误！');</script>");

                password.Text = string.Empty;

                Session["usercode"] = string.Empty;

            }

            else if(uspReturnValue == 0)

            {

                Response.Write(@"<script language=javascript>alert('登陆成功！');</script>");

                Session["usercode"] = usercode.Text;

                //更新用户最后登陆时间

                UpdateUserAccessDT(usercode.Text);

                usercode.Text = string.Empty;

                password.Text = string.Empty;

            }

        }


private void fill()//datagrid与后台数据库绑定

  {
   string connString="server=(local);database=table;uid=sa;pwd=;";
   //string sql="select *,year(getdate())-year(jb_2) as hh from ta1";
   SqlConnection conn=new SqlConnection(connString);
   SqlCommand cmd=new SqlCommand("show_waitlist",conn);
   cmd.CommandType=CommandType.StoredProcedure;
   DataSet objDataSet = new DataSet();
   SqlDataAdapter objDA = new SqlDataAdapter();

   objDA.SelectCommand = cmd;
   objDA.Fill(objDataSet, "DataGrid1");//数据添充
   DataGrid1.DataSource=objDataSet.Tables["DataGrid1"].DefaultView;//数据源
   DataGrid1.DataBind();//数据绑定
  }