private void BindGridView(int nPageNo) { cefDoctype objEfDoctype = new cefDoctype(); DataTable dt; string strMessage = string.Empty; string strCriteria = string.Empty; string stref_doctype_name = string.Empty; stref_doctype_name = txtef_doctype_name.Text.Replace("'", "''").Trim(); if (!stref_doctype_name.Equals("0")) { strCriteria = strCriteria + " And (ef_doctype_name like '%" + stref_doctype_name + "%')"; } try { dt = objEfDoctype.SP_DOCTYPE_SEL(strCriteria); try { GridView1.PageIndex = nPageNo; txthTotalRecord.Value = dt.Rows.Count.ToString(); dt.DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = dt; GridView1.DataBind(); } catch { GridView1.PageIndex = 0; txthTotalRecord.Value = dt.Rows.Count.ToString(); dt.DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = dt; GridView1.DataBind(); } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { objEfDoctype.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } } }
private void setData() { cefDoctype objECefDoctype = new cefDoctype(); DataTable dt; string strMessage = string.Empty, strCriteria = string.Empty; string strdoctype_code = string.Empty, strdoctype_name = string.Empty, strCreatedBy = string.Empty, strUpdatedBy = string.Empty, strCreatedDate = string.Empty, strUpdatedDate = string.Empty; try { strCriteria = " and ef_doctype_code = '" + ViewState["ef_doctype_code"].ToString() + "' "; dt = objECefDoctype.SP_DOCTYPE_SEL(strCriteria); if (dt.Rows.Count > 0) { #region get Data strdoctype_code = dt.Rows[0]["ef_doctype_code"].ToString(); strdoctype_name = dt.Rows[0]["ef_doctype_name"].ToString(); strCreatedBy = dt.Rows[0]["c_created_by"].ToString(); strUpdatedBy = dt.Rows[0]["c_updated_by"].ToString(); strCreatedDate = dt.Rows[0]["d_created_date"].ToString(); strUpdatedDate = dt.Rows[0]["d_updated_date"].ToString(); #endregion #region set Control txtdoctype_code.Text = strdoctype_code; txtdoctype_name.Text = strdoctype_name; txtUpdatedBy.Text = strUpdatedBy; txtUpdatedDate.Text = strUpdatedDate; #endregion } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }