All database Function Class

Just copy and past all function in C# class. and save as clsConnection.cs in App_Code folder.


public String gSqlConnectionString = ConfigurationManager.AppSettings["gConnectionString"];
public SqlConnection gSqlConnection;
public SqlCommand gSqlCommand;
public DataSet gDataSet;
public SqlDataReader gSqlDataReader;
public SqlDataAdapter gSqlDataAdapter;
public DataTable gDataTable;
public Boolean bIsExists;
public String sID;


public void chkConnection()
{
if (gSqlConnection != null)
{
gSqlConnection.Close();
}

if (gSqlDataReader != null)
{
gSqlDataReader.Close();
}

}

public void dbUpdate(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gSqlCommand = new SqlCommand(v_sSql, gSqlConnection);
gSqlConnection.Open();
gSqlCommand.ExecuteNonQuery();
gSqlConnection.Close();
}

public DataSet dbGetDateSet(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gDataSet = new DataSet();
gSqlDataAdapter = new SqlDataAdapter(v_sSql, gSqlConnection);
gSqlDataAdapter.Fill(gDataSet);
return gDataSet;
}

public DataTable dbGetDataTable(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gDataTable = new DataTable();
gSqlDataAdapter = new SqlDataAdapter(v_sSql, gSqlConnection);
gSqlDataAdapter.Fill(gDataTable);
return gDataTable;
}

public Boolean dbCheckData(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gSqlCommand = new SqlCommand(v_sSql, gSqlConnection);
gSqlConnection.Open();
gSqlDataReader = gSqlCommand.ExecuteReader();
if (gSqlDataReader.Read())
{
bIsExists = true;
}
else {
bIsExists = false;
}
gSqlDataReader.Close();
gSqlConnection.Close();
return bIsExists;
}

public string dbGetID(string v_sSql)
{
chkConnection();
gSqlConnection = new SqlConnection(gSqlConnectionString);
gSqlCommand = new SqlCommand(v_sSql, gSqlConnection);
gSqlConnection.Open();
gSqlDataReader = gSqlCommand.ExecuteReader();
sID = string.Empty;
if (gSqlDataReader.Read())
{
sID = gSqlDataReader.GetValue(0).ToString();
}
gSqlDataReader.Close();
gSqlConnection.Close();
return sID;
}