I'm going completely nuts. I have tried what you did and it works (don't
know if I should be :-) or :-(.). Now I have a form with nothing on it but
two stupid datagrids one bound to the dataset itself and the other one to
the dataview. My application on the other hand still doesn't work & I can't
see any mistake.
If anybody has ANY (really anything!!!) idea what my problem could be please
post it (Could it be a problem that my dataset was stored in a SessionID? Do
I loose any information doing so which I would need now?).
Thank you!
Daniel
"Daniel Walzenbach" <(E-Mail Removed)> schrieb im
Newsbeitrag news:(E-Mail Removed)...
> Carl,
>
>
>
> this is how I expected it should be but nevertheless I get different
> results. Do you know anything about the "cursor position" part in the
> definition of a DataView as it is written in the MSDN? It seems that I
> always get back a single cursor row but I don't know why and how to prove
my
> assumption?
>
>
>
> Thank you Carl for your help!! I appreciate your efforts.
>
>
>
> Daniel
>
>
> "Carl Prothman [MVP]" <(E-Mail Removed)> schrieb im Newsbeitrag
> news:#2$(E-Mail Removed)...
> > Daniel,
> > I get the same count when using the following code:
> >
> > ' Note I create the sqlConnection1 and sqlDataAdapter1
> > ' by dragging a Table from Server Explorer onto the WinForm.
> > Dim ds As DataSet = New DataSet
> > SqlDataAdapter1.Fill(ds, "customers")
> >
> > MsgBox("Rows.Count = " & ds.Tables("customers").Rows.Count)
> > MsgBox("DefaultView.RowFilter = " &
> ds.Tables("customers").DefaultView.RowFilter)
> > MsgBox("DefaultView.RowStateFilter = " &
> ds.Tables("customers").DefaultView.RowStateFilter.ToString())
> > MsgBox("DefaultView.Count = " &
ds.Tables("customers").DefaultView.Count)
> >
> > --
> >
> > Thanks,
> > Carl Prothman
> > Microsoft ASP.NET MVP
> > http://www.able-consulting.com
> >
> >
> > "Daniel Walzenbach" <(E-Mail Removed)> wrote in
> message news:ehhn#(E-Mail Removed)...
> > > Carl,
> > >
> > >
> > >
> > > I have checked those as well and they seem to be fine. However
> .RowFilter is
> > > set to "" (String.Empty) and .RowStateFilter ist set to "CurrentRows".
> > >
> > > I have also read on
> > >
>
http://msdn.microsoft.com/library/de...us/cpref/html/
> > > frlrfsystemdatadatatableclassdefaultviewtopic.asp that the DefaultView
> > > Property is "a customized view of the table which may include a
filtered
> > > view, or a cursor position." I assume it somehow returns a cursor
> position
> > > but I'm not sure why.
> > >
> > > Thanks
> > >
> > > Daniel
> > >
> > >
> > > "Carl Prothman [MVP]" <(E-Mail Removed)> schrieb im Newsbeitrag
> > > news:(E-Mail Removed)...
> > > > Daniel,
> > > > What are the values for the following properties?
> > > > ds.Tables(0).DefaultView.RowFilter
> > > > ds.Tables(0).DefaultView.RowStateFilter
> > > >
> > > > --
> > > >
> > > > Thanks,
> > > > Carl Prothman
> > > > Microsoft ASP.NET MVP
> > > > http://www.able-consulting.com
> > > >
> > > >
> > > > "Daniel Walzenbach" <(E-Mail Removed)> wrote
in
> > > message news:(E-Mail Removed)...
> > > > Hi,
> > > >
> > > > I have the following scenario:
> > > >
> > > > myDataSet.Tables("tblCustomer").Rows.Count = 4
> > > >
> > > > This is quite fine as the table contains 4 rows. However
> > > >
> > > > myDataSet.Tables("tblCustomer").DefaultView.Count = 1
> > > >
> > > > is not exactly what I expected it to be (I thought the result should
> be
> > > 4). Can anybody explain this behavior to me?
> > > >
> > > > Thanks in advance
> > > >
> > > > Daniel
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Similar Threads
