C#

<br />
private static void ExecuteSql(SqlConnection ___conn, string ___fileName)<br />
{<br />
    //array for storage of SQL<br />
    string[] __sqlStatements;<br />
    //the only clever bit: spilt at each GO statement<br />
    //as the normal SQL connector will spit out anything<br />
    //after the GO.<br />
    Regex __r = new Regex("^GO", RegexOptions.Multiline);<br />
<br />
    //for file reading: just replace with the string of<br />
    //SQL if not from file. Or embed SQL as resource…<br />
    StreamReader __sr = new StreamReader(___fileName);<br />
    string __sql = __sr.ReadToEnd();<br />
    __sqlStatements = __r.Split(__sql);<br />
    SqlCommand __comm = new SqlCommand();<br />
    __comm.Connection = ___conn;<br />
<br />
    //loop through each block in the spilt SQL and<br />
    //execute.<br />
    foreach (string __sqlBlock in __sqlStatements)<br />
    {<br />
        if (__sqlBlock.Trim().Length > 0)<br />
        {<br />
            __comm.CommandText = __sqlBlock;<br />
<br />
            try<br />
            {<br />
                __comm.ExecuteNonQuery();<br />
            }<br />
            catch (SqlException)<br />
            {<br />
                //here, execute your DROP script<br />
                break;<br />
            }<br />
        }<br />
    }<br />
}<br />

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

wasife wrote:

I have a T-SQL Script file which i want to run without opening it and reading its contents. Please tell me how can i do it using ADO.Net or any other way.

public override void MethodFromA()
{
             //Class C stuff
}

public void BaseMethodFromA()
{
    base.MethodFromA();
}

public override void MethodFromA()
{
    BaseMethodFromA();
}

Bonsta wrote:

Im very familiar with java(inheritance, polymorphism, generics and other things relating to classes) but I want to use C#...