第一篇:asp.net 修改密码功能模块 学习课件
修改用户后台密码
protected void Button1_Click(object sender, EventArgs e){ //创建数据库连接对象,并调用web.config文件的连接驱动
SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings[“connection”].ConnectionString);//根据用户名和旧密码查询用户
SqlCommand selectcmd = new SqlCommand(“select * from login where 用户名='” + Session[“用户名”].ToString()+ “'and 密码='” + TextBox1.Text.Trim()+ “'”, conn);try { conn.Open();//打开数据库
SqlDataReader sdr = selectcmd.ExecuteReader();//创建datareader对象,执行查询selectcmd对象
if(sdr.Read())//如果输入的旧密码正确,进行修改密码 { sdr.Close();//关闭数据库
//创建updatecmd,读取用户输入的新密码进行替换原有密码,并且限定用户名是session对象传输进来的用户名
SqlCommand updatecmd = new SqlCommand(“update login set 密码='” + TextBox2.Text.Trim()+ “'where 用户名='” + Session[“用户名”].ToString()+ “'”, conn);int i = updatecmd.ExecuteNonQuery();//执行修改操作
if(i > 0)//如果修改成功 { Response.Write(“<script language=javascript>alert('密码修改成功!')</script>”);} else//如果修改失败 { Response.Write(“<script language=javascript>alert('密码修改失败!')</script>”);}
} else//如果旧密码错误 { Response.Write(“<script language=javascript>alert('您输入的密码错误,检查后重新输入!')</script>”);} } catch(System.Exception ee)//进行异常处理 { Response.Write(“<script language=javascript>alert('” + ee.Message.ToString()+ “')</script>”);} finally { conn.Close();//关闭数据库 } }
第二篇:asp.Net 图片上传 学习课件
后台代码
protected void Page_Load(object sender, EventArgs e){
this.Image1.Visible = false;
}
protected void Button1_Click(object sender, EventArgs e){
string fullfilename = this.File1.PostedFile.FileName;
string filename = fullfilename.Substring(fullfilename.LastIndexOf(“”)+ 1);string type = fullfilename.Substring(fullfilename.LastIndexOf(“.”)+ 1);if(type == “jpg” || type == “bmp” || type == “gif”){
this.File1.PostedFile.SaveAs(Server.MapPath(“WebSite11”)+ “” + filename);this.Image1.ImageUrl = “WebSite11/” + filename;this.Image1.Visible = true;
}
else
{
Response.Write(“<script lanager=javascript>alert('上传文件格式有误,请上传jpg、gif或bmp格式文件!')</script>”);
}
}
第三篇:asp.Net 站内搜索 学习课件
后台代码
protected void Button1_Click(object sender, EventArgs e){
SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings[“connection”].ConnectionString);conn.Open();
string sql = “select * from 市”;if(TextBox1.Text!= ““)
{
sql = ”select * from 市 where 市名称 like '%“ + TextBox1.Text + ”%'”;SqlCommand com = new SqlCommand(sql, conn);SqlDataReader sdr = com.ExecuteReader();GridView1.DataSource = sdr;GridView1.DataBind();
conn.Close();
}
}
第四篇:asp.net 页面跳转 学习课件
页面跳转
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
bind();
}
}
protected void bind()
{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings[“newsConnectionString”].ConnectionString);con.Open();
string sql = “select * from login where 编号='” + Request.QueryString[“编号”] + “'”;SqlDataAdapter sda = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
sda.Fill(ds, “login”);
DataRowView drv = ds.Tables[“login”].DefaultView[0];
TextBox1.Text = Convert.ToString(drv.Row[“编号”]);
TextBox2.Text = Convert.ToString(drv.Row[“用户名”]);
TextBox3.Text = Convert.ToString(drv.Row[“密码”]);
TextBox4.Text = Convert.ToString(drv.Row[“年龄”]);
TextBox5.Text = Convert.ToString(drv.Row[“性别”]);
TextBox6.Text = Convert.ToString(drv.Row[“备注”]);
con.Close();
}
}
第五篇:asp.Net 登陆功能模块 学习资料
前台代码
<%@ Page Language=“C#” AutoEventWireup=“true” CodeFile=“login.aspx.cs” Inherits=“login” %>
“http://1/DTD/xhtml1-transitional.dtd”>