Dataset

[Guest]

HI
my issue is that i'm having a dataset with 2 tables in it, the problem that
i want to have a dataview wich represents a subquery ie (select * from tbl1
where id in (select top 10 from tbl2))

any ideas around

 

[Cor Ligthert]

Rani,

any ideas around

Yes use a relation that is made for this

Cor

 

[Ken Tucker [MVP]]

Hi,

Here is an example on how to bind a datagrid to a datareleation.
It will not allow you to select the top 10 records however.

http://www.windowsformsdatagridhelp.info/default.aspx?ID=a1a84750-08df-49b4-8657-7bc3068aca2c

Ken
----------------------
HI
my issue is that i'm having a dataset with 2 tables in it, the problem that
i want to have a dataview wich represents a subquery ie (select * from tbl1
where id in (select top 10 from tbl2))

any ideas around

 

[Guest]

--
Mirror Mirror On The Wall Who Is The Master Of Them ALL

 

[Guest]

thanks to ken and cor :

but a relation won't help because you can't get such the following

select * from tbl1 where id not in ( select id from tbl2 )

 

[Ken Tucker [MVP]]

Hi,

Your welcome. The only other option is to get the data when the
user changes to another record. Use the currencymanager's postionchanged
event to know when the user navigated to another record. From what i can
see you might be better off querying the database to get the records instead
of filtering records from a dataview.

General Declarations
Dim WithEvents cm As CurrencyManager

After you bind the grid.

cm = CType(Me.BindingContext(DataGrid1.DataSource), CurrencyManager)



Private Sub cm_PositionChanged(ByVal sender As Object, ByVal e As
System.EventArgs) Handles cm.PositionChanged

Me.Text = cm.Position

End Sub

Ken

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

thanks to ken and cor :

but a relation won't help because you can't get such the following

select * from tbl1 where id not in ( select id from tbl2 )