473,326 Members | 2,438 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,326 software developers and data experts.

WebApplication - DataSet Navigation HickUp

Hi!
I'm new to ASP.NET WebApplications and wonder whether I've missed
something out when programming it. I'm grateful for any hints to this
problem!

Thanks very much for your efforts!

Martin

Description:
I'm running a Webapplication connection to SQL Server 7 using a
DataSet.
The DataSet is stored on the client. The application works ok
initially e.g. I can browse through the records back and forwards with
Previous and Next.
The variable that holds the currentRow value is declared as 'Shared'
(in case this is important to know).

Trouble starts when I run the same application on a different client
machine on the network at the same time. When I browse through records
on Client B and then go back to Client A and e.g. click Next, it jumps
records. It often goes to the last record in a recordset consisting of
5 when clicking Next although it was only at the second record and
should have gone to the third. Any subsequent Next click behaves
normal until I go back to Client B and change the current Record. At
this point the problem also occurs on Client B since I've changed the
current row on Client A.
It's like that both clients interfere with each other, although the
DataSet is stored locally on each of them??
Nov 18 '05 #1
2 1615
Don't take my word for it. But I think a dataset cannot
be local to a client machine. I don't know much about
this, but it doesn't sound logical that your web browser
is showing something that is being picked up from your
own harddisk. No way.

The data set is created at the server and the asp.net
application running AT THE SERVER picks up some records
from the dataset and shows it in your screen in HTML
format. So as far as the client is concerned, it just
displays whatever that comes down in HTML format, so no
processing is done there.

And why did you 'share' the variable that holds the
current value? try not doing that

-----Original Message-----
Hi!
I'm new to ASP.NET WebApplications and wonder whether I've missedsomething out when programming it. I'm grateful for any hints to thisproblem!

Thanks very much for your efforts!

Martin

Description:
I'm running a Webapplication connection to SQL Server 7 using aDataSet.
The DataSet is stored on the client. The application works okinitially e.g. I can browse through the records back and forwards withPrevious and Next.
The variable that holds the currentRow value is declared as 'Shared'(in case this is important to know).

Trouble starts when I run the same application on a different clientmachine on the network at the same time. When I browse through recordson Client B and then go back to Client A and e.g. click Next, it jumpsrecords. It often goes to the last record in a recordset consisting of5 when clicking Next although it was only at the second record andshould have gone to the third. Any subsequent Next click behavesnormal until I go back to Client B and change the current Record. Atthis point the problem also occurs on Client B since I've changed thecurrent row on Client A.
It's like that both clients interfere with each other, although theDataSet is stored locally on each of them??
.

Nov 18 '05 #2
"Michelle Stone" <mi********@yahoo.com> wrote in message news:<00****************************@phx.gbl>...
Don't take my word for it. But I think a dataset cannot
be local to a client machine. I don't know much about
this, but it doesn't sound logical that your web browser
is showing something that is being picked up from your
own harddisk. No way.

The data set is created at the server and the asp.net
application running AT THE SERVER picks up some records
from the dataset and shows it in your screen in HTML
format. So as far as the client is concerned, it just
displays whatever that comes down in HTML format, so no
processing is done there.

And why did you 'share' the variable that holds the
current value? try not doing that

-----Original Message-----
Hi!
I'm new to ASP.NET WebApplications and wonder whether

I've missed
something out when programming it. I'm grateful for any

hints to this
problem!

Thanks very much for your efforts!

Martin

Description:
I'm running a Webapplication connection to SQL Server 7

using a
DataSet.
The DataSet is stored on the client. The application

works ok
initially e.g. I can browse through the records back and

forwards with
Previous and Next.
The variable that holds the currentRow value is declared

as 'Shared'
(in case this is important to know).

Trouble starts when I run the same application on a

different client
machine on the network at the same time. When I browse

through records
on Client B and then go back to Client A and e.g. click

Next, it jumps
records. It often goes to the last record in a recordset

consisting of
5 when clicking Next although it was only at the second

record and
should have gone to the third. Any subsequent Next click

behaves
normal until I go back to Client B and change the

current Record. At
this point the problem also occurs on Client B since

I've changed the
current row on Client A.
It's like that both clients interfere with each other,

although the
DataSet is stored locally on each of them??
.


Hi! Thanks for replying. I've the dataset stored in the page. Thought
this would be locally to the client to minimize transfers for
roundtrips. Isn't it?

I've done a bit more investigating why it might conflict and I think
storing the dataset on the server and using session state might help.
However, using session state is another science for itself. I just
can't get to see my assembly in the assembly list at START-CP-ADMIN
TOOLS-FRAMEWORK CONFIG as described in MSDN documentation. Tried to
add it but then it says that my assembly needs a strong name etc. Done
that all! Still can't add it.

I hate .NET. My cat does too.
Nov 18 '05 #3

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

Similar topics

1
by: Rob via .NET 247 | last post by:
Ok, I'm new to .NET so I'm afraid I'm doing something stupidhere, but I'm trying to populate a DataSet manually from aDataReader, and its turning out to be ridiculously difficult. Yes, I could use...
2
by: Jason Huang | last post by:
Hi, In the ASP.Net, what's the difference between DataSet and DataView? I what situation will I choose to use the DataSet or DataView? Thanks for help. Jason
4
by: Gopal Prabhakaran | last post by:
Dear All, In one solution , I have 2 webapplication, now i want transfer one control form webapplication 1 to webapplication 2. Pls help ASAP Millions of Thanx in advance.
22
by: EMW | last post by:
Hi, I managed to create a SQL server database and a table in it. The table is empty and that brings me to my next chalenge: How can I get the info in the table in the dataset to go in an empty...
1
by: jherl | last post by:
Hi, Please forgive me for the simplicity of the question, and the redundancy. I have searched the forum and believe my answer is out there amongst the multiple dataset question/responses, but I am...
4
by: Robert Bravery | last post by:
Hi all, I have now correctly set up my dataset and two grids, so that the parent navigates the child. THe thing is that the child table is actually a lookup type table. It lists billing types for...
4
by: Newbie | last post by:
Could someone answer a vb.net database question? what is a good way to code a form so that a user could navigate through a dataset ie: MoveFirst, MoveNext, MovePrevious, MoveLast, Update and...
0
by: Amit31 | last post by:
I create the application in VB.Net 2005. In this whole application i used the Binding for Textbox Controls for data storing and fetching from database (SQL Server 2005). I set the buttons on Form to...
0
by: PeterSummer | last post by:
Could someone answer a vb.net database question? what is a good way to code a form so that a user could navigate through a dataset ie: MoveFirst, MoveNext, MovePrevious, MoveLast, Update and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.