Database

David Mujica wrote:

a CYA (cover your ass) log table

David Mujica wrote:

Also, take frequent backups

I are Troll

modified on Thursday, September 30, 2010 1:03 PM

Karthik. A wrote:

Simply, you could find a list of all local servers installed by doing this:

* Click on the "Server name:" drop down
* Select ""
* Select "Local Servers" tab
* Expand "Database Engine"
* Here the instances are listed, choose 1 of them

patzerFish wrote:

Dataset->DataAdapter->TableAdapter->TableAdapterManager relationship

private static void executeNonQuery(String query) {
    SqlCommand command = new SqlCommand(query, Connection);
    try {
        openConnection();
        command.ExecuteNonQuery();
    } catch {
        throw;
    } finally {
        closeConnection();
    }
}

private static SqlDataReader executeQuery(String query) {
    SqlCommand command = new SqlCommand(query, Connection);
    SqlDataReader reader;
    try {
        openConnection();
        reader = command.ExecuteReader();
        return reader;
    } catch {
        throw;
    } finally {
        //connection left open because the reader is worked on elsewhere.
    }
}