How to save a storedproc result set to a text file? 1

[darwin101]

Hi all

How would I go about using VB.net 2003 to execute a stored proc, then save the result set out to a text file (csv)?
I would then need to use another button to rename and move that same file after it is used. Any suggestions will be appreciated.
This is for a non profit,we don't have any real language programmers. I spent a few hours last nite at the book store trying to find something similar, no luck.

Thanks

 

[PankajBanga]

This is how you can execute Stored Proc and save the result in DataSet object.

Dim DS As New DataSet
Dim Conn As New SqlConnection("Server=yourServer;Uid=yourUserID;pwd=yourPassword;Database=yourDatabase;")
Dim DA As New SqlDataAdapter

'Set Select Command for DA.
DA.SelectCommand = New SqlCommand
With DA.SelectCommand
    .Connection = Conn
    .CommandType = CommandType.StoredProcedure
    .CommandText = "yourProcedureName"
    .Parameters.Clear()
    .Parameters.Add("@yourVariable", yourValue)
End With

DA.Fill(DS, "yourTableName")

ofcourse, don't forget to include the following namespace

Imports System.Data.SqlClient


Use the following to see how you can write text file from DataSet.

http://www.dotnet247.com/247reference/msgs/39/196752.aspx

http://home.iprimus.com.au/pankajbanga

 

[PankajBanga]

Alternatively you can use Crystal Report in VB.NET to report off the DataSet. The CrystalReportViewer control provides an option to export reports to Word, Excel, Text, PDF, HTML format.

To get more detail on creating Crystal Reports from DataSet visit the following link

http://www.gotdotnet.com/Community/...mpleGuid=2c3858e5-8400-4bcc-b1b2-7c661c79f0a2

http://home.iprimus.com.au/pankajbanga

 

[darwin101]

Thanks for your help and advice, this should get me going.