mysqldataadapter not accepting ; in query

See more:

ASP.NET

MySQL

Hi
I am writing a query to generate a runtime index column as follows:

SET @rank = 0 ; SELECT @rank:=@rank+1 AS No,firstname from users where unm='abc'

The query is running fine when I copy & paste it to sqlyog editor (I am using mysql)
It shows the correct results.
But when i written same query in .NET code and at the movement below code it showing error. It might be becos of ';'

Dataset ds = new Dataset()<br />
MySqlDataAdapter dAdap = new MySqlDataAdapter(SelectQuery, connection);<br />
dAdap.Fill(ds);

Is there any other solution for that.

Is there any other solution if I want to generate runtime index column and return that column into dataset.

Thanks
sjs