/// <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); }