Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 11th, 2009, 10:15 AM
Authorized User
  
Join Date: Mar 2009
Posts: 64
Thanks: 0
Thanked 1 Time in 1 Post
Default Gridview and database will not update
Imar,

I am beating my head against the table trying to get a GridView and database to update. I have posted this on the ASP.NET and read a great deal on updating problems elsewhere on the internet to no avail. Perhaps you will see something I am missing. The code was basically auto generated when I put the GridView and SqlDataSource on the page. There is no Code Behind that has anything to do with updating. My understanding from the ASP.NET documentation is that the GridView and SqlDataSource, configured properly, will handling updating.

Note that I am not trying to update the two primary keys, both of which are set as ReadOnly in the Gridview. The GridView is in an update panel.

Thanks.

Thomas

HTML Code:
    <asp:GridView ID="GridView_masterHospitalList" runat="server" AllowSorting="True"          AutoGenerateColumns="False" CellPadding="4" DataKeyNames="HospitalIdentifier,HospitalName"          DataSourceID="SqlDataSource_masterHospitalList" ForeColor="#333333" Visible="False"          OnRowUpdating="GridView_masterHospitalList_RowUpdating">          <RowStyle BackColor="#EFF3FB" />          <Columns>              <asp:CommandField ShowEditButton="True" ShowSelectButton="True" />              <asp:BoundField DataField="HospitalIdentifier" HeaderText="Hospital ID" InsertVisible="False"                  ReadOnly="True" SortExpression="HospitalIdentifier" />              <asp:CheckBoxField DataField="Contract" HeaderText="Contract" SortExpression="Contract" />              <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />              <asp:CheckBoxField DataField="Terminated" HeaderText="Terminated" SortExpression="Terminated" />              <asp:CheckBoxField DataField="OContract" HeaderText="O Contract" SortExpression="OContract" />              <asp:BoundField DataField="HospitalName" HeaderText="Hospital Name" ReadOnly="True"                  SortExpression="HospitalName" />              <asp:BoundField DataField="ServerID" HeaderText="ServerID" SortExpression="ServerID" />              <asp:BoundField DataField="ContractIdentifier" HeaderText="Contract ID" SortExpression="ContractIdentifier" />              <asp:BoundField DataField="CorporateOwner" HeaderText="Corporate Owner" SortExpression="CorporateOwner" />              <asp:BoundField DataField="Affiliations" HeaderText="Affiliations" SortExpression="Affiliations" />              <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />              <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />              <asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />              <asp:BoundField DataField="TotalBeds" HeaderText="Total Beds" SortExpression="TotalBeds" />              <asp:BoundField DataField="CensusBeds" HeaderText="Census Beds" SortExpression="CensusBeds" />              <asp:BoundField DataField="AccountManager" HeaderText="AM" SortExpression="AccountManager" />          </Columns>          <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />          <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />          <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />          <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />          <EditRowStyle BackColor="#2461BF" />          <AlternatingRowStyle BackColor="White" />      </asp:GridView>  </center>  <asp:SqlDataSource ID="SqlDataSource_masterHospitalList" runat="server" ConnectionString="<%$ ConnectionStrings:Number1ConnectionString %>"      DeleteCommand="DELETE FROM [MasterHospitalList] WHERE [HospitalIdentifier] = @HospitalIdentifier AND [HospitalName] = @HospitalName"      InsertCommand="INSERT INTO [MasterHospitalList] ([Contract], [Active], [Terminated], [OContract], [HospitalName], [ServerID], [ContractIdentifier], [CorporateOwner], [Affiliations], [City], [State], [Zip], [TotalBeds], [CensusBeds], [AccountManager]) VALUES (@Contract, @Active, @Terminated, @OContract, @HospitalName, @ServerID, @ContractIdentifier, @CorporateOwner, @Affiliations, @City, @State, @Zip, @TotalBeds, @CensusBeds, @AccountManager)"      SelectCommand="SELECT * FROM [MasterHospitalList] ORDER BY [HospitalName]" UpdateCommand="UPDATE [MasterHospitalList] SET [Contract] = @Contract, [Active] = @Active, [Terminated] = @Terminated, [OContract] = @OContract, [ServerID] = @ServerID, [ContractIdentifier] = @ContractIdentifier, [CorporateOwner] = @CorporateOwner, [Affiliations] = @Affiliations, [City] = @City, [State] = @State, [Zip] = @Zip, [TotalBeds] = @TotalBeds, [CensusBeds] = @CensusBeds, [AccountManager] = @AccountManager WHERE [HospitalIdentifier] = @HospitalIdentifier AND [HospitalName] = @HospitalName"      OldValuesParameterFormatString="{0}">      <DeleteParameters>          <asp:Parameter Name="HospitalIdentifier" Type="Int32" />          <asp:Parameter Name="HospitalName" Type="String" />      </DeleteParameters>      <UpdateParameters>          <asp:Parameter Name="Contract" Type="Boolean" />          <asp:Parameter Name="Active" Type="Boolean" />          <asp:Parameter Name="Terminated" Type="Boolean" />          <asp:Parameter Name="OContract" Type="Boolean" />          <asp:Parameter Name="ServerID" Type="Int32" />          <asp:Parameter Name="ContractIdentifier" Type="Int32" />          <asp:Parameter Name="CorporateOwner" Type="String" />          <asp:Parameter Name="Affiliations" Type="String" />          <asp:Parameter Name="City" Type="String" />          <asp:Parameter Name="State" Type="String" />          <asp:Parameter Name="Zip" Type="String" />          <asp:Parameter Name="TotalBeds" Type="Int32" />          <asp:Parameter Name="CensusBeds" Type="Int32" />          <asp:Parameter Name="AccountManager" Type="String" />          <asp:Parameter Name="HospitalIdentifier" Type="Int32" />          <asp:Parameter Name="HospitalName" Type="String" />      </UpdateParameters>      <InsertParameters>          <asp:ControlParameter Name="Contract" ControlID="CheckBox_contract" Type="Boolean" />          <asp:ControlParameter Name="Active" ControlID="CheckBox_active" Type="Boolean" />          <asp:ControlParameter Name="Terminated" ControlID="CheckBox_terminated" Type="Boolean" />          <asp:ControlParameter Name="OContract" ControlID="CheckBox_OContract"              Type="Boolean" />          <asp:ControlParameter Name="HospitalName" ControlID="TextBox_hospitalName" Type="String" />          <asp:ControlParameter Name="ServerID" ControlID="DropDownList_serverID" Type="Int32" />          <asp:ControlParameter Name="ContractIdentifier" ControlID="DropDownList_contractName"              Type="Int32" />          <asp:ControlParameter Name="CorporateOwner" ControlID="TextBox_corporateOwner" Type="String" />          <asp:ControlParameter Name="Affiliations" ControlID="TextBox_affiliations" Type="String" />          <asp:ControlParameter Name="City" ControlID="TextBox_city" Type="String" />          <asp:ControlParameter Name="State" ControlID="DropDownList_state" Type="String" />          <asp:ControlParameter Name="Zip" ControlID="TextBox_zip" Type="String" />          <asp:ControlParameter Name="TotalBeds" ControlID="TextBox_totalBeds" Type="Int32" />          <asp:ControlParameter Name="CensusBeds" ControlID="TextBox_censusBeds" Type="Int32" />          <asp:ControlParameter Name="AccountManager" ControlID="DropDownList_accountManager"              Type="String" />      </InsertParameters>  </asp:SqlDataSource>
 
Old August 11th, 2009, 10:26 AM
Imar's Avatar
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
Hi there,

What chapter / page number of the book is this related to? If it's not related to the book, can you please post this in one of the other general ASP.NET categories? http://p2p.wrox.com/asp-net-3-5-436/

Helps to keep things on-topic here.

Also, please use the Remove Text Formatting toolbar when you post code or it becomes illegible as you see can above.

Finally, "Gridview and database will not update" is a pretty bad problem description. It's almost impossible to say something useful about it without *a lot* more information. What does it do instead? Crash? Be silent? Chase your cat? Format your harddrive? Etc etc etc etc etc

Try removing the update panel; it may be hiding the real error.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
 and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old August 11th, 2009, 11:17 AM
Authorized User
  
Join Date: Mar 2009
Posts: 64
Thanks: 0
Thanked 1 Time in 1 Post
Default
Imar,

As far as I know you did not cover this in the book. I think it is a small extension, but I do not recall you specifically discussing how to enable updating a Gridview and related SqlDataSource with not additional code behind.

The problem is that nothing happens. Clicking on the "Edit" link in the desired row (record) allows the user to make changes to the several fields, but when the "Update" link (the "Edit" link becomes the "Update" link) is clicked the Gridview returns to its normal view and the data remains unchanged. There is no error thrown, no failure of any kind.

I have tried removing the Update Panel to no avail.

Here is the code with the text formatting removed.

Is the link you suggested the best place to post such a question?

Thomas
  1. <asp:GridView ID="GridView_masterHospitalList" runat="server" AllowSorting="True"
  2. AutoGenerateColumns="False" CellPadding="4" DataKeyNames="HospitalIdentifier,HospitalName"
  3. DataSourceID="SqlDataSource_masterHospitalList" ForeColor="#333333" Visible="False"
  4. OnRowUpdating="GridView_masterHospitalList_RowUpda ting">
  5. <RowStyle BackColor="#EFF3FB" />
  6. <Columns>
  7. <asp:CommandField ShowEditButton="True" ShowSelectButton="True" />
  8. <asp:BoundField DataField="HospitalIdentifier" HeaderText="Hospital ID" InsertVisible="False"
  9. ReadOnly="True" SortExpression="HospitalIdentifier" />
  10. <asp:CheckBoxField DataField="Contract" HeaderText="Contract" SortExpression="Contract" />
  11. <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
  12. <asp:CheckBoxField DataField="Terminated" HeaderText="Terminated" SortExpression="Terminated" />
  13. <asp:CheckBoxField DataField="OContract" HeaderText="O Contract" SortExpression="OContract" />
  14. <asp:BoundField DataField="HospitalName" HeaderText="Hospital Name" ReadOnly="True"
  15. SortExpression="HospitalName" />
  16. <asp:BoundField DataField="ServerID" HeaderText="ServerID" SortExpression="ServerID" />
  17. <asp:BoundField DataField="ContractIdentifier" HeaderText="Contract ID" SortExpression="ContractIdentifier" />
  18. <asp:BoundField DataField="CorporateOwner" HeaderText="Corporate Owner" SortExpression="CorporateOwner" />
  19. <asp:BoundField DataField="Affiliations" HeaderText="Affiliations" SortExpression="Affiliations" />
  20. <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
  21. <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
  22. <asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />
  23. <asp:BoundField DataField="TotalBeds" HeaderText="Total Beds" SortExpression="TotalBeds" />
  24. <asp:BoundField DataField="CensusBeds" HeaderText="Census Beds" SortExpression="CensusBeds" />
  25. <asp:BoundField DataField="AccountManager" HeaderText="AM" SortExpression="AccountManager" />
  26. </Columns>
  27. <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  28. <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
  29. <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  30. <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  31. <EditRowStyle BackColor="#2461BF" />
  32. <AlternatingRowStyle BackColor="White" />
  33. </asp:GridView>
  34. </center>
  35. <asp:SqlDataSource ID="SqlDataSource_masterHospitalList" runat="server" ConnectionString="<%$ ConnectionStrings:Number1ConnectionString %>"
  36. DeleteCommand="DELETE FROM [MasterHospitalList] WHERE [HospitalIdentifier] = @HospitalIdentifier AND [HospitalName] = @HospitalName"
  37. InsertCommand="INSERT INTO [MasterHospitalList] ([Contract], [Active], [Terminated], [OContract], [HospitalName], [ServerID], [ContractIdentifier], [CorporateOwner], [Affiliations], [City], [State], [Zip], [TotalBeds], [CensusBeds], [AccountManager]) VALUES (@Contract, @Active, @Terminated, @OContract, @HospitalName, @ServerID, @ContractIdentifier, @CorporateOwner, @Affiliations, @City, @State, @Zip, @TotalBeds, @CensusBeds, @AccountManager)"
  38. SelectCommand="SELECT * FROM [MasterHospitalList] ORDER BY [HospitalName]" UpdateCommand="UPDATE [MasterHospitalList] SET [Contract] = @Contract, [Active] = @Active, [Terminated] = @Terminated, [OContract] = @OContract, [ServerID] = @ServerID, [ContractIdentifier] = @ContractIdentifier, [CorporateOwner] = @CorporateOwner, [Affiliations] = @Affiliations, [City] = @City, [State] = @State, [Zip] = @Zip, [TotalBeds] = @TotalBeds, [CensusBeds] = @CensusBeds, [AccountManager] = @AccountManager WHERE [HospitalIdentifier] = @HospitalIdentifier AND [HospitalName] = @HospitalName"
  39. OldValuesParameterFormatString="{0}">
  40. <DeleteParameters>
  41. <asp:Parameter Name="HospitalIdentifier" Type="Int32" />
  42. <asp:Parameter Name="HospitalName" Type="String" />
  43. </DeleteParameters>
  44. <UpdateParameters>
  45. <asp:Parameter Name="Contract" Type="Boolean" />
  46. <asp:Parameter Name="Active" Type="Boolean" />
  47. <asp:Parameter Name="Terminated" Type="Boolean" />
  48. <asp:Parameter Name="OContract" Type="Boolean" />
  49. <asp:Parameter Name="ServerID" Type="Int32" />
  50. <asp:Parameter Name="ContractIdentifier" Type="Int32" />
  51. <asp:Parameter Name="CorporateOwner" Type="String" />
  52. <asp:Parameter Name="Affiliations" Type="String" />
  53. <asp:Parameter Name="City" Type="String" />
  54. <asp:Parameter Name="State" Type="String" />
  55. <asp:Parameter Name="Zip" Type="String" />
  56. <asp:Parameter Name="TotalBeds" Type="Int32" />
  57. <asp:Parameter Name="CensusBeds" Type="Int32" />
  58. <asp:Parameter Name="AccountManager" Type="String" />
  59. <asp:Parameter Name="HospitalIdentifier" Type="Int32" />
  60. <asp:Parameter Name="HospitalName" Type="String" />
  61. </UpdateParameters>
  62. <InsertParameters>
  63. <asp:ControlParameter Name="Contract" ControlID="CheckBox_contract" Type="Boolean" />
  64. <asp:ControlParameter Name="Active" ControlID="CheckBox_active" Type="Boolean" />
  65. <asp:ControlParameter Name="Terminated" ControlID="CheckBox_terminated" Type="Boolean" />
  66. <asp:ControlParameter Name="OContract" ControlID="CheckBox_OContract"
  67. Type="Boolean" />
  68. <asp:ControlParameter Name="HospitalName" ControlID="TextBox_hospitalName" Type="String" />
  69. <asp:ControlParameter Name="ServerID" ControlID="DropDownList_serverID" Type="Int32" />
  70. <asp:ControlParameter Name="ContractIdentifier" ControlID="DropDownList_contractName"
  71. Type="Int32" />
  72. <asp:ControlParameter Name="CorporateOwner" ControlID="TextBox_corporateOwner" Type="String" />
  73. <asp:ControlParameter Name="Affiliations" ControlID="TextBox_affiliations" Type="String" />
  74. <asp:ControlParameter Name="City" ControlID="TextBox_city" Type="String" />
  75. <asp:ControlParameter Name="State" ControlID="DropDownList_state" Type="String" />
  76. <asp:ControlParameter Name="Zip" ControlID="TextBox_zip" Type="String" />
  77. <asp:ControlParameter Name="TotalBeds" ControlID="TextBox_totalBeds" Type="Int32" />
  78. <asp:ControlParameter Name="CensusBeds" ControlID="TextBox_censusBeds" Type="Int32" />
  79. <asp:ControlParameter Name="AccountManager" ControlID="DropDownList_accountManager"
  80. Type="String" />
  81. </InsertParameters>
  82. </asp:SqlDataSource>
 
Old August 11th, 2009, 11:21 AM
Imar's Avatar
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
Yes, it probably is. Pick a forum that best matches your situation (Beginners, Pro etc). This one is just for the book. That's why it's important to keep it on-topic as that makes it easier for others to find relevant messages related to the book.

Also, please post code without line numbers. With those numbers it's almost impossible to copy and paste it into VWD which, 9 out of 10 times, reveals the problem...

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
 and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
 
Old August 11th, 2009, 12:12 PM
Authorized User
  
Join Date: Mar 2009
Posts: 64
Thanks: 0
Thanked 1 Time in 1 Post
Default
Thanks. Here's the code without line numbers:

<asp:GridView ID="GridView_masterHospitalList" runat="server" AllowSorting="True"
AutoGenerateColumns="False" CellPadding="4" DataKeyNames="HospitalIdentifier,HospitalName"
DataSourceID="SqlDataSource_masterHospitalList" ForeColor="#333333" Visible="False"
OnRowUpdating="GridView_masterHospitalList_RowUpda ting">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:CommandField ShowEditButton="True" ShowSelectButton="True" />
<asp:BoundField DataField="HospitalIdentifier" HeaderText="Hospital ID" InsertVisible="False"
ReadOnly="True" SortExpression="HospitalIdentifier" />
<asp:CheckBoxField DataField="Contract" HeaderText="Contract" SortExpression="Contract" />
<asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
<asp:CheckBoxField DataField="Terminated" HeaderText="Terminated" SortExpression="Terminated" />
<asp:CheckBoxField DataField="OContract" HeaderText="O Contract" SortExpression="OContract" />
<asp:BoundField DataField="HospitalName" HeaderText="Hospital Name" ReadOnly="True"
SortExpression="HospitalName" />
<asp:BoundField DataField="ServerID" HeaderText="ServerID" SortExpression="ServerID" />
<asp:BoundField DataField="ContractIdentifier" HeaderText="Contract ID" SortExpression="ContractIdentifier" />
<asp:BoundField DataField="CorporateOwner" HeaderText="Corporate Owner" SortExpression="CorporateOwner" />
<asp:BoundField DataField="Affiliations" HeaderText="Affiliations" SortExpression="Affiliations" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
<asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />
<asp:BoundField DataField="TotalBeds" HeaderText="Total Beds" SortExpression="TotalBeds" />
<asp:BoundField DataField="CensusBeds" HeaderText="Census Beds" SortExpression="CensusBeds" />
<asp:BoundField DataField="AccountManager" HeaderText="AM" SortExpression="AccountManager" />
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</center>
<asp:SqlDataSource ID="SqlDataSource_masterHospitalList" runat="server" ConnectionString="<%$ ConnectionStrings:KConnectionString %>"
DeleteCommand="DELETE FROM [MasterHospitalList] WHERE [HospitalIdentifier] = @HospitalIdentifier AND [HospitalName] = @HospitalName"
InsertCommand="INSERT INTO [MasterHospitalList] ([Contract], [Active], [Terminated], [OContract], [HospitalName], [ServerID], [ContractIdentifier], [CorporateOwner], [Affiliations], [City], [State], [Zip], [TotalBeds], [CensusBeds], [AccountManager]) VALUES (@Contract, @Active, @Terminated, @OContract, @HospitalName, @ServerID, @ContractIdentifier, @CorporateOwner, @Affiliations, @City, @State, @Zip, @TotalBeds, @CensusBeds, @AccountManager)"
SelectCommand="SELECT * FROM [MasterHospitalList] ORDER BY [HospitalName]" UpdateCommand="UPDATE [MasterHospitalList] SET [Contract] = @Contract, [Active] = @Active, [Terminated] = @Terminated, [OContract] = @OContract, [ServerID] = @ServerID, [ContractIdentifier] = @ContractIdentifier, [CorporateOwner] = @CorporateOwner, [Affiliations] = @Affiliations, [City] = @City, [State] = @State, [Zip] = @Zip, [TotalBeds] = @TotalBeds, [CensusBeds] = @CensusBeds, [AccountManager] = @AccountManager WHERE [HospitalIdentifier] = @HospitalIdentifier AND [HospitalName] = @HospitalName"
OldValuesParameterFormatString="{0}" ConflictDetection="CompareAllValues">
<DeleteParameters>
<asp:Parameter Name="HospitalIdentifier" Type="Int32" />
<asp:Parameter Name="HospitalName" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Contract" Type="Boolean" />
<asp:Parameter Name="Active" Type="Boolean" />
<asp:Parameter Name="Terminated" Type="Boolean" />
<asp:Parameter Name="OContract" Type="Boolean" />
<asp:Parameter Name="ServerID" Type="Int32" />
<asp:Parameter Name="ContractIdentifier" Type="Int32" />
<asp:Parameter Name="CorporateOwner" Type="String" />
<asp:Parameter Name="Affiliations" Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="State" Type="String" />
<asp:Parameter Name="Zip" Type="String" />
<asp:Parameter Name="TotalBeds" Type="Int32" />
<asp:Parameter Name="CensusBeds" Type="Int32" />
<asp:Parameter Name="AccountManager" Type="String" />
<asp:Parameter Name="HospitalIdentifier" Type="Int32" />
<asp:Parameter Name="HospitalName" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:ControlParameter Name="Contract" ControlID="CheckBox_contract" Type="Boolean" />
<asp:ControlParameter Name="Active" ControlID="CheckBox_active" Type="Boolean" />
<asp:ControlParameter Name="Terminated" ControlID="CheckBox_terminated" Type="Boolean" />
<asp:ControlParameter Name="OContract" ControlID="CheckBox_oContract"
Type="Boolean" />
<asp:ControlParameter Name="HospitalName" ControlID="TextBox_hospitalName" Type="String" />
<asp:ControlParameter Name="ServerID" ControlID="DropDownList_serverID" Type="Int32" />
<asp:ControlParameter Name="ContractIdentifier" ControlID="DropDownList_contractName"
Type="Int32" />
<asp:ControlParameter Name="CorporateOwner" ControlID="TextBox_corporateOwner" Type="String" />
<asp:ControlParameter Name="Affiliations" ControlID="TextBox_affiliations" Type="String" />
<asp:ControlParameter Name="City" ControlID="TextBox_city" Type="String" />
<asp:ControlParameter Name="State" ControlID="DropDownList_state" Type="String" />
<asp:ControlParameter Name="Zip" ControlID="TextBox_zip" Type="String" />
<asp:ControlParameter Name="TotalBeds" ControlID="TextBox_totalBeds" Type="Int32" />
<asp:ControlParameter Name="CensusBeds" ControlID="TextBox_censusBeds" Type="Int32" />
<asp:ControlParameter Name="AccountManager" ControlID="DropDownList_accountManager"
Type="String" />
</InsertParameters>
</asp:SqlDataSource>
 
Old August 11th, 2009, 04:33 PM
Imar's Avatar
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
Are you sure it's not updating? Maybe the database does get updated but the Grid is not refreshed??

If that doesn't help can you please follow my suggestion and post in a different category (or maybe a moderator can move this post??). If you post there, please post the entire code for the page. You might also want to post the CREATE scripts for the database objects....

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
 and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with gridview update. ccarpenter ASP.NET 2.0 Basics 0 March 20th, 2008 09:18 AM
Can't get GridView to update xr280xr ASP.NET 2.0 Professional 5 February 15th, 2008 12:45 PM
Gridview using Update *only* pbranumfl ASP.NET 2.0 Basics 2 December 4th, 2006 03:21 PM
Gridview Update Issue jpgregg ASP.NET 2.0 Professional 0 September 1st, 2006 07:35 PM
FOXPRO gridview update webclown ASP.NET 1.x and 2.0 Application Design 0 May 1st, 2006 12:43 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.