Executing Sql Script Through C# Code

[deepaknawathe]

Hello all,
Does anybody know how to execute a sql script through .Net code?

e.g. The script for oracle is ...

create user testuser identified by testuser;
grant dba to testuser;
use testuse;
create table Table1(.....);


for running this script i m using OleDbCommand Object..

The code is:-
OleDbConnection conn = new OleDbConnection(constr);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "The Sql Script";

cmd.ExecuteNonQuery(); ----> Error-(Invalid Character)

so is there any option to execute the whole script or do i need to loop through the number of statements and execute each statement?

Thanks in Advance
Deepak

[radcaesar]

Hi,
Make that script in to an Stored Procedure and use

cmd.commandtype=StoredProcedure

The use the ExecuteNonquery() method as usual.

[deepaknawathe]

But can we create a user in stored procedure?
i m trying to do it but its giving me Error....

the Error is actually for Create Statement... its not accepting the Create statement...