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();
}
}
