Need your help on the following. I have one ASP.net webpage. It just works as a dashboard for us to show the numbers from oracle database.
public partial class _Default : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
string connectionstring = "PROVIDER=MSDAORA;Data source=OPSMGR;User ID=OPSMGR ;password=OPSMGR;";
OleDbConnection oracleConn = new OleDbConnection(connectionstring);
OleDbCommand oraclecomTOT = new OleDbCommand("select assignment,distinct count(number) as TOTAL from workorder where status <> 'closed'", oracleConn);
OleDbDataReader oracleread = oraclecomTOT.ExecuteReader(System.Data.CommandBehavior.Default);
GridView_data.DataSource = oracleread;
This works fine. if you check the connection string its string connectionstring = "PROVIDER=MSDAORA;Data source=OPSMGR;User ID=OPSMGR ;password=OPSMGR;";
The odbc is setup in the pc.
My problem is (1st one is important)
1. It takes ages to load the page. When run this query using some query analyser it just takes 1 second.
Please could you suggest me the best possible way to do this so that it will run faster.Also suggest me for SQL database as well.
2. I get the data in following format in gridview
Now I want to have the assignment groups (IT,HR etc) in the form of hyperlink in gridview, so when I click on that it will run the query for that particular assignment and give me the details in a separate page.