Is it possible to issue multiple sql server update statements in SSIS OLE DB Command?
I Tried the following with no luck
update table1 set column1 = 1
update table2 set column1 = 1
View Complete Post
I want to add multiple rows of a gridview if the data for multiple fields are same.
Idea for this is that a user may search a record with some parameter e.g. Sector, plot.
For example 15 records being displayed in gridview.
There should be checkbox before every row and if user wants to update Plot and Flat No that is same for 10 rows out of 15 so he will check the rows and update.
For this a dialog box should appear asking for the parameter i.e. Plot and Flat or something else next time may be it will be City or country. Moreover, there is already an Edit button to update records, when user click it another page open for the record to be updated and whatever he wants to update, it updates.
Hope everone understand the scenario.
I don't want to disturb the already provided Edit functionality and want to provide same record to be updated.
Any idea in this regard would be appreciated.
my aspx page works in VWD, and everything works on the server EXCEPT update and delete sql functions. any ideas?
ClickOnce is a new deployment technology that allows users to download and execute Windows-based client applications over the Web, a network share, or from a local disk. Users get the rich interactive and stateful experience of Windows Forms, but still have the ease of deployment and updates available to Web applications. ClickOnce applications can be run offline and support a variety of automatic and manual update scenarios.Learn all about it here.
MSDN Magazine May 2004
Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.
Paul Yao and David Durant
MSDN Magazine June 2001
I want to set up a gridview that will display data like this
WeekEndingDate Project Category Sun Mon Tues Wed Thu Fri Sat8/14/2010 proj1 test 2 1 2 3 2 1 0 8/21/2010 proj1 test 0 2 2 2 2 1 0 8/28/2010 proj1 test 0 1