C # calls Sybase stored procedures

Stored Procedures

C # calls Sybase stored procedures

1: Referencing the ODBC namespace

Using System.Data;
Using System.Data.Odbc;

2: Establish the connection

Connstr= "Driver={sybase SYSTEM 11}; srvr= database name; uid= user name; pwd= password ";

OdbcConnection conn=new OdbcConnection (CONNSTR);

3: Calling the stored procedure

Conn.Open ();
OdbcCommand cmd=new OdbcCommand ();
Cmd. Connection=conn;
Cmd.commandtype=commandtype.storedprocedure;
cmd.commandtext= "database name. dbo. Stored procedure name?,?,?";

OdbcParameter Para1=cmd. Parameters.Add ("@para1", Odbctype.varchar);
Para1.direction=parameterdirection.input;
para1.value=value1;

OdbcParameter Para2=cmd. Parameters.Add ("@para2", Odbctype.varchar);
Para2.direction=parameterdirection.input;
Para2.value=value2;

OdbcParameter Para3=cmd. Parameters.Add ("@para3", Odbctype.varchar);
Para3.direction=parameterdirection.input;
Para3.value=value3;

Cmd. Nonquery ();
Cmd. Dispose ();
Conn.close ();

Conn.dispose ();

4: On the internet for a while, now to boil down to him.

Hehe:----)

Hope to be useful later!