SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Member
    Join Date
    Jun 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Report Generation In ASP.Net

    I have a task to generate a report from an oracle database using ASP.net. I used C# in ASP.net to connect to the Oracle Database and was able to pull out the tables and fields given in my task. How do I now generate a report using the fields from that table? The report is to contain the top 20 records of the database. Please help me solve this task.

  2. #2
    SitePoint Enthusiast
    Join Date
    Aug 2011
    Location
    OH, USA
    Posts
    72
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ctkimba View Post
    I have a task to generate a report from an oracle database using ASP.net. I used C# in ASP.net to connect to the Oracle Database and was able to pull out the tables and fields given in my task. How do I now generate a report using the fields from that table? The report is to contain the top 20 records of the database. Please help me solve this task.
    the simple place on form datagrid and connection objects and config them...

  3. #3
    SitePoint Guru Jason__C's Avatar
    Join Date
    Oct 2009
    Location
    Racoon City
    Posts
    660
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    An overview is a good starting place:


    http://msdn.microsoft.com/en-us/library/ms228214.aspx
    Chuck Norris is so tough,
    mosquitos ask for permission before they bite him

  4. #4
    SitePoint Member
    Join Date
    Jun 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thanks...

    Thanks Jason,

    I went through the link you sent me. What I did not see was a tool in ASP.net you can use to generate a report after successfully connecting to the database. Can you help in that direction?

  5. #5
    SitePoint Guru Jason__C's Avatar
    Join Date
    Oct 2009
    Location
    Racoon City
    Posts
    660
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ctkimba View Post
    Thanks Jason,

    I went through the link you sent me. What I did not see was a tool in ASP.net you can use to generate a report after successfully connecting to the database. Can you help in that direction?
    Quick question, what are you outputting /saving it to? PDF, Word, are just an .aspx page? I can help you further from there
    Chuck Norris is so tough,
    mosquitos ask for permission before they bite him

  6. #6
    SitePoint Member
    Join Date
    Jun 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thanks And...

    Jason,

    Thanks again for your prompt response. Actually my boss did not tell which format he want the report in. All he said was that i should a report in ASP.net using any tool am familiar with. But we normally reports are generated in either excel or pdf in my work place.

    Regards and hope to hearing from you...

    Quote Originally Posted by Jason__C View Post
    Quick question, what are you outputting /saving it to? PDF, Word, are just an .aspx page? I can help you further from there

  7. #7
    SitePoint Member
    Join Date
    Jun 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Keeping In Touch...

    Quote Originally Posted by Jason__C View Post
    Quick question, what are you outputting /saving it to? PDF, Word, are just an .aspx page? I can help you further from there
    Hi Jason,

    Hope you are doing great. I've not heard from you in recent time. Can you please update me concerning our previous discussion relating to the task (as you asked above) you are trying to help me with?

    Clement.

  8. #8
    SitePoint Zealot davejuk's Avatar
    Join Date
    Apr 2006
    Location
    UK
    Posts
    188
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This sounds like homework.

    Select the data and bind it to a control. It's only a few lines.

  9. #9
    SitePoint Member
    Join Date
    Jul 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I suggest you to use SQL Report reporting service instead of just plain HTML. SQL Reporting service is purely for reporting and it provides all basic reporting features like export to excel,pdf etc.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •