protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
mysql = "SELECT 学历 FROM Education";
myds = mydb.ExecuteQuery(mysql, "Education"); //执行查询语句
DataRow nrow = myds.Tables["Education"].NewRow(); //新建一个空行
nrow["学历"] = "";
myds.Tables["Education"].Rows.InsertAt(nrow, 0);
DropDownList1.DataSource = myds.Tables["Education"]; //设置学历下拉列表数据源
DropDownList1.DataTextField = "学历"; //设置绑定字段
DropDownList1.DataBind(); //数据绑定
mysql = "SELECT distinct 地区 FROM Area";
myds = mydb.ExecuteQuery(mysql, "Area");
DataRow nrow1 = myds.Tables["Area"].NewRow();
nrow1["地区"] = "";
myds.Tables["Area"].Rows.InsertAt(nrow1, 0);
DropDownList2.DataSource = myds.Tables["Area"];//设置学历下拉列表数据源
DropDownList2.DataTextField = "地区";
DropDownList2.DataBind();
DropDownList2.SelectedValue = "";
DropDownList3.Enabled = false;
DropDownList4.Enabled = false;
DropDownList5.Enabled = false;
}
}
public void bind()
{
mysql = "SELECT * FROM ShoppingCart WHERE 用户名 = '" + Session["uname"] + "'";
myds = mydb.ExecuteQuery(mysql, "ShoppingCart");
GridView1.DataSource = myds.Tables["ShoppingCart"];
//GridView1.DataKeyNames = new string[] { "商品编号" };
GridView1.DataBind(); //在GridView1中显示满足查询条件的记录
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
mysql = "SELECT distinct 分类 FROM ProdType";
myds = mydb.ExecuteQuery(mysql, "ProdType");
DataRow nrow = myds.Tables["ProdType"].NewRow();
nrow["分类"] = "";
myds.Tables["ProdType"].Rows.InsertAt(nrow, 0);
DropDownList1.DataSource = myds.Tables["ProdType"];
DropDownList1.DataTextField = "分类";
DropDownList1.DataBind();
DropDownList2.Enabled = false;
DropDownList3.Enabled = false;
}
}
public void bind()
{
mysql = "SELECT * FROM OrderForm";
myds = mydb.ExecuteQuery(mysql, "OrderForm");
GridView1.DataSource = myds.Tables["OrderForm"];
GridView1.DataBind();//在GridView1中显示记录
}
protected void submit_Click(object sender, EventArgs e)
{
string condstr = "";
if (!startplace.Text.Equals(""))
{
condstr += "始发地 = '" + startplace.Text + "'";
if (!endplace.Text.Equals(""))
{
condstr += "AND 目的地 = '" + endplace.Text + "'";
}
}
else
{
if (!endplace.Text.Equals(""))
{
condstr += "目的地 = '" + endplace.Text + "'";
}
}
string mysql = "SELECT fid AS ID, fname AS 航班, fstartplace AS 始发地, fendplace AS 目的地, fstarttime AS 起飞时间, fendtime AS 到达时间, fseat AS 座位数, fprice AS 价格 FROM flight";
DataSet myds = mycmd.ExecuteQuery(mysql, "flight");
DataView mydv = myds.Tables["flight"].DefaultView;
mydv.RowFilter = condstr;
if (mydv.Count == 0)
{
Response.Write("<script>alert('没有此航班!');</script>");
}
else
{
GridView1.DataSourceID = null;
GridView1.DataSource = mydv;
GridView1.DataBind();
}
}
public void bind()
{
mysql = Session["sql"].ToString();
myds = mydb.ExecuteQuery(mysql, "Users");
GridView1.DataSource = myds.Tables["Users"];
GridView1.DataKeyNames = new string[] { "用户名" };
GridView1.DataBind();
}
public void bind() //数据绑定
{
mysql = "SELECT * FROM selcourse WHERE sno = '" + Session["uno"] + "'";
myds = mydb.ExecuteQuery(mysql, "selcourse");
GridView1.DataSource = myds.Tables["selcourse"];
GridView1.DataKeyNames = new string[] { "cno" };
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string mysql = "SELECT * FROM score WHERE sno='" + Session["uno"] + "'";
myds = mydb.ExecuteQuery(mysql, "score");
if (myds.Tables["score"].Rows.Count > 0)
{
GridView1.DataSource = myds.Tables["score"];
GridView1.DataBind();
}
else
{
Response.Redirect("~/dispinfo.aspx?info=你没选修任何课程或选课没有提交");
}
}
}
public void bind()
{
mysql = Session["sql"].ToString();
myds = mydb.ExecuteQuery(mysql, "Products");
GridView1.DataSource = myds.Tables["Products"];
//GridView1.DataKeyNames = new string[] { "商品编号" };
GridView1.DataBind(); //在GridView1中显示满足查询条件的记录
}
public void bind()
{
mysql = "SELECT * FROM course";
myds = mydb.ExecuteQuery(mysql, "course");
GridView1.DataSource = myds.Tables["course"];
GridView1.DataKeyNames = new string[] { "cno", "cname" };
GridView1.DataBind();
}
public void bind()
{
mysql = "SELECT * FROM teacher ORDER BY tno";
myds = mydb.ExecuteQuery(mysql, "teacher");
GridView1.DataSource = myds.Tables["teacher"];
GridView1.DataKeyNames = new string[] { "tno" };
GridView1.DataBind();
}
public void bind()
{
mysql = "SELECT * FROM OrderForm WHERE 用户名 = '" + Session["uname"] + "'";
myds = mydb.ExecuteQuery(mysql, "OrderForm");
GridView1.DataSource = myds.Tables["OrderForm"];
GridView1.DataKeyNames = new string[] { "订单号" };
GridView1.DataBind();
}
public void bind()
{
mysql = "SELECT 分类,子类,SUM(数量) AS 销售数量,SUM(金额) AS 销售金额 "
+ "FROM Sales "
+ "GROUP BY 分类,子类";
myds = mydb.ExecuteQuery(mysql, "Sales");
GridView1.DataSource = myds.Tables["Sales"];
GridView1.DataBind();//在GridView1中显示
}
public void bind()
{
mysql = "SELECT 订单号,日期,商品编号,分类,子类,品牌,型号,单价,数量,金额 FROM Sales "
+ " WHERE 用户名 = '" + Session["cname"] + "' ";
myds = mydb.ExecuteQuery(mysql, "Sales");
GridView1.DataSource = myds.Tables["Sales"];
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
mysql = "SELECT cno FROM course WHERE tno='" + Session["uno"] + "'";
myds = mydb.ExecuteQuery(mysql, "course");
if (myds.Tables["course"].Rows.Count > 0)
{
DropDownList1.DataSource = myds.Tables["course"];
DropDownList1.DataTextField = "cno";
DropDownList1.DataBind();
}
else
{
Response.Redirect("~/dispinfo.aspx?info=没有安排任何上课课程!");
}
}
}
public void bind()
{
mysql = "SELECT 日期,商品编号,分类,子类,品牌,型号,单价,数量,金额 FROM Sales "
+ " WHERE 用户名 = '" + Session["uname"] + "' "
+ " AND 订单号 = '" + Session["ddh"] + "'";
myds = mydb.ExecuteQuery(mysql, "Sales");
GridView1.DataSource = myds.Tables["Sales"];
GridView1.DataKeyNames = new string[] { "商品编号" };
GridView1.DataBind();
}
public void bind()
{
CommDB mydb = new CommDB();
string mysql = Request.QueryString["mysql"];
DataSet myds = new DataSet();
myds = mydb.ExecuteQuery(mysql, "score");
GridView1.DataSource = myds.Tables["score"];
GridView1.DataKeyNames = new string[] { "sno" };
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataSet myds = new DataSet();
string mno = Request.QueryString["mno"];
mysql = "SELECT * FROM manager WHERE mno='" + mno + "'";
myds = mydb.ExecuteQuery(mysql, "manager");
DataRow mydr = myds.Tables["manager"].Rows[0];
TextBox1.Text = mydr["mno"].ToString();
TextBox2.Text = mydr["mname"].ToString();
}
}
public bool check()
{
string str1, str2;
mysql = "SELECT 密码 FROM Users WHERE 用户名 = '" + Session["uname"] + "'";
myds = mydb.ExecuteQuery(mysql, "Users");
str1 = myds.Tables[0].Rows[0][0].ToString().Trim();
str2 = passTextBox1.Text.ToString();
if (str1 != str2)
{
return(true);
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataSet myds = new DataSet();
string cno = Request.QueryString["cno"];
mysql = "SELECT * FROM course WHERE cno='" + cno + "'";
myds = mydb.ExecuteQuery(mysql, "course");
DataRow mydr = myds.Tables["course"].Rows[0];
TextBox1.Text = mydr["cno"].ToString();
TextBox2.Text = mydr["cname"].ToString();
TextBox3.Text = mydr["ctime"].ToString();
TextBox4.Text = mydr["cplace"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["uname"] == null)
{
Response.Write("<script>alert('请先登录!');</script>");
Response.Redirect("~/", false);
}
if (!IsPostBack)
{
String mysql = "SELECT * FROM user_ WHERE uname = '" + Session["uname"] + "'";
DataSet info = mycom.ExecuteQuery(mysql, "user_");
DataRow row = info.Tables["user_"].Rows[0];
uid.Value = row.ItemArray[0].ToString();
name.Text = row.ItemArray[1].ToString();
username.Text = row.ItemArray[2].ToString();
tel.Text = row.ItemArray[3].ToString();
money.Text = row.ItemArray[4].ToString();
password.Text = row.ItemArray[5].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["uname"] == null)
{
Response.Write("<script>alert('请先登录!');</script>");
Response.Redirect("~/", false);
}
String mysql = "SELECT book.bid AS ID, book.fid AS 航班号, flight.fname AS 航空公司, flight.fstartplace AS 始发地, flight.fendplace AS 目的地, book.fdate AS 起飞日期, flight.fstarttime AS 起飞时间, book.btime AS 预定时间, flight.fprice AS 价格 ,book.uid FROM book INNER JOIN flight ON book.fid = flight.fid WHERE (book.uid = '" + Session["uid"] + "') AND (book.bid NOT IN(SELECT bid FROM rebook))";
DataSet myds = mycmd.ExecuteQuery(mysql, "book");
DataView mydv = myds.Tables["book"].DefaultView;
if (mydv.Count == 0)
{
Response.Write("<script>alert('没有订票记录!');</script>");
}
else
{
GridView1.DataSource = mydv;
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataSet myds = new DataSet();
string tno = Request.QueryString["tno"];
mysql = "SELECT * FROM teacher WHERE tno='" + tno + "'";
myds = mydb.ExecuteQuery(mysql, "teacher");
DataRow mydr = myds.Tables["teacher"].Rows[0];
TextBox1.Text = mydr["tno"].ToString();
TextBox2.Text = mydr["tname"].ToString();
string xb = mydr["tsex"].ToString();
if (xb == "男")
{
RadioButton1.Checked = true;
}
else if (xb == "女")
{
RadioButton2.Checked = true;
}
TextBox3.Text = mydr["tdepart"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataSet myds = new DataSet();
string sno = Request.QueryString["sno"];
mysql = "SELECT * FROM student WHERE sno='" + sno + "'";
myds = mydb.ExecuteQuery(mysql, "student");
DataRow mydr = myds.Tables["student"].Rows[0];
TextBox1.Text = mydr["sno"].ToString();
TextBox2.Text = mydr["sname"].ToString();
string xb = mydr["ssex"].ToString();
if (xb == "男")
{
RadioButton1.Checked = true;
}
else if (xb == "女")
{
RadioButton2.Checked = true;
}
DropDownList1.Text = mydr["snation"].ToString();
TextBox3.Text = mydr["sclass"].ToString();
}
}
