Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static DataSet GetDataSet(string databaseName,string
- storedProcedureName,params object[] parameters)
- {
- //Creates blank dataset
- DataSet ds = null;
- try
- {
- //Creates database
- Database db = DatabaseFactory.CreateDatabase(databaseName);
- //Creates command to execute
- DbCommand dbCommand = db.GetStoredProcCommand(storedProcedureName);
- dbCommand.CommandTimeout = COMMAND_TIMEOUT;
- //Returns the list of SQL parameters associated with that stored proecdure
- db.DiscoverParameters(dbCommand);
- int i = 1;
- //Loop through the list of parameters and set the values
- foreach (object parameter in parameters)
- {
- dbCommand.Parameters[i++].Value = parameter;
- }
- //Retrieve dataset and set to ds
- ds = db.ExecuteDataSet(dbCommand);
- }
- //Check for exceptions
- catch (SqlException sqle)
- {
- throw sqle;
- }
- catch (Exception e)
- {
- throw e; // Error is thrown here.
- }
- //Returns dataset
- return ds;
- }
- protected void btnSearchSBIDatabase_Click(object sender, EventArgs e)
- {
- LicenseSearch ls = new LicenseSearch();
- DataTable dtSearchResults = new DataTable();
- dtSearchResults = ls.Search();
- Session["dtSearchResults"] = dtSearchResults;
- Response.Redirect("~/FCCSearch/SearchResults.aspx");
- }
- else
- lblResults.Visible = true;
- }
Add Comment
Please, Sign In to add comment