You must Sign In to post a response.
  • Category: ASP.NET

    How to extract selected data in a defined format from sql

    Sir i am working on a project and facing some problem that i want o extract the selected data from the sql database in a defined format but i m unable to do it. i am getting tired to search the Solution of it on google. Also i want that before submitting the data in the database the user can get a preview of the data in a defined format but i am unable to do it. I am using visual studio 2010 with c#.
  • #766221
    Hi

    Can you share how to selected data from the sql database in a defined format ?

    because then i will help you

    for ex : Select Statement this


    Select * from TableName

    Select ID,Name From Tablename



    Different type of select statement in sql so share your code or snapshots

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #766230
    what format you have saved in database and how you want to show it, Please give any sort of example so that we can help you better to resolve your issue .
    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #766233
    Hi,

    What format did you expect to extract data from database? and what did you did so far? Please elaborate more..

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #766372
    Sir supoose i want the data in an arranged manner as in the image i have attached. So what should i do for that.

  • #766382
    Hi

    In your Post below Attachment Provisions have you can upload your snapshot with extension must zip or jpg only you can do that.

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #766387
    from your screen shot, it looks, it is better to use report, it will give you preview as you want.
    you can use RDLC report, crystal report for it. here are some good example of report you can use
    http://www.c-sharpcorner.com/blogs/how-to-create-report-using-report-viewer-in-asp-net1
    http://www.aspsnippets.com/Articles/How-to-create-RDLC-report-step-by-step-in-ASPNet-using-C-and-VBNet.aspx
    use 'Microsoft.ReportViewer.WebForms' assembly for it

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #766388
    Hi,

    My suggestion is first get the data from database and then bind the same to any report builder, my preference is SSRS report builder, this will help you to show the data in your desired format.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #766887
    I think you are expecting the row and column format as shown in screen shot for that you have to dynamically append the html tags with the database other wise use crystal reports.
    SRI RAMA PHANI BHUSHAN KAMBHAMPATI


Sign In to post your comments