void loadData() { SqlConnection conn = new SqlConnection(constr); conn.Open(); string SqlStr1 = $"select [comID] ,[comName] ,[comPrice] ,[comType] ,[comSurplus] ,[comIntroduction] ,[comAddress] ,[saleStatu] from [webordertable]"; SqlDataAdapter data1 = new SqlDataAdapter(SqlStr1, conn); DataSet dataset1 = new DataSet(); data1.Fill(dataset1, "webordertable"); //绑定DataList控件 GridView1.DataSource = dataset1; GridView1.DataKeyNames = new string[] { "comID" }; GridView1.DataBind(); string SqlStr2 = $"select [comID] ,[comName] ,[comPrice] ,[comType] ,[comSurplus] ,[comIntroduction] ,[comAddress] ,[saleStatu] from [webordertable] where saleStatu='待上架'"; SqlDataAdapter data2 = new SqlDataAdapter(SqlStr2, conn); DataSet dataset2 = new DataSet(); data2.Fill(dataset2, "webordertable"); //绑定DataList控件 GridView2.DataSource = dataset2; GridView2.DataKeyNames = new string[] { "comID" }; GridView2.DataBind(); string SqlStr3 = $"select [comID] ,[comName] ,[comPrice] ,[comType] ,[comSurplus] ,[comIntroduction] ,[comAddress] ,[saleStatu] from [webordertable] where saleStatu='已发售'"; SqlDataAdapter data3 = new SqlDataAdapter(SqlStr3, conn); DataSet dataset3 = new DataSet(); data3.Fill(dataset3, "webordertable"); //绑定DataList控件 GridView3.DataSource = dataset3; GridView3.DataKeyNames = new string[] { "comID" }; GridView3.DataBind(); string SqlStr4 = $"select [comID] ,[comName] ,[comPrice] ,[comType] ,[comSurplus] ,[comIntroduction] ,[comAddress] ,[saleStatu] from [webordertable] where saleStatu='已售罄'"; SqlDataAdapter data4 = new SqlDataAdapter(SqlStr4, conn); DataSet dataset4 = new DataSet(); data4.Fill(dataset4, "webordertable"); //绑定DataList控件 GridView4.DataSource = dataset4; GridView4.DataKeyNames = new string[] { "comID" }; GridView4.DataBind(); string SqlStr5 = $"select [comID] ,[comName] ,[comPrice] ,[comType] ,[comSurplus] ,[comIntroduction] ,[comAddress] ,[saleStatu] from [webordertable] where saleStatu='已下架'"; SqlDataAdapter data5 = new SqlDataAdapter(SqlStr5, conn); DataSet dataset5 = new DataSet(); data5.Fill(dataset5, "webordertable"); //绑定DataList控件 GridView5.DataSource = dataset5; GridView5.DataKeyNames = new string[] { "comID" }; GridView5.DataBind(); conn.Close(); }
public void addfeeinfo() { SqlDataAdapter da = new SqlDataAdapter("Select * from add_fee where batch='" + batch_ddl.SelectedItem.ToString() + "'and class='" + class_ddl.SelectedItem.ToString() + "'and section='" + section_ddl.SelectedItem.ToString() + "' and stream='" + stream_ddl.SelectedItem.ToString() + "' ", con); DataTable dt = new DataTable(); da.Fill(dt); GridView5.DataSource = dt; GridView5.DataBind(); }
public void binddetailbook() { TrainBLL tbll = new TrainBLL(); DataSet ds = new DataSet(); ds = tbll.displaybook(); GridView5.DataSource = ds; GridView5.DataBind(); }
// } protected void btnAssignUser_Click(object sender, EventArgs e) { hidTAB.Value = "#tab5"; if (string.IsNullOrEmpty(this.ddlMakers.Text)) { this.lblAssgnUserMsg.Text = MessageFormatter.GetFormattedErrorMessage("Maker Name required!"); return; } if (string.IsNullOrEmpty(this.ddlcheckers.Text)) { this.lblAssgnUserMsg.Text = MessageFormatter.GetFormattedErrorMessage("Checker Name required!"); return; } con.Open(); try { OracleCommand cmd = new OracleCommand(); // Set the command text on an OracleCommand object cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.BindByName = true; cmd.CommandText = "insert into CDMS.CM_MAKER_CHECKER_XREF (MAKER_ID,CHECKER_ID)" + " values (:p_MakerID,:p_CheckerID)"; // OracleParameter prm = new OracleParameter(); cmd.Parameters.Add(":p_MakerID", OracleDbType.Int32).Value = Convert.ToInt32(this.ddlMakers.SelectedValue); cmd.Parameters.Add(":p_CheckerID", OracleDbType.Int32).Value = Convert.ToInt32(this.ddlcheckers.SelectedValue); // Execute the command var rst = cmd.ExecuteNonQuery(); this.lblAssgnUserMsg.Text = MessageFormatter.GetFormattedSuccessMessage("User assigned sucessfully!"); //Emailing EmailHelper Email = new EmailHelper(); Email.UserAssignmentMailSender(this.ddlMakers.SelectedValue, this.ddlcheckers.SelectedValue); this.ddlMakers.SelectedValue = ""; this.ddlcheckers.SelectedValue = ""; } catch (Exception ex) { lblAssgnUserMsg.Text = MessageFormatter.GetFormattedErrorMessage(ex.Message); } // Close and Dispose OracleConnection object con.Close(); con.Dispose(); //bind data to gridview GridView5.DataBind(); }
private void BindDataList4() { int RecordCount = 0; DataSet ds = BusinessFacadeDLT.GetUserTrackInfo(Request.QueryString["TrackAcceptID"].ToString(), AspNetPager4.CurrentPageIndex, AspNetPager4.PageSize); GridView5.DataSource = ds; GridView5.DataBind(); RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString()); this.AspNetPager4.RecordCount = RecordCount; }
protected void freshbindingtype() { DataSet dst = new DataSet(); SqlConnection cnn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dtcnn"].ConnectionString); SqlDataAdapter adpt = new SqlDataAdapter("select * from binding_type", cnn); adpt.Fill(dst); GridView5.DataSource = dst.Tables[0]; GridView5.DataBind(); }
public void BindDataRequest() { List <Requests> requestList = new List <Requests>(); RequestDaoSqlImpl requestDao = new RequestDaoSqlImpl(); requestList = requestDao.getRequestList(long.Parse(Request.QueryString["requestId"])); GridView5.DataSource = requestList; GridView5.DataBind(); }
protected void GridView5_RowDeleting(object sender, GridViewDeleteEventArgs e) { using (var context = new MainEntities()) { var model = context.Фильмы.ToList()[e.RowIndex]; context.Фильмы.Remove(model); context.SaveChanges(); } GridView5.DataBind(); }
protected void btnPardakhtInsert_Click(object sender, EventArgs e) { if (txtPardakhtTitle.Text != "") { Value.InsertValues(lblPardakhtID.Text, lblPardakhtValue.Text, txtPardakhtTitle.Text); } txtPardakhtTitle.Text = ""; GridView5.DataBind(); //Response.Redirect("Editfactors.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (SqlConnection conn = new DB().GetConnection()) { // 焦点图 string sql = "select * from Focuses where valid = 1 order by orders desc"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); Repeater1.DataSource = rd; Repeater1.DataBind(); rd.Close(); // GridView1 教师通知 cmd.CommandText = "select top 10 ID,Title,CDT from Articles where SubID = 6 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc"; rd = cmd.ExecuteReader(); GridView1.DataSource = rd; GridView1.DataBind(); rd.Close(); // GridView2 学生通知 cmd.CommandText = "select top 10 ID,Title,CDT from Articles where SubID = 7 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc"; rd = cmd.ExecuteReader(); GridView2.DataSource = rd; GridView2.DataBind(); rd.Close(); // GridView3 学院动态 cmd.CommandText = "select top 10 ID,Title,CDT from Articles where SubID = 5 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc"; rd = cmd.ExecuteReader(); GridView3.DataSource = rd; GridView3.DataBind(); rd.Close(); // GridView4 作品展示 cmd.CommandText = "select top 4 ID,Title,Abs,Author,CoverPhotoURL,CDT,Catalog from Shows where Status =1 Order by Orders Desc,CDT Desc,ID Desc"; rd = cmd.ExecuteReader(); GridView4.DataSource = rd; GridView4.DataBind(); rd.Close(); // GridView5 活动剪影 cmd.CommandText = "select top 10 ID,Title,CDT from Articles where SubID = 39 and Status =1 and Finished = 1 Order by Orders Desc,CDT Desc,ID Desc"; rd = cmd.ExecuteReader(); GridView5.DataSource = rd; GridView5.DataBind(); rd.Close(); conn.Close(); } } }
/// <summary> /// 优质区日志 /// </summary> private void BindData5() { int RecordCount = 0; DataSet ds = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings["MSSql"], "BM_GoodLogList", txtUID8.Text.Trim(), AspNetPager5.CurrentPageIndex, AspNetPager5.PageSize); GridView5.DataSource = ds.Tables[0]; GridView5.DataBind(); RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString()); this.AspNetPager5.RecordCount = RecordCount; }
protected void Button5_Click(object sender, EventArgs e) { String query = "SELECT * FROM Product a , Size_cost b , Order_table c WHERE (c.Product_item_no = b.Product_item_no AND b.Product_id = a.Product_id AND c.Customer_id = '" + TextBox7.Text + "')"; SqlDataAdapter dataadapter = new SqlDataAdapter(query, conx); DataSet ds = new DataSet(); dataadapter.Fill(ds); GridView5.DataSource = ds; GridView5.DataBind(); }
// Updates the grid veiw after adding the new data protected void UpdateTablesData() { GridView1.DataBind(); GridView2.DataBind(); GridView3.DataBind(); GridView4.DataBind(); GridView5.DataBind(); GridView6.DataBind(); GridView7.DataBind(); GridView8.DataBind(); }
protected void LinkButton13_Click(object sender, EventArgs e) { GridViewRow gv = (GridViewRow)(sender as Control).Parent.Parent; int i = gv.RowIndex; LinkButton LinkButton13 = (LinkButton)GridView5.Rows[i].FindControl("LinkButton13"); HiddenField HiddenField2 = (HiddenField)GridView5.Rows[i].FindControl("HiddenField2"); HiddenField_VehicleId_p10.Value = HiddenField2.Value; SqlDataSource_Save.Delete(); GridView5.DataBind(); }
protected void radiobuttonlistLocalNonLocal_SelectedIndexChanged(object sender, EventArgs e) { DataSet ds = new DataSet(); if (radiobuttonlistCII.SelectedIndex == 2) // Terrorist { if (radiobuttonlistDIA.SelectedIndex == 0) // Death { if (radiobuttonlistLocalNonLocal.SelectedIndex == 0) // Local { Session["casualityType"] = "TerroristDeathL"; } else if (radiobuttonlistLocalNonLocal.SelectedIndex == 1) // Non-Local { Session["casualityType"] = "TerroristDeathNL"; } } else if (radiobuttonlistDIA.SelectedIndex == 1) // Injury { if (radiobuttonlistLocalNonLocal.SelectedIndex == 0) // Local { Session["casualityType"] = "TerroristInjuryL"; } else if (radiobuttonlistLocalNonLocal.SelectedIndex == 1) // Non-Local { Session["casualityType"] = "TerroristInjuryNL"; } } else if (radiobuttonlistDIA.SelectedIndex == 2) // Arrested { if (radiobuttonlistLocalNonLocal.SelectedIndex == 0) // Local { Session["casualityType"] = "TerroristArrestedL"; } else if (radiobuttonlistLocalNonLocal.SelectedIndex == 1) // Non-Local { Session["casualityType"] = "TerroristArrestedNL"; } } } ds = select.bindGridView(Session["casualityType"].ToString(), Session["q"].ToString()); if (ds.Tables[0].Rows.Count > 0) { GridView5.DataSource = ds; GridView5.DataBind(); } else { GridView5.DataSource = null; GridView5.DataBind(); } GridView5.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { string connectionString = ConfigurationManager.ConnectionStrings["conStr"].ToString(); SqlConnection con = new SqlConnection(connectionString); try { con.Open(); } catch (Exception) { con.Close(); return; throw; } DataSet ds1 = new DataSet(); string sqlstr = "select * from Visitor_T"; SqlDataAdapter da1 = new SqlDataAdapter(sqlstr, con); da1.Fill(ds1); GridView1.DataSource = ds1; GridView1.DataBind(); DataSet ds2 = new DataSet(); sqlstr = "select * from Tourist_T"; SqlDataAdapter da2 = new SqlDataAdapter(sqlstr, con); da2.Fill(ds2); GridView2.DataSource = ds2; GridView2.DataBind(); con.Close(); DataSet ds3 = new DataSet(); sqlstr = "select * from Ticket_T"; SqlDataAdapter da3 = new SqlDataAdapter(sqlstr, con); da3.Fill(ds3); GridView5.DataSource = ds3; GridView5.DataBind(); con.Close(); }
protected void MakeBind() { DataSet ds = new DataSet(); ds = getDataSet(); DataTable dt = ds.Tables[0]; dt.DefaultView.Sort = SortField + " " + SortDir; GridView5.DataSource = dt.DefaultView; GridView5.DataBind(); }
//显示员工资料至 GridView5 void ShowData() { using (SqlConnection cn = new SqlConnection()) { cn.ConnectionString = sqlconn; cn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM equipment", cn); SqlDataReader dr = cmd.ExecuteReader(); GridView5.DataSource = dr; GridView5.DataBind(); } }
protected void Button38_Click(object sender, EventArgs e) { GridView5.DataSource = bom.Query_Material(TextBox21.Text, TextBox22.Text); GridView5.DataBind(); Panel51.Visible = false; Panel5.Visible = true; Panel52.Visible = true; Panel53.Visible = false; Panel6.Visible = false; UpdatePanel5.Update(); UpdatePanel6.Update(); }
protected void btngreporte_Click(object sender, EventArgs e) { if (DropDownList1.SelectedItem.Text == "Seleccione Prueba") { lblmensaje.Text = "Debe elegir el tipo de usuario"; DropDownList1.Focus(); } else { oeresultado_d.idusuario = TextBox1.Text.Trim(); oeresultado_d.n_prueba = DropDownList1.SelectedIndex.ToString().Trim(); ds1 = ortotal.resTotalesD(oeresultado_d); GridView3.DataSource = ds1; GridView3.DataBind(); oeresultado_c.idusuario = TextBox1.Text.Trim(); oeresultado_c.n_prueba = DropDownList1.SelectedIndex.ToString().Trim(); ds2 = ortotal.resTotalesC(oeresultado_c); GridView2.DataSource = ds2; GridView2.DataBind(); oeresultado_i.idusuario = TextBox1.Text.Trim(); oeresultado_i.n_prueba = DropDownList1.SelectedIndex.ToString().Trim(); ds3 = ortotal.resTotalesI(oeresultado_i); GridView4.DataSource = ds3; GridView4.DataBind(); oeresultado_s.idusuario = TextBox1.Text.Trim(); oeresultado_s.n_prueba = DropDownList1.SelectedIndex.ToString().Trim(); ds4 = ortotal.resTotalesS(oeresultado_s); GridView5.DataSource = ds4; GridView5.DataBind(); GridView2.Visible = true; GridView3.Visible = true; GridView4.Visible = true; GridView5.Visible = true; btnlimpiar.Visible = true; DropDownList1.Enabled = false; validaciones(); btngreporte.Enabled = false; string D, I, S, C; D = ds1.Tables[0].Rows[0]["SumaD"].ToString(); I = ds3.Tables[0].Rows[0]["SumaI"].ToString(); S = ds4.Tables[0].Rows[0]["SumaS"].ToString(); C = ds2.Tables[0].Rows[0]["SumaC"].ToString(); txtD.Text = D; txtI.Text = I; txtS.Text = S; txtC.Text = C; } }
protected void UpLoad_Click(object sender, EventArgs e) { string database = Session["DatabaseName"].ToString(); String savepath = DAL.SystemSet.savePath(Session["DatabaseName"].ToString()); string ProjectCode = Session["ProjectCode"].ToString(); string RFQ_Code = SystemSet.CheckMSSQLLike(SystemSet.ReplaceBlank(TxNo.Text)); if (FileUpload1.HasFile) { String fileName = FileUpload1.FileName; fileName = DateTime.Now.ToString("yyyy-MM-dd-HHmmss") + "_" + fileName; string Name = AttachName.Text; savepath += fileName; string kind = DDL_kind.SelectedItem.Text; FileUpload1.SaveAs(savepath); // FileUpload1.SaveAs(System.Web.HttpContext.Current.Server.MapPath(savepath)); //上傳檔案 string[] name = fileName.Split('_'); string realname = name[1]; Response.Write("<script>alert('" + kind + "" + realname + "已上傳');</script>"); string SQLInsert = "RFQ_Code,Name,Type,Path"; DataTable DataTableBox = new DataTable(); foreach (string DataName in SQLInsert.Split(',')) { DataTableBox.Columns.Add(DataName, typeof(string)); } DataRow DataTableDr = DataTableBox.NewRow(); DataTableDr["RFQ_Code"] = RFQ_Code; DataTableDr["Name"] = Name; DataTableDr["Type"] = kind; DataTableDr["Path"] = savepath; DataTableBox.Rows.Add(DataTableDr); string insert = WebModel.SaveAction(database, "RFQ_File", DataTableBox); GridView5.DataBind(); if (insert != "1") { Response.Write("<script>alert('" + kind + "" + realname + "已上傳,資料庫更新失敗');</script>"); } } else { Response.Write("<script>alert('圖說" + FileUpload1.FileName + "上傳失敗');</script>"); } }
protected void currenttimetbl() { Service1Client com = new Service1Client(); GridView2.DataSource = com.GetCurrentComTimeTable(); GridView2.DataBind(); GridView3.DataSource = com.GetCurrentEngTimeTable(); GridView3.DataBind(); GridView5.DataSource = com.GetCurrentMngTimeTable(); GridView5.DataBind(); }
void seansgetir() { baglanti.ConnectionString = "provider=Microsoft.Jet.OleDb.4.0; Data Source=" + Server.MapPath("Srezervasyon.mdb"); baglanti.Open(); OleDbDataAdapter adap14 = new OleDbDataAdapter("Select seanslar.Kimlik,seanslar.saat,filmler.filmadi From seanslar INNER JOIN filmler ON seanslar.filmid=filmler.Kimlik ", baglanti); DataSet dc14 = new DataSet(); adap14.Fill(dc14); GridView5.DataSource = dc14; GridView5.DataBind(); baglanti.Close(); }
protected void Button5_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand("select * from apti where name='" + TextBox2.Text + "'", con); SqlDataAdapter ad = new SqlDataAdapter(cmd); cmd.Parameters.AddWithValue("@name", TextBox2.Text); con.Open(); SqlDataReader rd = cmd.ExecuteReader(); GridView5.DataSource = rd; GridView5.DataBind(); con.Close(); }
private void View4_databind() { if (!DropDownList7.SelectedValue.Equals("-1")) { GridView4.DataBind(); Chart4.DataBind(); GridView5.DataSource = SqlDataSource11; GridView5.DataBind(); Label14.Text = DropDownList7.SelectedItem.Text + " results"; Label16.Visible = true; Label17.Visible = true; } }
private void DQIBE4BVNPageDataBind() { hidTAB.Value = "#tab3"; //string cat = "INDIVIDUAL"; //string branch = "001"; OracleCommand cmd = new OracleCommand(); cmd.Connection = con; cmd.CommandText = "select table_category,table_name,column_name, sum(failed_pct) as Completeness_Failed_PCT,sum(VALIDITY_FAILED_PCT) as Correctness_Failed_PCT " + "from DQI_PROFILE_RESULT group by table_category,table_name,column_name order by table_category desc"; cmd.CommandType = System.Data.CommandType.Text; cmd.BindByName = true; try { con.Open(); //cmd.Parameters.Add("cust", OracleDbType.RefCursor).Direction = ParameterDirection.Output; DataSet ds = new DataSet(); OracleDataAdapter da = new OracleDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { GridView5.DataSource = ds; GridView5.DataBind(); } else { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GridView5.DataSource = ds; GridView5.DataBind(); int columncount = GridView5.Rows[0].Cells.Count; GridView5.Rows[0].Cells.Clear(); GridView5.Rows[0].Cells.Add(new TableCell()); GridView5.Rows[0].Cells[0].ColumnSpan = columncount; GridView5.Rows[0].Cells[0].Text = "No Records Found"; } } catch (Exception ex) { lblMsg.Text = MessageFormatter.GetFormattedErrorMessage(ex.Message + " <br />"); //ex.StackTrace + } finally { con.Close(); // con.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { if (Convert.ToBoolean(Session["giris"]) != true) { Response.Redirect("LoginRegisterPage.aspx?msg=Oncelikle giris yapmalisiniz"); } else { string baglan = ConfigurationManager.ConnectionStrings["baglan"].ToString(); SqlConnection baglan2 = new SqlConnection(baglan); string KulAd = "'" + Convert.ToString(Session["KullaniciAdi"]) + "'"; string Kullaniciadi = "'" + Convert.ToString(Session["KullaniciAdi"]) + "'"; /*Kullanici Bilgileri*/ string sql2 = "select * from KullaniciTable where KullaniciAdi=" + KulAd; SqlDataAdapter adaptor2 = new SqlDataAdapter(sql2, baglan2); DataTable dt2 = new DataTable(); adaptor2.Fill(dt2); Label1.Text = dt2.Rows[0]["Adi"].ToString(); Label2.Text = dt2.Rows[0]["Soyadi"].ToString(); Image1.ImageUrl = dt2.Rows[0]["KullaniciFoto"].ToString(); /*Kitap Okuma*/ DataSet okunankitap = Islemler.okunankitap(Kullaniciadi); GridView1.DataSource = okunankitap.Tables[0]; GridView1.DataBind(); /*Puan Tablosu*/ DataSet KitapPuan = Islemler.KitapPuan(Kullaniciadi); GridView2.DataSource = KitapPuan.Tables[0]; GridView2.DataBind(); /*Yorum/inceleme Tablosu*/ DataSet KitapInceleme = Islemler.KitapInceleme(Kullaniciadi); GridView3.DataSource = KitapInceleme.Tables[0]; GridView3.DataBind(); /*Alıntı Tablosu*/ DataSet Alintilar = Islemler.Alintilar(Kullaniciadi); GridView4.DataSource = Alintilar.Tables[0]; GridView4.DataBind(); /*Mesajlar Tablosu*/ DataSet Mesajlar = Islemler.Mesaj(Kullaniciadi); GridView5.DataSource = Mesajlar.Tables[0]; GridView5.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string user = (string)Session["userName"]; string pass = (string)Session["passWord"]; ////////////////Listagens Scores////////////// GridView5.DataSource = getDataSet(); GridView5.DataBind(); /* * GWSiteClassLibrary.IScore sc = GWSiteClassLibrary.Factory.CreateScoreService(); * DataSet ds = null; * ds = sc.GetAll(user, pass); * GridView5.DataSource = ds; * GridView5.DataBind(); * */ /*GWSiteClassLibrary.IUser ustest = GWSiteClassLibrary.Factory.CreateUserService(); * //DataSet ds = null; * DataSet ds = ustest.FindByName(user, pass, username); * GridView5.DataSource = ds; * GridView5.DataBind();*/ ////////////////Listagens Mapas////////////// GWSiteClassLibrary.IMap m = GWSiteClassLibrary.Factory.CreateMapService(); DataSet dsP1 = null; dsP1 = m.GetAll(user, pass); GridView3.DataSource = dsP1; // GridView1.DataTextField = "Name"; // GridView1.DataValueField = "PlayerID"; GridView3.DataBind(); ////////////////Listagens Users////////////// GWSiteClassLibrary.IUser u = GWSiteClassLibrary.Factory.CreateUserService(); DataSet dsP2 = null; dsP2 = u.GetAll(user, pass); GridView2.DataSource = dsP2; // GridView1.DataTextField = "Name"; // GridView1.DataValueField = "PlayerID"; GridView2.DataBind(); ////////////////Listagens Players////////////// GWSiteClassLibrary.IPlayer p = GWSiteClassLibrary.Factory.CreatePlayerService(); DataSet dsP3 = null; dsP3 = p.GetAll(user, pass); GridView4.DataSource = dsP3; GridView4.DataBind(); } }
protected void Button14_Click(object sender, EventArgs e) { if (TextBox21.Text.Length > 0) { Pass_BarCode.DataBind(); GridView5.DataBind(); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Δεν έχει συμπληρωθεί ο αριθμός αίτησης !!!');", true); } }
protected void Button6_Click1(object sender, EventArgs e) { conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); conn.Open(); string query = "Select DISTINCT Name, Category From Items t Inner Join Transcation r ON t.ItemId = r.ItemId Where quality > 3 "; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); GridView5.DataSource = ds; GridView5.DataBind(); conn.Close(); }