473,387 Members | 1,722 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

What is the syntax for setting RowFilter in a DataView on a multi-table DataSet?

I'm trying to set a filter on a table in a DataView to a multi-table DataSet
and am guessing it is something like this:

dvMyView.RowFilter = "['AgencyTable']AgencyID = " txtAgencyID.Text;

Can someone help me with the exact format for something like this?
Nov 15 '05 #1
1 1459
DataView dv = new DataView(ds.Tables["Custome"]);
dv.RowFilter = "Customname = 'blar'";

Hop this help

"tgif" <nf*@nospam.com> wrote in message
news:O6**************@TK2MSFTNGP10.phx.gbl...
I'm trying to set a filter on a table in a DataView to a multi-table DataSet and am guessing it is something like this:

dvMyView.RowFilter = "['AgencyTable']AgencyID = " txtAgencyID.Text;

Can someone help me with the exact format for something like this?

Nov 15 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: vbnetrookie | last post by:
In the dataview rowfilter property, how can I say that I just want Titles that start with 'A' to 'J' ?? ex: dv.rowfilter = " Country = ' France ' " I want dv.rowfilter = " Title = (from...
2
by: David | last post by:
Hi, I use DataView to filter my record. But when I use: ls_filter += " and DATEPART(hh, CA103)=" + i ; mydv.RowFilter = ls_filter; I got error. How should I filter by hour using...
10
by: Roy Lawson | last post by:
Can anyone explain the difference between RowStateFilter and RowFilter properties of the DataView objects in simple terms? I am going through a Transcender practice exam and just when I think I...
1
by: Bill Nguyen | last post by:
Can I have more than 1 criteria for Dataview.Rowfilter? For example: Dataview.Rowfilter = "Column1 = " & Var1 & "AND colum2 = " & Var2 Thanks Bill
3
by: Catullus | last post by:
Hi everyone, I'm a n00b on VB.net programming and now I stumbled upon a problem I can't solve, even after browsing the net for hours.. I have a dataview witg 4 columns; 2 string columns and 2...
0
by: GabrielsDad | last post by:
I am writing a winform that has a DataGrid attached to a DataView. The filter uses date column that is set using a user supplied value. The filter works great (less than 1 second for grid...
1
by: sg_pl | last post by:
Hi, I'have RowFilter in my aplication: DataView view = (DataView)this.klienciBindingSource.List; view.RowFilter = string.Format("IMIE LIKE '%{0}%'", textBox1.Text); and when I change text...
0
by: Tom | last post by:
i have this DataView dv = new DataView(ds.tables); dv.RowFilter = "Carmake=" + strCars; dg.datasource = dv; dg.DataBind(); I get the error" Can't find column BMW is the strCars value not...
0
by: neeraj | last post by:
Hi, all Could anny one give me help how can I use like operator with these data types "integer , datetime or boolean" in DataView.RowFilter Actually when I try to get the data from dataview...
2
by: neeraj | last post by:
Hi, all Could anny one give me help how can I use like operator with these data types "integer , datetime or boolean" in DataView.RowFilter Actually when I try to get the data from dataview...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.