RE: RowFilter Failing

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

rowFilter acts the same way as a where clause in SQL and SQL WHERE clause
doesnt support GUID and image types.

I hope this helps

Mahesh B.
--



"Elton W" wrote:

Hi Spence,

Try

vueDisplayImages.rowfilter = "PatientID =" & PatientID

If in datatable PatientID's data type is string, try

vueDisplayImages.rowfilter = "PatientID ='" & PatientID +& "'"


HTH

Elton Wang


"Spence" wrote:

I hope someone royally owns me using my own stupidity but follow this
thought process if you will.
vs.net 2003 .net 1.1, MSDE

I have a table with three fields:
PatientsDisplayImageTypes
PatientsDisplayImageTypeID (GUID), PatientID (Guid), ImageTypeID (Guid)
PK FK FK

I fill my dataset using the dataAdapter ("Select * from
PatientsDisplayImageTypes", conSLDB)
da.fill(ds, "DisplayImages")

I then create a view upon the datatable

Dim vueDisplayImages As New DataView(ds.Tables("DisplayImages"), "",
"ImageTypeID", DataRowViewState.CurrentRows) *** IF i were to be owned I
believe this line could be it, perhaps need to use a different row state.

So now I have my view.

I then select a PatientID as a GUID from a working list, and this is where
it gets interesting. (Have verified PatientID to be valid during Debugging,
and records exist in the Sql (PatientsDisplayImageTypes) data table (Verified
directly using enterprise manager)

I set vueDisplayImages.rowfilter = "PatientID = '{" & PatientID.toString &
"}')
vueDisplayImages.Count is 0 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Hence my problem. So patient ID is valid. Syntax for rowfilter is valid(?).
Records exist in the underlying SQL table. Used a select * to fill the ds,
with no where condition, hence if record is in the SQL table, it is now in my
dataset.

Does this sound like a .net bug?
.

Relevant Pages

  • RE: RowFilter Failing
    ... working on GUID filtering? ... rowFilter acts the same way as a where clause in SQL and SQL WHERE clause ... PatientsDisplayImageTypes", conSLDB) ... (Have verified PatientID to be valid during Debugging, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: programatically add table in access
    ... In SQL Server you can default a guid datatype with a newGUIDbuiltin function, but check the documentation for Access. ... Autonumber is a field attribute, as is the format property which you would use to set the displayed decimal places. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Setting control value based on a SQL Select statement
    ... I don't understand what you mean by « So as an alternative I use a SQL ... Select statement where GUID = linked server GUID in the hope I can return ... The form is bound to a SQL view and the control is bound to a field ... Each time you select a client from the client combo box a GUID is ...
    (microsoft.public.access.adp.sqlserver)
  • Not finding GUID value after migration sql 2005 to 2000
    ... I've developed a web app using sql 2005. ... a guid value in the ASP.NET ... which works fine on my 2005 server but breaks on the 2000 server. ... // Retrieve information through the stored GUID ...
    (comp.databases.ms-sqlserver)
  • Re: The Web site that is referenced here is not in the configuration database.
    ... a wrong GUID in the SQLServerAgent can cause such 324 ... SQL Server Agent feature is not available/ supported on a WMSDE ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)