protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { clsbuisness objapp = new clsbuisness(); string s = GridView1.SelectedValue.ToString(); DataTable dt = objapp.detailsviewapplication(s); dvviewdetails.DataSource = dt; dvviewdetails.DataBind(); mpe.Show(); }
protected void Btnsearch_Click(object sender, EventArgs e) { clsbuisness objapp = new clsbuisness(); System.Text.StringBuilder s = new System.Text.StringBuilder(); s.AppendFormat("select * from tbl_omr_application where 1=1"); if (!String.IsNullOrEmpty(txtid.Text)) { s.AppendFormat(" AND application_no =" + txtid.Text); } if (!String.IsNullOrEmpty(txtloc.Text)) { s.AppendFormat(" AND location =" + txtloc.Text); } //if (!String.IsNullOrEmpty(txthusband.Text)) //{ // s.AppendFormat(" AND husbandname =" + txthusband.Text); //} //if (!String.IsNullOrEmpty(txtwife.Text)) //{ // s.AppendFormat(" AND wifename =" + txtwife.Text); //} DataTable dt = objapp.Viewfilter(s.ToString()); if (dt != null) { if (dt.Rows.Count == 0) { lblmsg.Visible = true; lblmsg.Text = "No applications to display"; } else { GridView1.DataSource = dt; GridView1.DataBind(); } } else { lblmsg.Visible = true; lblmsg.Text = "Error in dispalying applications "; } }
private void bindgrid() { clsbuisness objapp = new clsbuisness(); DataTable dt = objapp.viewall(); if (dt != null) { if (dt.Rows.Count == 0) { lblmsg.Visible = true; lblmsg.Text = "No applications to display"; } else { GridView1.DataSource = dt; GridView1.DataBind(); } } else { lblmsg.Visible = true; lblmsg.Text = "Error in dispalying applications "; } }