Execute List of Query c#
public Result ExecuteQuery(List<string> SQL)
{
Result oResult = new Result();
SqlTransaction oTransaction = null;
SqlCommand oCmd = null;
try
{
if (connection != null)
{
connection.Open();
oTransaction = connection.BeginTransaction();
foreach (string s in SQL)
{
oCmd = new SqlCommand(s, connection);
oCmd.Transaction = oTransaction;
oCmd.ExecuteNonQuery();
oResult.ExecutionState = true;
}
oTransaction.Commit();
}
}
catch (Exception ex)
{
oResult.ExecutionState = false;
oResult.Error = ex.Message;
oTransaction.Rollback();
}
finally
{
connection.Close();
}
return oResult;
}
{
Result oResult = new Result();
SqlTransaction oTransaction = null;
SqlCommand oCmd = null;
try
{
if (connection != null)
{
connection.Open();
oTransaction = connection.BeginTransaction();
foreach (string s in SQL)
{
oCmd = new SqlCommand(s, connection);
oCmd.Transaction = oTransaction;
oCmd.ExecuteNonQuery();
oResult.ExecutionState = true;
}
oTransaction.Commit();
}
}
catch (Exception ex)
{
oResult.ExecutionState = false;
oResult.Error = ex.Message;
oTransaction.Rollback();
}
finally
{
connection.Close();
}
return oResult;
}
Comments
Post a Comment