SqlServerDB_dotNET 1.1.2

Example: using SqlServerDB;

string server = @"INSTANCE\SQLEXPRESS"; string database = "DEMODB"; string username = "sa"; string password = "";

string connectionString = @"Data Source="+ server + ";Initial Catalog="+ database + "; Trusted_Connection=True;User ID="+ username + ";Password="+ password + ""; DBConnection db_conn = new DBConnection(connectionString);

Console.WriteLine("isConnected: " + db_conn.isConnected()); if (db_conn == null || !db_conn.isConnected()) { Console.WriteLine("Connessione non valida."); return; }

string sql = "SELECT ID, Message FROM Logs ORDER BY IDLic;"; DataTable dtLogs = db_conn.SelectTable(sql);

if (dtLogs == null || dtLogs.Rows.Count == 0) return;

// Loop with the foreach keyword. foreach (DataRow dr in dtLogs.Rows) { Console.WriteLine("Message: " + dr["Message"].ToString().Trim()); }

using (DBConnection db_conn = new DBConnection(connectionString)) { string sNominativo = "Micky"; string sql = "INSERT INTO TabLav (Nominativo) " + "values('" + sNominativo + "');";

if (!db_conn.sql_query(sql))
{
	Console.WriteLine("Error during insert: " + db_conn.sql_error()[0]);
	Console.WriteLine(sql);
}

int insertedID = db_conn.GetLastInsertedRowID();
Console.WriteLine("GetLastInsertedRowID: " + insertedID);
int recordsAffected = db_conn.GetNumRecordsAffected();
Console.WriteLine("GetNumRecordsAffected: " + recordsAffected);

}