Solved

C# DataGridView export to a text file

Posted on 2008-10-23
1
5,705 Views
Last Modified: 2010-10-05
Hi im just brand new here and already im highly impressed with the site.

Just a simple question (hopefully), i am trying to do something exactly the same as shown here http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23263374.html?sfQueryTermInfo=1+c+datagridview+export

But my DataGridView is made up of all text. So how would i modify this function to work accordingly?

And then how would i call it?   ExportGridData(List<string>);     ???


I have included the code snipits used to populate the datagridview if that heklps explain what i am trying to do.

Basically i want to export the data once modified to comma separated file.
private void ImportCSV()

{

    List<string[]> testParse =

          parseCSV(txtInputPath.Text);

    

    DataTable newTable = new DataTable();

            foreach (string column in testParse[0])

            {

                newTable.Columns.Add();

            }

  

    foreach (string[] row in testParse)

    {

        newTable.Rows.Add(row);

    }

        DataGrid.DataSource = newTable;

}
 

public List<string[]> parseCSV(string path)

        {

            List<string[]> parsedData = new List<string[]>();

            using (StreamReader readFile = new StreamReader(path))

            {

                string line;

                string[] row;
 

                while ((line = readFile.ReadLine()) != null)

                {

                    row = line.Split(',');

                    parsedData.Add(row);

                }

            }
 

            return parsedData;
 

        }

Open in new window

0
Comment
Question by:A_Kardas
1 Comment
 
LVL 18

Accepted Solution

by:
Priest04 earned 50 total points
ID: 22798816
The code should work fine with your datagridview. What confuses you is the parameter List<int>. As I understood at a quick view at code, its an array of RowIndeces that you want to avoid exporting to txt file. for example, if your datagridview contains 10 rows, and you want to avoid exporting rows with index 2, 4 and 7, then you would do this

List<int> list = new List<int>();
list.Add(2);
list.Add(4);
list.Add(7);

// and then call the function
ExportGridData(list);

What I dont like about this function is that it is hardcoded to a particular datagridview name. DataGRidView should be passed as a parameter to this function, so I would rewrite it in the bellow way

to call the function
ExportGridData(MyDataGridView, null, @"C:\test.txt");
private void ExportGridData(DataGridView dgv, List<int> omitIndices, string filePath)

{

    StreamWriter writer = new StreamWriter(filePath);

 

    if (dgv.Rows.Count > 0)

    {

        foreach (DataGridViewColumn col in dgv.Columns)

        {

            if (col.Index == dgv.Columns.Count - 1)

            {

                writer.WriteLine(col.HeaderText);

            }

            else

            {

                writer.Write(string.Concat(col.HeaderText, ","));

            }

        }

 

        foreach (DataGridViewRow row in dgv.Rows)

        {

            if (omitIndices == null || !omitIndices.Contains(row.Index))

            {

                foreach (DataGridViewCell cell in row.Cells)

                {

                    if (cell.OwningColumn.Index == dgv.Columns.Count - 1)

                    {

                        if (cell.Value != null)

                            writer.WriteLine(cell.Value.ToString());

                        else

                            writer.WriteLine("");

                    }

                    else

                    {

                        if (cell.Value != null)

                            writer.Write(string.Concat(cell.Value.ToString(), ","));

                        else

                            writer.Write(string.Concat("", ","));

                    }

                }

            }

        }

    }

 

    writer.Close();

}

Open in new window

0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
ConsoleSql 1 17
Check my code out(2) 1 29
what technologies offer Authentication over Web Services? 4 65
fomat Json objects 6 17
This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now