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();
}
