Execute Stored procedure

  • Thread starter Thread starter Belee
  • Start date Start date
B

Belee

I have an update stored procedure that returns an output
parameter. How do I execute it directly in the database
without a data adapter and dataset using C#? I am using
odbc with ms sql server 2000.
 
Why would you want to use ODBC instead of the SQL Server .NET Data Provider?
SqlCommand.ExecuteNonQuery is the way to do this via ADO.NET.
 
Hello,

Belee said:
I have an update stored procedure that returns an output
parameter. How do I execute it directly in the database
without a data adapter and dataset using C#? I am using
odbc with ms sql server 2000.
Click to expand...

This is a *Windows Forms* ng. Turn to the ng mentioned below.

INFO: Newsgroup for .NET+database (ADO .NET) questions:

news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet

Regards,
Herfried K. Wagner
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Column Name Sql-Error :Executing a stored procedure 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL Server Stored Procedure timeout 3
Call stored procedure with paremeter output in c# 7
Table Adapter parameters 1
How to execute SQL stored procedure from Access 8
call stored procedure from access 1
Calling Stored Procedure and have it return records for a report 4

Back
Top