run sql scripts from vb.net

• Pieter-423357

  SSCommitted

  Points: 1619

  More actions

  September 22, 2008 at 7:25 pm

  #92490

  Hi,

  At present I have a vb.net app that creates an commandline argument for SQLCMD.exe and than calls it. The sqlcmd executes a sql script with a series of sql statements. Unfortunately, the app hangs at times without exiting or providing any kind of error.

  How can I execute SQL scripts directly from vb.net?

  Thanks,

  Piet

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 23, 2008 at 7:32 am

  #875633

  You use ADO.NET connection, command, datareader, and dataset objects. Import System.Data.SQLClient. You can have your scripts in a file and just read the file to load the appropriate script.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question