vba - Pulling Column Names into Excel from SQL query -

-

i'm using excel pull data sql db. used code question , works fine. want pull in column names table in addition actual table. figured out names using each fld loop. there's still issue of populating them horizontally in row in excel number of columns might change - i'm thinking need each loop or similar.

sub getdatafromado()  'declare variables'     set objmyconn = new adodb.connection     set objmycmd = new adodb.command     set objmyrecordset = new adodb.recordset  'open connection'     objmyconn.connectionstring = "provider=sqloledb;data source=localhost;user id=abc;password=abc;"     objmyconn.open  'set , excecute sql command'     set objmycmd.activeconnection = objmyconn     objmycmd.commandtext = "select * mytable"     objmycmd.commandtype = adcmdtext     objmycmd.execute  'loop names'     ' here????'  'open recordset'     set objmyrecordset.activeconnection = objmyconn     objmyrecordset.open objmycmd  'copy data excel'     activesheet.range("a1").copyfromrecordset (objmyrecordset)  end sub

my usual code similar:

for intcolindex = 0 objmyrecordset.fields.count - 1      range("a4").offset(0, intcolindex).value = objmyrecordset.fields(intcolindex).name next

Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have
Read more

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

-
i'm using devexpress grid , i'm trying 'country' column display header filter properly: <dx:gridviewdatacolumn caption="country" fieldname="countryname" showincustomizationform="true" visible="false"> <settings allowheaderfilter="true"/> </dx:gridviewdatacolumn> if 'country' column set visible='true', header filter displayed should(it shows value option list). however, want 'country' column hidden, available in customization window(like in code above). in case, when column dragged outside customization window , grid , header filter clicked, javascript error encountered: element null element.addeventlistener(eventname, func, true); is known bug? there workarounds? set aspxgridview.settings.showheaderfilterbutton property true resolve problem. the following markup works fine me (i using dxperience 10.1.7): <asp:accessdatasource id="accessda
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj
Read more