// This function gets the user activity from the tblPersonnel public static clsPersonnel GetPersonnel(string Database, string strSearch) { // New instances of dsUserActivity, OleDbConnection and OleDbAdapter clsPersonnel DS; OleDbConnection sqlConn; OleDbDataAdapter sqlDA; // Connection string using OleDbConnection sqlConn = new OleDbConnection("PROVIDER=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + Database); // Select statement, retrieves all data from tblPersonnel if (strSearch == null || strSearch.Trim() == "") { sqlDA = new OleDbDataAdapter("select * from tblPersonnel", sqlConn); } else { sqlDA = new OleDbDataAdapter("select * from tblPersonnel where LastName = '" + strSearch + "'", sqlConn); } // new dsUserAvtivity instantiated DS = new clsPersonnel(); // tblUserActivity data assigned sqlDA.Fill(DS.tblPersonnel); // data is returned return(DS); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //Declare the Dataset clsPersonnel myDataSet = new clsPersonnel(); // assign search value to string variable string strSearch = Request["txtSearch"]; //Fill the dataset with shat is returned from the method. myDataSet = clsDataLayer.GetPersonnel(Server.MapPath("PayrollSystem_DB.accdb"), strSearch); //Set the DataGrid to the DataSource based on the table grdViewPersonnel.DataSource = myDataSet.Tables["tblPersonnel"]; //Bind the DataGrid grdViewPersonnel.DataBind(); } }