SQL Query to convert grid result to csv file

Question

I am using SMS caster to send sms.It has an option to Import csv files.

Now I want to dynamically create csv file of CellNo column of Person table from Visual Studio 2010 connected SQL Server 2008.So that I click on a button and it creates a csv file which I can then access from my software SMSCaster to send sms.

The solutions available are either manual-based or if some query is provided it requires Microsoft OLEDB.....so is there any simple query to convert queryresult into .csv file?

Answer 1

Try this :

Namespace : System.IO;

        var _lines = new List<string>();
        for(int _i=0;i<gridview1.rows.count;_i++)
        {
            string[] _mobileNos = gridView1.rows[_i].cells[mobilecolumn index in gridview].text;
            var header = string.Join(",", _mobileNos);
            _lines.Add(header);
        }
        File.WriteAllLines("FileName.csv",_lines);

Answer 2

Here is the solution that worked:

public void gridtoCSVFILE()

    {
        string ing;
        List<string> lines = new List<string>();
        for (int i = 0; i < gvStudCellNo.Rows.Count; i++)
        {
            ing = gvStudCellNo.Rows[i].Cells[0].Value.ToString();
            lines.Add(ing);
            File.WriteAllLines("StudentsCellNo.csv", lines);
        }
    }

//it will create csv file in your bin folder...also it automatically replaces each new file with the old one