SqlServerDB_dotNET 1.3.4

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

}