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 ...