简单的登录等程序代码

《简单的登录等程序代码》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、登录页面：protectedvoidImageButton1_Click(objectsender,ImageClickEventArgse){stringUserName=txtUser.Text.Trim();stringUserPwd=txtPwd.Text.Trim();SqlConnectioncon=newSqlConnection("server=.;database=db_huobaowang;uid=sa;pwd=123;");con.Open();SqlCommandcmd=newSqlCommand("selec

2、tcount(0)fromuserswheres_name='"+UserName+"'ands_psw='"+UserPwd+"'",con);intcount=Convert.ToInt32(cmd.ExecuteScalar());con.Close();cmd.Dispose();con.Dispose();if(count>0){Session["users"]=txtUser.Text.Trim();Response.Redirect("UserList.aspx");}else{Response.Write("

3、pt>alert('对不起，添加失败！您可以尝试再填一次。')");}}用户管理页面protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){BindView();}}privatevoidBindView(){SqlConnectioncon=newSqlConnection("server=.;database=db_huobaowang;uid=sa;pwd=123;");con.Open();SqlDataAdaptersda=newSql

4、DataAdapter("select*fromusers",con);DataSetds=newDataSet();sda.Fill(ds);con.Close();GridView1.DataSource=ds;GridView1.DataBind();}protectedvoidtxtAdd_Click(objectsender,EventArgse){stringuser=txtUser.Text.Trim();stringpwd=txtPwd.Text.Trim();stringsex=rdlSex.Text.Trim();

5、if(Request.QueryString["id"]!=null&&Request.QueryString["id"].ToString()!=""){intid=Convert.ToInt32(Request.QueryString["id"].ToString());SqlConnectioncon=newSqlConnection("server=.;database=db_huobaowang;uid=sa;pwd=123;");con.Open();SqlCommandcmd=newSqlCommand("updateu

6、serssets_name='"+user+"',s_psw='"+pwd+"'wherei_id="+id,con);cmd.ExecuteNonQuery();con.Close();}else{SqlConnectioncon=newSqlConnection("server=.;database=db_huobaowang;uid=sa;pwd=123;");con.Open();SqlCommandcmd=newSqlCommand("insertintousersvalues('"+user+"','"+pwd+"','"

7、+sex+"','"+DateTime.Now.ToLocalTime()+"')",con);cmd.ExecuteNonQuery();con.Close();}}protectedvoidGridView1_RowEditing(objectsender,GridViewEditEventArgse){}删除用户protectedvoidGridView1_RowDeleting(objectsender,GridViewDeleteEventArgse){stringid=GridView1.DataKeys[e.RowInd

8、ex].Values[0].ToString();SqlConnectioncon=newSqlConnection("server=.;database=db_huobaowang;uid=sa;pwd=123;");