How to do multiple inserts into sybase from c# at once

Question

I am new to sybase db. I am trying inset multiple rows using following code

string sql="INSERT INTO dbo.table1 (c1,c2,c3)
     VALUES ('C1','c2','c2'); INSERT INTO dbo.table1 (c1,c2,c3)
     VALUES ('C1','c2','c2'); ";


                Sybase.Data.AseClient.AseCommand cmd = new Sybase.Data.AseClient.AseCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = sql;
                cmd.CommandTimeout = 30 * 60;`enter code here`
                cmd.Connection = conn;
                cmd.ExecuteNonQuery();

and i am getting the error "Incorrect syntax near ';'." at the end of the first statement? Any ideas?

I don't see any insert statements above. Did you post your full code snippet? — Chris Laplante, Jun 27 '12 at 18:45

score 0 · Accepted Answer · answered Jun 27 '12 at 19:42

0

I figured out there is no need for ; or GO. Thanks a lot for the input

answered Jun 27 '12 at 19:42

Grasshopper

1,778
6
27
48

How to do multiple inserts into sybase from c# at once

1 Answers1