How to export the contents of a datareader to a CSV file - asp.net c# and sql server

I have a routine that does a dynamic search that returns a datareader.  How can I amend the following routine so that it exports the datareader fields to a csv file............
Here is the code

 IDataReader thisReader = null;
        try
        {
            try
            {

                if (isAllUserSearch == true)
                {
                    thisReader = doAllUserSearch();
                }
                else
                {
                    thisReader = doSearch();
                }

                int count = 0;
                while (thisReader.Read())
                {
                    //THIS IS WHERE I WANT TO ADD THE SQL DATAREADER FIELDS INTO A CSV FILE
                    For example, I want to have the following fields on different lines
                        (string)thisReader["Address1"];
                        (string)thisReader["Address2"];                                    
                }
                Emailer.ActiveStepIndex = 6;            }
            catch (Exception Ex)
            {
                lblMessagesProcessed.Text = "There appears to be an error whilst sending emails";
                throw;
            }
        }
mugseyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ashish PatelConnect With a Mentor Commented:
Below is complete one for this way of csv.
Salutation, FirstName, LastName, Address1, Address2, PostalCode

last try catch has file wrtting stuff.

	IDataReader thisReader = null;
	string strvalues = "";
 
        try
        {
            try
            {
 
                if (isAllUserSearch == true)
                {
                    thisReader = doAllUserSearch();
                }
                else 
                {
                    thisReader = doSearch();
                }
 
                int count = 0;
                while (thisReader.Read())
                {
 
                        strvalues += (string)thisReader["Salutation"] + ", " + (string)thisReader["FirstName"] + ", " + (string)thisReader["LastName"] + ", ";
                        strvalues += (string)thisReader["Address1"] + ", " + (string)thisReader["Address2"] + ", " + (string)thisReader["PostalCode"] + ", ";
 
 
			if(strvalues.length > 2)
				strvalues = strvalues.substring(0, strvalues.length-2) + "\n";
 
                }
 
 
                Emailer.ActiveStepIndex = 6;            }
            catch (Exception Ex)
            {
                lblMessagesProcessed.Text = "There appears to be an error whilst sending emails";
                throw;
            }
        }
 
	try    
	{
        	FileStream fsOutput = new FileStream ("C:\\Temp\\schema.csv", FileMode.Create, FileAccess.Write);
 
		StreamWriter srOutput = new StreamWriter (fsOutput);
		srOutput.WriteLine(strvalues.ToString());
        	srOutput.Close ();
        	fsOutput.Close ();                    
    	}
    	catch (Exception ex)
    	{
        	lblMessagesProcessed.Text = "Writting file error.";
                throw;
    	}
    	finally
    	{
    	}

Open in new window

0
 
Ashish PatelCommented:
Try this and note the last line comment to proceed further.
IDataReader thisReader = null;
string add1 = "";
string add2 = "";
        try
        {
            try
            {
 
                if (isAllUserSearch == true)
                {
                    thisReader = doAllUserSearch();
                }
                else 
                {
                    thisReader = doSearch();
                }
 
                int count = 0;
                while (thisReader.Read())
                {
                    //THIS IS WHERE I WANT TO ADD THE SQL DATAREADER FIELDS INTO A CSV FILE
                    For example, I want to have the following fields on different lines
                        add1 += (string)thisReader["Address1"] + ", ";
                        add2 += (string)thisReader["Address2"] + ", ";
                }
 
		if(add1.length > 2)
			add1 = add1.substring(0,add1.length-2);
		if(add2.length > 2)
			add2 = add2.substring(0,add2.length-2);
 
                Emailer.ActiveStepIndex = 6;            }
            catch (Exception Ex)
            {
                lblMessagesProcessed.Text = "There appears to be an error whilst sending emails";
                throw;
            }
        }
 
	//NOW here you have add1 and add2 string as CSV, so you can now write this to the file.

Open in new window

0
 
mugseyAuthor Commented:
Thanks for your reply, so say I wanted the csv file export to look like the following

Salutation,
FirstName,
LastName,
Address1,
Address2,
PostalCode,

How would I write the last bit of code to save the CSV to file?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mugseyAuthor Commented:
In fact the CSV file could just be
firstname, lastname, address1, address2, postcode
0
 
Ashish PatelCommented:
What should you CSV file look like when you have more than 1 records. Can you please show me.
0
 
mugseyAuthor Commented:
Well it does not matter really, so long as the user can search through the CSV

I think they want to have CSV but the ability to export to Excel also.  So it could be in either format

say

Salutation, FirstName, LastName, Address1, Address2, PostalCode

OR

Salutation,
FirstName,
LastName,
Address1,
Address2,
PostalCode,


0
 
mugseyAuthor Commented:
Thanks a lot

So could I have a browse dialog box so the user can save the csv file on their desktop?
0
 
Ashish PatelCommented:
Sorry mugsey, i dont know about that, but you can search it from google somewhere writting open save dialog C#. Time to go for me now. Have a nice day
0
 
mugseyAuthor Commented:
OK Thanks - I will award points as I will use it as a basis
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.