How to execute the sql scripts (which may be in .sql file or a string) from code behind files?
Thanx
Veeru.SqlCommand.ExecuteNonQuery()
The only problem I can think of is that .SQL scripts generated by Query Analyzer often have the 'GO' keyword in them, which is not a SQL keyword, but rather used for batching in QA.|||True, going to have to parse out GO statement. Some more things needed
SqlCommand comm = New SqlCommand("select * from table", sqlConnection)
comm.CommandType = CommandType.Textsql
No comments:
Post a Comment