i am working in C#.net (windows application) and sql server 2005.
In my project i have to create multiple storeprocedures. So that i am keeping the query in a single text file. In between every storeprocedures i put a 'go' statement. But while running, it shows an error...
here is my code,
SqlCommand
sqlEmp.Connection =
sqlEmp.CommandType =
string
{s = sr.ReadToEnd();}
sqlEmp.CommandText = s;
sqlEmp.ExecuteNonQuery();
can u help me ?