How To Execute A Sql Script File From ADO.NET Using VB.NET

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: SqlJunkies User (User_at_-NOSPAM-SqlJunkies.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 08:48:20 -0700

I have a sql script file containing a number of batch commands to create a new database with 50 tables. Is there anyway i can use ado.net to open this file and execute the sql command in side in a batch format. Basically I would like to execute the myscriptfile.sql from vb.net using ado.net 

---
Posted using Wimdows.net NntpNews Component - 
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

Relevant Pages

  • Unexpected error writing metadata to file
    ... Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. ...
    (microsoft.public.dotnet.academic)
  • transact sql question - returning x rows
    ... Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. ...
    (microsoft.public.sqlserver.programming)
  • leave it to a Indian
    ... Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. ...
    (microsoft.public.dotnet.framework.webservices)
  • RE: UAB on compact Framework?
    ... Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: SQL 2000 install fails - Drivers SQLAllocHandle on SQL_HANDLE_ENV
    ... Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. ...
    (microsoft.public.sqlserver.odbc)