The data is not updating the data; What am I doing wrong? RSS

• • Reply
  

  kenbati

  Member

  234 Points

  408 Posts

  The data is not updating the data; What am I doing wrong?

  Dec 10, 2008 02:02 AM|LINK

  void Page_Load()

  {

  AccountDataSource.DataFile = "~/App_Data/AccountInfo.mdb";

  AccountDataSource.SelectCommand = " SELECT Scenario.* from Scenario ";

  AccountDataSource.UpdateCommand = "UPDATE Scenario SET Scenario.BusinessStartYear = ?, Scenario.ReportingStart = ?, Scenario.ReportingEnd = ?, Scenario.FilterString = ? WHERE (Scenario.ScenarioID=Year2005) ";

  AccountDataSource.DeleteCommand = "DELETE FROM [Scenario] WHERE (Scenario.ScenarioID=?) ";

  myGridView.ID = "myGridView";

  myGridView.DataSourceID = "AccountDataSource";

  myGridView.AutoGenerateColumns = true;myGridView.AllowPaging = true;

  myGridView.PageSize = 16;

  myGridView.AllowSorting = true;

  myGridView.CellPadding = 3;

  myGridView.CellSpacing = 1;

  myGridView.AutoGenerateEditButton = true;

  myGridView.AutoGenerateSelectButton=true;

  myGridView.SelectedIndex = 0;

  myGridView.AlternatingRowStyle.BorderColor = System.Drawing.Color.BlanchedAlmond;myGridView.AlternatingRowStyle.BackColor = System.Drawing.Color.Bisque;

   

   

   

  }

   

  </script>

  <asp:Content ID="Content1" runat="Server" ContentPlaceHolderID="ContentPlaceHolder1">

  <div>

  <asp:AccessDataSource ID="AccountDataSource" runat="server"></asp:AccessDataSource>

  <asp:PlaceHolder ID="GridViewPlaceHolder" runat="Server"></asp:PlaceHolder>

  <asp:GridView onrowupdating="myGridView_RowUpdating" OnSelectedIndexChanged="myGridView_SelectedIndexChanged" ID="myGridView" runat="server" >

  </asp:GridView>

   

   

   

   

  </div>

  </asp:Content>

  update gridview

  Do not forget to mark it as answer!!
  
  Our economy is bad due to corruption and monoply!
  • Moved by limno on Dec 10, 2008 02:18 AM
• • Reply
  

  deval

  Member

  68 Points

  14 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 10, 2008 04:49 AM|LINK

  You have not bound the columns of the Grid 

  <asp:GridView onrowupdating="myGridView_RowUpdating" OnSelectedIndexChanged="myGridView_SelectedIndexChanged" ID="myGridView" runat="server" >

  <Columns>
          <asp:BoundField    HeaderText="Header you want to display"           DataField="column name from your table" />
          <asp:BoundField    HeaderText="Header you want to display            DataField ="column name from your table" />
  </Columns>

  </asp:GridView>

  -------------------------------------------------------------------------------- 

  Mark as Answer if it is helpful to you

  --------------------------------------------------------------------------------- 

  http://www.ondemandsharepoint.com/
  • Edited by deval on Dec 10, 2008 04:51 AM
• • Reply
  

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 10, 2008 05:01 AM|LINK

  deval

  You have not bound the columns of the Grid 

  <asp:GridView onrowupdating="myGridView_RowUpdating" OnSelectedIndexChanged="myGridView_SelectedIndexChanged" ID="myGridView" runat="server" >

  <Columns>
          <asp:BoundField    HeaderText="Header you want to display"           DataField="column name from your table" />
          <asp:BoundField    HeaderText="Header you want to display            DataField ="column name from your table" />
  </Columns>

  </asp:GridView>

  No, that's not the problem. The fields are autogenerated by default, so they are bound. The problem is the updatecommand:

  WHERE (Scenario.ScenarioID=Year2005)

  This should be:

  WHERE (Scenario.ScenarioID='Year2005')

  Since it is a string

• • Reply
  

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 10, 2008 05:04 AM|LINK

  Oh,

  And don't forget to provide values for the 4 parameters. Matbe you should read this

  • Edited by hans_v on Dec 10, 2008 05:05 AM
  • Edited by Wencui Qian - MSFT on Dec 16, 2008 09:32 AM
  • Edited by Wencui Qian - MSFT on Dec 17, 2008 09:15 AM
• • Reply
  

  kenbati

  Member

  234 Points

  408 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 10, 2008 03:01 PM|LINK

  The quotes did not work. The problem is not resolved. Can you try the code on your vwd?

  Do not forget to mark it as answer!!
  
  Our economy is bad due to corruption and monoply!
• • Reply
  

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 10, 2008 06:09 PM|LINK

  kenbati

  The quotes did not work. The problem is not resolved. Can you try the code on your vwd?

  The quoates are not the only issue! Like I said, I don't see where you provide the values for the parameters!

  Again, read this, you probably don't need any code whatsover!

  • Edited by hans_v on Dec 10, 2008 06:10 PM
• • Reply
  

  kenbati

  Member

  234 Points

  408 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 17, 2008 12:00 AM|LINK

  the fields are autogenerated

  Do not forget to mark it as answer!!
  
  Our economy is bad due to corruption and monoply!
• • Reply
  

  kenbati

  Member

  234 Points

  408 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 20, 2008 03:37 PM|LINK

  none of the solutions provided make technical sense. Can someone copy the code and try it on their computer.  PLEASE

  Do not forget to mark it as answer!!
  
  Our economy is bad due to corruption and monoply!
• • Reply
  

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 20, 2008 04:08 PM|LINK

  Show the code you have so far (use the Source Code button in the editor!)

  Do you get any error messages?

• • Reply
  

  kenbati

  Member

  234 Points

  408 Posts

  Re: The data is not updating the data; What am I doing wrong?

  Dec 20, 2008 04:55 PM|LINK

  the code is on the thread. I do not get any errors

  Do not forget to mark it as answer!!
  
  Our economy is bad due to corruption and monoply!