Guest User

Untitled

a guest
Sep 18th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.11 KB | None | 0 0
  1. asp net updating gridview row
  2. <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True" OnRowEditing="EditRecord" OnRowUpdating="UpdateRecord" DataKeyName = "payClaimId">
  3. <Columns>
  4. <asp:TemplateField HeaderText="Duty ID">
  5. <ItemTemplate><%# DataBinder.Eval(Container.DataItem, "dutyId")%></ItemTemplate>
  6. </asp:TemplateField>
  7. <asp:TemplateField HeaderText="Pay Claim ID">
  8. <ItemTemplate><%# DataBinder.Eval(Container.DataItem, "payClaimId")%></ItemTemplate>
  9. <EditItemTemplate><asp:TextBox ID="txtpayclaimid" runat="Server" ReadOnly ="true" Text ='<%# Eval("payClaimId") %>'></asp:TextBox></EditItemTemplate>
  10. </asp:TemplateField>
  11. <asp:TemplateField HeaderText="Date Submitted">
  12. <ItemTemplate><%# DataBinder.Eval(Container.DataItem, "printeddate", "{0:d}")%></ItemTemplate>
  13. </asp:TemplateField>
  14. <asp:TemplateField HeaderText="Date Worked">
  15. <ItemTemplate><%# DataBinder.Eval(Container.DataItem, "dateWorked", "{0:d}")%></ItemTemplate>
  16. <EditItemTemplate><asp:TextBox ID="txtdateworked" runat="Server" Text ='<%# Eval("dateWorked", "{0:d}") %>'></asp:TextBox></EditItemTemplate>
  17. </asp:TemplateField>
  18. <asp:TemplateField HeaderText="Total Hours">
  19. <ItemTemplate><%# DataBinder.Eval(Container.DataItem, "totalHours")%></ItemTemplate>
  20. <EditItemTemplate><asp:TextBox ID="txttotalhours" runat="Server" Text ='<%# Eval("totalHours") %>'></asp:TextBox></EditItemTemplate>
  21. </asp:TemplateField>
  22. <asp:TemplateField HeaderText="Status">
  23. <ItemTemplate><%# DataBinder.Eval(Container.DataItem, "status")%></ItemTemplate>
  24. </asp:TemplateField>
  25.  
  26. </Columns>
  27. </asp:GridView>
  28. private void loaddata()
  29. {
  30. DataTable dt = new DataTable();
  31. Timesheet ts = new Timesheet();
  32. dt = ts.gettimesheetrecords(Convert.ToInt32(txtboxeid.Text));
  33. GridView3.DataSource = dt;
  34. GridView3.DataBind();
  35. }
  36.  
  37. protected void EditRecord(object sender, GridViewEditEventArgs e)
  38. {
  39.  
  40. GridView3.EditIndex = e.NewEditIndex;
  41.  
  42. loaddata();
  43.  
  44. }
  45. protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)
  46. {
  47. GridViewRow row = (GridViewRow)GridView3.Rows[e.RowIndex];
  48. TextBox pcid = (TextBox)row.FindControl("txtpayclaimid");
  49. TextBox dworked = (TextBox)row.FindControl("txtdateworked");
  50. TextBox tHours = (TextBox)row.FindControl("txttotalhours");
  51. int payClaimId = int.Parse(pcid.Text);
  52. string dateWorked = Convert.ToString(dworked.Text);
  53. double totalHours = double.Parse(tHours.Text);
  54. int res = 0;
  55. PayClaim pc = new PayClaim();
  56.  
  57.  
  58. try
  59. {
  60. res = pc.updatepayclaim(payClaimId, dateWorked, totalHours);
  61. if (res > 0)
  62. {
  63. statuslabel.Text = "Record saved";
  64. GridView3.EditIndex = -1;
  65.  
  66. loaddata();
  67. }
  68. else
  69. {
  70. statuslabel.Text = "Duplicates";
  71. }
  72. }
  73. catch (Exception ex)
  74. {
  75. statuslabel.Text = "Error";
  76. }
  77. finally
  78. {
  79. pc = null;
  80. }
  81. }
  82.  
  83. public int updatepayclaim(int payClaimId, string dateWorked, double totalHours)
  84. {
  85.  
  86. dbCon = new OleDbConnection(sConnection);
  87.  
  88. dbCon.Open();
  89. OleDbCommand com = dbCon.CreateCommand();
  90. com.CommandText = "Update PayClaim Set totalHours=?, dateWorked=? where payClaimId=?";
  91. try
  92. {
  93. com.Parameters.AddWithValue("payClaimId", payClaimId);
  94. com.Parameters.AddWithValue("dateWorked", dateWorked);
  95. com.Parameters.AddWithValue("totalHours", totalHours);
  96. return com.ExecuteNonQuery();
  97. }
  98. catch
  99. {
  100. throw;
  101. }
  102. finally
  103. {
  104. com.Dispose();
  105. dbCon.Close();
  106. dbCon.Dispose();
  107. }
  108. }
  109.  
  110. com.CommandText = "Update PayClaim Set totalHours='@pTotalHours', dateWorked='@pDateWorked' where payClaimId='@pPayClaimId'";
  111. try
  112. {
  113. com.Parameters.AddWithValue("@pPayClaimId", payClaimId);
  114. com.Parameters.AddWithValue("@pDateWorked", dateWorked);
  115. com.Parameters.AddWithValue("@pTotalHours", totalHours);
  116. return com.ExecuteNonQuery();
  117. }
Add Comment
Please, Sign In to add comment