473,224 Members | 1,597 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,224 software developers and data experts.

Databind DataList Display Problem

I have a website that performs a search on an indexing service and returns
the results. During the initial load, I get the recordcount through a DS,
then bind a DataList using a second DS with page count of 20.

This site executes successfully on my local machine and indexing service.
When ran on the intended server, the app retrieves the record count, then
binds the data in the 2nd DS, but doesn't display the records bound to the
DataList. When a user goes to the 2nd page, the results will display. If I
remove the initial recordcount DS, the results are displayed fine. The code
is simple and is abbr below:

Dim CN as New OleDB.Connection("Provider=MSIDXS.1;Data Source=HDSN-Standard")
Dim DA as New OleDBDataAdapter("Select filename From Scope()",CN)
Dim RC as Integer = 0

Dim DS1 as New DataSet
Dim DS2 as New DataSet
DA.Fill(DS1,"RecordCount")
RC = DS1.Tables("RecordCount").Rows.Count
DS1.Dispose()
DA.Fill(DS2,CurrentIndex,PAGE_SIZE,"Results")
DataList1.DataSource = DS2
DataList1.DataBind

I simplified the code, but it works in full on my local machine, but not on
the initial search on the server. In order to start viewing the results on
the server, you must proceed to another page. At that time, you can then go
back to the first page to view results 1 - 20.

I've tried placing code in classes, seperate functions returned by Booleans,
time delays, but nothing works. It almost looks like the code runs to quick
for the data to bind, but if I take out the DS1, it all works fine.

Please help with ideas.

Nov 19 '05 #1
0 1144

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

Similar topics

0
by: New User | last post by:
I have a datasource as a xml file. I display one row at a time based on filter value. when I chage different value the datalist displays currect information on display based on filter value but...
2
by: Olav Tollefsen | last post by:
I have a Web Form with a DataList. Inside the ItemTemplate, I have a DropDownList control. <asp:DataList ID="ProductDataList" Runat="server"> <ItemTemplate> <asp:DropDownList ID="DropDownList1"...
1
by: Craig | last post by:
This is killing me, I've been trying to figure this out for 2 days. When I click on the linkbutton, it executes the GetData(int) method to set the DataSource. The FAILURE is when it tries to...
0
by: nicklang | last post by:
Say you are creating a page which contains a child control which uses a DataList or DataGrid control. In a DataList, the rows are dynamic controls and are data bound, so you have to first load the...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

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.