private void RunSqlCommands(Stack<SqlCommand> sqlCommandStack)
{
while (sqlCommandStack.Count != 0)
{
SqlCommand cmd = sqlCommandStack.Pop();
using (SqlConnection cn = new SqlConnection(this.m_ConnectionString))
{
cn.Open();
cmd.Connection = cn;
cmd.ExecuteNonQuery();
Console.WriteLine(cmd.CommandText);
}
}
}
private void RunSqlCommands(Stack<SqlCommand> sqlCommandStack, SqlConnection cn, SqlTransaction trans)
{
while (sqlCommandStack.Count != 0)
{
SqlCommand cmd = sqlCommandStack.Pop();
cmd.Connection = cn;
cmd.Transaction = trans;
cmd.ExecuteNonQuery();
}
}