管理员页面后台程序.doc

管理员页面后台程序 管理员页面后台程序: using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class xianshi : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void select1_SelectedIndexChanged(object sender, EventArgs e) { string select = select1.SelectedValue; } protected void submit_xianshi_Click(object sender, EventArgs e) { string select = select1.SelectedValue; string sdept=select_2 .Text; string sno = select_2.Text; string sex = select_2.Text; if (select == 学号查询) { SqlConnection sqlcon = new SqlConnection(server=localhost;database=test_1;uid=login1;pwd=123); sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand(); sqlcmd.Connection = sqlcon; string sql = select * from sc,student,course where student.sno=sc.sno and course.cno=sc.cno and student.sno= + sno + ; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(sql , sqlcon ); DataSet ds = new DataSet(); da.Fill(ds, student,sc,course); this.GridView1.DataSource = ds.Tables[0].DefaultView; this.DataBind(); sqlcon.Close(); } if (select == 系名查询) { SqlConnection sqlcon_sdept = new SqlConnection(server=localhost;database=test_1;uid=login1;pwd=123); sqlcon_sdept.Open(); string sql_sdept = select * from sc,student,course where student.sno=sc.sno and course.cno=sc.cno and student.sdept= + sdept + ; DataTable dt = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(sql_sdept, sqlcon_sdept); DataSet ds1 = new DataSet(); da1.Fill(ds1, student,sc,course); this.Grid