/// <summary>
/// </summary>
void gvFields_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
Guid fieldId;
try
{
fieldId = new Guid(gvFields.Rows[e.RowIndex].Cells[0].Value.ToString());
}
catch (Exception ex)
{
MessageBox.Show("ERROR: see status window below for details.", "ERROR");
var msg = "Error retrieving field ID from gridview: " + ex.Message;
GenUtil.LogIt(txtStatus, msg);
return;
}
if (fdf != null)
{
fdf.Close();
}
fdf = new FieldDetailsForm();
fdf.siteUrl = txtSiteUrl.Text.Trim(); // "http://localhost/"
//fdf.webID = selListNode.Parent.Name; // "/"
//fdf.webName = selListNode.Parent.Text; // "Root"
fdf.listID = selListNode.Name; // "guid"
fdf.listName = selListNode.Text; // "States"
fdf.fieldId = fieldId;
fdf.parentForm = this;
fdf.Show();
}
/// <summary>
/// </summary>
private void ExportGrid(DataGridView gv, string type)
{
var saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
saveFileDialog1.Filter = "Csv file (*.csv)|*.csv|All Files (*.*)|*.*";
saveFileDialog1.FilterIndex = 1;
saveFileDialog1.AddExtension = true;
saveFileDialog1.FileName = "export.csv";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
toolStripStatusLabel1.Text = "Running...";
statusStrip1.Refresh();
picLogoWait.Visible = true;
picLogoWait.Refresh();
System.IO.StreamWriter streamWriter = null;
try
{
streamWriter = new System.IO.StreamWriter(saveFileDialog1.FileName);
string strHeader = "";
for (int i = 0; i < gv.Columns.Count; i++)
{
string curval = GenUtil.SafeTrim(gv.Columns[i].HeaderText);
if (curval.Contains(",") && !curval.StartsWith("\""))
{
strHeader += "\"" + curval + "\"" + ",";
}
else
{
strHeader += curval + ",";
}
}
streamWriter.WriteLine(strHeader);
for (int m = 0; m < gv.Rows.Count; m++)
{
string strRowValue = "";
for (int n = 0; n < gv.Columns.Count; n++)
{
string curval = GenUtil.SafeTrim(gv.Rows[m].Cells[n].Value);
if (curval.Contains(",") && !curval.StartsWith("\""))
{
strRowValue += "\"" + curval.Replace("\"", "'") + "\"" + ",";
}
else
{
strRowValue += curval.Replace("\"", "'") + ",";
}
}
streamWriter.WriteLine(strRowValue);
}
}
catch (Exception ex)
{
MessageBox.Show("ERROR: see status window below for details.", "ERROR");
GenUtil.LogIt(txtStatus, string.Format("ERROR: cannot export to CSV: {0}", ex.ToString()));
}
finally
{
if (streamWriter != null)
{
streamWriter.Close();
}
}
toolStripStatusLabel1.Text = oldStatusText;
statusStrip1.Refresh();
picLogoWait.Visible = false;
picLogoWait.Refresh();
}
}
