Does not save csv file from datagridview in correct format

Question

0.00/5 (No votes)

See more:

Hi developer's
I am loading a csv file in dataset and visualize them in datagridview and after applied some operation on data , i am save a datagridview values again in csv file format.

but from some time my csv file not save csv file in correct format because values from the cell are fall to the another cells
for example
if in a orignal csv file values at [0] index location, after save this file from datagridview values fall at the [3] index location .

and given some unknown type of values , I do not know Because my orignal csv file not cantain this type values

"PASI ID : < 10441494957439>
"
please check my code .

  public void DataExport()
        {
            try
            {
                string strColumn = string.Empty;
                string strRow = string.Empty;
                StringBuilder objSB = new StringBuilder();
                for (int i = 0; i < Datagidveiw1.Columns.Count; i++)
                {
                    strColumn += (i >= Datagidveiw1.Columns.Count - 1) ? Datagidveiw1.Columns[i].Name : Datagidveiw1.Columns[i].Name + ",";
                }
                objSB.AppendLine(strColumn);

                for (int i = 1; i < Datagidveiw1.Rows.Count - 1; i++)
                {
                    for (int j = 0; j < Datagidveiw1.Columns.Count; j++)
                    {
                        strRow += (j >= Datagidveiw1.Columns.Count - 1) ? Datagidveiw1.Rows[i].Cells[j].Value.ToString().Replace("\n", "") : Datagidveiw1.Rows[i].Cells[j].Value.ToString().Replace("\n", "") + ",";
                    }
                    objSB.AppendLine(strRow);
                    strRow = string.Empty;
                }
                File.AppendAllText(Locations.Text, objSB.ToString());
                Datagidveiw1.Refresh();
               
                MessageBox.Show("Data save sucessfull");
                Application.Exit();
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        public void save_Click(object sender, EventArgs e)
        {
            
            try
            {
                SaveFileDialog SaveDialogbox = new SaveFileDialog();
                SaveDialogbox.FileName = Locations.Text;
                SaveDialogbox.Filter = "Text and CSV Files(*.txt, *.csv)|*.txt;*.csv|Text Files(*.txt)|*.txt|CSV Files(*.csv)|*.csv|All Files(*.*)|*.*";
                SaveDialogbox.FilterIndex = 1;
                SaveDialogbox.RestoreDirectory = true;
                DialogResult Dialogresult1 = SaveDialogbox.ShowDialog();
                if (Dialogresult1 == DialogResult.OK)
                {
                    Locations.Text = SaveDialogbox.FileName;
                    DataExport();
                    Application.DoEvents();
                }
                 else
                 {
                 MessageBox.Show("Invalid Arguments");
                }
}}

please check this code,
thanks

Posted 22-Dec-10 20:22pm

vishu1999a

Updated 22-Dec-10 20:23pm

Hiren solanki

v2

Add a Solution

Comments

Hiren solanki 23-Dec-10 2:23am

Always prefer to wrap code in 'pre' tag.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vivekse · Answer 1 · 2010-12-22T21:47:00

Solution 1

Hi Vishu,

Get the objSB.ToString()in quick watch and try to save directly in notepad in CSV format so you can able to visible those character and string extra, need to removed form string.

Posted 22-Dec-10 21:47pm

vivekse

sucram · Answer 2 · 2010-12-28T03:40:00

I would approach this slightly differently.

To generate the column names, I would use the original DataSet. Instead of using a for loop I would a foreach loop they ahve less over head then the for loops

eg.

let's assume that your dataset is called ds.

StringBuilder sb = new Stringbuilder();

int numColumns = Tables[0].Columns.Count-1 //-1 is for zero based count
int columnCounter= numColumns;

foreach(DataColumn dc in ds.Tables[0].Columns)
{
    sb.Append(dc.ColumnName);
    AppendDelimiter(sb, ref columnCounter);
}



foreach(GridViewRow gvr in Datagidveiw1.Rows)
{
   columnCounter=numColumns
   foreach(TableCell c in grv.Cells)
   {
       sb.Append(c.Text)
       AppendDelimiter(sb,ref columnCounter);
   }
}


private void AppendDelimiter(StringBuilder sb, ref int columnCounter)
{
       if (columnCounter > 0)
         sb.Append(';');
       else
         sb.Append(Environment.NewLine);

       columnCounter--;
}

do the rest of the code here to write content to file.

I have tested this and it worked just fine.

If you have any more issues then I would like to see the code that you use to construct your gridview and or a screenshot of the populated gridview.

Another alternative is to persit your changes in the gridview to the DataSet and then iterate through the DataSet.Table[0].Rows to create the csv.