/// <summary>
/// Runs and executes the SQL statement.
/// </summary>
/// <param name="connString">The connection string.</param>
/// <param name="sql">The SQL.</param>
/// <param name="errOut">The error out.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="Exception"></exception>
/// <example>
/// SEE UNIT TEST @ UnitTest_MSSQL_MSSQLDatabase <br/>
/// <br/>
/// string connString = MSSQLDatabase.ConnectionString("192.168.1.6", "", "test", "test", "test");<br/>
/// string SQL = "UPDATE test set value=1;";<br/>
/// bool value = MSSQLDatabase.RunExec(connString, SQL, out errOut);<br/>
/// </example>
public static bool RunExec(string connString, string sql, out string errOut)
{
bool bAns = false;
errOut = @"";
try
{
MssqlDatabase obj = new MssqlDatabase();
if (obj.ConnectToDb(connString, out errOut))
{
SqlCommand cmd = new SqlCommand()
{
CommandText = sql,
Connection = obj.Conn
};
cmd.ExecuteNonQuery();
cmd.Dispose();
}
else
{
throw new Exception(errOut);
}
bAns = true;
}
catch (Exception e)
{
errOut = ErrorMessage("RunExec", e);
}
return(bAns);
}
/// <summary>
/// Converts to database.
/// </summary>
/// <param name="connString">The connection string.</param>
/// <param name="errOut">The error out.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
public static bool ConnectToDatabase(string connString, out string errOut)
{
bool bAns = false;
errOut = @"";
try
{
MssqlDatabase obj = new MssqlDatabase();
bAns = obj.ConnectToDb(connString, out errOut);
}
catch (Exception e)
{
errOut = ErrorMessage("ConnectToDatabase", e);
}
return(bAns);
}
