TableAdapter.GetData.Compute Problem

Question

0.00/5 (No votes)

See more:

Hi,

I'm trying to find the largest number in a table with:
TblInventoryTableAdapter.GetData.Compute("Max(InvID)", Nothing)

The code works just dandy. However for reasons unknown, it does not update while my program is already running. When I enter a larger value, it I have to close my app and open it again before it returns my newly entered larger number. Just closing and reopening the form does not work, the entire application needs to be closed and reopened.

I'm also reading the row count with: TblInventoryTableAdapter.GetData.Rows.Count, at the same time as finding the largest number. The row count updates, which means the TableAdaptor is updating. So for reasons unknown Compute does not include new records.:confused:

Do I have to somehow release the compute function from the table adaptor, similarly to how you remove a filter when you are done filtering data?

I have tried TblInventoryTableAdapter.Update(Me.AccommodationDataSet.tblInventory) but no difference.

Any help would be greatly appreciated

Marco

Posted 10-Oct-10 20:35pm

bigbro_1985

Updated 10-Oct-10 21:36pm

v2

Add a Solution

Comments

[no name] 11-Oct-10 5:55am

Is this a Microsoft thing? If been playing around with some of the TableAdaptor functions and now it updates every second record. I'm confused

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

terpy · Answer 1 · 2010-10-11T11:22:00

Solution 1

Did you try TblInventoryTableAdapter.Fill? If you set Clear before fill to true, I think the table adapter goes back to the database to get everything fresh.

Posted 11-Oct-10 11:22am

terpy

Comments

[no name] 12-Oct-10 2:00am

Hi terpy,

Thanks for the help, I tried that already it only updates every two records. I believe that TblInventoryTableAdapter.GetData.Reset() does the same thing.

It simply must be one of those Microsoft things, im just going to try something completely different.

Thanks Though.