protected void BindDefault()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
var strSQL = new StringBuilder();
var dt = new DataTable();
#endregion
#region Procedure
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("A.UID,");
strSQL.Append("A.Photo,");
strSQL.Append("A.Name,");
strSQL.Append("A.Detail,");
strSQL.Append("A.MWhen,");
strSQL.Append("A.Sort,");
strSQL.Append("A.StatusFlag ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " A ");
strSQL.Append("ORDER BY ");
strSQL.Append("A.Sort;");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString());
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
gvDefault.DataSource = dt;
#region PageBuilder
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
#endregion
gvDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageGray("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
#endregion
#endregion
}
