C # Call the Sybase Stored Procedure

 

1: Reference ODBC namespace

Using system. Data;
Using system. Data. ODBC;

2. Establish a connection

Connstr = "driver = {sybase system 11}; srvr = database name; uid = username; Pwd = password ";

Odbcconnection conn = new odbcconnection (connstr );

3: Call 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: I have been searching for it online for a while. Now I want to sum it up.

Haha :--)

Hope it will be useful in the future!