how execute multi SQL command (C# - ADO.NET)

[zeroonea]

i use [code] string strQuery = "USE HMDTest" + " \nGO" + " \nsp_addrole 'HMEmpManager'" + " \nGO" + " \nsp_addrole 'HMEmpViewer'"; SqlCommand sqlCom = new SqlCommand(strQuery, sqlCon); sqlCom.ExecuteNonQuery(); [/code] but it throw a exception with message: "incorrect syntax near 'GO'...", i need help, thanks.

[Vikram A Punathambekar]

The three queries are separate, so you must execute them with three statements.

Cheers, Vikram.

---

"But nowadays, it means nothing. Features are never frozen, development keeps happening, bugs never get fixed, and documentation is something you might find on wikipedia." - Marc Clifton on betas.

Join the CP group at NationStates. Password: byalmightybob

[Jaiprakash M Bankolli]

I would suggest that write a SP and call that from Application .... here it will take two parameter and

Regards, Jaiprakash M Bankolli jaiprakash.bankolli@gmail.com Blog: http://jaiprakash.blog.com/ Suggestions: http://jaitoimprove.blog.com/