Results 1 to 12 of 12

Thread: how can i print table data?

  1. 07-10-2003, 12:18 PM #1
    maf
    maf is offline Registered User
    Join Date
    Jul 2003
    Posts
    5

    how can i print table data?

    Please excuse this beginner question - I need to print data from certain columns in a SQL table. How can I do this?
    Thank you very much for the help.

    maf
    Reply With Quote Reply With Quote
  2. 07-10-2003, 12:20 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    what database? sql server, oracle, ms-access, ingress, sybase, mysql

    what tool you are using to connect to the database?
    Last edited by MAK; 07-10-2003 at 12:26 PM.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 07-10-2003, 12:26 PM #3
    maf
    maf is offline Registered User
    Join Date
    Jul 2003
    Posts
    5
    I am using sql server7 and am accessing it through DotNet (SqlConnection)

    maf
    Reply With Quote Reply With Quote
  4. 07-10-2003, 12:32 PM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    from .net datagrid you can use browser -file print to print the data.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  5. 07-10-2003, 12:36 PM #5
    maf
    maf is offline Registered User
    Join Date
    Jul 2003
    Posts
    5
    I am going to sound REALLY dumb (!) - please excuse me! ... you mean dragging a datagrid on the form, populate it and then print from browser?
    Another question - How can I get the data in a text file? Maybe a CSV file?

    Thanks!

    maf
    Reply With Quote Reply With Quote
  6. 07-10-2003, 12:49 PM #6
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    From SQL Server you can either BCP out the data check BCP.exe
    or
    your can export it
    or
    you can run DTS
    or
    OSQL
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  7. 07-10-2003, 12:50 PM #7
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use DTS to export data in CSV format.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  8. 07-10-2003, 12:54 PM #8
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Print the data from web form

    http://www.asp.net/Forums/ShowPost.a...&PostID=268460
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  9. 07-10-2003, 01:03 PM #9
    maf
    maf is offline Registered User
    Join Date
    Jul 2003
    Posts
    5
    Thank you both MAK and shailesh for the info ... I will read up on DTS in the next hour or so and try out your suggestions ... I am just starting with this so MANY thanks for your help ... if there are any good links you can suggest I would be very grateful.
    One more question, if you don't mind: How do I get the data in a text file from Enterprise manager?
    Thanks
    maf
    Reply With Quote Reply With Quote
  10. 07-10-2003, 01:22 PM #10
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    From EM. click on the menu - TOOLS- Data transformation services- export
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  11. 07-10-2003, 01:22 PM #11
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    http://www.databasejournal.com/featu...le.php/2225481

    http://www.sqldts.com
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  12. 07-10-2003, 01:29 PM #12
    maf
    maf is offline Registered User
    Join Date
    Jul 2003
    Posts
    5
    Awesome! Thanks!

    maf
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules