grid view row updatin

See more:

C#

ASP.NET

Gridview

Hello All,

I got a gridview which consists of hyperlink in last column upon clicking that it will redirect to another page showing the particular row values in assigned textbox and labels. and there is a reapply button in the page which allows to re aply the leave which is rejected. I have written stored procedure for Updating the grid view and passed it to reaply button what i need is once i press reaply button gridview should update where the particular row which is rejected and should display it as pending status. I got LeaveID as identity column and im retrivin values by using that.

Please help me how to write Row Updating code for this..

code for Button ReApply

protected void BtnReApply_Click(object sender, EventArgs e)
    {
        MTMSDTO objc = new MTMSDTO();

        int Flag = 0;

        LblLoggedInUser.Text = Session["EmpName"].ToString();
        objc.LoggedInUser = LblLoggedInUser.Text;

        objc.TypeofLeave = LblTypeofLeave.Text;

        string date;
        date = Convert.ToDateTime(TxtBeginDate.Text).ToString("dd/MM/yyyy");

        DateTime dt = new DateTime();
        dt = Convert.ToDateTime(date);

        objc.BeginDate = dt;
        objc.EndDate = Convert.ToDateTime(TxtEndDate.Text);
        objc.Description = TxtDescription.Text;
        objc.NumofDays = Convert.ToInt32(TxtNumofDays.Text);
        objc.Status = LblStatus.Text;

        int X = obj.InsertLeave(objc);
        {
            if (X >= 0)
            {
                Flag = 1;
            }
            else
            {
                Flag = 0;

            }
        }

        if (Flag == 1)
        {
            LblSuccess.Visible = true;
            LblSuccess.Text = "Data Added Successfully and Leave Application Succesfully Sent";
        }
        else
        {
            LblErr.Visible = true;
            LblErr.Text = "Failed To Add Data and Send Leave Request!!!";
        }

        MailMessage message = new MailMessage();
        message.To.Add("");
        message.Subject = "Leave Request";
        message.From = new MailAddress("");
        message.IsBodyHtml = true;

        LblLoggedInUser.Text = Session["EmpName"].ToString();
        objc.LoggedInUser = LblLoggedInUser.Text;

        TxtManager.Text = Session["Manager"].ToString();
        objc.Manager = TxtManager.Text;

        objc.TypeofLeave = LblTypeofLeave.Text;

        objc.NumofDays = Convert.ToInt32(TxtNumofDays.Text.Trim());

        message.Body = "<span style = font-family:Arial,font-size:10pt>";
        message.Body += "Hello " + Session["Manager"].ToString() + ",<br /><br />";
        message.Body += "" + Session["EmpName"].ToString() + "" + "  has requested" + "" + " " + LblTypeofLeave.Text + "" + " for" + "" + " " + TxtNumofDays.Text + " " + "<br />";
        message.Body += "day/days, kindly login to the portal to Accept or Reject it";
        message.Body += "<br />";
        message.Body += "<br />";
        message.Body += "Thank You.<br />";
        message.Body += "</span>";
        SmtpClient smtp = new SmtpClient("");
        smtp.Send(message);

        LblTypeofLeave.Text = "";
        TxtBeginDate.Text = "";
        TxtEndDate.Text = "";
        TxtDescription.Text = "";
        TxtNumofDays.Text = "";
        LblStatus.Text = "";
    }

code for GridView

protected void GrdLeaveHistory()
    {
        MTMSDTO objc = new MTMSDTO();
        {
            objc.EmpName = Convert.ToString(Session["EmpName"]);
            DataSet GrdLH = obj.GrdLeaveHistory(objc);
            DataView GrdLeaveH = new DataView();
            GrdLeaveH.Table = GrdLH.Tables[0];
            GridViewLeaveHistory.DataSource = GrdLeaveH;
            GridViewLeaveHistory.DataBind();
        }
    }

code for Stored Procedure

public int UpdateGrdLeaveHistory(MTMSDTO M)
       {
           DBAccess db = new DBAccess();
           SqlParameter objParam = new SqlParameter("@LeaveID", M.LeaveID);
           objParam.Direction = ParameterDirection.Input;
           objParam.Size = 50;

           db.Parameters.Add(new SqlParameter("@Status", M.@Status));
           db.Parameters.Add(new SqlParameter("@TypeofLeave ", M.TypeofLeave));
           db.Parameters.Add(new SqlParameter("@BeginDate", M.BeginDate));
           db.Parameters.Add(new SqlParameter("@EndDate", M.EndDate));
           db.Parameters.Add(new SqlParameter("@Description", M.Description));
           db.Parameters.Add(new SqlParameter("@NumofDays", M.NumofDays));

           db.Parameters.Add(objParam);

           int retval = db.ExecuteNonQuery("UpdateGrdLeaveHistory");

           if (retval >= 1)
           {
               int i = 0;
               return i;
           }
           else
           {
               return -1;
           }
       }

here is Stored Procedure

ALTER PROCEDURE [dbo].[UpdateGrdLeaveHistory]

@LeaveID int,
@Status nvarchar(50),
@TypeofLeave nvarchar(50),
@Description nvarchar(50),
@BeginDate date,
@EndDate date,
@NumofDays int

AS


Update dbo.LeaveApply

Set 

TypeofLeave = @TypeofLeave,
NumofDays = @NumofDays,
BeginDate = @BeginDate,
EndDate = @EndDate,
Description = @Description,
Status = @Status

Where LeaveID = @LeaveID ;