MySQL Forums

Hi all,

How to execute this statement in MySQL using c#

Declare @ID int;
Declare @ERR int;
INSERT INTO table VALUES(@UserId, @Date);
SELECT @ID=@@IDENTITY;
SELECT @ERR=@@ERROR;

Im sending all theses statment in one line in C#
Issues are:

1. Decalare wont work here unless its a procedure and I can use SET but no idea how to able multiple statments execution in MySQL conn. string as im using MySQL connection
2. Error returned value

Thanks