.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to manage commit of some data and rollback of other data simultaneosly?

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi, I am quite a beginner in SQL server. Few days back I came across a question, I am wondering what can be the answer for that. Pls help me out if anyone knows the answer. The question goes as below :   There is a stored procedure (say proc1) which has transaction block implemented. Now I call another stored procedure(say proc2) within the proc1. Proc2 contains a simple insert into table statement. Now some error occurs : 1) Tell me whether the inserted data (from proc2) will be rollbacked or not? 2)How can u manage not to rollback the inserted rows  (from proc2) however other data must be rollbacked (proc1).   Thanks in advance.

View Complete Post

More Related Resource Links

Sync Up: Manage Your Data Effectively With The Microsoft Sync Framework


Synchronization Services for ADO.NET provide a set of tools to help you synchronize data between two database sources, synchronize files between machines, and synchronize with an RSS or ATOM feed. Learn more here.

James Yip

MSDN Magazine April 2009

Report Builder Report manage data sources - relink programmatically

As part of a site definition solution several report builder report rdl files are uploaded to a report folder.  After a site is created with the defintion, the reports must be manually re-linked to the data source through the UI context menu ("Manage Data Sources").  I have been trying to figure out how to do the re-linking programmatically without luck.  Any ideas? ( Reporting Services is configured as integrated with sharepoint)


hi I Have deleted my sql table data (delete from employee) but this was a fault.i was suppose to delete data from other table what should i do to get my data back i have used (ROLLBACK select * from employee) to get my data back but it didnt help me.my DataBase recovery mode is also set to FUll ,still i am not able to get back my data Plaese Help me what query should i run?

a way to submit data from ssrs to database and commit?

Hi, I want to know a way to submit data from ssrs to database and commit? if yes, how? Thank you Francis sZEfsze88

How can I manage session data outside the ASP.Net session object?


I want to be able to persist data across a session but do this outside of the built-in session state object.  Why is a long story that I will not go into here.  I just need to know where I can put data other than in the session object that will persist across the specific session (in memory - I already have a database solotion).


manage a dropdownlist though data source



all of you, actuly i am a new user of asp.net and i am a learner so i just want to connect two dropdownlist to data souce  and i want that the list item of second dropdown is changed according to change of selected item of first dropdown.

i have connect it to data source successfully it getting chaged items but it happance only when its load then if i select the next item of first one it would not work properly,

so please solve my problem i think you definatly give the answer.

thank you !

Manage Data Connections in code



I'm new to Windows Phone 7 development.

How do I handle 'roaming' events in code?


I want my users to be able to choose if they want to work online or offline when roaming.

In addition to this, I want to be able to tell them the traffic sent and received.

How do I do this?


Best way to manage SQL Server Package Configuration data

I inherited approximately 150 SSIS packages doing various ETL operations. They use a custom table that requires that we add a new column when a package requires a new type of config data storage.
As part of an upgrade from 2005 to 2008 and a partial rewrite effort I am exploring, among other changes, switching from storing config data in the flat/wide table I mentioned to using SQL Server Package Configurations to manage configuration data. What do you think of the following?
  1. Having two Package Configurations per SSIS package. Both will be pointed to the same database containing only the config table, but with different filters. One filter will be specific to the package that will contain package-specific configuration data and one will be called "global" which will contain configuration data that all packages share (things like "default alert email" should Armageddon ensue during package execution).
  2. How best to manage configuration data when moving a brand new package from DEV to STAGING to PRODUCTION?
  3. How best to manage properties for the connection object used to initially connect to the Package Configuration database/table?


Make everything as simple as possible, but not simpler.
-Albert Einstein

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!

Dynamic Data Templates in GridView ASP.NET 3.5

At a high level, Dynamic Data Templates can be seen as a system to very quickly build up a User Interface linked with the relevant data model, immediately enabling you to perform CRUD operations (Create, Read, Update, Delete) on the database using the specified data source. They provide a powerful method for building up these kinds of applications, and I'm going to focus on an overview of what Dynamic Data Templates actually are, and a few ways of customizing them to suit industry needs.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Displaying Data using ASP.NET 2.0 Repeater and C#

This tutorial will show you how to display data using the .NET Repeater Control, ASP.NET 2.0 and C#.NET

The Repeater control is a powerful tool and is easy to use.

First, you will need to import the System.Data.SqlClient namespace.

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

ASP.NET 4.0 Dynamic Data and Many to Many Entity Framework Entities

I did not play much with Dynamic Data controls in VS2008 and just made a cool discovery in VS2010 Beta 2. This may not even be new, but as I'm sitting 30,000+ feet over the Atlantic ocean, I don't have access to VS2008 at the moment to check.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend