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