ASP.NET

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

           int autoid = Int32.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
           TextBox tDate = (TextBox)row.FindControl("txtDate");
           TextBox tCoupon = (TextBox)row.FindControl("txtcoupon");
           TextBox dStart = (TextBox)row.FindControl("txtStart");
           TextBox dEnd = (TextBox)row.FindControl("txtend");
           TextBox dBy = (TextBox)row.FindControl("txtby");
           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 = tDate.Text.Trim();
               updateCmd.Parameters.Add("@Coupon", SqlDbType.NVarChar, 60).Value = tCoupon.Text.Trim();
               updateCmd.Parameters.Add("@Start", SqlDbType.BigInt).Value = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString());

               updateCmd.Parameters.Add("@By", SqlDbType.NVarChar, 50).Value = dBy.Text.Trim();

           }
           catch (Exception ex)
           {
               ErrorMessage.Text = ex.Message;
           }
           finally
           {
               cnx.Close();
               cnx.Dispose();
           }
       }

<asp:TemplateField HeaderText="Date" SortExpression="RecievingDate">

<EditItemTemplate>



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

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="txtDate1" runat="server"  Width="100px"></asp:TextBox>

</FooterTemplate>

<ItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("RecievingDate") %>'></asp:Label>
 Error message DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'RecievingDate'.


</ItemTemplate>

</asp:TemplateField>

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

<EditItemTemplate>

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

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="txtcoupon1" Width="100px" runat="server" ></asp:TextBox>

</FooterTemplate>

<ItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Bind("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("Serial_Start") %>'></asp:TextBox>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="txtstart1"  Width="100px" runat="server" ></asp:TextBox>

</FooterTemplate>

<ItemTemplate>

<asp:Label ID="Label3" runat="server" Text='<%# Bind("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("Serial_End") %>'></asp:TextBox>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="txtend1" Width="100px" runat="server" ></asp:TextBox>

</FooterTemplate>

<ItemTemplate>

<asp:Label ID="Label4" runat="server" Text='<%# Bind("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("Recieved_By") %>'></asp:TextBox>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="txtby1" Width="100px" runat="server" ></asp:TextBox>

</FooterTemplate>

<ItemTemplate>

<asp:Label ID="Label5" runat="server" Text='<%# Bind("Recieved_By") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>




                <asp:CommandField HeaderText ="Edit" ShowEditButton="True" />

best

best