Users Pricing

forum

Home Forums How to filter a dataview – MindStick

How to filter a dataview

Takeshi Okada 2175 04 Sep 2013

I have a dataview that contains a list of tables. I am reading in a list of values that I then want to apply as a filter to this dataview. The list of values is actually in the form of "table1, table2, table3". So I thought I would be able to use this as a filter on my dataview.

SqlOp.CommandText = "select name from dbo.sysobjects where xtype='u'";

SqlOp.ExecuteDataReader();

DataView dv = SqlOp.GetDataAsDataView();

SqlOp.CloseConnection();

Returns a list of all the tables in a dataview. Any help on how to filter this dataview?


1 Answers

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md