/// <summary> /// Inherited method. Executes an SQL Query. /// </summary> /// <param name="query">The query to be executed.</param> /// <returns>The result on a DataTable format.</returns> public SqlResult executeQuery(Query query) { //Open a connection: SqlConnection con = new SqlConnection("user id="+DbHelper.UserName+";" + "password="******";server="+DbHelper.ServerURL+";" + "Trusted_Connection=yes;" + "database="+DbHelper.DatabaseName+"; " + "connection timeout=30"); con.Open(); //Convert the query: SqlCommand cmd = query.getSqlCommand(); cmd.Connection = con; //Execute the query: SqlDataReader reader = cmd.ExecuteReader(); //Build the result: SqlResult result = new SqlResult(reader); //Close the connection: con.Close(); //Return the result: return result; }