Re: Ado.net DataSet Refresh

Dear Manjree,

Did you receive any error message when you executed SP from ado.net?
For such issue, I would like to suggest you use SQL profile to trace server.

1) Open SQL 2005 Server Management Studio.
2) Connect your Database Server and click "connect" button.
3) Click Tools|SQL Server Profile in the menu.
* Note: SQL server 2005 express edition doesn't have SQL Server Profile. If
you are developing with this edition, please let me know.
4) Connect your Database server and click "connect" button again in the
SQL Server Profile.
5) Create a new trace and select "Run" button with default configuration.
6) Reproduce the issue.
7) After repro the issue, please stop the select trace in SQL Server
Profile.
8) Save the trace file as SQL Server Profile trace file (*.trc)
(File|Saveas|TraceFile)

Please packet the trace file and send it to me (v-wywang@xxxxxxxxxxxxx).
By the way, please let me know the exact database name and stored procedure
name. I will review on it.

Sincerely,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.