c4 Code - About Technologies

This is the simple user define SQL Database Class. It is useful to avoid redundancy of the code. Database Class In C# using System; using System.Data; using System.Data.SqlClient; using System.Configuration; public class _Database { public SqlConnection con; public SqlCommand com = null; public SqlDataReader dr = null; public SqlDataAdapter da = null; public DataSet ds = null; public String glQuery = ""; public String glnonQuery = ""; public const int EXECUTE_NONE_QUERY = 1; public const int EXECUTE_QUERY = 2; public const int DATA_ADAPTER = 3; // connection for data list paging public SqlConnection globalcon = new SqlConnection("server=**;uid=**;pwd=***;Database=**"); public _Database() { } public void Query(String SqlQuery) { this.glQuery = this.Get_DataBasePrefix(SqlQuery); } private String Get_DataBasePrefix(String str) { return str.Replace("#__", "GD_").ToString(); } public void ConnectDB() { try { con = new SqlConnection(); con.Co