DataConnection

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.SqlClient;

using System.Data;

///

/// Summary description for DataConnection

///

public class DataConnection

{

public string ConString = "Data Source=devsvr1;Initial Catalog=EMPDB;User ID=Sa;Password=Password00";

public SqlConnection AppConnection = new SqlConnection();

public SqlDataAdapter AppDataAdapter = new SqlDataAdapter();

public SqlCommand AppCommand = new SqlCommand();

public DataSet AppDataSet = new DataSet();

public SqlTransaction AppTran;

public DataConnection(string Constr)

{

ConString = Constr;

}

public void OpenConnection()

{

try

{

AppConnection.ConnectionString = ConString;

AppConnection.Open();

AppCommand.Connection = AppConnection;

}

catch (SqlException Ex)

{

throw;

}

}

public void BegingTran()

{

AppTran = AppConnection.BeginTransaction(IsolationLevel.ReadCommitted);

AppCommand.Transaction = AppTran;

}

public void RollBackTran()

{ AppTran.Rollback(); }

public void CommitTran()

{

AppTran.Commit();

}

public void closeConnction()

{

AppConnection.Close();

}

}