[
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;
}