protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
        if (e.Exception != null)
        {
            // Display a user-friendly message
            ExceptionDetails.Visible = true;
            ExceptionDetails.Text = "There was a problem updating the product. ";

            if (e.Exception.InnerException != null)
            {
                Exception inner = e.Exception.InnerException;

                if (inner is System.Data.Common.DbException)
                    ExceptionDetails.Text += "Our database is currently experiencing problems. Please try again later.";
                else if (inner is NoNullAllowedException)
                    ExceptionDetails.Text += "There are one or more required fields that are missing.";
                else if (inner is ArgumentException)
                {
                    string paramName = ((ArgumentException)inner).ParamName;
                    ExceptionDetails.Text += string.Concat("The ", paramName, " value is illegal.");
                }
                else if (inner is ApplicationException)
                    ExceptionDetails.Text += inner.Message;
            }

            // Indicate that the exception has been handled
            e.ExceptionHandled = true;

            // Keep the row in edit mode
            e.KeepInEditMode = true;
        }
    }

    protected void dridView_RoeUpdated(object sender, GridViewUpdatedEventArgs e)
    {
        GridView1.Columns[1].Visible = true;
        GridView1.Columns[2].Visible = true;
        GridView1.Columns[3].Visible = true;
        GridView1.Columns[4].Visible = true;
        GridView1.Columns[5].Visible = true;
        GridView1.Columns[6].Visible = true;

        GridView1.Columns[9].Visible = false;

        //MailAddress mailfrom = new MailAddress("[email protected]");
        //MailAddress mailto = new MailAddress("[email protected]");
        //MailMessage newmsg = new MailMessage(mailfrom, mailto);

        //newmsg.Subject = "APPOINTMENT";
        //newmsg.Body = "Appointment On date :" + GridView1.Rows[ + " is " + GridView1.SelectedRow.Cells[6].Text;

        ////    Attachment att = new Attachment("C:\\...file path");
        ////  newmsg.Attachments.Add(att);

        //SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
        //smtp.UseDefaultCredentials = false;
        //smtp.Credentials = new NetworkCredential("[email protected]", "were690vase804");
        //smtp.EnableSsl = true;
        //smtp.Send(newmsg);
        //Response.Write(@"<script language='javascript'>alert('Appointment Status sent to Student's Mail')</script>");
    }

 protected void gridBenchmarkData_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null) {
         showException(e.Exception, labelException, "updating the benchmark prices");
         e.ExceptionHandled = true;
         e.KeepInEditMode = true;
     }
 }

 protected void Categories_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     // If there were no problems and we updated the PDF file, then delete the existing one
     if (e.Exception == null)
     {
         DeleteRememberedBrochurePath();
     }
 }

 protected void GridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
         lblConnError.Text = "Fout opgetreden bij het verbinden met de database:<br />" + e;
         e.ExceptionHandled = true;
     }
 }

 protected void gvProducts_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
         lblError.Text = "A database error has occurred.<br /><br />" +
           e.Exception.ToString();
     }
 }

 protected void gridAssetClass_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null) {
         showException(e.Exception, labelException, "updating the asset class");
         e.ExceptionHandled = true;
         e.KeepInEditMode = true;
     }
 }

 protected void grdaltkategoriler_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     int AltKategoriID = Convert.ToInt32((this.grdaltkategoriler.Rows[e.AffectedRows].FindControl("lblID") as Label).Text);
     AltKategoriler altkat = et.AltKategorilers.Single(v => v.ALTID == AltKategoriID);
     altkat.ALTAD = (this.grdaltkategoriler.Rows[e.AffectedRows].FindControl("txtAd") as TextBox).Text;
     altkat.AKID = Convert.ToInt32((this.grdaltkategoriler.Rows[e.AffectedRows].FindControl("DropDownList2") as DropDownList).SelectedValue);
     et.SubmitChanges();
 }

 protected void gridContent_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
         showException(e.Exception, labelException, "updating the Text Content");
         e.ExceptionHandled = true;
         e.KeepInEditMode = true;
     }
 }

 protected void GridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
         e.ExceptionHandled = true;
         e.KeepInEditMode = true;
         this.Alert(e.Exception.Message);
     }
 }

 protected void grvStock_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     e.ExceptionHandled = (e.Exception != null);
     if (e.ExceptionHandled)
     {
         e.KeepInEditMode = true;
         Appz.ClientAlert(this, e.Exception.InnerException.Message);
     }
 }

 protected void GroupGridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
       Flash.Visible = true;
       Flash.Text = e.Exception.Message;
       e.ExceptionHandled = true;
       e.KeepInEditMode = true;
     }
 }

    protected void Products_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
        if (e.AffectedRows == 0)
        {
            ConcurrencyViolationMessage.Visible = true;
            e.KeepInEditMode = true;

            // Rebind the data to the GridView to show the latest changes
            Products.DataBind();
        }
    }

 protected void gridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     GridView1.Columns[1].Visible = true;
     GridView1.Columns[4].Visible = true;
     GridView1.Columns[5].Visible = true;
     GridView1.Columns[6].Visible = true;
     GridView1.Columns[8].Visible = true;
     GridView1.Columns[9].Visible = true;
     GridView1.Columns[10].Visible = false;
     GridView1.Columns[11].Visible = true;
     GridView1.Columns[7].Visible = true;
 }

 protected void grdDiskografije_RowUpdated(Object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception == null)
     {
         porukaPromjene.InnerText = "Uspješno promijenjeno";
     }
     else
     {
         porukaPromjene.InnerText = "Dogodila se greška";
         e.ExceptionHandled = true;
     }
 }

    public void gvFSFileOverview_RowUpdated(object sender,  GridViewUpdatedEventArgs e)
    {
        if (e.Exception != null)
        {
            lblErrorMessage.Text = "Error updating fund settle number, check for duplicate numbers";
            e.ExceptionHandled = true;
            e.KeepInEditMode = true;
        }
        int fileId = Convert.ToInt32(e.Keys[0].ToString());

        FSFileOverviewAdapter.PlaceOrdersForFile(fileId);
    }

 protected void GridView_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
         ActionStatus.Text = e.Exception.Message;
         e.ExceptionHandled = true;
         e.KeepInEditMode = true;
     }
     else
     {
         ActionStatus.Text = "";
     }
 }

 protected void GridViewProject_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
       Message.Text = e.Exception.Message + " , Please try again!";
       e.ExceptionHandled = true;
       e.KeepInEditMode = true;
     }
     else
     {
       Message.Text = "Project Update Successful!";
     }
 }

 protected void grdIncidents_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
         lblError.Text = "A database error has occurred. <br /><br />" +
                         "Message: " + e.Exception.Message;
         e.ExceptionHandled = true;
         e.KeepInEditMode = true;
     }
     else if (e.AffectedRows == 0)
     {
         lblError.Text = "Another user may have updated that incident.<br /> Please try again.";
     }
 }

 //handle exceptions for the row update event
 protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
 {
     if (e.Exception != null)
     {
         lblError.Text = "A database error has occurred. <br /><br />" + e.Exception.Message;
         if (e.Exception.InnerException != null)
             lblError.Text += "<br /> Message: " + e.Exception.InnerException.Message;
         e.ExceptionHandled = true;
         e.KeepInEditMode = true;
     }
     else if (e.AffectedRows == 0)
     {
         lblError.Text = "Another user may have updated that repair, please try again.";
     }
 }