How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

247Customer,

1. What is the difference between Cache and Session? 2. I cache limited to page like viewstate or it's accessible through out the application like session? 3. Which one is better when I've some data that is to be used across the application? Why is to better than the other?

247Customer,

What is the difference between response.redirect and server.transfer, how to choose one among the other?

247Customer,

What is the use of trigger in ajax?

What is HTTPContext and HTTPModule. What is the use of them?

How to consume a webservice in a windows application without adding through the web reference?

247Customer,

What is SQL Profiler and the use of it?

247Customer,

What are SQL Jobs, please mention the use of it and how to create them.

247Customer,

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

Accenture,

We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?

Accenture, FastStream,