ASP.NET

protected void DocumentUploadButton_Click(object sender, EventArgs e)
    {        
       
        string errMsg = string.Empty;
        string PDFFilename = string.Empty;
        string PDFSaveLocation = string.Empty;

        if (DocumentFileUpload.HasFile)
        {
            string DocFileName = Path.GetFileName(DocumentFileUpload.PostedFile.FileName);
            string FileExtension = Path.GetExtension(DocumentFileUpload.PostedFile.FileName);

            string appPath = System.Web.HttpContext.Current.Request.ApplicationPath;
           

            if (!appPath.EndsWith("/", StringComparison.Ordinal))
            {
                appPath = String.Concat(appPath, "/");               
                PDFFilename = Path.GetFileName(DocumentFileUpload.PostedFile.FileName);
                ViewState["PDFFilename"] = PDFFilename;
                PDFSaveLocation = Server.MapPath(String.Concat(appPath, "/tmp/")) + PDFFilename;
                Label3.Text = "PDFFileName: " + PDFFilename;
                Label1.Text = "PDFLocation: " + PDFSaveLocation;
                DocumentFileUpload.PostedFile.SaveAs(PDFSaveLocation);
            }
            try
            {
                Guid g = AddFile(DocumentFileUpload.FileBytes, PDFFilename);
                ViewState["DocumentFileId"] = g;              
                File.Delete(PDFSaveLocation);

                DocumentUploadedCustomValidator.IsValid = true;
          
            }
            catch (Exception ex)
            {
                string strmsg = ex.Message;
                Label4.CssClass = "ErrorMessagesLabel";
                Label4.Text = "Error Uploading File. " + strmsg;
            }
}

 <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
            AutoGenerateColumns="False" CellPadding="4" 
            DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" 
            style="z-index: 1; top: 413px; left: 285px; position: absolute; height: 172px; width: 476px; margin-right: 88px" 
            onrowcancelingedit="GridView1_RowCancelingEdit" 
            OnRowUpdating="UpdateRecord" 
            onrowediting="GridView1_RowEditing" PageSize="5">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#E3EAEB" />
            <Columns>
            
               <asp:TemplateField HeaderText="Date" HeaderStyle-HorizontalAlign="Left" SortExpression="RecievingDate">
               <ItemTemplate >
               <asp:Label ID="lbl1" runat ="server" Text ='<%# Eval("Coupon_Info.RecievingDate") %>'></asp:Label>
               </ItemTemplate>

 <EditItemTemplate>
   <asp:TextBox ID="txtDate" Width="100px" runat="server" Text='<% Bind("Coupon_Info.RecievingDate") %>'></asp:TextBox>
 </EditItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="Coupon" SortExpression="CouponName">

 <EditItemTemplate>
  <asp:TextBox ID="txtcoupon"  Width="100px" runat="server" Text='<% Bind("CouponType.CouponName") %>'></asp:TextBox>
 </EditItemTemplate>

  <ItemTemplate>
    <asp:Label ID="lblcoupon1" Width="100px" runat="server" Text='<%# Eval("CouponType.CouponName") %>'></asp:Label>
  </ItemTemplate>
  
</asp:TemplateField>

<asp:TemplateField HeaderText="Serial Start" SortExpression="Serial_Start">
  <EditItemTemplate>
   <asp:TextBox ID="txtstart"  Width="100px" runat="server" Text='<% Bind("Coupon_Info.Serial_Start") %>'></asp:TextBox>
  </EditItemTemplate>

   <ItemTemplate>
     <asp:Label ID="lblstart1"  Width="100px" runat="server" Text='<%# Eval ("Coupon_Info.Serial_Start") %>'></asp:Label>
   </ItemTemplate>
</asp:TemplateField>


<asp:TemplateField HeaderText="End" SortExpression="Serial_End">

         <EditItemTemplate>
            <asp:TextBox ID="txtend" Width="100px" runat="server" Text='<% Bind("Coupon_Info.Serial_End") %>'></asp:TextBox>
         </EditItemTemplate>

         <ItemTemplate>
            <asp:Label ID="lblend1" Width="100px" runat="server" Text='<%# Eval ("Coupon_Info.Serial_End") %>'></asp:Label>
         </ItemTemplate>
   
      
</asp:TemplateField>

        <asp:TemplateField HeaderText="Recieved By" SortExpression="Recieved_By">

            <EditItemTemplate>

                <asp:TextBox ID="txtby" Width="100px" runat="server" Text='<% Bind("Coupon_Info.Recieved_By") %>'></asp:TextBox>

            </EditItemTemplate>

   <ItemTemplate >

       <asp:Label ID="lblby1" Width="100px" runat="server" Text='<%# Eval("Coupon_Info.Recieved_By") %>'></asp:Label>

   </ItemTemplate>


</asp:TemplateField>




               
<asp:TemplateField HeaderText="Edit" ShowHeader="False"> 
<EditItemTemplate> 

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update" Text="Update"></asp:LinkButton> 

<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton> 

</EditItemTemplate> 
<ItemTemplate> 

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"></asp:LinkButton> 

</ItemTemplate>
</asp:TemplateField>

            </Columns>
            
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" 
                Height="4px" />
            <EditRowStyle BackColor="#7C6F57" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView> 
                              

       
 
         </asp:Panel>  
        </div>
        
    </asp:Panel>  
   <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Coupon ManagementConnectionString9 %>" 
            SelectCommand="SELECT Coupon_Info.RecievingDate AS Date, CouponType.CouponName AS Name, Coupon_Info.Serial_Start AS [Serial Start], Coupon_Info.Serial_End AS [Serial End], Coupon_Info.Recieved_By AS [Recieved By] FROM Coupon_Info INNER JOIN CouponType ON Coupon_Info.Coupon_TypeID = CouponType.CouponTypeID">
                   </asp:SqlDataSource>

 public partial class CouponRecieving : System.Web.UI.Page
    {
        SqlConnection cnx = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Coupon Management.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
        SqlDataAdapter da1 = new SqlDataAdapter();
        DataSet ds = new DataSet();
        SqlCommand cmd = new SqlCommand();
        DataTable dataTable;


        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {

                FillVendorGrid();

            }
        }



      private void FillVendorGrid()
      {

          dataTable = new DataTable();

          cmd.Connection = cnx;

          cmd.CommandText = "SELECT Coupon_Info.RecievingDate AS Date, CouponType.CouponName AS Name, Coupon_Info.Serial_Start AS [Serial Start], Coupon_Info.Serial_End AS [Serial End], Coupon_Info.Recieved_By AS [Recieved By] FROM Coupon_Info INNER JOIN CouponType ON Coupon_Info.Coupon_TypeID = CouponType.CouponTypeID";

          da1  = new SqlDataAdapter(cmd);

          da1.Fill(dataTable);
          GridView1.DataSource = dataTable;
          GridView1.DataSourceID = String.Empty;

      }protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];

          
            try
            {
                cnx.Open();
                SqlCommand updateCmd = new SqlCommand("UPDATE [Coupon_Info,CouponType] SET [Coupon_Info.RecievingDate]=@date,[CouponType.CouponName]=@Coupon,[Coupon_Info.Serial_Start]=@Start,[Coupon_Info.Serial_End]=@End,[Coupon_Info.Recieved_By]=@By ", cnx);
                updateCmd.CommandType = CommandType.Text;
                updateCmd.Parameters.Add("@date", SqlDbType.Date).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
                updateCmd.Parameters.Add("@Coupon", SqlDbType.NVarChar ,60).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
                updateCmd.Parameters.Add("@Start", SqlDbType.BigInt).Value = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[2].Text);
                updateCmd.Parameters.Add("@End", SqlDbType.BigInt ).Value = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[3].Text);
                updateCmd.Parameters.Add("@By", SqlDbType.NVarChar ,50).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text;
                updateCmd.Connection = cnx;
                cnx.Open();
                updateCmd.ExecuteNonQuery();
                cnx.Close();
            }
            catch (Exception ex)
            {
                ErrorMessage.Text = ex.Message;
            }
            finally  
            {
              //  j
               // updateCmd.Dispose();
               cnx.Close();
                cnx.Dispose();
            }
        }protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    GridView1.EditIndex =e.NewEditIndex;
    FillVendorGrid();
}
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        FillVendorGrid();
    }
}