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:
- how hide index user , able select several computernames part of group name pluto.
- i need user select date , time here using datetimepicker.
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; }should rather use add button allow user add new row ?
- what code required remove entry when user selects 1 remove ?
- 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(); 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 dgvto 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); } }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
Post a Comment