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 }