reload 1 row from database

Hot Topic

Error while accessing MS ACCESS database via ASP
How to sign an assembly that is already compiled?
Emails sent incorrectly formatted with =0D=0A instead of line breaks
multithreading with in web service
Asynchronous socket reading using BeginRead
Appending prefixes to Elements in XML file
Declaring array of objects WithEvents
I am the newest newbe to VB2005, please can someone help me with this simple DB update form.
Application Cached HTTP Connections
Wants to download file greater than 2GB

.NET Development

Can we sent multiple mail to one or more persons....?????????
ignoring certain attributes in XML file?
TcpClient.BeginAcceptTcpClient / Socket.BeginAccept / all other variations...
Need of a fast timer
calling CL programs in AS400 from a Winapp
How to display text on imagebutton that contains image
I found the reason
System.ServiceProcess.ServiceBase - Calls to via Start, Stop, ExecuteCommand are asynchronous in .NET 2.0
Windows App from .Net 1.1 to 2.0
Moving child nodes in a schema

reload 1 row from database

Hi

Is it possible to reload 1 row from a sql table into a datatable

I have a DataTable filled using a table adapter. I added some queries to the datatable.
One of those queries contains a reference to a (complicated) stored procedure. This stored procedure updates a specific row.
I know the ID of the updated row and i would like to reload this row into the dataset.

I can of course clear and re-fill the datatable. But i was wondering if there wasn't a shortcut which is less stress for my sql server.

I am using Windows Forms btw.

kind regards



Answer this question

reload 1 row from database

  • STorne

    I'm not sure but I can think of just selecting that 1 record of data and use SqlDataReader to read the columns and store it back into the dataset, perhaps removing the row you are wanting to re-read from the dataset itself before adding/constructing this datarow from SqlDataReader.

  • reload 1 row from database
Answer this question