private void GridviewBind() { ds = new DataSet(); ObjPpms = new PpmsFlag(); ds = ObjPpms.GetPerformanceDetails(); if (ds.Tables[0].Rows.Count > 0) { gvDetails.DataSource = ds; gvDetails.DataBind(); dt = ds.Tables[0]; Session[clsConstant.SESS_TABLE] = dt; } else { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); gvDetails.DataSource = ds; gvDetails.DataBind(); int columncount = gvDetails.Rows[0].Cells.Count; gvDetails.Rows[0].Cells.Clear(); gvDetails.Rows[0].Cells.Add(new TableCell()); gvDetails.Rows[0].Cells[0].ColumnSpan = columncount; gvDetails.Rows[0].Cells[0].Text = "No Records Found"; } }
protected void GridviewBind() { ds = new DataSet(); ObjPpms = new PpmsFlag(); ds = ObjPpms.GetPerformanceDetails(); grdPpmsFlag.DataSource = ds; grdPpmsFlag.DataBind(); dt = ds.Tables[0]; Session[clsConstant.SESS_TABLE] = dt; }
protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e) { int ppmsid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString()); TextBox txtfrom = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txteditfrom"); TextBox txtto = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtTo"); TextBox txtflag = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtflag"); ObjPpms = new PpmsFlag(); int status = ObjPpms.getUpdate(txtfrom.Text, txtto.Text, txtflag.Text, ppmsid); if (status != 0) { lblresult.ForeColor = Color.Green; lblresult.Text = " Details Updated successfully"; gvDetails.EditIndex = -1; GridviewBind(); } }