Hi experts,

I have created a form using c#. This particular form includes data housed within SQL compact editiona. Iadded this data via thedatagrid view tomy form. I would like to have the ability to output data (int or string) of a specific row within the datagrid, to a txt file. Ideally, I would like to create a box, enter my primary key, and then click a button that will cause the data to output to .txt file.

I'm new to C# and would truly appreciate your insight!!!

Hi KINGM56,

If you want to store these data so it can be reload to the form, you'd better save it as an xml file, the WriteXml method of DataTable should be the easiest way. (DataTable is your DataGridView binded datasource)
http://msdn.microsoft.com/en-us/library/3hyx9hb4.aspx

If you want to store the table as a format so your user can read it. You'd better choose a format first, e.g. The following example show a table using "|" as separator.
private void DGVToTxt(DataGridView dataGridView, string fileName)
{
string text = "";
foreach (DataGridViewColumn dgvCol in dataGridView.Columns)
{
text += dgvCol.HeaderText;
text += " | ";
}
text += "\r\n";
foreach (DataGridViewRow dgvRow in dataGridView.Rows)
{
if (dgvRow.IsNewRow == false)
{
foreach (DataGridViewCell dgvCell in dgvRow.Cells)
{
text += dgvCell.Value.ToString();
text += " | ";
}
text += "\r\n";
}
}
if (!File.Exists(fileName))
{
FileStream fs = File.Create(fileName);
fs.Close();
}
File.WriteAllText(fileName, text);
}

Hope this helps.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

Hi KINGM56,

If you want to store these data so it can be reload to the form, you'd better save it as an xml file, the WriteXml method of DataTable should be the easiest way. (DataTable is your DataGridView binded datasource)
http://msdn.microsoft.com/en-us/library/3hyx9hb4.aspx

If you want to store the table as a format so your user can read it. You'd better choose a format first, e.g. The following example show a table using "|" as separator.
private void DGVToTxt(DataGridView dataGridView, string fileName)
{
string text = "";
foreach (DataGridViewColumn dgvCol in dataGridView.Columns)
{
text += dgvCol.HeaderText;
text += " | ";
}
text += "\r\n";
foreach (DataGridViewRow dgvRow in dataGridView.Rows)
{
if (dgvRow.IsNewRow == false)
{
foreach (DataGridViewCell dgvCell in dgvRow.Cells)
{
text += dgvCell.Value.ToString();
text += " | ";
}
text += "\r\n";
}
}
if (!File.Exists(fileName))
{
FileStream fs = File.Create(fileName);
fs.Close();
}
File.WriteAllText(fileName, text);
}

Hope this helps.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.