private void ExecuteSQL(String dbName, String sql)
{
var connection = new SqlConnection(@"Data Source=Localhost\SQLEXPRESS;Initial Catalog=master;Integrated Security=True");
var sqlCommand = new SqlCommand(sql, connection);
String[] commands = sql.Split(new string[] { "\nGO" }, StringSplitOptions.RemoveEmptyEntries);
sqlCommand.Connection.Open();
sqlCommand.Connection.ChangeDatabase(dbName);
var curr = String.Empty;
try
{
foreach (String cmd in commands)
{
curr = cmd;
sqlCommand.CommandText = cmd;
sqlCommand.ExecuteNonQuery();
}
}
catch (Exception)
{
var form = new LogShow("Error at: " + curr);
form.ShowDialog();
throw;
}
finally
{
sqlCommand.Connection.Close();
}
}
private void ExecuteSQL(String dbName, String sql)
{
var connection = new SqlConnection(@"Data Source=Localhost\SQLEXPRESS;Initial Catalog=master;Integrated Security=True");
var sqlCommand = new SqlCommand(sql, connection);
String[] commands = sql.Split(new string[] { "\nGO" }, StringSplitOptions.RemoveEmptyEntries);
sqlCommand.Connection.Open();
sqlCommand.Connection.ChangeDatabase(dbName);
var curr = String.Empty;
try
{
foreach (String cmd in commands)
{
curr = cmd;
sqlCommand.CommandText = cmd;
sqlCommand.ExecuteNonQuery();
}
}
catch (Exception)
{
var form = new LogShow("Error at: " + curr);
form.ShowDialog();
throw;
}
finally
{
sqlCommand.Connection.Close();
}
}
