473,320 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DataView with RowFilter (Result Error)

Hi,

I have a store procedure there is a select statement with a Group by
MobileNo. When I get the result to DataSet I create a DataView then I
filter to the DataView with RowFilter condition based on a category.

The result is not correct:

The ResultView.Count gives the correct no of rows (I check it with the SQL
server query analyzer) but I get some MobileNo to more than 1 categories,
this thing is wrong because I have "GROUP BY MobileNo" to my SQL statement.
I believe the error is on the RowFilter.

P.S. I have loop in order to validate the MobileNo and do some process …

Any ideas?

Thx in Advance
Isambella

--
Message posted via http://www.dotnetmonster.com
Nov 19 '05 #1
1 1150
I'd put 10 to 1 odds the problem is in your SQL. Try just doing:

SELECT MobileNumber FROM Telephones GROUP BY MobileNumber

If you have more than one column in your select/group by you might get
multiple rows back with the same mobilenumber.

"Isambella Yiota via DotNetMonster.com" wrote:
Hi,

I have a store procedure there is a select statement with a Group by
MobileNo. When I get the result to DataSet I create a DataView then I
filter to the DataView with RowFilter condition based on a category.

The result is not correct:

The ResultView.Count gives the correct no of rows (I check it with the SQL
server query analyzer) but I get some MobileNo to more than 1 categories,
this thing is wrong because I have "GROUP BY MobileNo" to my SQL statement.
I believe the error is on the RowFilter.

P.S. I have loop in order to validate the MobileNo and do some process …

Any ideas?

Thx in Advance
Isambella

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Randy | last post by:
Hello All, I'm trying to use a DataView and in the rowfilter, base it on two fields in the table. I can't find any examples on this. Is there a way to do it. I'm talking about something like......
2
by: Daniel Groh | last post by:
Hi People, I have the following code: --------- DataView dvErrorSQL = new DataView(dsErroSQL.Tables); dvErroSQL.RowFilter = "cdError = " + iError; --------------------- I need to send the...
2
by: Alpha | last post by:
I have a window application. In one of the form, a datagrid has a dataview as its datasource. Initial filtering result would give the datavew 3 items. When I double click on the datagrid to edit...
3
by: Siegfried Heintze | last post by:
I'm displaying information on job postings in various cities. For example, might have a dozen jobs in Atlanta GA and I decide, at run time, that I don't want to see them. How do I set my DataView...
8
by: Dave Hagerich | last post by:
I'm using a DataGrid with a DataSet and I'm trying to filter the data being displayed, using the following code as a test: DataView theView = new DataView(theDataSet.Tables); theView.RowFilter =...
4
by: James | last post by:
Basically I have a DataGrid that I'm binding to the results of a stored procedure call. The recordset is fairly small. Initially I'm creating a DataSet from the results and binding it. There's a...
0
by: neeraj | last post by:
Hi, all Could anny one give me help how can I use like operator with these data types "integer , datetime or boolean" in DataView.RowFilter Actually when I try to get the data from dataview...
2
by: neeraj | last post by:
Hi, all Could anny one give me help how can I use like operator with these data types "integer , datetime or boolean" in DataView.RowFilter Actually when I try to get the data from dataview...
1
by: AlexW | last post by:
Hi I am in the process of developing an inventory application in visual basic. I keep coming up against a problem with using the dataview.rowfilter property. Basically what happens is this: -a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.