I written one application in C# using Sybase iAnywhere
database and its version is 8.0.2.

Question 1: Is there any way to connect database at (Insert,
update, fetch ) query time and if i do so then it takes time
to connect every time. and I don't want to keep open
connection. what is the best solution.

Question 2: I wrote one stored procedure in database and
that procedure expect three parameters and it returns some
record so how do i call this procedure with parameter in C#.

Thanks for reading
Chandresh Patel