vb.net - add column in datagridview -

-

i use vb.net excel

i have buttom "get name of column worksheet" combobox

this code of button:

private sub button7_click(byval sender system.object, byval e system.eventargs) handles button7.click     dim excols new dictionary(of integer, string)     form2.xlworksheet = ctype(form2.xlworkbook.sheets(form2.combobox1.text), excel.worksheet)     form2.xlworksheet.activate()      form2.xlworksheet         dim lastcol integer = form2.xlworksheet.cells(1,         form2.xlworksheet.columns.count).end(xldirection.xltoleft).column         x integer = 2 lastcol             excols.add(x, form2.xlworksheet.cells(1, x).value.tostring)         next         combobox2.datasource = new bindingsource(excols, nothing)         combobox2.valuemember = "key"         combobox2.displaymember = "value"         addhandler combobox2.selectedindexchanged, addressof            combobox2_selectedindexchanged     end end sub

this code of combobox:

private sub combobox2_selectedindexchanged(byval sender system.object, byval e system.eventargs)     form2.xlworksheet = ctype(form2.xlworkbook.sheets(form2.combobox1.text), excel.worksheet)     form2.xlworksheet.activate()     form2.xlapp.visible = true     dim key string =               cstr(directcast(combobox2.selecteditem, keyvaluepair(of integer, string)).key)     dim value string =                  directcast(combobox2.selecteditem, keyvaluepair(of integer, string)).value     dim doessheetexists boolean = false     each xs in form2.xlapp.sheets         if xs.name = value             doessheetexists = true     next      if doessheetexists = true         msgbox("sheet exists", ctype(messageboxicon.error, msgboxstyle))     else         form2.xlworksheet             dim lastrow integer = form2.xlworksheet.cells.rows.end(xldirection.xldown).row             dim colletter string = columnindextocolumnletter(cint(key))             exws2 = directcast(form2.xlworkbook.sheets.add, microsoft.office.interop.excel.worksheet)             exws2.name = value             form2.xlworksheet.range("a1:a" & lastrow.tostring).copy(exws2.range("a1"))             form2.xlworksheet.range(colletter & "1:" & colletter & lastrow.tostring).copy(exws2.range("b1"))             exws2.range("a1").font.color = system.drawing.colortranslator.toole(system.drawing.color.blue)             exws2.range("b1").font.color = system.drawing.colortranslator.toole(system.drawing.color.blue)             exws2.range("a1").interior.colorindex = 8             exws2.range("b1").interior.colorindex = 8             exws2.range("a2:a" & lastrow.tostring).interior.colorindex = 20             exws2.range("a1:a" & lastrow.tostring).horizontalalignment =       -4108              exws2.range("b1:b" & lastrow.tostring).horizontalalignment = -4108             exws2.range("a1").font.name = "times new roman"             exws2.range("b1").font.name = "times new roman"             exws2.range("b1").font.fontstyle = "gras"             exws2.range("a1").font.fontstyle = "gras"         end     end if end sub

what want add every time when select column , added datagridview

this column want add datagridview

help me please


Comments

Post a Comment

Popular posts from this blog

c# - SharpSsh Command Execution -

-
Image
i trying create ssh client using c#. using tamir.sharpssh library. having issues sending command , getting appropriate response server. the way have been testing sending on ls command, followed cd.. command, followed ls command again -- see whether or not cd.. command being executed properly. however, there no difference between first ls command , second ls command. not entirely sure doing wrong. perhaps using wrong ssh type. have provided code , output getting. have added output expect. using tamir.sharpssh; namespace sshnetexample { class program { static void main(string[] args) { sshexec ssh = null; try { console.write("-connecting..."); ssh = new sshexec(host, username, password); ssh.connect(); console.writeline("ok ({0}/{1})", ssh.cipher, ssh.mac); console.writeline("server version={0}, client versio
Read more

python - Specify path of savefig with pylab or matplotlib -

-
i struggling on how find correct way specify save path (or repository) when calling function savefig in matplotlib or pylab. i tried several syntaxes, everytime python console returns : filenotfounderror: [errno 2] no such file or directory: '../mydocs/resource/frames/myimage.png' currently, have written following : pylab.savefig('../mydocs/resource/frames/myimage.png') does know how it? thanks in advance! the tilde operator , variable $home entered strings , therefore not function while saving. have provide either relative path (as did) or provide full path. eg. pylab.savefig("/home/username/desktop/myfig.png") .
Read more

How to run C# code using mono without Xamarin in Android? -

-
i want create program uses mono runtime run c# code (binary not application). i copied libmono.so unity app , i'm write code using documentation: http://www.mono-project.com/docs/advanced/embedding/ and it's working have problems references can access classes mscorlib.dll , have problems system.reflection.assembly class throwing exception, when print console see: system.missingmethodexception: method not found: 'system.reflection.assembly.op_inequality' can fix it? can use mono runtime in c binary on android? ps. i'm using android tests. edit: found solution loading libraries, need set environment variable mono_path libraries path. but have still problems assembly class. the system.missingmethodexception error have seems .net profile mismatch error, 1 explained here . can use mono runtime in c binary on android? yes, using ndk guess. there alternatives can use instead of rolling own, such xmadevlab .
Read more