访问数据库及页面跳转.docVIP

访问数据库和页面跳转.txt世上有三种人：一是良心被狗吃了的人，二是良心没被狗吃的人，三是良心连狗都不吃的人。︶﹋丶　　　爱情是个梦，而我却睡过了头﹌访问数据库 OleDbConnection conn=new OleDbConnection(); Protected void Page_Load(object sender;EventArgs e) {conn.ConnectionString= Provider=Microsoft.Jet.OleDb.4.0;Date Source=+ Server.MapPath(App_Data/db1.mdb); String SqlStr=select*from职员情况表; OleDbCommand cmd=newOleDbCommand(conn,sqlStr); Conn.Open(); GridView1.DataSource=cmd.ExecuteReader(); GridView1.DataBind(); Conn.Close(); 数据库2 Public partial class_Default:System.Web.UI.page { String strConn=System.Connfiguration.ConfigurationMannager.ConnectionStrings [ConnStr].ToString(); OleDbConnection conn=new OleDbConnection(); Protected void Page_Load(object sender;EventArgs e) { Conn.ConnectionString=strConn; Conn.Open(); String strCmd=Select*from职员情况表； OleDbCommand cmd=newOleDbCommand(strCmd,conn); GridView1.DataSource=cmd.ExecuteReader(); GridView1.DataBind(); Conn.Close(); } Protected void Button1_Click(object sender;EventArgs e) { Conn.ConnectionString=strConn; Conn.Open(); String strTemp=TextBox1.Text++TextBox2.Text++TextBox3.Text++TextBox4.Text++TextBox5.Text++ TextBox6.Text; String strCmd=Insert Into职员情况表（编号，姓名，性别，年龄，部门，职务）value是（+strTemp+）; OleDbCommand cmd=newOleDbCommand(strCmd,conn); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect(Default.aspx); } 页面跳转 public partical class_Deafult:system.web.UL.page {protected void page_load(object sender,eventargs e) {} protected void button1_click(object sender,eventargs e) {respinse.redirect(default2.aspx?name=+textbox1.text +password=+textbox2.text+type=+dropdownlist1.selectedvalue) } public partial class default2:system.web.ui.page {protected void page_load(object sender,eventargs e) {string name=request.quertstring[name]; string password=request.querystring[password]; string type=request.querystring[type]; if(name==||password==) {response.write(请输入用户名及密码); return;} response.write(欢迎+name+登陆+用户类型为+type); } } session 方法: protected void page_load(object sender,eventargs e) {} protected void butt