How to exec a C#. Net Windows app calling a Sybase Stored Proc ? 1

[barden9]

Do you know how to execute a Sybase Stored Procedure in a C# .Net Windows forms application from an ODBC connection ?

I am developing a C# .Net Windows forms application using Visual Studio 2005.
I need to call Sybase Stored Procedures from my application.
I use a Sybase ODBC connection as follows:

User Data Sources
------------------------
Name NYP Driver DataDirect 4.0 Sybase WIre Protocol

I have created the following code so far:

OdbcConnection _conn2 = new System.Data.Odbc.OdbcConnection("DSN=NYP;UID=PW;PWD=Tl;");
_conn2.Open();

 

[jmeckley]

I would assume it looks something like this

var cmd = _conn2.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "exec [name of proc]";
var parameter = cmd.CreateParameter();
parameter.Name = "name";
parameter.Value = value;
cmd.Parameters.Add(parameter);
cmd.Execute[Reader/NonQuery/Scalar]();

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190