protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("frmLogin.aspx"); } if (!IsPostBack) { if (Request["Text"] != null) { LblPaid.Visible = true; LblPaid.Text = Request["Text"].ToString(); LblPaid.Visible = true; } if (Request["Text2"] != null) { LblPaid.Text = Request["Text2"].ToString(); LblPaid.Visible = true; } obj.BookingId = Convert.ToInt32(Request["BookingId"]); DataSet ds = obj.ShowBookingConform(); LblMessage.Visible = true; LblMessage.Text = "For Amount Paying Click On Amount! "; GridViewDisplay.DataSource = ds.Tables[0]; GridViewDisplay.DataBind(); } }
public void bind() { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString()); conn.Open(); string str; str = "select * from Work2,Teacher where Work2.Wnum=Teacher.Tnum"; SqlCommand cmd = new SqlCommand(str, conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); GridViewDisplay.DataSource = ds; GridViewDisplay.DataBind(); conn.Close(); }
public void bind() { String user_num = Server.UrlDecode(Request.Cookies["Userisgrade"].Value); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString()); conn.Open(); string str = "select * from Teacher,Class,Crouse,Work1 where Teacher.Tnum = Work1.Wtnum AND Work1.Wclnum = Class.Clnum AND Work1.Wcrnum = Crouse.Crnum AND Class.Clgrade = '" + user_num + "' order by Class.Clnum , Crouse.Crnum"; SqlCommand cmd = new SqlCommand(str, conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); GridViewDisplay.DataSource = ds; GridViewDisplay.DataBind(); GridViewDisplay.Visible = true; conn.Close(); }
public void bind2() { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString()); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; String str; str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay where Teacher.Tnum=Pay.Ptnum"; cmd.CommandText = str; SqlDataAdapter sda = new SqlDataAdapter(cmd); dsk = new DataSet(); sda.Fill(dsk); GridViewDisplay.DataSource = dsk; GridViewDisplay.DataBind(); conn.Close(); }
public void bind() { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString()); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; String str; str = "select * from Teacher"; cmd.CommandText = str; SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); GridViewDisplay.DataSource = ds; GridViewDisplay.DataBind(); conn.Close(); }
protected void search_Click(object sender, EventArgs e) { String search_way = Way.SelectedItem.Value.Trim(); String str = ""; String choose_item = choose.SelectedItem.Value.Trim(); if (search_way.Equals("按年级查询")) { str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay,Work1,Class where Teacher.Tnum=Pay.Ptnum and Teacher.Tnum=Work1.Wtnum and Work1.Wclnum=Class.Clnum and Class.Clgrade='" + choose_item + "'"; } else if (search_way.Equals("按月份查询")) { int i = int.Parse(choose_item); str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay where Pay.Ptnum=Teacher.Tnum and Pay.Pmonth='" + i + "'"; } else if (search_way.Equals("按教师类型查询")) { if (choose.SelectedItem.Value.ToString().Equals("后勤")) { str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay,Work2 where Teacher.Tnum=Pay.Ptnum and Teacher.Tnum=Work2.Wnum "; } else { str = "select distinct Tnum,Tname,Pterm,Pmonth,Ptimes,Pposition,Pmanager,Paward,Pabsent,Paddelse,Preduceelse,Pservice from Teacher,Pay,Work1 where Teacher.Tnum=Pay.Ptnum and Teacher.Tnum=Work1.Wtnum "; } } SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString()); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = str; SqlDataAdapter sda = new SqlDataAdapter(cmd); dsk = new DataSet(); sda.Fill(dsk); GridViewDisplay.DataSource = dsk; GridViewDisplay.DataBind(); conn.Close(); }
public void bind(String key) { key = keyname.Text.Trim(); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConString"].ToString()); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; String str; str = "select * from Teacher where Tname='" + key + "' or Tnum='" + key + "'"; cmd.CommandText = str; SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); GridViewDisplay.DataSource = ds; GridViewDisplay.DataBind(); conn.Close(); }