[WebMethod]

public DataSet queryReqs(long reqID)

{

        //Create a connection to the local Access Database.

        string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0; ";

        strCnn += "Data Source=" + Server.MapPath("/WebSite");

        strCnn += "\\portReqDB.01.mdb";

         

      OleDbConnection cnn = new OleDbConnection();

       

        cnn.ConnectionString = strCnn;

 

        //Create an SQL DataAdapter to read the data.

        string strSQL = "SELECT reqID, type, Device, releaseType, ";

        strSQL += "tech, product ";

        strSQL += "FROM reqs WHERE reqID =" + reqID;

 

        OleDbDataAdapter daSuppliers = new OleDbDataAdapter(strSQL, cnn);

 

        // Create a DataSet and Fill it.

        DataSet dsSuppliers = new DataSet();

        daSuppliers.Fill(dsSuppliers);

 

        return dsSuppliers;

}