?
Solved

no database linked Dataset seems to lose values

Posted on 2004-08-15
5
Medium Priority
?
163 Views
Last Modified: 2010-04-07
Hi,

I have a strongly typed non-database connected local dataset called "priceStream1".  I am iterating through a grid which adds rows to the "Instrument" table within this dataset (see below).  

At the end of this loop, for debug reasons, I am displaying the table data in XML of the records added - in my instance this is two and all is fine so far.

However, when I then try to inspect the dataset from another procedure within the same page (in my example I am assigning this new messageBox function which should display the data again to a simple server side button) the record count of the dataset is zero and therefore the XML statement is empty (apart from the default stuff).

It looks like some sort of scope issue but the priceStream1 dataset should be visible throughout my class.

Any help would greatly be appreciated.

Thanks.

James.

      private void Button2_Click(object sender, System.EventArgs e)
      {
            for (int i = 0; i <= WebGrid1.RootTable.Rows.Count - 1; i++)
            {
                  PriceStream.InstrumentRow myRow = priceStream1.Instrument.NewInstrumentRow();
                  myRow.Code = WebGrid1.RootTable.Rows[i].Cells[1].Text;
                  myRow.Price = Convert.ToDouble(strPrice);
                  myRow.Col = 0;
                  myRow.Row = i;
                  myRow.RequestID = i;
                  priceStream1.Instrument.Rows.Add(myRow);
                        
            }
            MessageBox.Show(priceStream1.GetXml(), "",MessageBoxButtons.OK,
                  MessageBoxIcon.Information,MessageBoxDefaultButton.Button1,
                  MessageBoxOptions.DefaultDesktopOnly);
      }
0
Comment
Question by:JAMES
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 11803573
Hi there,
is "WebGrid1" your DataSet. Well, I would say store it in a session and use it further.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconpassingservercontrolvaluesbetweenpages.asp

-Baan
0
 

Author Comment

by:JAMES
ID: 11803688
Baan,

WebGrid1 is a databound grid which is linked to another bound dataset.  I iterate through this grid on startup to populate my dataset called priceStream1.

I am not trying to see this data in another web page, I just want to retrieve it in the same page.  

Would you still consider it a session issue?

Thanks.

James.
0
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 11804397
ok... I got it now... sorry about that.
Try to insert a strongly typed row just to see if you can insert into the "Instrument" table. Don't use the loop... for testing.

-Baan
0
 

Author Comment

by:JAMES
ID: 11804614
The instrument table is being updated no problem - I show the XML from the datagrid after all the updates have been done and all is fine - they are all there...  It's only when I try to retrieve that data (after a button click elsewhere but on the same page) that it's gone.

I think you are correct when you say I have to save the data in a session object (or viewstate) and then repopulate the dataset after postback!

Would you agree?

Thanks.

0
 
LVL 18

Accepted Solution

by:
DotNetLover_Baan earned 2000 total points
ID: 11804732
hmm, ya.. since you are clicking on a button to display the data, this is as good as a different page, but with Page.IsPostBack = true. Go ahead and use session... that should work.
-Baan
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question