网站设计.docx
《网站设计.docx》由会员分享，可在线阅读，更多相关《网站设计.docx（24页珍藏版）》请在冰豆网上搜索。
网站设计
usingSystem;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
usingSystem.Data.OleDb;
publicpartialclass_Default:
System.Web.UI.Page
{
protectedvoidButton2_Click（objectsender,EventArgse）
{
stringstrt=Server.MapPath（"Information.mdb"）;
stringconstrt="provider=Microsoft.Jet.OLEDB.4.0;DataSource="+strt+";";
stringstr1=TextBox1.Text.ToString（）.Trim（）;
stringstr2=TextBox2.Text.ToString（）.Trim（）;
stringstr3=TextBox3.Text.ToString（）.Trim（）;
stringstr4=TextBox4.Text.ToString（）.Trim（）;
stringstr5=TextBox5.Text.ToString（）.Trim（）;
if（RadioButton2.Checked）
{
stringstt="insertintoTeacherlogin（Tname,Tno,Tpassword,Tcollege,Tmajor）values（'"+str1+"','"+str2+"','"+str3+"','"+str4+"','"+str5+"'）";
OleDbConnectionmyConnt=newOleDbConnection（constrt）;
myConnt.Open（）;
OleDbCommandmycomt=newOleDbCommand（stt,myConnt）;
mycomt.ExecuteNonQuery（）;
Response.Write（""）;
myConnt.Close（）;
}
elseif（RadioButton3.Checked）
{
stringst="insertintoStudentlogin（Sname,Sno,Spassword,Scollege,Smajor）values（'"+str1+"','"+str2+"','"+str3+"','"+str4+"','"+str5+"'）";
OleDbConnectionmyConn=newOleDbConnection（constrt）;
myConn.Open（）;
OleDbCommandmycom=newOleDbCommand（st,myConn）;
mycom.ExecuteNonQuery（）;
Response.Write（""）;
myConn.Close（）;
}
}
usingSystem;
usingSystem.Collections;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;usingSystem.Data.OleDb;
publicpartialclassTeacherinsert:
System.Web.UI.Page
{
protectedvoidButton1_Click（objectsender,EventArgse）
{
stringstrt=Server.MapPath（"Information.mdb"）;
stringconstrt="provider=Microsoft.Jet.OLEDB.4.0;DataSource="+strt+";";
stringstr1=TextBox1.Text.ToString（）.Trim（）;
stringstr2=TextBox2.Text.ToString（）.Trim（）;
stringstr3=TextBox3.Text.ToString（）.Trim（）;
stringstt="insertintoTest（ethem,etext,eanswer）values（'"+str1+"','"+str2+"','"+str3+"'）";
OleDbConnectionmyConnt=newOleDbConnection（constrt）;
myConnt.Open（）;
OleDbCommandmycom=newOleDbCommand（stt,myConnt）;
mycom.ExecuteNonQuery（）;
Response.Write（""）;
myConnt.Close（）;
}
}
}usingSystem;
usingSystem.Collections;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
publicpartialclassDefault3:
System.Web.UI.Page
{
protectedvoidDropDownList1_SelectedIndexChanged（objectsender,EventArgse）
{
inti=DropDownList1.SelectedIndex;
switch（i）
{
case0:
Response.Redirect（""）;break;
case1:
Response.Redirect（""）;break;
case2:
Response.Redirect（""）;break;
case3:
Response.Redirect（""）;break;
case4:
Response.Redirect（""）;break;
default:
break;
}
}
protectedvoidButton1_Click（objectsender,EventArgse）
{
strings=TextBox1.Text.Trim（）;
Response.Redirect（s）;
}
}
usingSystem;
usingSystem.Collections;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
usingSystem.Data.OleDb;
publicpartialclass_Default:
System.Web.UI.Page
{
protectedvoidButton1_Click（objectsender,EventArgse）
{
stringstrt=Server.MapPath（"Information.mdb"）;
stringconstrt="provider=Microsoft.Jet.OLEDB.4.0;DataSource="+strt+";";
stringstr1=TextBox1.Text.ToString（）.Trim（）;
stringstr2=TextBox2.Text.ToString（）.Trim（）;
if（RadioButton1.Checked）
{
if（str1=="20104923"&&str2=="20104923"）
Response.Write（""）;
else
Response.Write（""）;
}
elseif（RadioButton2.Checked）
{
stringstt="select*fromTeacherloginorderbyTpassword";
OleDbConnectionmyConnt=newOleDbConnection（constrt）;
myConnt.Open（）;
OleDbCommandmycomt=newOleDbCommand（stt,myConnt）;
inti;
i=Convert.ToInt32（mycomt.ExecuteScalar（））;myConnt.Close（）;
if（i>0）
Response.Write（""）;
else
Response.Write（""）;
}
elseif（RadioButton3.Checked）
{
stringstt="selectcount（*）fromStudentloginwhereSno='"+str1+"'andSpassword='"+str2+"'";
OleDbConnectionmyConnt=newOleDbConnection（constrt）;
myConnt.Open（）;
OleDbCommandmycomt=newOleDbCommand（stt,myConnt）;
inti;
i=Convert.ToInt32（mycomt.ExecuteScalar（））;
myConnt.Close（）;
if（i>0）
Response.Write（""）;
else
Response.Write（""）;
}
}
}
usingSystem;
usingSystem.Collections;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
usingSystem.Data.OleDb;
publicpartialclassDefault7:
System.Web.UI.Page
{
protectedvoidButton1_Click（objectsender,EventArgse）
{
stringstr=Server.MapPath（"Information.mdb"）;
stringconstr="provider=Microsoft.Jet.OLEDB.4.0;DataSource="+str+";";
stringstr1=TextBox1.Text.ToString（）.Trim（）;
stringstr2=TextBox2.Text.ToString（）.Trim（）;
stringstr3=TextBox3.Text.ToString（）.Trim（）;
stringstr5=TextBox4.Text.ToString（）.Trim（）;
stringstr4=RadioButtonList1.SelectedValue.ToString（）.Trim（）;
stringst="updateStudentloginsetScollege='"+str3+"',Sname='"+str2+"',Smajor='"+str5+"'whereSno='"+str1+"'";
OleDbConnectionmyConn=newOleDbConnection（constr）;
myConn.Open（）;
Response.Write（myConn.State）;
OleDbCommandmycom=newOleDbCommand（st,myConn）;
mycom.ExecuteNonQuery（）;
Response.Write（""）;
myConn.Close（）;
}
protectedvoidButton2_Click（objectsender,EventArgse）
{
Response.Redirect（"~/Studentindex.aspx"）;
}
}
usingSystem;
usingSystem.Collections;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
usingSystem.Data.OleDb;
publicpartialclassDefault4:
System.Web.UI.Page
{
protectedvoidButton1_Click（objectsender,EventArgse）
{
stringstr=Server.MapPath（"Information.mdb"）;
stringconstr="provider=Microsoft.Jet.OLEDB.4.0;DataSource="+str+";";
stringstr1=TextBox1.Text.ToString（）.Trim（）;
stringst="select*fromStudentscorewhereSno='"+str1+"'";
OleDbConnectionmyConn=newOleDbConnection（constr）;
myConn.Open（）;
OleDbCommandmycom=newOleDbCommand（st,myConn）;
OleDbDataReaderdr=mycom.ExecuteReader（）;
GridView1.DataSource=dr;
GridView1.DataBind（）;
dr.Close（）;
myConn.Close（）;
}
protectedvoidButton2_Click（objectsender,EventArgse）
{
Response.Redirect（"~/Studentindex.aspx"）;
}
}
usingSystem;
usingSystem.Collections;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;
publicpartialclassTeacherindex:
System.Web.UI.Page
{
protectedvoidDropDownList1_SelectedIndexChanged（objectsender,EventArgse）
{
inti=DropDownList1.SelectedIndex;
switch（i）
{
case0:
Response.Redirect（""）;break;
case1:
Response.Redirect（""）;break;
case2:
Response.Redirect（""）;break;
case3:
Response.Redirect（""）;break;
case4:
Response.Redirect（""）;break;
default:
break;
}
}
protectedvoidButton1_Click（objectsender,EventArgse）
{
strings=TextBox1.Text.Trim（）;
Response.Redirect（s）;
}
}
usingSystem;
usingSystem.Collections;
usingSystem.Configuration;
usingSystem.Data;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.HtmlControls;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Xml.Linq;usingSystem.Data.OleDb;
publicpartialclassTeacherinsert:
System.Web.UI.Page
{
protectedvoidButton1_Click（objectsender,EventArgse）
{
stringstrt=Server.MapPath（"Information.mdb"）;
stringconstrt="provider=Microsoft.Jet.OLEDB.4.0;DataSource="+strt+";";
stringstr1=TextBox1.Text.ToString（）.Trim（）;
stringstr2=TextBox2.Text.ToString（）.Trim（）;
stringstr3=TextBox3.Text.ToString（）.Trim（）;
stringstt="insertintoTest（ethem,etext,eanswer）values
升级会员 