Author: billy_111 | Posted on: 5/21/2009 6:00:11 AM | Views : 329

Hey,
I have the following web method which is pulling out details from a forums table. 
#region Display Forums
    [WebMethod(Description = "Method displays forums.")]
    public DataSet Display_Forums()
    {
        DataSet ds = new DataSet();
        string database = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|/forum.mdb;Persist Security Info=True";

        const string connStr = "Provider=Microsoft.Jet.OleDb.4.0; " + "Data Source=|DataDirectory|forum.mdb;";
        OleDbConnection dbConn = new OleDbConnection(connStr);

        string queryStr = "Select forums.forum_id, (forums.forum_name + forums.info) AS Forum, &q ...

Go to the complete details ...