How do I call the stored procedure

I am using executescalar to update a table. When testing the sql statement,
I am sending a value that does not exist in the condition. However, the
command is successful. Is there any way to know that in reality no records
were affected by the update?

What is the difference between View and
StoredProcedrue when both all fetch data form database.

I have a stored procedure that returns a recordset as well as an output parameter.  When I use ExecuteReader and then
try to get the value of the output parameter I get an error saying "Object reference not set to an instance of an
object.".  Is it not possible to get a ...

Hi Newsgroup
I am making a selection with a ODBC-Dataadapter into a Dataset. Then I
create Parameters for Updating the Data with Dataadapter.
When I create the Parameters then I cannot update because I have set the

I have a long running transaction that gets started by calling a stored
procedure using the OpenXML functionality.
While this transaction is running all other reads from the tables used in
the transaction are blocked and results in a timeout.

I need to be able to create an untyped dataset from some sql using an
OracleDataAdapter. Unfortunately, I am getting problems where the result set
contains a large number of decimal places. I get the exception:
"An unhandled exception of type 'System.Data.OracleClient ...

I am using a ODBC-Driver in .NET. For reading and writing data I use normal
SQLCommands.
Reading an writing integer and string fields is no problem. But when I try
to read or write Date / Time fields I always get exeptions:

Hi,
I recently completed a tutorial that allowed me to use Indexing services to
search for a word document then display an abstract of the document and its
title.

I have a method in WebServcie, which retrun a DataTable:
[WebMethod]
public DataTable GetSchoolList()
{

I have to convert a untyped DataSet object to an  strongly typed DataSet
object.
The method DataSet.Merge seen to be a good opportunity to convert the
DataSet. But I am not successfull with this method. Even when I rename the

I have done many projects in VB 6.0 mostly database related. But when i
transfer in .NET platform, i wonder about disconnected dataset. I know there
is many many advantages of Disconnected dataset. But what can i do when i
make a project which shows stock exchange share prices or ...

i have been struggling with porting a large VB6 project over 55 forms, 5
data environment objects, each with 50-100 commands (over 30 total), plus all
the hand-coded connections, commands and recordsets where applicable.
And with the Crystal Reports XI RDC, now a total bitch to ...

can we add parameter in the view of SQLServer? like
Select * from Employee where gender=@myGender

Is the connection pool associated with database server  or an
application  or a machine?
parez