Public feed #376896

Something

public text v1 · immutable
Raw Edit
·published 2007-03-01 10:32 UTC
rendered paste body
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

/// <summary>
/// Summary description for Database
/// </summary>
public class Database
{
    Database db = new Database();
	public Database()
	{
		//
		// TODO: Add constructor logic here
		//
        myConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WINDOWS\Temp\392Ass1\App_Data\ass1db.mdb");
    }
    protected OleDbConnection myConnection;

    public OleDbConnection GetConnection()
    {
        myConnection.Open();
        return myConnection;
    }

    public void CloseConnection()
    {
        myConnection.Close();
    }

    public int UpdateDatabase(OleDbCommand cmd)
    {
        myConnection.Open();
        cmd.Connection = myConnection;
        int ct = cmd.ExecuteNonQuery();
        myConnection.Close();
        return ct;
    }
}