C# Datagridview - How to organize and set certain column and cell values and save the data in a text file -


i'm using c3 vs 2012 express. have windows form tab control. on 1 of tabs (and have setup) datagridview (not sure if should use accomplish need seems suit - open other suggestions). please refer attached picture. need create text file have settings set , selected in datagridview shown. image reference user can edit field (which keep fields have marked areas need answers for. here goes:

  1. how hide index user , able select several computernames part of group name pluto.
  2. i need user select date , time here using datetimepicker.
  3. how make button read browse , place value in location cell (or same cell) edit : have part answer this.. can place value in location cell now:

    private void datagridview1_cellcontentclick(object sender, datagridviewcelleventargs e) {      openfiledialog fdialog = new openfiledialog();      if (fdialog.showdialog() != dialogresult.ok)          return;      system.io.fileinfo finfo = new system.io.fileinfo(fdialog.filename);      string strfilename = finfo.name;      string strfilepath = finfo.directoryname;      string strfullfilename = finfo.fullname;      textbox4.text = strfullfilename;     //datagridview1.rows[e.rowindex].cells[3].value = strfullfilename;     messagebox.show(strfilename + ", " + strfilepath + ", " + strfullfilename);     // set value cell, assuming rowindex refer new row.     datagridview1.rows[e.rowindex].cells[3].value = strfullfilename;   } 
  4. should rather use add button allow user add new row ?

  5. what code required remove entry when user selects 1 remove ?
  6. generate used write file (currently using fileappend) what/how specify element append (eg colum/row number) ?

i solved of 1 lot's of browsing , way many late nights. number: 2. decided not use date , time it's not necessary @ stage 3.a browse button added using this:

//this button click event clicking cell in dgv     private void datagridview1_cellclick(object sender,   datagridviewcelleventargs e)     {          if (e.columnindex == 7)         {             //messagebox.show(datagridview1.rows[e.rowindex].cells[e.columnindex].value.tostring());             // choose file here             openfiledialog fdialog = new openfiledialog();              if (fdialog.showdialog() != dialogresult.ok)                  return;              system.io.fileinfo finfo = new system.io.fileinfo(fdialog.filename);              string strfilename = finfo.name;              string strfilepath = finfo.directoryname;              string strfullfilename = finfo.fullname;               datagridview1.rows[e.rowindex].cells[e.columnindex].value = strfullfilename;              datagridview1.refreshedit(); 
  1. i managed add rows using add button using :

    private void button17_click(object sender, eventargs e) // add rows dgv {       this.datagridview1.rows.insert("one", "two", "three", "four","etc");      datagridview1.rows.addrange();  } //end add rows dgv 
  2. to remove rows used button , code :

    private void button18_click(object sender, eventargs e) {      if (this.datagridview1.selectedrows.count != -1)     {          foreach (datagridviewrow row in datagridview1.selectedrows)         {              this.datagridview1.rows.remove(row);          }      } 
  3. to remove row used button , code:

    private void button19_click(object sender, eventargs e) {     system.io.streamwriter file = new system.io.streamwriter(@"c:\foo\dgvtextfile.txt");//select name created text file     try     {         string mytableline = ""; //variable hold each line           (int r = 0; r <= datagridview1.rows.count - 1; r++)//loop through table rows, 1 @ time         {             //now loop though each column row number main loop             (int c = 0; c <= datagridview1.columns.count - 1; c++)             {                 mytableline = mytableline + datagridview1.rows[r].cells[c].value;                 if (c != datagridview1.columns.count - 1)                 {                     //set delimiter changinig value between ""                     mytableline = mytableline + ",";                 }             }             //write each line             file.writeline(mytableline);             mytableline = "";         }          file.close();         system.windows.forms.messagebox.show("grid export complete.all changes saved. use create create commands", "program info", messageboxbuttons.ok, messageboxicon.information);      }     catch (system.exception err)     {         system.windows.forms.messagebox.show(err.message, "error", messageboxbuttons.ok, messageboxicon.error);         file.close();     } } 

i hope helps else battling.

on final note .. proabably not best code worked me , hope @ least going if you're battling too.


Comments

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -