public void ViewImg() { SqlCommand command = new SqlCommand("SELECT HImgName,ID from [IM] where ID='" + lblEnrolment.Text.ToString() + "'", con); SqlDataAdapter daimages = new SqlDataAdapter(command); DataTable dt = new DataTable(); daimages.Fill(dt); DataList1.DataSource = dt; DataList1.DataBind(); SqlCommand cmdhsign = new SqlCommand("SELECT HSignName,ID from [IM] where ID='" + lblEnrolment.Text.ToString() + "'", con); SqlDataAdapter dasign = new SqlDataAdapter(cmdhsign); DataTable dtsign = new DataTable(); dasign.Fill(dtsign); dlsign.DataSource = dtsign; dlsign.DataBind(); SqlCommand cmd2 = new SqlCommand("SELECT AImgName,ID from [IM] where ID='" + lblEnrolment.Text.ToString() + "'", con); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); DataTable dt22 = new DataTable(); da2.Fill(dt22); DataList3.DataSource = dt22; DataList3.DataBind(); SqlCommand cmd3 = new SqlCommand("SELECT ASignName,ID from [IM] where ID='" + lblEnrolment.Text.ToString() + "'", con); SqlDataAdapter da3 = new SqlDataAdapter(cmd3); DataTable dt23 = new DataTable(); da3.Fill(dt23); DataList4.DataSource = dt23; DataList4.DataBind(); imgDefault.Visible = false; panelImage.Visible = true; Image2.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int StuId = ((Model.Login)Session["CurrentUser"]).UserName; int CourseId = Convert.ToInt32(Request.Params["CourseId"]); coursename.Text = (new CourseManege().queryCourseById(CourseId)).CourseName; //绑定未完成作业 List <Homework> ufhkList = new HomeworkManage().queryUnfinishedHw(CourseId, StuId); DataList1.DataSource = ufhkList; DataList1.DataBind(); //绑定已完成作业 List <Homework> fhkList = new HomeworkManage().queryfinishedHw(CourseId, StuId); DataList3.DataSource = fhkList; DataList3.DataBind(); //绑定已审批作业 List <Homework> chkList = new HomeworkManage().querycheckedHw(CourseId, StuId); DataList4.DataSource = chkList; DataList4.DataBind(); //绑定考勤 List <KQ> KqList = new KqManage().queryAllKq(CourseId); foreach (KQ kq in KqList) { int State = new KqManage().HasChecked(StuId, kq.KQId); if (State > 0) { kq.state = "已签到"; } else { kq.state = "<span style='color:red;'>未签到<span>"; } } DataList2.DataSource = KqList; DataList2.DataBind(); //绑定公告 List <JXGG> gglist = new GGManage().LookJXGG(CourseId); Repeater3.DataSource = gglist; Repeater3.DataBind(); } }
protected void DataList4_UpdateCommand(object sender, DataListCommandEventArgs e) { string numRow = DataList4.DataKeys[e.Item.ItemIndex].ToString(); TextBox txtVcCallRefNo = e.Item.FindControl("txtVcCallRefNo") as TextBox; TextBox txtVcFuComment = e.Item.FindControl("txtVcFuComment") as TextBox; TextBox txtVcContactName = e.Item.FindControl("txtVcContactName") as TextBox; TextBox txtVcContactPhone = e.Item.FindControl("txtVcContactPhone") as TextBox; TextBox txtVcContactEmail = e.Item.FindControl("txtVcContactEmail") as TextBox; TextBox txtDatFollowUp = e.Item.FindControl("txtDatFollowUp") as TextBox; String UpdateQuery = string.Format( "UPDATE FollowUp SET " + "vcCallRefNo={0}," + "vcFuComment={1}," + "vcContactName={2}," + "vcContactPhone={3}," + "vcContactEmail={4}," + "datFollowUp={5} " + "WHERE numRowFu={6}", txtVcCallRefNo.Text.Equals("") ? "NULL" : "'" + txtVcCallRefNo.Text + "'", txtVcFuComment.Text.Equals("") ? "NULL" : "'" + txtVcFuComment.Text + "'", txtVcContactName.Text.Equals("") ? "NULL" : "'" + txtVcContactName.Text + "'", txtVcContactPhone.Text.Equals("") ? "NULL" : "'" + txtVcContactPhone.Text + "'", txtVcContactEmail.Text.Equals("") ? "NULL" : "'" + txtVcContactEmail.Text + "'", txtDatFollowUp.Text.Equals("") ? "NULL" : "'" + Convert.ToDateTime(txtDatFollowUp.Text) + "'", Convert.ToInt32(numRow) ); DataList4.EditItemIndex = -1; DataSet ds = GridDataTable(UpdateQuery); Session["AccountsTable"] = ds.Tables[0]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); DataList4.DataSource = ds.Tables[2]; DataList4.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataList4.DataSource = data.GetDataReader("select * from dbo.LanMu "); DataList4.DataBind(); if (Request.QueryString["BID"] == null) { TD1.Visible = false; TD2.Visible = false; } else { TD1.Visible = true; TD2.Visible = true; DataList1.DataSource = data.GetDataReader("select * from NewType where Bid='" + Request.QueryString["BID"].ToString() + "' order by id desc "); DataList1.DataBind(); } } }
//int di; protected void Page_Load(object sender, EventArgs e) { GetGoodsInfo(); Label123.Text = Session["UserName"].ToString(); //DataList1.DataSource = op.SelectInfo(); //DataList1.DataBind(); DataList3.DataSource = op.SelectImage("手机", 5); DataList3.DataBind(); DataList4.DataSource = op.SelectImage("电器城", 5); DataList4.DataBind(); DataList5.DataSource = op.SelectImage("西西超市", 5); DataList5.DataBind(); DataList6.DataSource = op.SelectImage("西西生活", 5); DataList6.DataBind(); DataList7.DataSource = op.SelectImage("有我你更美", 5); DataList7.DataBind(); DataList8.DataSource = op.SelectImage("智能硬件", 5); DataList8.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = 1; DataTable dt = new DataTable(); dt = bus.Show8AProduct(id); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); dt2 = bus.Show8AProduct(2); dt3 = bus.Show8AProduct(3); DataList1.DataSource = dt; DataList1.DataBind(); DataList2.DataSource = dt2; DataList2.DataBind(); DataList3.DataSource = dt3; DataList3.DataBind(); DataTable dt4 = new DataTable(); dt4 = bus.Show3Product(); DataList4.DataSource = dt4; DataList4.DataBind(); } }
public void load_data() { try { string mablog = Request.QueryString["MaSP"].ToString(); string sql = "SELECT BinhLuanSP.MaSP, BinhLuanSP.NgayBL, BinhLuanSP.NoiDungBL, TaiKhoan.TenTK FROM BinhLuanSP INNER JOIN TaiKhoan ON BinhLuanSP.MaTK = TaiKhoan.MaTK where binhluansp.MaSP=" + mablog + " order by binhluansp.NgayBL desc"; p.DataSource = XLDL.GetData(sql).DefaultView; p.PageSize = 5; p.CurrentPageIndex = trangthu; p.AllowPaging = true; btnDau.Enabled = true; btnTruoc.Enabled = true; btnSau.Enabled = true; btnCuoi.Enabled = true; if (p.IsFirstPage == true) { btnDau.Enabled = false; btnTruoc.Enabled = false; btnSau.Enabled = true; btnCuoi.Enabled = true; } if (p.IsLastPage == true) { btnDau.Enabled = true; btnTruoc.Enabled = true; btnSau.Enabled = false; btnCuoi.Enabled = false; } if (p.PageCount == 1) { btnDau.Visible = false; btnTruoc.Visible = false; btnSau.Visible = false; btnCuoi.Visible = false; tbTrang.Visible = false; } tbTrang.Text = (trangthu + 1) + " / " + p.PageCount; DataList4.DataSource = p; DataList4.DataBind(); } catch { Response.Redirect("~/Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { SqlCommand komut = new SqlCommand("Select *From Tbl_Kategoriler ", bgl.baglanti()); SqlDataReader oku = komut.ExecuteReader(); DataList1.DataSource = oku; DataList1.DataBind(); SqlCommand komutt = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=1 ", bgl.baglanti()); SqlDataReader okuu = komutt.ExecuteReader(); DataList3.DataSource = okuu; DataList3.DataBind(); SqlCommand komut2 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=6 ", bgl.baglanti()); SqlDataReader oku2 = komut2.ExecuteReader(); DataList4.DataSource = oku2; DataList4.DataBind(); SqlCommand komut3 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=9 ", bgl.baglanti()); SqlDataReader oku3 = komut3.ExecuteReader(); DataList5.DataSource = oku3; DataList5.DataBind(); SqlCommand komut4 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=11 ", bgl.baglanti()); SqlDataReader oku4 = komut4.ExecuteReader(); DataList6.DataSource = oku4; DataList6.DataBind(); SqlCommand komut5 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=8 ", bgl.baglanti()); SqlDataReader oku5 = komut5.ExecuteReader(); DataList7.DataSource = oku5; DataList7.DataBind(); SqlCommand komut6 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=10 ", bgl.baglanti()); SqlDataReader oku6 = komut6.ExecuteReader(); DataList8.DataSource = oku6; DataList8.DataBind(); SqlCommand komut7 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=7 ", bgl.baglanti()); SqlDataReader oku7 = komut7.ExecuteReader(); DataList9.DataSource = oku7; DataList9.DataBind(); SqlCommand komut8 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=2 ", bgl.baglanti()); SqlDataReader oku8 = komut8.ExecuteReader(); DataList10.DataSource = oku8; DataList10.DataBind(); SqlCommand komut9 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=9 ", bgl.baglanti()); SqlDataReader oku9 = komut9.ExecuteReader(); DataList11.DataSource = oku9; DataList11.DataBind(); SqlCommand komut10 = new SqlCommand("Select *From Tbl_kahveler WHERE Kahveid=7 ", bgl.baglanti()); SqlDataReader oku10 = komut10.ExecuteReader(); DataList12.DataSource = oku10; DataList12.DataBind(); }
protected void Timer1_Tick(object sender, EventArgs e) { DataList1.DataBind(); DataList3.DataBind(); DataList4.DataBind(); }
private void ProveriLattestVesti() { // Izminuvanje na novite neprocitani vesti i odreduvanje na nivniot broj: SqlConnection konekcija = new SqlConnection(); konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["Konekcija"].ConnectionString; string sqlString = @"SELECT COUNT(Vest_Id) AS Broj, V.Tip FROM Vest AS V WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"' AND V.Tip=1 AND V.Vest_Id NOT IN (SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP WHERE Tip = 1 AND MAC_Add='" + Session["MAC"] + @"' ) GROUP BY V.Tip UNION SELECT COUNT(Vest_Id) AS Broj, V.Tip FROM Vest AS V WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"' AND V.Tip=2 AND V.Vest_Id NOT IN (SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP WHERE Tip = 2 AND MAC_Add='" + Session["MAC"] + @"' ) GROUP BY V.Tip UNION SELECT COUNT(Vest_Id) AS Broj, V.Tip FROM Vest AS V WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"' AND V.Tip=3 AND V.Vest_Id NOT IN (SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP WHERE Tip = 3 AND MAC_Add='" + Session["MAC"] + @"' ) GROUP BY V.Tip UNION SELECT COUNT(Vest_Id) AS Broj, V.Tip FROM Vest AS V WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"' AND V.Tip=4 AND V.Vest_Id NOT IN (SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP WHERE Tip = 4 AND MAC_Add='" + Session["MAC"] + @"' ) GROUP BY V.Tip "; SqlCommand komanda = new SqlCommand(sqlString, konekcija); try { konekcija.Open(); SqlDataReader citac = komanda.ExecuteReader(); while (citac.Read()) { // Zapisuvanje na brojot na neprocitani vesti: if (citac["Tip"].ToString() == "1") { lblFudbalLattest.Text = citac["Broj"].ToString(); } if (citac["Tip"].ToString() == "2") { lblKosarkaLattest.Text = citac["Broj"].ToString(); } if (citac["Tip"].ToString() == "3") { lblRakometLattest.Text = citac["Broj"].ToString(); } if (citac["Tip"].ToString() == "4") { lblOstanatoLattest.Text = citac["Broj"].ToString(); } } citac.Close(); // Fudbal - Disabled ako nema novi if (lblFudbalLattest.Text == "0") { pnlFudbalLattest.Visible = false; lblFudbalDDLInfo.Visible = true; imgFudbalLattest.ImageUrl = "~/Images/fudbal_topka-disabled.png"; } else { // Fudbal - Ispolnuvanje samo so novite vesti : sqlDSFudbalDDL.SelectCommand = @"SELECT * FROM Vest AS V WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"' AND V.Tip=1 AND V.Vest_Id NOT IN (SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP WHERE Tip = 1 AND MAC_Add='" + Session["MAC"] + @"' )"; DataList2.DataSource = sqlDSFudbalDDL; DataList2.DataBind(); } // Kosarka - Disabled ako nema novi if (lblKosarkaLattest.Text == "0") { pnlKosarkaLattest.Visible = false; lblKosarkaDDLInfo.Visible = true; imgKosarkaLattest.ImageUrl = "~/Images/basket_topka_disabled.png"; } else { // Kosarka - Ispolnuvanje samo so novite vesti : sqlDSKosarkaDDL.SelectCommand = @"SELECT * FROM Vest AS V WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"' AND V.Tip=2 AND V.Vest_Id NOT IN (SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP WHERE Tip = 2 AND MAC_Add='" + Session["MAC"] + @"' )"; DataList3.DataSource = sqlDSKosarkaDDL; DataList3.DataBind(); } // Rakomet - Disabled ako nema novi if (lblRakometLattest.Text == "0") { pnlRakometLattest.Visible = false; lblRakometDDLInfo.Visible = true; imgRakometLattest.ImageUrl = "~/Images/rakomet_topka_disabled.png"; } else { // Rakomet - Ispolnuvanje samo so novite vesti : sqlDSRakometDDL.SelectCommand = @"SELECT * FROM Vest AS V WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"' AND V.Tip = 3 AND V.Vest_Id NOT IN (SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP WHERE Tip = 3 AND MAC_Add='" + Session["MAC"] + @"' )"; DataList4.DataSource = sqlDSRakometDDL; DataList4.DataBind(); } // Ostanato - Disabled ako nema novi if (lblOstanatoLattest.Text == "0") { pnlOstanatoLattest.Visible = false; lblOstanatoDDLInfo.Visible = true; imgOstanatoLattest.ImageUrl = "~/Images/ostanati_sportovi_disabled.png"; } else { // Ostanato - Ispolnuvanje samo so novite vesti : sqlDSOstanatoDDL.SelectCommand = @"SELECT * FROM Vest AS V WHERE V.Datum_Objava > '" + DateTime.Now.AddDays(-2).ToString("dd-MMM-yyyy", CultureInfo.InvariantCulture) + @"' AND V.Tip = 4 AND V.Vest_Id NOT IN (SELECT Vest_Id FROM Vest_MAC_Poseta AS VMP WHERE Tip = 4 AND MAC_Add='" + Session["MAC"] + @"' )"; DataList5.DataSource = sqlDSOstanatoDDL; DataList5.DataBind(); } } catch (Exception err) { } finally { konekcija.Close(); } }
protected void Page_Load(object sender, EventArgs e) { Data_con dc = new Data_con(); SqlConnection con = dc.SQL_con(); con.Open(); SqlDataAdapter da1 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题' ", con); DataSet ds1 = new DataSet(); da1.Fill(ds1, "Down_1"); con.Close(); DataList1.DataSource = ds1; DataList1.DataBind(); con.Open(); SqlDataAdapter da2 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con); DataSet ds2 = new DataSet(); da2.Fill(ds2, "Down_1"); con.Close(); DataList2.DataSource = ds2; DataList2.DataBind(); con.Open(); SqlDataAdapter da3 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='软件专题' ", con); DataSet ds3 = new DataSet(); da3.Fill(ds3, "Down_1"); con.Close(); DataList3.DataSource = ds3; DataList3.DataBind(); con.Open(); SqlDataAdapter da4 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con); DataSet ds4 = new DataSet(); da4.Fill(ds4, "Down_1"); con.Close(); DataList4.DataSource = ds4; DataList4.DataBind(); con.Open(); SqlDataAdapter da5 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='游戏专题' ", con); DataSet ds5 = new DataSet(); da5.Fill(ds5, "Down_1"); con.Close(); DataList5.DataSource = ds5; DataList5.DataBind(); con.Open(); SqlDataAdapter da6 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con); DataSet ds6 = new DataSet(); da6.Fill(ds6, "Down_1"); con.Close(); DataList6.DataSource = ds6; DataList6.DataBind(); }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.Text == "All") { Panel2.Visible = true; Panel3.Visible = true; Panel4.Visible = true; Panel5.Visible = true; cn.Open(); cmd = new SqlCommand("Select * from house", cn); dr = cmd.ExecuteReader(); DataList1.DataSource = dr; DataList1.DataBind(); cn.Close(); cn.Open(); cmd = new SqlCommand("Select * from room", cn); dr = cmd.ExecuteReader(); DataList2.DataSource = dr; DataList2.DataBind(); cn.Close(); cn.Open(); cmd = new SqlCommand("Select * from hall", cn); dr = cmd.ExecuteReader(); DataList3.DataSource = dr; DataList3.DataBind(); cn.Close(); cn.Open(); cmd = new SqlCommand("Select * from ground", cn); dr = cmd.ExecuteReader(); DataList4.DataSource = dr; DataList4.DataBind(); cn.Close(); } else { if (DropDownList1.Text == "HOUSE") { Panel2.Visible = true; Panel3.Visible = false; Panel4.Visible = false; Panel5.Visible = false; cn.Open(); cmd = new SqlCommand("Select * from house", cn); dr = cmd.ExecuteReader(); DataList1.DataSource = dr; DataList1.DataBind(); cn.Close(); } else if (DropDownList1.Text == "ROOM") { Panel2.Visible = false; Panel3.Visible = true; Panel4.Visible = false; Panel5.Visible = false; cn.Open(); cmd = new SqlCommand("Select * from room", cn); dr = cmd.ExecuteReader(); DataList2.DataSource = dr; DataList2.DataBind(); cn.Close(); } else if (DropDownList1.Text == "HALL") { Panel2.Visible = false; Panel3.Visible = false; Panel4.Visible = true; Panel5.Visible = false; cn.Open(); cmd = new SqlCommand("Select * from hall", cn); dr = cmd.ExecuteReader(); DataList3.DataSource = dr; DataList3.DataBind(); cn.Close(); } else if (DropDownList1.Text == "GROUND") { Panel2.Visible = false; Panel3.Visible = false; Panel4.Visible = false; Panel5.Visible = true; cn.Open(); cmd = new SqlCommand("Select * from ground", cn); dr = cmd.ExecuteReader(); DataList4.DataSource = dr; DataList4.DataBind(); cn.Close(); } } }
protected void DdlDoctors_SelectedIndexChanged(object sender, EventArgs e) { DataList2.Visible = false; DataList4.Visible = true; try { var Query = from item in db.doctor_availabilities where item.d_id == DdlDoctors.SelectedValue.ToString() orderby item.a_date ascending select item; DataList4.DataSource = Query; DataList4.DataBind(); foreach (DataListItem dli in DataList4.Items) { var Query4 = from item in db.doctor_availabilities where item.d_id == DdlDoctors.SelectedValue.ToString() select item; Label lbl6 = dli.FindControl("Label6") as Label; DataList dl3 = dli.FindControl("DataList5") as DataList; var Query2 = from item in db.view_doc_available_times where item.a_date == lbl6.Text && item.d_hakkimid == DdlDoctors.SelectedValue.ToString() select item; DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[3] { new DataColumn("date"), new DataColumn("time"), new DataColumn("d_hakkimid") }); foreach (var ss in Query2) { if (ss.time == "") { } else { string ab1 = "", ab2 = "", timet = ""; int l = ss.time.ToString().Count(); ab1 = ss.time.ToString().Substring(0, l - 2); ab2 = ss.time.ToString().Substring(l - 2, 2); timet = ab1.ToString() + " " + ab2.ToString(); dt.Rows.Add(ss.a_date, timet, ss.d_hakkimid); } } dl3.DataSource = dt; dl3.DataBind(); lbl6.Text = DateTime.Parse(lbl6.Text).ToString("yyy d MMM"); foreach (DataListItem dl3i in dl3.Items) { //Button btn2 = dl3i.FindControl("Button2") as Button; LinkButton lnk2 = dl3i.FindControl("LinkButton2") as LinkButton; string date = DateTime.Parse(lbl6.Text).ToString("yyyy-MM-dd"); var Query3 = from item in db.tbl_doctor_appointments where item.d_id == DdlDoctors.SelectedValue.ToString() && item.a_date == date && item.a_time == lnk2.Text select item; if (Query3.Count() > 0) { foreach (var tt in Query3) { if (tt.a_status == 0) { //if (Session["Speciality"].ToString() == "Auto") //{ lnk2.BackColor = System.Drawing.Color.Orange; lnk2.Enabled = false; lnk2.ToolTip = "Waiting for confirmation"; //} //else //{ // lnk2.BackColor = System.Drawing.Color.Orange; lnk2.Enabled = false; lnk2.ToolTip = "في انتظار التأكيد"; //} } if (tt.a_status == 1 || tt.a_status == 4) { //if (Session["Speciality"].ToString() == "Auto") //{ lnk2.BackColor = System.Drawing.Color.IndianRed; lnk2.Enabled = false; lnk2.ToolTip = "Booked"; //} //else //{ // lnk2.BackColor = System.Drawing.Color.IndianRed; lnk2.Enabled = false; lnk2.ToolTip = "حجز"; //} } } } else { //lnk2.BackColor = System.Drawing.Color.Green; //if (Session["Speciality"].ToString() == "Auto") //{ lnk2.ToolTip = "Available"; //} //else //{ // lnk2.ToolTip = "متاح"; //} } } } } catch (Exception ex) { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //fetch data from database display in datalist1 code SqlCommand cmd = new SqlCommand("select * from ProductRegi", con); con.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); DataList1.DataSource = ds; DataList1.DataBind(); //select Last 10 Record from database display datalist2 SqlDataAdapter top = new SqlDataAdapter("select TOP 8 * from ProductRegi order by PR_Id desc", con); DataTable ds1 = new DataTable(); top.Fill(ds1); DataList2.DataSource = ds1; DataList2.DataBind(); SqlDataAdapter top1 = new SqlDataAdapter("select TOP 5 * from ProductRegi order by PR_Id desc", con); DataTable ds2 = new DataTable(); top1.Fill(ds2); DataList3.DataSource = ds2; DataList3.DataBind(); SqlDataAdapter adp = new SqlDataAdapter("select * from Notifications", con); DataTable ds3 = new DataTable(); adp.Fill(ds3); DataList4.DataSource = ds3; DataList4.DataBind(); con.Close(); //fetch data form database malls name in pune SqlDataAdapter pune = new SqlDataAdapter("select Distinct(M_Name) from Mall_Regi where M_city='Pune' ", con); DataTable dp = new DataTable(); pune.Fill(dp); DropDownList1.DataSource = dp; DropDownList1.DataTextField = "M_Name"; DropDownList1.DataValueField = "M_Name"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "Select Pune Malls"); //fetch data form database malls name in Mumbai SqlDataAdapter mumbai = new SqlDataAdapter("select Distinct(M_Name) from Mall_Regi where M_city='Mumbai' ", con); DataTable dm = new DataTable(); mumbai.Fill(dm); DropDownList2.DataSource = dm; DropDownList2.DataTextField = "M_Name"; DropDownList2.DataValueField = "M_Name"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "Select Mumbai Malls"); //fetch data form database malls name in Ahmedabad SqlDataAdapter Ahmedabad = new SqlDataAdapter("select Distinct(M_Name) from Mall_Regi where M_city='Ahmedabad' ", con); DataTable dah = new DataTable(); Ahmedabad.Fill(dah); DropDownList3.DataSource = dah; DropDownList3.DataTextField = "M_Name"; DropDownList3.DataValueField = "M_Name"; DropDownList3.DataBind(); DropDownList3.Items.Insert(0, "Select Ahmedabad Malls"); //fetch data form database malls name in Baroda SqlDataAdapter Baroda = new SqlDataAdapter("select Distinct(M_Name) from Mall_Regi where M_city='Baroda' ", con); DataTable db = new DataTable(); Baroda.Fill(db); DropDownList4.DataSource = db; DropDownList4.DataTextField = "M_Name"; DropDownList4.DataValueField = "M_Name"; DropDownList4.DataBind(); DropDownList4.Items.Insert(0, "Select Baroda Malls"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string MALOAI = Request.QueryString["MALOAI"]; DataTable dt = new DataTable(); if (MALOAI == null) { dt = x.GetData("select* from SANPHAM WHERE MALOAI=1"); if (dt.Rows.Count > 0) { DataList.DataSource = dt; DataList.DataBind(); dt.Clear(); dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=1"); title.DataSource = dt; title.DataBind(); } dt.Clear(); dt = x.GetData("select* from SANPHAM WHERE MALOAI=2"); if (dt.Rows.Count > 0) { DataList1.DataSource = dt; DataList1.DataBind(); dt.Clear(); dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=2"); title1.DataSource = dt; title1.DataBind(); } dt.Clear(); dt = x.GetData("select* from SANPHAM WHERE MALOAI=3"); if (dt.Rows.Count > 0) { DataList2.DataSource = dt; DataList2.DataBind(); dt.Clear(); dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=3"); title2.DataSource = dt; title2.DataBind(); } dt.Clear(); dt = x.GetData("select* from SANPHAM WHERE MALOAI=4"); if (dt.Rows.Count > 0) { DataList3.DataSource = dt; DataList3.DataBind(); dt.Clear(); dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=4"); title3.DataSource = dt; title3.DataBind(); } dt.Clear(); dt = x.GetData("select* from SANPHAM WHERE MALOAI=5"); if (dt.Rows.Count > 0) { DataList4.DataSource = dt; DataList4.DataBind(); dt.Clear(); dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=5"); title4.DataSource = dt; title4.DataBind(); } dt.Clear(); dt = x.GetData("select* from SANPHAM WHERE MALOAI=6"); if (dt.Rows.Count > 0) { DataList5.DataSource = dt; DataList5.DataBind(); dt.Clear(); dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=6"); title5.DataSource = dt; title5.DataBind(); } } else { dt = x.GetData("select* from SANPHAM WHERE MALOAI=" + MALOAI); if (dt.Rows.Count > 0) { DataList.DataSource = dt; DataList.DataBind(); dt.Clear(); dt = x.GetData("SELECT TEN FROM LOAI WHERE MALOAI=" + MALOAI); title.DataSource = dt; title.DataBind(); } } /* * if (dt.Rows.Count > 0) * { * DataList.DataSource = dt; * DataList.DataBind(); * }*/ } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { int xyz = 0; DataList2.DataSource = ""; DataList2.DataBind(); DataList3.DataSource = ""; DataList3.DataBind(); DataList4.DataSource = ""; DataList4.DataBind(); if (DropDownList1.Text == "All" && TextBox2.Text == "") { Panel2.Visible = true; Panel3.Visible = true; Panel4.Visible = true; Panel5.Visible = true; cn.Open(); cmd = new SqlCommand("Select * from house", cn); dr = cmd.ExecuteReader(); DataList1.DataSource = dr; DataList1.DataBind(); cn.Close(); cn.Open(); cmd = new SqlCommand("Select * from room", cn); dr = cmd.ExecuteReader(); DataList2.DataSource = dr; DataList2.DataBind(); cn.Close(); cn.Open(); cmd = new SqlCommand("Select * from hall", cn); dr = cmd.ExecuteReader(); DataList3.DataSource = dr; DataList3.DataBind(); cn.Close(); cn.Open(); cmd = new SqlCommand("Select * from ground", cn); dr = cmd.ExecuteReader(); DataList4.DataSource = dr; DataList4.DataBind(); cn.Close(); } else { if (DropDownList1.Text == "HOUSE" && TextBox2.Text == "") { Panel2.Visible = true; Panel3.Visible = false; Panel4.Visible = false; Panel5.Visible = false; DataTable dt = new DataTable(); cn.Open(); da = new SqlDataAdapter("Select * from house", cn); ds = new DataSet(); da.Fill(ds); int colCount = ds.Tables[0].Rows.Count; DataTable ta = new DataTable(); String abc; for (int i = 0; i < colCount; i++) { for (int j = 0; j < 5; j++) { String s = (ds.Tables[0].Rows[i][j + 9].ToString().ToUpper()).Trim(); String l = (TextBox2.Text.ToUpper()).Trim(); for (int k = 0, a = 0; k < s.Length; k++) { if (l[a] == s[k] && l.Length <= s.Substring(k).Length) { if (String.Compare(l, (s.Substring(k, l.Length))) == 0) { abc = "select * from house where " + ds.Tables[0].Columns[j + 9].ColumnName + " = '" + ds.Tables[0].Rows[i][j + 9].ToString() + "'"; xyz++; cn.Close(); cn.Open(); cmd = new SqlCommand(abc, cn); dr = cmd.ExecuteReader(); DataList4.DataSource = dr; DataList4.DataBind(); cn.Close(); } } } } } } else if (DropDownList1.Text == "ROOM" && TextBox2.Text == "") { Panel2.Visible = false; Panel3.Visible = true; Panel4.Visible = false; Panel5.Visible = false; DataTable dt = new DataTable(); cn.Open(); da = new SqlDataAdapter("Select * from ground", cn); ds = new DataSet(); da.Fill(ds); int colCount = ds.Tables[0].Rows.Count; DataTable ta = new DataTable(); String abc; for (int i = 0; i < colCount; i++) { for (int j = 0; j < 5; j++) { String s = (ds.Tables[0].Rows[i][j + 9].ToString().ToUpper()).Trim(); String l = (TextBox2.Text.ToUpper()).Trim(); for (int k = 0, a = 0; k < s.Length; k++) { if (l[a] == s[k] && l.Length <= s.Substring(k).Length) { if (String.Compare(l, (s.Substring(k, l.Length))) == 0) { abc = "select * from room where " + ds.Tables[0].Columns[j + 9].ColumnName + " = '" + ds.Tables[0].Rows[i][j + 9].ToString() + "'"; cn.Close(); cn.Open(); cmd = new SqlCommand(abc, cn); dr = cmd.ExecuteReader(); DataList4.DataSource = dr; DataList4.DataBind(); cn.Close(); } } } } } } else if (DropDownList1.Text == "HALL" && TextBox2.Text == "") { Panel2.Visible = false; Panel3.Visible = false; Panel4.Visible = true; Panel5.Visible = false; DataTable dt = new DataTable(); cn.Open(); da = new SqlDataAdapter("Select * from ground", cn); ds = new DataSet(); da.Fill(ds); int colCount = ds.Tables[0].Rows.Count; DataTable ta = new DataTable(); String abc; for (int i = 0; i < colCount; i++) { for (int j = 0; j < 5; j++) { String s = (ds.Tables[0].Rows[i][j + 9].ToString().ToUpper()).Trim(); String l = (TextBox2.Text.ToUpper()).Trim(); for (int k = 0, a = 0; k < s.Length; k++) { if (l[a] == s[k] && l.Length <= s.Substring(k).Length) { if (String.Compare(l, (s.Substring(k, l.Length))) == 0) { abc = "select * from hall where " + ds.Tables[0].Columns[j + 9].ColumnName + " = '" + ds.Tables[0].Rows[i][j + 9].ToString() + "'"; cn.Close(); cn.Open(); cmd = new SqlCommand(abc, cn); dr = cmd.ExecuteReader(); DataList4.DataSource = dr; DataList4.DataBind(); cn.Close(); } } } } } } else if (DropDownList1.Text == "GROUND" && TextBox2.Text == "") { Panel2.Visible = false; Panel3.Visible = false; Panel4.Visible = false; Panel5.Visible = true; DataTable dt = new DataTable(); cn.Open(); da = new SqlDataAdapter("Select * from ground", cn); ds = new DataSet(); da.Fill(ds); int colCount = ds.Tables[0].Rows.Count; DataTable ta = new DataTable(); String abc; for (int i = 0; i < colCount; i++) { for (int j = 0; j < 5; j++) { String s = (ds.Tables[0].Rows[i][j + 9].ToString().ToUpper()).Trim(); String l = (TextBox2.Text.ToUpper()).Trim(); for (int k = 0, a = 0; k < s.Length; k++) { if (l[a] == s[k] && l.Length <= s.Substring(k).Length) { if (String.Compare(l, (s.Substring(k, l.Length))) == 0) { abc = "select * from ground where " + ds.Tables[0].Columns[j + 9].ColumnName + " = '" + ds.Tables[0].Rows[i][j + 9].ToString() + "'"; cn.Close(); cn.Open(); cmd = new SqlCommand(abc, cn); dr = cmd.ExecuteReader(); DataList4.DataSource = dr; DataList4.DataBind(); cn.Close(); } } } } } } } }
public void load_data() { try { string mablog = Request.QueryString["MaBlog"].ToString(); string sql = "select MaBLB,MaBlog,NguoiBL,NgayBL,NoiDungBL from BinhLuanBlog where MaBlog='" + mablog + "' order by NgayBL desc"; p.DataSource = XLDL.GetData(sql).DefaultView; p.PageSize = 5; p.CurrentPageIndex = trangthu; p.AllowPaging = true; btnDau.Enabled = true; btnTruoc.Enabled = true; btnSau.Enabled = true; btnCuoi.Enabled = true; if (p.IsFirstPage == true) { btnDau.Enabled = false; btnTruoc.Enabled = false; btnSau.Enabled = true; btnCuoi.Enabled = true; } if (p.IsLastPage == true) { btnDau.Enabled = true; btnTruoc.Enabled = true; btnSau.Enabled = false; btnCuoi.Enabled = false; } if (p.PageCount == 1) { btnDau.Visible = false; btnTruoc.Visible = false; btnSau.Visible = false; btnCuoi.Visible = false; tbTrang.Visible = false; } tbTrang.Text = (trangthu + 1) + " / " + p.PageCount; DataList4.DataSource = p; DataList4.DataBind(); } catch { Response.Redirect("~/TrangChu.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { Label11.Text = "Whelcom:" + Session["UserName"] + Session["AdminName"]; //实例化SqlConnection对象 string fid = ""; if (Request.QueryString["fid"] == null) { fid = "1"; } else { fid = Request.QueryString["fid"]; } SqlConnection sqlCon = new SqlConnection(); //实例化SqlConnection对象连接数据库的字符串 sqlCon.ConnectionString = "server=.;database=flowershop;Integrated Security=True;"; //定义SQL语句 string SqlStr = "select * from flower where fid='" + fid + "'"; //实例化SqlDataAdapter对象 SqlDataAdapter da = new SqlDataAdapter(SqlStr, sqlCon); //实例化数据集DataSet DataSet ds = new DataSet(); da.Fill(ds, "flower"); //绑定DataList控件 DataList1.DataSource = ds; //设置数据源,用于填充控件中的项的值列表 DataList1.DataBind(); //将控件及其所有子控件绑定到指定的数据源 string SqlStr1 = "select top(4)* from flower "; //实例化SqlDataAdapter对象 SqlDataAdapter da1 = new SqlDataAdapter(SqlStr1, sqlCon); //实例化数据集DataSet DataSet ds1 = new DataSet(); da1.Fill(ds1, "flower"); //绑定DataList控件 DataList2.DataSource = ds1; //设置数据源,用于填充控件中的项的值列表 DataList2.DataBind(); //将控件及其所有子控件绑定到指定的数据源 string SqlStr2 = "select * from flower where fid='" + fid + "' "; //实例化SqlDataAdapter对象 SqlDataAdapter da2 = new SqlDataAdapter(SqlStr2, sqlCon); //实例化数据集DataSet DataSet ds2 = new DataSet(); da2.Fill(ds2, "flower"); //绑定DataList控件 DataList3.DataSource = ds2; //设置数据源,用于填充控件中的项的值列表 DataList3.DataBind(); //将控件及其所有子控件绑定到指定的数据源 string SqlStr3 = "select top(7)* from flower WHERE SORT='婚庆系列' or SORT='情侣系列'"; //实例化SqlDataAdapter对象 SqlDataAdapter da3 = new SqlDataAdapter(SqlStr3, sqlCon); //实例化数据集DataSet DataSet ds3 = new DataSet(); da3.Fill(ds3, "flower"); //绑定DataList控件 DataList4.DataSource = ds3; //设置数据源,用于填充控件中的项的值列表 DataList4.DataBind(); //将控件及其所有子控件绑定到指定的数据源 }
//void partiyalar() //{ // DataTable meqsed = klas.getdatatable("Select PartiyaID,Adi from PartiyalarSiyahi order by PartiyaID"); // partiya.DataTextField = "Adi"; // partiya.DataValueField = "PartiyaID"; // partiya.DataSource = meqsed; // partiya.DataBind(); // partiya.Items.Insert(0, new ListItem("Seçin", "-1")); //} protected void btnAxtar_Click(object sender, EventArgs e) { vizual(); DataList1.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,c.adi,c.Proqramteminat,c.Lisenziya,c.Sair,Proqramteminat+Lisenziya+Sair as Cemi " + "from Tesnifatlar t left join IQQeyrimaddiaktiv c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=2 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList1.DataBind(); DataList3.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,t.Tesnifatadi adi,c.Binatikili,c.Avadanliq, c.Neqliyyatvas,c.Invertar,c.Sair, c.Avadanliq + c.Neqliyyatvas +c.Binatikili+ c.Invertar + c.Sair as Cemi from Tesnifatlar t left join IQTorpaq c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=3 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList3.DataBind(); DataList4.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,t.Tesnifatadi adi,c.Depozit, c.Sair,c.Depozit + c.Sair as Cemi from " + "Tesnifatlar t left join IQSairuzunmudaktiv c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=4 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList4.DataBind(); DataList5.DataSource = klas.getdatatable(" select ROW_NUMBER() OVER (order by t.TesnifatID) SN,c.Adi,c.Defterxana,c.Yanacaq,c.Sair,c.Defterxana + c.Yanacaq + c.Sair as Cemi from " + "Tesnifatlar t left join IQEhtiyat c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=5 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList5.DataBind(); DataList6.DataSource = klas.getdatatable(" select ROW_NUMBER() OVER (order by c.IQqisamdebitor) SN,* from " + " IQQisamudDebitor c where c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList6.DataBind(); DataList7.DataSource = klas.getdatatable(" select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " + "Tesnifatlar t left join IQSairqisamudaktiv c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=7 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList7.DataBind(); DataList8.DataSource = klas.getdatatable(" select ROW_NUMBER() OVER (order by t.TesnifatID) SN,*,Bankkredit + Lizinq as Cemi from " + "Tesnifatlar t left join IQUzunmudfaizxerc c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=8 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList8.DataBind(); DataList9.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,*,Bankkredit + Lizinq as Cemi from " + "Tesnifatlar t left join IQQisamudfaizxerc c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=9 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList9.DataBind(); DataList10.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " + "Tesnifatlar t left join IQMecburiodenis c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=10 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList10.DataBind(); DataList11.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " + "Tesnifatlar t left join IQQisamudkreditor c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=11 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList11.DataBind(); DataList12.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " + "Tesnifatlar t left join IQSairqisamudohdelik c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=12 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList12.DataBind(); DataList13.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " + "Tesnifatlar t left join IQUzvlukhaqlari c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=13 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList13.DataBind(); DataList14.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by IQAlinmisianeID) SN,IQAlinmisianeID," + "PartiyaID, UserID, Hesabatili, Adi+' '+Soyad+' '+Ataadi adsoyad, Ianekodu, Seriyasi+', '+Nomresi+', '+ " + "convert(nvarchar,Verilmetarixi,104) seriyanomretarix, convert(nvarchar,Dogumtarixi,104) Dogumtarixi, Unvan, Esasvesait, Malmaterial," + " Pulformasinda, Esasvesait+Malmaterial+Pulformasinda Cemi, DaxiletmeTarixi, DeyishmeTarixi from IQAlinmisIaneler where Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and PartiyaID=" + Session["PartiyaID"].ToString()); DataList14.DataBind(); DataList15.DataSource = klas.getdatatable("select ROW_NUMBER() OVER (order by t.TesnifatID) SN,* from " + "Tesnifatlar t left join IQPulvesait c on t.TesnifatID=c.TesnifatID where t.Tesnifattipi=15 and c.Hesabatili=" + DropDownListyear.SelectedValue.ToString() + " and c.PartiyaID=" + Session["PartiyaID"].ToString()); DataList15.DataBind(); }