public void exportUser(string username, string datapath)
{
string sqlStmt = "SELECT * FROM tblApplications WHERE Username = '******'";
//new adapter
OleDbDataAdapter sqlDataAdapter = new OleDbDataAdapter(sqlStmt, dbConnection);
//new dataset
dsApplications myApplicationsDataSet = new dsApplications();
sqlDataAdapter.Fill(myApplicationsDataSet.tblApplications);
myApplicationsDataSet.WriteXml(datapath + username + ".xml");
}
public dsApplications listApplications(string Username)
{
//Select all applications from tblPrograms
OleDbDataAdapter sqlDataAdapter = new OleDbDataAdapter("SELECT * FROM tblPrograms WHERE Username = '******'", dbConnection);
//Fills information gathered via data adapter
dsApplications myApplications = new dsApplications();
sqlDataAdapter.Fill(myApplications.tblPrograms);
//Returns all applications
return(myApplications);
}
private dsApplications BindApplicationGridView(string Username)
{
string tempPath = Server.MapPath("~/App_Data/");
clsBusinessLayer myBusinessLayer = new clsBusinessLayer(tempPath);
dsApplications applicationListing = myBusinessLayer.FillApplications(txtUsername.Text);
gvApplications.DataSource = applicationListing.tblPrograms;
gvApplications.DataBind();
Cache.Insert("ApplicationDataSet", applicationListing);
return(applicationListing);
}
public dsApplications FillApplications(string Username)
{
dsApplications dsFillApplications = myDataLayer.listApplications(Username);
return(dsFillApplications);
}
