467,219 Members | 1,439 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,219 developers. It's quick & easy.

SQL SELECT query on DataSet(not fill)

Hi

I need execute SELECT SQL query in DataSet. No in SQL
server(da.selectcommand) and fill dataset, only show in datagrid
filtered by select-where query records from dataset:) For example I
fill dataset(ds)
da.selectcommand.commandtext="select * from xxx"
da.fill(ds.tables(0))

and when i write
datagrid.datasource=da.tables(0)
datagrid show me all records, but here i need something, i don't know
what, maybe DataView wich allow me to show in datagrid only records
WHERE for example city=London. Is it possible?? maybe RowFilter??

Mrozu

Nov 21 '05 #1
  • viewed: 6923
Share:
1 Reply
Mrozu,

ds.tables(0).DefaultView.rowfilter = "city = 'London'"
datagrid.datasource=ds.tables(0).Defaultview

I hope this helps,

Cor
Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Cyrille \cns\ Szymanski | last post: by
4 posts views Thread by Kris Rudin | last post: by
2 posts views Thread by VB Programmer | last post: by
9 posts views Thread by Udo Marx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.