Hi,
I have a gridview which is using a SqlDataSource to update a table.
The SqlDatasource is using a stored procedure to update the table.
If I edit a row, change a value and click update the change is successfully
applied to the SQL table.
After this, the values in the underlying table are changed by another
process
If I click the refresh button, when the page is redisplayed (after clicking
retry on the warning), the underlying table is updated with the old values
that were in the grid.
This is obviously very dangerous.
How can I stop this from happening?
Surely when the page is refreshed, it shouldn't reapply the updates.
Regards
Mike
5  1898 
Bit of a long shot this, but you wouldn't happen to be the Mike Grace of
Mileoak would you?
Andy L of Shoreham
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:OV**************@TK2MSFTNGP04.phx.gbl... Hi,
I have a gridview which is using a SqlDataSource to update a table.
The SqlDatasource is using a stored procedure to update the table.
If I edit a row, change a value and click update the change is
successfully applied to the SQL table.
After this, the values in the underlying table are changed by another
process
If I click the refresh button, when the page is redisplayed (after
clicking retry on the warning), the underlying table is updated with the
old values that were in the grid.
This is obviously very dangerous.
How can I stop this from happening?
Surely when the page is refreshed, it shouldn't reapply the updates.
Regards
Mike
Yup. :-)
Mike
"Code Rodent" <Co********@noemail.noemail.com> wrote in message
news:%2******************@TK2MSFTNGP02.phx.gbl... Bit of a long shot this, but you wouldn't happen to be the Mike Grace of
Mileoak would you?
Andy L of Shoreham
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:OV**************@TK2MSFTNGP04.phx.gbl... Hi,
I have a gridview which is using a SqlDataSource to update a table.
The SqlDatasource is using a stored procedure to update the table.
If I edit a row, change a value and click update the change is
successfully applied to the SQL table.
After this, the values in the underlying table are changed by another
process
If I click the refresh button, when the page is redisplayed (after
clicking retry on the warning), the underlying table is updated with the
old values that were in the grid.
This is obviously very dangerous.
How can I stop this from happening?
Surely when the page is refreshed, it shouldn't reapply the updates.
Regards
Mike
How do I send you an email?
Got an address.
Mike
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:um**************@TK2MSFTNGP03.phx.gbl... Yup. :-)
Mike
"Code Rodent" <Co********@noemail.noemail.com> wrote in message
news:%2******************@TK2MSFTNGP02.phx.gbl... Bit of a long shot this, but you wouldn't happen to be the Mike Grace of
Mileoak would you?
Andy L of Shoreham
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:OV**************@TK2MSFTNGP04.phx.gbl... Hi,
I have a gridview which is using a SqlDataSource to update a table.
The SqlDatasource is using a stored procedure to update the table.
If I edit a row, change a value and click update the change is
successfully applied to the SQL table.
After this, the values in the underlying table are changed by another
process
If I click the refresh button, when the page is redisplayed (after
clicking retry on the warning), the underlying table is updated with the
old values that were in the grid.
This is obviously very dangerous.
How can I stop this from happening?
Surely when the page is refreshed, it shouldn't reapply the updates.
Regards
Mike
Hi Mike,
or should I say Mick the fish. Withouht pasting my email addy directly into
this NG use the following without the spaces and replace the AT for an @ on
a n d y . l a m p e r AT d o t c o n n e c t e d . com.
I'll be good to hear from you old bean.
Cheers
Andy
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:uP**************@TK2MSFTNGP04.phx.gbl... How do I send you an email?
Got an address.
Mike
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:um**************@TK2MSFTNGP03.phx.gbl... Yup. :-)
Mike
"Code Rodent" <Co********@noemail.noemail.com> wrote in message
news:%2******************@TK2MSFTNGP02.phx.gbl... Bit of a long shot this, but you wouldn't happen to be the Mike Grace of
Mileoak would you?
Andy L of Shoreham
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:OV**************@TK2MSFTNGP04.phx.gbl...
Hi,
I have a gridview which is using a SqlDataSource to update a table.
The SqlDatasource is using a stored procedure to update the table.
If I edit a row, change a value and click update the change is
successfully applied to the SQL table.
After this, the values in the underlying table are changed by another
process
If I click the refresh button, when the page is redisplayed (after
clicking retry on the warning), the underlying table is updated with
the old values that were in the grid.
This is obviously very dangerous.
How can I stop this from happening?
Surely when the page is refreshed, it shouldn't reapply the updates.
Regards
Mike
O.K.
Mike
"Code Rodent" <Co********@noemail.noemail.com> wrote in message
news:u0**************@TK2MSFTNGP02.phx.gbl... Hi Mike,
or should I say Mick the fish. Withouht pasting my email addy directly
into this NG use the following without the spaces and replace the AT for
an @ on a n d y . l a m p e r AT d o t c o n n e c t e d . com.
I'll be good to hear from you old bean.
Cheers
Andy
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:uP**************@TK2MSFTNGP04.phx.gbl... How do I send you an email?
Got an address.
Mike
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:um**************@TK2MSFTNGP03.phx.gbl... Yup. :-)
Mike
"Code Rodent" <Co********@noemail.noemail.com> wrote in message
news:%2******************@TK2MSFTNGP02.phx.gbl...
Bit of a long shot this, but you wouldn't happen to be the Mike Grace
of Mileoak would you?
Andy L of Shoreham
"Mike Grace" <no**************@xxx.xxx> wrote in message
news:OV**************@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I have a gridview which is using a SqlDataSource to update a table.
>
> The SqlDatasource is using a stored procedure to update the table.
>
> If I edit a row, change a value and click update the change is
> successfully applied to the SQL table.
>
> After this, the values in the underlying table are changed by another
> process
>
> If I click the refresh button, when the page is redisplayed (after
> clicking retry on the warning), the underlying table is updated with
> the old values that were in the grid.
>
> This is obviously very dangerous.
>
> How can I stop this from happening?
>
> Surely when the page is refreshed, it shouldn't reapply the updates.
>
> Regards
>
>
> Mike
>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Inigo Jimenez |
last post by:
I have an ASP .net web application installed in a Windows 2003 server.
This web application has a webform that has a Datagrid.
This Datagrid is filled with the data of a SQL table.
I have a...
|
by: Greg Ramsey |
last post by:
Hi - I'm a real newbie to ASP . . so please forgive me. . . and please point
me in the right direction for how to do this "the right way" . . :)
Using Northwind DB as an example, I have a...
|
by: Mike Grace |
last post by:
Hi,
I have a gridview which is using a SqlDataSource to update a table.
The SqlDatasource is using a stored procedure to update the table.
If I edit a row, change a value and click update...
|
by: Mike Grace |
last post by:
Hi,
I have a gridview which is using a SqlDataSource to update a table.
The SqlDatasource is using a stored procedure to update the table.
If I edit a row, change a value and click update...
|
by: Curious Trigger |
last post by:
Hi NG,
in my asp.net page a DetailView-Control is bound to a DataSource-Control
with select, insert, update and delete-commands configured.
As long as I type valid data into the DetailView all...
|
by: shapper |
last post by:
Hello,
In my GridView I have a HyperLink Field where I set the
DataNavigateUrlFormaString
MyHyperLinkField.DataNavigateUrlFormatString =
"~\RSS.ashx?Channel={0}&Culture=" &...
|
by: Norbert Ruessmann |
last post by:
Hello group,
I have a business object, which contains Orders. Each Order has a list of
OrderItems. Orders are collected in a list List<Order>, OrderItems for each
order are of type...
|
by: news.ipartners.pl |
last post by:
Hello,
I've run across problem with paging in gridview.
I have 2 elementson my web page - drop down list filled with manufacturers
and grid view for displaying data connected with certain...
|
by: Ed Dror |
last post by:
Hi there,
I'm using ASP.NET 2.0 and SQL Server 2005 with VS 2005 Pro.
I have a Price page (my website require login) with GridView with the
following columns
PriceID, Amount, Approved,...
|
by: cmrhema |
last post by:
Hi,
I have a gridview problem while binding more than two gridviews.
I am giving a sample scenario of what I have done so far
I have two tables
First table: Department , having columns...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |
