public void LoadData_FilePDF() { string _where = GetWhereFilePDF(); string _sql = "select * from T_Publish_Pdf where " + _where; DataSet _ds = _daltinbai.Sp_SelectT_Publish_PdfDynamic(_where, " ID DESC"); this.DataGrid_FilePDF.DataSource = _ds; this.DataGrid_FilePDF.DataBind(); }
public void LoadData_FilePDF() { string _where = "Status=1"; if (cboPage.SelectedIndex > 0) { _where += " and Page_Number=" + cboPage.SelectedValue; } if (cboSoBao.SelectedIndex > 0) { _where += " and Publish_Number_ID=" + cboSoBao.SelectedValue; } if (txt_tungay.Text.Trim() != "" && txt_denngay.Text.Trim() != "") { _where += " AND Publish_Number_ID in (select Ma_Sobao from T_Sobao where Ngay_Xuatban>='" + txt_tungay.Text.Trim() + " 00:00:00' and Ngay_Xuatban<='" + txt_denngay.Text.Trim() + " 23:59:59')"; } string _sql = "select * from T_Publish_Pdf where " + _where; DataSet _ds = Daltinbai.Sp_SelectT_Publish_PdfDynamic(_where, " ID ASC"); this.DataGrid_FilePDF.DataSource = _ds; this.DataGrid_FilePDF.DataBind(); }