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

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"

and when i write
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??


Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a

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

I hope this helps,

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.