protected void Search_btn_Click(object sender, EventArgs e) { string sErrMsg = string.Empty; DataTable dataTable = new DataTable(); DBUtility sqlObj = null; sqlObj = new DBUtility(); sqlObj.StoreProcedureName = "SP_Qry_ClassInfo"; sqlObj.SetupSqlCommand(ref sErrMsg); sqlObj.SqlCmd.Parameters["@ClassName"].Value = ClassName_txb.Text; sqlObj.SqlCmd.Parameters["@Instructor"].Value = Instructor_txb.Text; sqlObj.SqlCmd.Parameters["@Organizer"].Value = Organizer_txb.Text; sqlObj.SqlCmd.Parameters["@OpenType"].Value = OpenType_ddl.SelectedValue; sqlObj.SqlCmd.Parameters["@StartType"].Value = StartType_ddl.SelectedValue; sqlObj.SqlCmd.Parameters["@ClassType"].Value = ClassType_ddl.SelectedValue; sqlObj.SqlCmd.Parameters["@StartDate"].Value = StartDate_txb.Text; sqlObj.SqlCmd.Parameters["@EndDate"].Value = EndDate_txb.Text; try { sqlObj.SqlConn.Open(); SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd); da.Fill(dataTable); } catch (Exception ex) { throw ex; } finally { sqlObj.SqlConn.Close(); } BootstrapGridView1.DataSource = dataTable; //告訴GridView資料來源為誰 BootstrapGridView1.DataBind(); //綁定 }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DateTime dt = DateTime.Now; StartDate_txb.Text = dt.ToString("yyyy/MM/dd"); EndDate_txb.Text = dt.ToString("yyyy/MM/dd"); } string sErrMsg = string.Empty; DataTable dataTable = new DataTable(); DBUtility sqlObj = null; sqlObj = new DBUtility(); sqlObj.StoreProcedureName = "SP_Qry_ClassInfo"; sqlObj.SetupSqlCommand(ref sErrMsg); sqlObj.SqlCmd.Parameters["@StartDate"].Value = StartDate_txb.Text; sqlObj.SqlCmd.Parameters["@EndDate"].Value = EndDate_txb.Text; try { sqlObj.SqlConn.Open(); SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd); da.Fill(dataTable); } catch (Exception ex) { throw ex; } finally { sqlObj.SqlConn.Close(); } BootstrapGridView1.DataSource = dataTable; //告訴GridView資料來源為誰 BootstrapGridView1.DataBind(); //綁定 }
protected void Page_Load(object sender, EventArgs e) { string sErrMsg = string.Empty; DataTable dataTable = new DataTable(); DBUtility sqlObj = null; sqlObj = new DBUtility(); sqlObj.StoreProcedureName = "SP_Qry_ClassSub"; sqlObj.SetupSqlCommand(ref sErrMsg); sqlObj.SqlCmd.Parameters["@ClassNo"].Value = Session["ClassNo"].ToString(); try { sqlObj.SqlConn.Open(); SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd); da.Fill(dataTable); } catch (Exception ex) { throw ex; } finally { sqlObj.SqlConn.Close(); } BootstrapGridView1.DataSource = dataTable; //告訴GridView資料來源為誰 BootstrapGridView1.DataBind(); //綁定 }
protected void GridViewBind() { string sErrMsg = string.Empty; DataTable dt = new DataTable(); DBUtility sqlObj = null; sqlObj = new DBUtility(); sqlObj.StoreProcedureName = "SP_Qry_MemberExam"; sqlObj.SetupSqlCommand(ref sErrMsg); sqlObj.SqlCmd.Parameters["@Account"].Value = Session["Account"].ToString(); sqlObj.SqlCmd.Parameters["@ClassNo"].Value = Session["ClassNo"].ToString(); sqlObj.SqlCmd.Parameters["@ExamPaperName"].Value = ExamPaperName_txb.Text; sqlObj.SqlCmd.Parameters["@Pass"].Value = Pass_ddl.SelectedValue; sqlObj.SqlCmd.Parameters["@StartDate"].Value = StartDate_txb.Text; sqlObj.SqlCmd.Parameters["@EndDate"].Value = EndDate_txb.Text; sqlObj.SqlCmd.Parameters["@XOLTP"].Value = 5; try { sqlObj.SqlConn.Open(); SqlDataAdapter da = new SqlDataAdapter(sqlObj.SqlCmd); da.Fill(dt); } catch (Exception ex) { throw ex; } finally { sqlObj.SqlConn.Close(); } BootstrapGridView1.DataSource = dt; BootstrapGridView1.DataBind(); }
protected void BootstrapButton2_Click(object sender, EventArgs e) { var tabPage = (BootstrapPageControl)BootstrapGridView1.FindEditFormTemplateControl("pageControl"); BootstrapFormLayout BsFormL = tabPage.FindControl("FormLayoutDataBinding") as BootstrapFormLayout; BootstrapComboBox cb = BsFormL.FindControl("BootstrapComboBox1") as BootstrapComboBox; sLabel.Text = cb.SelectedItem.Text; BootstrapGridView1.CancelEdit(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && !IsCallback) { Session.Clear(); } ((BootstrapGridViewComboBoxColumn)BootstrapGridView1.Columns["TypeID"]).PropertiesComboBox.DataSource = ItemTypeFactory.GetItemTypes(); BootstrapGridView1.DataSource = objectDataSource1; BootstrapGridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { System.Net.ServicePointManager.SecurityProtocol |= SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; Uri uri = new Uri("http://services.odata.org/V4/OData/OData.svc/"); var container = new DemoService(uri); var source = new ODataServerModeSource { KeyExpression = "ID", Query = container.Products }; BootstrapGridView1.DataSource = source; BootstrapGridView1.DataBind(); }