By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,784 Members | 3,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,784 IT Pros & Developers. It's quick & easy.

SQL SELECT query on DataSet(not fill)

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.