kedar pawgi

kedar pawgi

  • NA
  • 105
  • 38k

Printing sql query result into text file

Mar 10 2012 9:18 AM
Hi All
i am facing big problem. I am fetching rows from a table, I have shown them in gridview. I want to print them in text file instead of exporting it, means when user click print button, it should open word pad with properly formatted text with header and after ever 30 rows a form feed. I got query working properly but i am not getting how can i send the result to text file using textwriter or streamwriter. I am using ADODB recordset.
Please guide me asap.
Thanking You in advance.
Please give code for ADODB