Execute multi lined SQL 1

[spangeman]

Hi there.

Using ADO Dot Net could you show me how to execute multi-lined sql. For example I may have some SQL in a string like this that I want to execute

string SqlToExecute =
"UPDATE MYTABLE
SET COL1 = 'FRED'
WHERE COL2 = '1'
GO"
SqlToExecute = SqlToExecute + Environment.NewLine + "UPDATE MYTABLE
SET COL1 = 'DAVE'
WHERE COL2 = '2'
GO"


Regards
Spangeman

 

[chiph]

Just pass it to your ExecuteNonQuery method for the provider you're using. If MS-SqlServer:

SqlCommand myCommand = new SqlCommand(SqlToExecute, myConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();

Code for other providers will be similar.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[spangeman]

Thanks