public DB_Access() { try { conn = DB_Connect.GetConnection(); conn.Open(); } catch (System.TypeInitializationException) { } }
public DataTable getTable(string sp) { conn = DB_Connect.GetConnection(); conn.Open(); SqlDataAdapter _sqlda = new SqlDataAdapter(sp, conn); DataTable dt = new DataTable(); _sqlda.Fill(dt); conn.Close(); return(dt); }