Records not updating

[Monty]

Hi there, I have a simple medical database with patient records. I use:
TotalRecords.Te xt = DetailsViewMain .DataItemCount & " records" to reflect
the number of patients in the db.
I then filter the records per person and update the count with the same
code. My problem is that the actual number of records is always off by one
update. That is to say that initially it reads correctly say 25 records.
Then I filter for person1 which has 3 records. The TotalRecords will read
25 the first time, then I filter for person2, which should read 4 but it
reads 3. Very strange! Any help with this?
Is there a way to cause an update/postback whatever to get the correct
number consistantly?

Thank you, Mark

[Göran Andersson]

It appears that you are reading the DataItemCount property before the
filtering takes effect.

What do you use for data source, and what do you do to filter it?

Monty wrote:

Hi there, I have a simple medical database with patient records. I use:
TotalRecords.Te xt = DetailsViewMain .DataItemCount & " records" to reflect
the number of patients in the db.
I then filter the records per person and update the count with the same
code. My problem is that the actual number of records is always off by one
update. That is to say that initially it reads correctly say 25 records.
Then I filter for person1 which has 3 records. The TotalRecords will read
25 the first time, then I filter for person2, which should read 4 but it
reads 3. Very strange! Any help with this?
Is there a way to cause an update/postback whatever to get the correct
number consistantly?

Thank you, Mark

[Monty]

Hi, and thanks in advance.

* What do you use for data source, and what do you do to filter it?

Protected Sub ListBoxSelectRC P_SelectedIndex Changed(ByVal sender As Object,
ByVal e As System.EventArg s) Handles
ListBoxSelectRC P.SelectedIndex Changed

If ListBoxSelectRC P.SelectedIndex + 1 = 1 Then
DetailsViewMain .DataSourceID = "roomFind1"
ListBoxSelectPa tient.DataSourc eID = "Patientfin d1"
ListBoxSelectRo om.DataSourceID = "RoomFind1"
End If

If ListBoxSelectRC P.SelectedIndex + 1 = 2 Then
DetailsViewMain .DataSourceID = "roomFind2"
ListBoxSelectPa tient.DataSourc eID = "Patientfin d2"
ListBoxSelectRo om.DataSourceID = "RoomFind2"
End If

TotalRecords.Te xt = DetailsViewMain .DataItemCount & " records"

End sub


"Göran Andersson" <gu***@guffa.co m> wrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

It appears that you are reading the DataItemCount property before the
filtering takes effect.

What do you use for data source, and what do you do to filter it?

Monty wrote:

Hi there, I have a simple medical database with patient records. I use:
TotalRecords.Te xt = DetailsViewMain .DataItemCount & " records" to reflect
the number of patients in the db.
I then filter the records per person and update the count with the same
code. My problem is that the actual number of records is always off by
one update. That is to say that initially it reads correctly say 25
records. Then I filter for person1 which has 3 records. The TotalRecords
will read 25 the first time, then I filter for person2, which should read
4 but it reads 3. Very strange! Any help with this?
Is there a way to cause an update/postback whatever to get the correct
number consistantly?

Thank you, Mark

[Göran Andersson]

Setting the DataSourceID property doesn't perform a DataBind, it only
set the RequiresDataBin ding property. The data binding is done at some
later stage, probably when the control is going to be rendered and
detects that it needs data binding.

You either have to call DataBind yourself before getting DataItemCount,
or get it after the data binding occurs.

Monty wrote:

Hi, and thanks in advance.

* What do you use for data source, and what do you do to filter it?

Protected Sub ListBoxSelectRC P_SelectedIndex Changed(ByVal sender As Object,
ByVal e As System.EventArg s) Handles
ListBoxSelectRC P.SelectedIndex Changed

If ListBoxSelectRC P.SelectedIndex + 1 = 1 Then
DetailsViewMain .DataSourceID = "roomFind1"
ListBoxSelectPa tient.DataSourc eID = "Patientfin d1"
ListBoxSelectRo om.DataSourceID = "RoomFind1"
End If

If ListBoxSelectRC P.SelectedIndex + 1 = 2 Then
DetailsViewMain .DataSourceID = "roomFind2"
ListBoxSelectPa tient.DataSourc eID = "Patientfin d2"
ListBoxSelectRo om.DataSourceID = "RoomFind2"
End If

TotalRecords.Te xt = DetailsViewMain .DataItemCount & " records"

End sub


"Göran Andersson" <gu***@guffa.co m> wrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

It appears that you are reading the DataItemCount property before the
filtering takes effect.

What do you use for data source, and what do you do to filter it?

Monty wrote:

Hi there, I have a simple medical database with patient records. I use:
TotalRecords.Te xt = DetailsViewMain .DataItemCount & " records" to reflect
the number of patients in the db.
I then filter the records per person and update the count with the same
code. My problem is that the actual number of records is always off by
one update. That is to say that initially it reads correctly say 25
records. Then I filter for person1 which has 3 records. The TotalRecords
will read 25 the first time, then I filter for person2, which should read
4 but it reads 3. Very strange! Any help with this?
Is there a way to cause an update/postback whatever to get the correct
number consistantly?

Thank you, Mark