Guest User

Untitled

a guest
Jun 21st, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.03 KB | None | 0 0
  1. UPDATE dbo.tblHardware SET TypeID = @TypeID, Name = @Name, Description = @Description, Cost = @Cost, Weight = @Weight, Image = @Image WHERE (HardwareID = @HardwareID)
  2.  
  3. <asp:SqlDataSource ID="dsHardware" runat="server"
  4. ConnectionString="<%$ ConnectionStrings:RequestFormsConnectionString %>"
  5. OldValuesParameterFormatString="original_{0}"
  6. SelectCommand="SELECT * FROM [vHardware]"
  7. UpdateCommand="UPDATE dbo.tblHardware SET TypeID = @TypeID, Name = @Name, Description = @Description, Cost = @Cost, Weight = @Weight, Image = @Image WHERE (HardwareID = @HardwareID)"
  8. InsertCommand="INSERT INTO [vHardware] ([HardwareID], [TypeID], [Description], [Name], [Cost], [Weight], [Image], [TypeDesc], [TypeName], [TypeTypeID]) VALUES (@HardwareID, @TypeID, @Description, @Name, @Cost, @Weight, @Image, @TypeDesc, @TypeName, @TypeTypeID)"
  9. DeleteCommand="DELETE From tblHardware WHERE HardwareID = @HardwareID">
  10. <UpdateParameters>
  11. <asp:FormParameter FormField="TypeID" Name="TypeID" />
  12. <asp:FormParameter FormField="Name" Name="Name" />
  13. <asp:FormParameter FormField="Description" Name="Description" />
  14. <asp:FormParameter FormField="Cost" Name="Cost" />
  15. <asp:FormParameter FormField="Weight" Name="Weight" />
  16. <asp:FormParameter FormField="Image" Name="Image" />
  17. <asp:FormParameter FormField="HardwareID" Name="HardwareID" />
  18. </UpdateParameters>
  19. <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
  20. AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" DataKeyNames="HardwareID,TypeTypeID"
  21. DataSourceID="dsHardware">
  22. <Columns>
  23. <asp:BoundField DataField="HardwareID" HeaderText="HardwareID" InsertVisible="False"
  24. ReadOnly="True" SortExpression="HardwareID" />
  25. <asp:BoundField DataField="TypeID" HeaderText="TypeID" SortExpression="TypeID" />
  26. <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
  27. <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
  28. <asp:BoundField DataField="Cost" HeaderText="Cost" SortExpression="Cost" />
  29. <asp:BoundField DataField="Weight" HeaderText="Weight" SortExpression="Weight" />
  30. <asp:BoundField DataField="Image" HeaderText="Image" SortExpression="Image" />
  31. <asp:BoundField DataField="TypeDesc" HeaderText="TypeDesc" SortExpression="TypeDesc" />
  32. <asp:BoundField DataField="TypeName" HeaderText="TypeName" SortExpression="TypeName" />
  33. <asp:BoundField DataField="TypeTypeID" HeaderText="TypeTypeID" InsertVisible="False"
  34. ReadOnly="True" SortExpression="TypeTypeID" />
  35. </Columns>
  36. </asp:GridView>
  37.  
  38. <asp:ControlParameter> should help you out.
  39.  
  40. <asp:ControlParameter ControlID="GridView1" Name="HardwareID"
  41.  
  42. PropertyName="SelectedValue" Type="Int32" />
  43.  
  44. OldValuesParameterFormatString="original_{0}"
Add Comment
Please, Sign In to add comment