public void OpenFile() { try { int rowid = attachment_list.CurrentCellAddress.Y; string _data = attachment_list["filedata", rowid].Value.ToString(); string temp = Environment.GetEnvironmentVariable("temp"); File.WriteAllBytes(temp + "\\" + attachment_list["filedisplay", rowid].Value.ToString(), _filedata(_data)); System.Diagnostics.Process.Start(temp + "\\" + attachment_list["filedisplay", rowid].Value.ToString()); } catch { List<Attachments> ListAtt = new List<Attachments>(); for (int i = 0; i < attachment_list.Rows.Count; i++) { Attachments Att = new Attachments(); Att.Data = attachment_list["filedata", i].Value.ToString(); Att.FileName = attachment_list["filename", i].Value.ToString(); Att.FileExtension = attachment_list["fileext", i].Value.ToString(); Att.Directory = "(in database)"; Att.rowid = int.Parse(attachment_list["rowid", i].Value.ToString()); ListAtt.Add(Att); } New_Attachment NewAtt = new New_Attachment(ListAtt, projectnum_txt.Text); NewAtt.ShowDialog(); eSRAttachmentsTableAdapter.FillByESR(engDataDataSet.ESRAttachments, projectnum_txt.Text); } }
private void addNewToolStripMenuItem_Click(object sender, EventArgs e) { List<Attachments> ListAtt = new List<Attachments>(); for (int i = 0; i < attachment_list.Rows.Count; i++) { Attachments Att = new Attachments(); Att.Data = attachment_list["filedata", i].Value.ToString(); Att.FileName = attachment_list["filename", i].Value.ToString(); Att.FileExtension = attachment_list["fileext", i].Value.ToString(); Att.Directory = "(in database)"; Att.rowid = int.Parse(attachment_list["rowid", i].Value.ToString()); ListAtt.Add(Att); } New_Attachment NewAtt = new New_Attachment(ListAtt, projectnum_txt.Text); NewAtt.ShowDialog(); eSRAttachmentsTableAdapter.FillByESR(engDataDataSet.ESRAttachments, projectnum_txt.Text); }
private void ok_btn_Click(object sender, EventArgs e) { if (ExistingESR) { for (int i = 0; i < fileGrid.Rows.Count; i++) { if (!(fileGrid["Path", i].Value.ToString() == "(in database)")) eSRAttachmentsTableAdapter.Insert(ESRnum, fileGrid["File_Name", i].Value.ToString(), fileGrid["FileExt", i].Value.ToString(), fileGrid["FileData", i].Value.ToString(), fileGrid["File_Name", i].Value.ToString() + "." + fileGrid["FileExt", i].Value.ToString()); } } else { Datums = new List<Attachments>(); for (int i = 0; i < fileGrid.Rows.Count; i++) { Attachments AData = new Attachments(); AData.FileName = fileGrid["File_Name", i].Value.ToString(); AData.FileExtension = fileGrid["FileExt", i].Value.ToString(); AData.Data = fileGrid["FileData", i].Value.ToString(); AData.Directory = fileGrid["Path", i].Value.ToString(); Datums.Add(AData); } } }