Reading Data from Excel with all column filled gives error

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Winforms
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Thumbnails & Listviews Hi there, I'm currently developing a program to manage my image collection. The main form contains a llistview in which the location and filenames of these images are displayed. When switching the listview to Tile mode, I want to display the thumbnails of these images. My image collection contains over 4.000 images so it doesn't make any sense to populate the needed imagelist with over 4.000 thumbnails. It makes more sense to populate the imagelist with thumbnails of the images which are currently visible in the listview, but how can determine which images (listviewitems) are currently visible in the listview? Further more; how can determine changes in the visibility (after scrolling or browsing)? It should be possible, because I think that Windows Explorer (in tile mode) uses a same sort of technique, but I can't figure it out myself. Can anybody help me out? Thnx Peter Tag: Reading Data from Excel with all column filled gives error Tag: 117478
  - 2
    - Expression Blend I saw in wpf books that Expression Blend is recommended to develop wpf application. In the Expression suit there are some other products. My question- in order to develop desktop application is there any need to the other products and in what way? Is it a must? Is there some article that covers that? Regards Ronny Tag: Reading Data from Excel with all column filled gives error Tag: 117476
  - 3
    - Sort DGV after edit, reposition grid doesn't work when user hits Enter or Tab I have a DataGridView bound to a binding source which is bound to a BindingList<obj>. The first column is [Name], and the user can edit this column. I have it set to be edited programmatically, and have DoubleClick event calling BeginEdit. When the CellEndEdit event is fired, I save the record, re-sort the binding source, go find the record, and set FirstDisplayedScrollingIndex to that row. This works great if the user clicks somewhere else on the grid or the form while he is editing. If the user hits Enter or Tab, it ends up on the next line, or one column over on the same line, and not on the line where I asked for it to be repositioned. I think what is it doing is repositioning programmatically, and then processing the Enter or Tab key and putting the user back in that location. Any ideas how I can handle this to suppress the Enter or Tab keys in this instance? Or if I am wrong in my supposition, what is wrong and how I can fix it? Thanks, RobinS. GoldMail.com Tag: Reading Data from Excel with all column filled gives error Tag: 117474
  - 4
    - Vista controls Hi, I have three questions regarding new Vista controls: 1. How can I create the standard "(v) Show Details" button, like in TaskDialog. 2. How can I create the standard back-forward standard buttons, like in Explorer/MSIE/WMP? 3. How can I create the standard Vista-look toolbar, like in Windows Mail? I could not find the right documentation anywhere. Thank you for your tips. PS: C# preferred, but VB, Java, Delphi, C++ should be ok. Martin Tag: Reading Data from Excel with all column filled gives error Tag: 117473
  - 5
    - Assembly missing in GAC after Publish? Hi, We're using ClickOnce alreaddy more than a year for a given applicaiton, doing more than 50 publishes without any problem. Yesterday we made a minor change to one of our components (let's say with the name MyAssembly), and incremented it's version (AssemblyVersion: from 0.1.7.0 to 0.1.7.1). We did the Publish with ClickOnce, but when the users know want to run the application they get this error: "Unable to install or run the application. The application requires that assembly MyAssembly Version 0.1.7.0 be installed in the Global Assembly Cache (GAC) first." This is so weird, especially when knowing we had alreaddy inremented this version number without any problems in the past. Anybody has any idea? Your help will be really appreciated! Thanks a lot in advance, Pieter Tag: Reading Data from Excel with all column filled gives error Tag: 117467
  - 6
    - C# Winform invocation from Classic ASP page Hi, I have an appilcation which is using C# Winform and classic ASP. Child form only migrated to C# from classic ASP. Hence need to invoke C# winform (child form) from legacy classic ASP form (parent form). Also return values from Child form (C# winform) to Parent form (classic ASP). How can this be achieved OR do I need to migrate parent form (ASP) to C# winform as well?. Please reply back with help/pointers. Thanks Amol Tag: Reading Data from Excel with all column filled gives error Tag: 117463
  - 7
    - FREE Tutorials on HTML XHTML CSS JavaScript XML XSL ASP SQL ADO access all computer tutorials for free visit http://freecomputertutorials2.blogspot.com/ Tag: Reading Data from Excel with all column filled gives error Tag: 117462
  - 8
    - The data area passed to a system call is too small Hi all, I'm trying to create an app that will process several files at once, dropped onto its icon in Explorer. But if I drop too many files at once (e.g. > ~30 files, which equates to 2048 bytes of command line args), the app isn't even launched and I get an alert box saying "The data area passed to a system call is too small". Now I know of several apps that can accept a huge amount of files dropped on them, like for instance Winrar. Is there a trick to increase the internal buffer size for the command line args ? Michel Tag: Reading Data from Excel with all column filled gives error Tag: 117454
  - 9
    - No activity on a form... What is the easiest way of tracking whether there has been any activity on a form at all in a specific time ? I want to have a form that automatically "timeouts" after a period of no activity. I don't really want to have to go through every button, box and catch every mouse-click etc. to know that the user is actively using the form - I just want to be able to somehow have a function called which can then close the form if there has been no activity for a few minutes. I don't actually mind if the "no activity" is just on that form, or I have to rely on no-activity on the whole pc for a period of time.. Many thanks in advance Simon Tag: Reading Data from Excel with all column filled gives error Tag: 117453
  - 10
    - Can anyone recommend a WPF-like control for WinForms? I am needing to develop animated effects in my WinForms application. The trick is that the background of the control needs to be semi- transparent or completely transparent. - WPF through Interop does not allow this, it always shows a black background. - Silverlight will only run in the browser - Is there a Flash alternative ? I have also tried reproducing animations through GDI+ using a single transparent container to add/remove graphical controls, however, there are massive problems with controls not getting destroyed properly. (We're talking about hundreds of icons/controls getting created & destroyed routinely). Thanks Tag: Reading Data from Excel with all column filled gives error Tag: 117443
  - 11
    - Ativate Form Hello, When a window is closed, what is the next window to get activated, and how is that determined? Thanks, Schneider Tag: Reading Data from Excel with all column filled gives error Tag: 117438
  - 12
    - associating value with treenode in vb.net hello everyone, How can I associate a value with a tree node? I have this TreeNode nodeFirstRecord nodeFirstRecord = new TreeNode[dr["location"]] How can I se the value of IndexId to the treeNode in order to retrieve the value later nodeFirstRecord.value = dr["indexId"], I want to do something like this Any help will be greatly apprecaited. Tag: Reading Data from Excel with all column filled gives error Tag: 117436
  - 13
    - IBindingList Filter and DataGridView I do binding collections to DataGridView. It is necessary to do filtration and it is probably needed to realize IBindingList. It would be desirable to see an example, as it is done. http://www.alvas.net - Audio tools for C# and VB.Net developers Tag: Reading Data from Excel with all column filled gives error Tag: 117435
  - 14
    - funny look to tab with bottom alignment When a tab page is made with the tabs aligned at the bottom instead of the default top one gets a funny look and feel. The rounded parts of the tabs continues to be at the top and the square end is at the bottom. One would expect it to be inverted. (This is .NET 2.0 framework and I cannot move to new frameworks due to certain other problems) Is something wrong here ? Anonymous Tag: Reading Data from Excel with all column filled gives error Tag: 117433
  - 15
    - Databinding problem - DisplayName empty I'm having some trouble getting databinding to a ListBox to work correctly. I think the collection I'm trying to bind against is a little odd, so I'm wondering if that could be part of the problem. Below is a sample of the databinding code. AxisCollection axis = GetAxisCollection() myListBox.DataSource = null; myListBox.Items.Clear(); myListBox.DisplayMember = "Attribute.Name"; myListBox.ValueMember = "Attribute.AttributeID"; myListBox.DataSource = attribs; AxisCollection is a collection which derives from List<Axis>. The Axis class looks something like: Attributes Name AttributeID DisplayNumber Attributes is a reference type property for the Axis class. After setting the DataSource property, I notice (using the debugger) that the DisplayMember property changes to an empty string. When I look at the displayed values in the listbox, they are just the name of the class (repeated for each element in the collection). Interestingly, if I change the myListBox.DisplayName to a value type (i.e. "DisplayNumber") on the class, the value is displayed correctly in the ListBox and the DisplayName remains after setting the DataSource. Any ideas on what could be going on would be greatly appreciated. Thanks! Tag: Reading Data from Excel with all column filled gives error Tag: 117425
  - 16
    - TooStripComboBox.Validate event: setting Cancel = true doesn't prevent other toolbar controls from being clicked I have a toolbar with a buncha buttons and a combo box. When the program starts, the combo opens and its mandatory that the user make a selection before continuing. I'm trying to do this with the Validate event, but its not working. If the combo is open and the user clicks a different toolbar button, my code sets Cancel = true and maintains focus on the combo box, but the Click event of the other button still gets executed. The result is not at all what I'm looking for! How can I prevent the other buttons from being clicked? Tag: Reading Data from Excel with all column filled gives error Tag: 117424
  - 17
    - Form created on BackGroundThread Hi, I have some generic module that handles exceptions. simply you call it like this: "LogManager.ErrorMessage(ex)". Worked great, until we now discovered that it isn't Thread-safe. What actially happens is this: A Form is made, labels and buttons are made etc with the exception-details, but when trying to show the Form (MyExceptionForm.ShowDialog) we get an System.Security.SecurityException (see udnerneath for more info). Seems completely normal to me, because we are accessing the UI from another Thread. But how to find a solution? Thanks a lot in advance, Pieter PS 1 : I see 2 possiblities: 1. Call InvokeRequired with Invoke like we usally do when accessing controls from another thread (http://msdn.microsoft.com/en-us/library/ms171728(VS.80).aspx). BUT: MyExceptionForm.InvokeRequired returns false... I guess this is because it has been constructed in a background Thread? 2. To get around this problem: Figure out when we are on a background thread (via Threading.Thread.CurrentThread.IsBackground: is this true??) and than get via an event an an Invoke or something like that on the Main-htread and call the form from there? 3. ... PS 2: The exception when doing a MyExceptionForm.ShowDialog: System.Security.SecurityException was caught Message="Request for the permission of type 'System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed." Source="mscorlib" StackTrace: at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.Windows.Forms.NativeWindow.CreateHandle(CreateParams cp) at System.Windows.Forms.Control.CreateHandle() at System.Windows.Forms.Form.CreateHandle() at System.Windows.Forms.Control.get_Handle() at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at System.Windows.Forms.Form.ShowDialog() at LoggingManager.LogManager.ExceptionToUI(LogException MyException) Tag: Reading Data from Excel with all column filled gives error Tag: 117417
  - 18
    - deadlock when using waitOne in a STA thread Hi, I have the problem described bellow with the calls to WaitHandle.WaitOne causing re-entrancy on main GUI thread (STA) of a .NET application and I would like to find out: - did anybody else run into the same problem? - is it a known issue? is there a fix for it? - is there a workaround for it? - if no fix/workaround I would like to find out the complete list of messages that are being handled (dispatched by ole32.dll OLE/COM message pump) when doing WaitOne on a STA thread. The problem is: I have 2 (or more) calls pending to execute on the main gui thread (I am actually doing Invoke on some control) the first call, at some point does WaitHandle.WaitOne. at this point, if a Windows message comes to the app (like WM_POPUPSYSTEMMENU - 0x0313 ) triggered by a right-click on the task bar icon of the app the following happens: - the app processes this message - the app starts processing other pending messages - like my second invoke - at this point my app is deadlocked, because it is not supposed to enter the second call before finishing processing the first one. - also at this point the entire system is not behaving properly - for example I cannot bring up any window by clicking on the taskbar icon important note: if I would not do right click on the taskbar icon of my app, and just let it work in background, everything would be ok. After investigating this issue for a while, I found that WaitOne is not actually a blocking call when called from an STA thread. The only reference I found related to this matter in MSDN pages is here: http://msdn.microsoft.com/en-us/library/74169f59.aspx . Quoting from that page: "WaitHandle..::.WaitOne,WaitHandle..::.WaitAny, WaitHandle..::.WaitAll, Monitor..::.Enter, Monitor..::.TryEnter, Thread..::.Join, GC..::.WaitForPendingFinalizers, and so on are all responsive to Thread..::.Interrupt and to Thread..::.Abort. Also, if your thread is in a single-threaded apartment, all these managed blocking operations will correctly pump messages in your apartment while your thread is blocked." If the apartment state is STA this function actually creates a message loop that is processing some events (for now I have been able to identify 2 of them (WM_POPUPSYSTEMMENU and WM_ACTIVATEAPP). The problem is that these messages triggers processing of other messages in the queue (like the registered messages used for invoke in .NET ). I have attached a simplified application to demonstrate the issue. In this app I have created a thread from where I am calling multiple times the same function which is suppose to execute on the GUI thread. I have put some console prints to show that it is executing another invoke on the main thread even if it is supposed to stay in the wait. Another thing, in my app the calls to some functions are not supposed to re-enter (and we are protecting them with the waitOnes) but if I modified the sample app (attached to this mail) to have a non-blocking re-entrancy , I noticed if I right click on the taskbar icon while the first call is in waitOne, all the other calls will be executed before the first call ends - this is actually easy to explain since the other calls are not processed by the app message loop but they are processed by the message loop created by the WaitOne. however I don't think this should be the normal behavior - that is: when I invoke 3 calls on some thread, the order of execution should be the order of the invokes. waiting forward for your replies Daniel. begin 666 DeadLockWaitOne.zip M4$L#!!0````(`&-ONSA2]6S&:0,``"@)```F````1&5A9$QO8VM786ET3VYE M+T1E861,;V-K5V%I=$]N92YC<W!R;VJ]5LUNVS@0OA?H.W"-`FF!6C*2;..T ML@#_)0W0;@([:?:0"R6.;+;\`TDUT6[WR?:PC[2OL*1,N5:<I+YL#X'#^3[. M#+\9<?COW_\D%UI^AMRB"12X9/82ZP58,^B,2LI(!]UQ)MQJ::UZ&\<F7P+' M)N(TU]+(PD:YY#&!K\"D`AUSD_EM\7ZO=]!)GS]#R/MWB*U.M2Q5;7+&L10% M790:6RH%<BM"_7^##MI[\;(%OMI#@P':VT.== )9N4CB%MPXO&#8%E+S^[X: M^X:;H:C&%U=)W$!K%UJ2,K>?0!OON!_UHE][1_M'CME&`G]>:]$8]Z->$K=- MW_UZ@4]+2M(_^^/1N'_<GW2/1V\.NH<GHU'WN#\==D_VWTR/1OW)P>'PZ*\Z MXGI/<'->6E7:RTI!.KV#)-Y8!\90J0D8NA"@3R0CH-.@/063Q-MHV#:3TOZ& M.1B%<W B8_)!YE^N,;7GPL5IPTTH8X!GK/+ ]I866C=!O-T%[<9XN@>^;16R M[H5OJU+ZHH:\:O.\XIED)K6Z=,FT3)NT6KJB9"QP-J4\5Y9R^H?#,3->[&;= M*L8%MLLTH^*FWG_3U*0VKR,55( [C;%86)-.IJ.KTW>7L^%XZL.VP;!GJK74 M,U!2VU1IR95-XDU;H%UC+:A8?/ ?7WJ8Q*UUX%P9^#1_+XUU@-,[!V.:(ST$ M_3^UF@$#;."1:M6R*Y))P:JG*K&JY@\*$4+M5(J?4X0'Y3RSP%OWX0P*T"!R M0&<B9R6!06=>&<?JH/B'G&B"+=Z-J/&MRVXG[C451-Z:Z,05TNRTXW?.&EX2 MMX^X?>*QDY2R#2=.IH7&/,I-TQ^.-2^SNAE\$NYZ#:O@(@X^GG(9KK^;YDHZ M$X7T(7;.<\HS( 3(#(PL=?Y PAK,W0,I-Y?M_;3K3E0@" A[I=R8^'YPWXR; M2'/.^SD\DCKWC8G"Z!AT7KS\.*^'^(@*_QV\NOFXGMKC^1)K%=G5L%^K\4NW MBRXEXI+0HD*5"X;J>8[4ZH)XC3 A*[O%Y@NBPE "2 KW5R"[!!0\HLP]"&X1 M%@25PCT1N#L2HC9"C0;HW+$U,NYC9E@CN+,@_-!$2E+W%3H#-?8U,@!H(VOG M2(HFZZA.>?5>07[4N#<+N&L'5B^7(-(*3[>YP\*"?HS:[;J?]1A._P-02P,$ M% ````@`8V^[.#$>KM2Z````^0```"L```!$96%D3&]C:U=A:71/;F4O1&5A M9$QO8VM786ET3VYE+F-S<')O:BYU<V5R=8]-"L(P$(7W@G<(16B[,:([,051 M<=M-#Y"VTS229$I^Q$)OYL(C>07;NG+A<K[W^'CS?KX.N<4;5)X\M#*.1:WW MW9Y25[6@N5MK65ETV/AUA9K6< >%'5BJ71FDJNEVL]E%V7)!R"0:$]]?+8:. MG-#4TDLT+"+Q*AG/1HI@^832897DBOL&K4YCPAB)SU &,1Q-?\J+F'R-H_-B M>*F@,)H;+J">6T(:D7D;X$#_QO,@^K-H9#.9GLT^4$L#!!0````(`"MRQ3BB M^H,SNP,``-,,```:````1&5A9$QO8VM786ET3VYE+U!R;V=R86TN8W.M5DM/ M&S$0OD?*?QC1RZ*F"X&^$8<0:!L)*"(4#@A59G<(+HZ]M;T)%.6_=[R["?M, MHJISV(=G/._Y[-AP.8+AD[$XWFNWXMROWU="8&"YDL;_BA(U#ZHBXTA)E/9$ MA2C*W$-F665-LRG]EI<O\-&6UZZX#-74^%^4'IO*AGN-+$PUM5N2C=%$+$ X MI-5C%3Q<,6Z_2VRWGH&HW7+/*+X5/("(:<N9@$ P8\!I[\+GY)V*/:<O1Z\T MCBA^TFKXB#+PPHDTGS"+<!!;2P*WR:N[MQ#(2:96$SO>YLMZSHRC@>3.*_X' M%TGU-E_TP<S%N="969\H'M;O;+1C[[GQ,W=A'R1.:_/MIX$57%AL'\8F0AD> MLR<5VXK(UA94%C*#*P3SOOE41>::K^ADUC_^F>(49G>G`]V=6A_G:DZI-4C% M1O:_L4QV2#FL-^<XWL?W'=CM+K5VP6X',L1'TK*]5([Z?5VO?AB\Y"9F8FB? M!!ZPX($F4VG:;G6,RW;VJ?$>X'4AHJ,)]<<W)D.!VLM+_TRDUREFTLKKE)(T MDK$56=WY1$7<^;!;F]>^DE8K8?Q>&!:\K96>USIQL#:GYVCB,6:->\>$P<V] M_&#-<K-/'5X9_[SL'!Q.GJ!/\-<PG87L>NKV%T$J&-*-N@-),7IZ9 ";)[:, M>-D7V&)2RWR/$!E'Y$<>#&K4.[)H:)C*.5UP*A.VX%2JMN"\;>2\*W-FQ=]* M:?V!<5T_TBJ684/;^T-+L+X:,>=)28MS0?X<SM-$@ (!$^)4Y;7,-QI+:!2 M$Z*:H>Z3,[8TYH7")['F=#;6EWK<*('^E>86C[E$;^/(67"E]'UXWIYM=&H< M<\3OP$L;>R GZ@'/\7?,-8:PNN0'U+PRW>6Y+BJDPOF^V634D48;:UFM8\F] M0K(NF8C=> [<BJ S&D-R.] X=B>6QKN<;-EF4XXH5,H/O('G[@PL'^,B59VR MY;+*%4/6BZTBM$";S"C@I&G:BH)UH.*(`)**1; #@1J[@($0B$J'I)2.`D$A M)=PI%X+@`8G%4K[2!!6@*#N/&,3)B1C<,SE"0V%3J*5 DI:H)'T?NFOTQ/]& MF@8SCM*=_E @1EYWFZBNS1SAQ!]B]9;A:%:+,6O 12I7A0Q')30B\]E=TJM6 MM:XM'^GSW[MR^;@<XNIQJ3_""H=4)I)_9K?4]$Y\IM5(L^IU^'IXT4L+=_.R MF.W,\#&!OA/&I6>L0[#K&V!TOJT\W8J7SUX4D<[D^N>?QS(!J.P"71-J@CNS M]'!NM_X"4$L#!!0````(`/==NSBB/YBZS@4``+86```<````1&5A9$QO8VM7 M86ET3VYE+U!R;V=R86TN<F5S>-586V_;-A1^'[#_<*:'[266XEX3PW:!IBU0 M;&V')E@+#'N@9<;B2I$J2<7V?OT.#RE9OB5QD@Y=`O@B'G[GRN\<<_AB44JX MXL8*K49)/SU.@*M<3X6:C9+:7?9.DA?C'W\8&JT=O@,,?^KUP'\`>"=RHZV^ M=/"1V\]PGA>\9'$MO/X1@.%1>MQ]?%%PJ(PHF5G"3#-I05^"*X2%2VU*Y@`_ M.0U,2CT'!E:4E>3P^=UOS7J <440+;5U<@E%73(%AK,IFTB>DI895]PPYVU@ M:@H50WO4+*CC$>:*&:%K"U/F&+AEQ2TPPV&J%4<IH^M90=(7N'2F%0;+<0.Y M9-:B:,# SSH7S/$IS(4+\BN\M.O\ZP7S[@RZS](T!3;5J>(N\VX6Z 2&#GX& M&X**`D%R:+@-JZ!8R4<)?B]%R;V>9.SXPF5EDY8>KBV&6;MCO <BIC\98YIN M(6[H2S(^7UK'RQ1SKVN3HY>^"IIO'TGH"*+0)Z&F>F[3-Y@_>^3=N86BN1'N M1D6?2.@P1929H.,]OO:3\?"*R9J/J09]12U!:JP3ZPR6RS +J\-<ER57KA5C M$)\,LV9IF'GP'8K.M-2FGU!!C))H[2O#YJ@@I<76A_@T&;]$K7L!7PI7L@H1 MF_2/$E954N14[MFBU]:!+ZM43_[FN4LG0N&I2R?,\F=/D@A+T,''/\,*@08F MP)*VW @FQ3_X,7W_^@+>&+1@KLT7"*A_-1&*5NXS^6VNU;X0^+6M"!SHV])Q M9@P[V#W*,C)'A96"2?1?&'@T(#ABG88S;A,`4MA4Q,7^8MD1KNY?2Y:&$R,Q MM015EQ,\(&A,TI9U`@9+/M A1M$QH1K.#! ^^L% 9$!A-OB(Y47@*D1I]GMS M_:XCHDW:&@C5RR!AZZY@9&-,$VC3IBPEPD0Y@X966DT#IX<`$GL&BVU=5=JT MG.X9+)B:$]=2_]A/P\SD!1) [FJ#&@/&6:1F@D<:_V6EA$ZNCV6GI+V'UFG3 MY>X`U+B"TFXM9CX2[2(BUA8W8Y5T84-EV!!!QZ6T'>1MJH0"(XL!FO+*.VT= M2<?*AJ:(\AJCJ7RW4[H)&4:,*RNHYR'M88AGXHJKE8$>*(2TK!%W0OX`RS$U MOL_+Y5HO>J^Q[GMP*)=0ST9%VQW:/]UF;(RUE$U_QCI#]SGFE*1#AX$<VWG M\0^H_.,A#$HL2(P3AGK"<5!82U#C^^!@/\+^$"Z `:4ZR'6BUR:9"F;]Y X: M$OM8(Y64/#V/XF0#-2;F, `V?1GTAK?V^28:E4^!^6SHBG3&H#>SVMV=MYI5 M_[WKYUZK?[FWVW?)]T:?.,QOH8C&.NUAT_3:A@X2@W&F2Z0_/+7OT ^9KO'7 M?9+=ZX6!?&&G@S@FBBF.9SBI)X!CO;*C)'X8H,PH*9RK!EDVG\_3^>-4FUGV MZ/BX[P?.,+HWPJ7U[0#'?Z,BL%T%LH?-:X!RO2#5]%BR`GN.)UG?.&S%<KY+ M)6K+^J>G)UDKE4#6!>&2^^;8#)OD3= U>&M?X=LY=Z/$F9JO^CMM1,.PY2U\ M?+M]F)8*+7*D/[;XD".%8F!J-=&UP@@G:XUWAP586*SKZ3KP3IT=`<N_UIBW M[=6=NJ@&FP&)MM-HXN<@U5A^O(I7!RN[5AFIPF-FQ*3&L@W*_&OB6Y<?Z;_6 M`AO@+M4[E.U"HQ\@=]_>_H:Y"X3AE[BCE(.->FK%L^MR%59C(FZJ!C]9E!.Y MO%LU;'J-E,+L/:(64GCS]@<,P'=V%"(S?/"3#).CI+\K=CL5Q"'\<!6/'O8` M;JO?.)*W<O&@,[F)^/A!CNDFZI/OZ^2N?B[]SZKW&Y;6PX0[[J(>VS[>![4- M$OVC02,\N/:.*\+$"YM=%UZKG^*;=S_[K[[64.D>[ `4LU97$>0>UV/QVG2$ M=OC_(SBKI?^!.U*\=H;)(_B]GN"4^RM?7N@O7(TFSY^SI_G39_W3QT_X\<GI M0=8WUVRWM_[Z.[=O:#U^\_?0_P)02P,$"@``````W*V]. `````````````` M`!L```!$96%D3&]C:U=A:71/;F4O4')O<&5R=&EE<R]02P,$% ````@`AER[ M.$(3,JLZ`@``_@0``"H```!$96%D3&]C:U=A:71/;F4O4')O<&5R=&EE<R]! M<W-E;6)L>4EN9F\N8W.-5,%NTT 0O5?J/XQR"A))TU)*6TZ0BBH2I:@MY8 X MK.W99-OUCK4[V]:?Q#=P0.*'^ 5F-TF=B :(#QFOW[QYXWGC7]]_Q&#<%"[; MP%@/+U!;+-F0>[V]M?XD.C8U#L=4-\:BOT1_9TH,FW 3Q^BI68%M;^WLP"DZ M],K"Q&GRM4J50!44&90$(6!=V!9,@)(<>[(6*^"9ISB=R3^"EB.Z3_4R74 & MTJ"8O2DB8QC">*;<%!,X8/<`[I2-&( ):JJ,;C.;Z51D.A% I5$L1>\-SU8U M#;>WOBSC8WBSB*X,6^SW3E!5[ZF\_:P,GSOL/?OZ)/H$0^E-D\KU>YM 8W+: M3*-7_X+5C7+M9L!'3U4L^;_%C:EIO9G.).,QA)_?`/9&H\--25=>55@K?_L7 MH=%R]+@`Y-=\B<QIA-+#M0FFL)CFHI65B=7J-HU)AL-M(Y%Q<B-^>/2&(X:[ M159FD]3Q^9D8IF[(H6/Q`$PTM!3!8;(/@2K%@L*1.?^DU)[J.9<0/<^F2@)6 MY'4^$C;V$8$2B>+,N.Z-+JV?6WIL^VK-OZ>?)B?)Z.+ 7$WNQ,G+QJTIP.BY MSL;3C2QE`N-#0V'>DTA=*WL:3=7O[:O#T>Z+HASHO0('^]61'A2X>S2H7NJ# M5WB@<4_M=X.X1A_2!J[L0=:SNHNRB,$$#DMU70>:HE_LU7&BRY3Y=Z9NA&7! MOG)L7'<,W?G;:&P%'V)=H.].+S"->9[_I+,61/W>[G"4KDT.?"??JR>QOP%0 M2P,$"@``````*W+%. ```````````````! ```!$96%D3&]C:U=A:71/;F4O M4$L#!!0````(`(=<NSA.`2^[9@$``*8#```3````1&5A9$QO8VM786ET3VYE M+G-L;J6204^#,!B&SY+P'PA>9K*2;L,-#AYHH7J8NDC4BY<.RE*M=(%B8N9^ MF0=_DG_!$K<YV&+,O/&]??M]S_>6S_</T[CD22%+F2GKCI<5%5:LJI1+*Y:B M4ESF%N&"=2TBBV>J/:PH:]%W(#2-X]:=/H2GIC$IY"-+5,=>D""";H0A&, > M`;U>. "(N A B*%+1GY$$%[:)]:998>,IF.9/-U3KJYS9G=WI(=6[23E7$^J MG0L/(^SY7@A\-!P`ER $?"\*`.D/HQ'RPH$;C):V:41YNJ(SC7,AIU28QM'W M1ZQ%O5EGO3>6><9G54'K8B*HRG0"9<TZ+]C:I&\?A6Q:S=Z"_-7"DUM]W*AK MPPT3C)9LR])2M$F#-3!VL%;8OU#)4FUC_2T3IT'K!'K8"\/9;-\>!W5$%1>I M`__1KQ56@W$WR$.[_G >\#CKW/4CS5FA.-OWGUSP=%-?R91I!PG&<;1WP$8Q MC2]02P$"% `4````" !C;[LX4O5LQFD#```H"0``)@`````````!`" ````` M````1&5A9$QO8VM786ET3VYE+T1E861,;V-K5V%I=$]N92YC<W!R;VI02P$" M% `4````" !C;[LX,1ZNU+H```#Y````*P`````````!`" ```"M`P``1&5A M9$QO8VM786ET3VYE+T1E861,;V-K5V%I=$]N92YC<W!R;VHN=7-E<E!+`0(4 M`!0````(`"MRQ3BB^H,SNP,``-,,```:``````````$`( ```+ $``!$96%D M3&]C:U=A:71/;F4O4')O9W)A;2YC<U!+`0(4`!0````(`/==NSBB/YBZS@4` M`+86```<``````````$`( ```*,(``!$96%D3&]C:U=A:71/;F4O4')O9W)A M;2YR97-X4$L!`A0`"@``````W*V]. ```````````````!L````````````0 M````JPX``$1E861,;V-K5V%I=$]N92]0<F]P97)T:65S+U!+`0(4`!0````( M`(9<NSA"$S*K.@(``/X$```J``````````$`( ```.0.``!$96%D3&]C:U=A M:71/;F4O4')O<&5R=&EE<R]!<W-E;6)L>4EN9F\N8W-02P$"% `*```````K M<L4X````````````````$ ```````````! ```!F$0``1&5A9$QO8VM786ET M3VYE+U!+`0(4`!0````(`(=<NSA.`2^[9@$``*8#```3``````````$`( `` M`)01``!$96%D3&]C:U=A:71/;F4N<VQN4$L%!@`````(``@`7P(``"L3```` !```` ` end Tag: Reading Data from Excel with all column filled gives error Tag: 117415
  - 19
    - ProgressBar and Form loading Hello, I don't know if such question was already posted but I didn't find anything through different posts. I have the Main MDI window with a StatusBar. Inside my StatusBar there is a ProgressBar. When I click on the menu in my MDI Parent, a child form is loaded. I would like to know if there is a way to increment a progressbar value while child form is loading ? I tried to use background worker but i had some cross thread access exceptions. any ideas ? Thanks in advance. Thomas -- Thomas JASKULA - NODEVO 1, avenue du Général de Gaulle 60500 - Chantilly Tag: Reading Data from Excel with all column filled gives error Tag: 117414
  - 20
    - Redirecting to ClickOnce application fails Hello, We have implemented a few years ago a "zero touch" deployed smart client application for .NET 1.1. We ported now this application to .NET 2.0 and deploying it with ClickOnce. Because we have still .NET 1.1 clients around, we made a small ASP.NET startup application that checks host header values and redirects (Response.Redirect(...)) to the .application file in case the client has .NET 2.0 installed. Otherwise it will launch the old smart client on a web page. This all works fine as long as we start the ASP.NET startup page (let's call it StartClient.aspx) from within Internet Explorer. If we put a link to the startup page into an e-mail or just on the desktop launching the ClickOnce client with this link fails with a "Cannot Start Application" message box. The details say: SOURCES Deployment url : https://myserver/Client/StartClient.aspx ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of https://myserver/Client/StartClient.aspx resulted in exception. Following failure messages were detected: + Downloading https://myserver/Client/StartClient.aspx did not succeed. + The remote server returned an error: (403) Forbidden. The deployment url is the startup page and not the .application manifest file as we would expect. When checking IIS logs, we can find first a request to StartClient.aspx, second a request to https://myserver/ClickOnceClient/MyApp.application (the manifest), and a third request back to StartClient.aspx. This third request doesn't happen when we access the aspx page from within Internet Explorer (where, as mentioned before, everything works as expected). It seems like it only partially redirects when launching from a hyperlink in a document. Thanks for your help in advance, Jürgen Tag: Reading Data from Excel with all column filled gives error Tag: 117413
  - 21
    - Checking whether or not checkbox on web page is checked Let's say that I use the following code to get a reference to a checkbox on a web page in a WebBrowser control: Dim oHtmlElement As HtmlElement oHtmlElement = WebBrowser1.Document.GetElementById("chkThrowInTheTowel") How can I tell if the checkbox is checked or not? oHtmlElement.Checked is not an option, so how would I do this? Tag: Reading Data from Excel with all column filled gives error Tag: 117412
  - 22
    - Restarting app Hi Is there a way to restart a winform app in case of a serious error? Thanks Regards Tag: Reading Data from Excel with all column filled gives error Tag: 117409
  - 23
    - System.Collections ' i face the following problem while using different types of system collection classes while using Hashtables as shown in the example below, the week days will be shown in combobox1 start with "Wed" and will start with "Sat" while using Stack and other collections are ok I wonder if i miss something here, or what is going on Exactly i.am using VS2008 if that help ----------------------------------------- Case 1 - Hashtable ' ' Create a new Hashtable. Dim Hweeks As New Hashtable() ' Add some elements to the Hashtable Hweeks.Add("1", "Sun") Hweeks.Add("2", "Mon") Hweeks.Add("3", "Tue") Hweeks.Add("4", "Wed") Hweeks.Add("5", "Thu") Hweeks.Add("6", "Fri") Hweeks.Add("7", "Sat") ' ' Create a new DictionaryEntry. Dim Hday As DictionaryEntry For Each Hday In Hweeks ComboBox1.Items.Add(Hday.Value) Next ' Case 2 - Stack ' ' Create a new Stack. Dim stackTable As New Stack() ' Add some elements to the Stack stackTable.Push("Sun") stackTable.Push("Mon") stackTable.Push("Tue") stackTable.Push("Wed") stackTable.Push("Thu") stackTable.Push("Fri") stackTable.Push("Sat") For s As Integer = 0 To stackTable.Count - 1 ComboBox2.Items.Add(stackTable.ToArray(s)) Next ------------------------------------------------------------------------------------------ ' Case 3 - Queue ' ' Create a new Queue. Dim queueList As New Queue() ' Add some elements to the Queue queueList.Enqueue("Sun") queueList.Enqueue("Mon") queueList.Enqueue("Tue") queueList.Enqueue("Wed") queueList.Enqueue("Thu") queueList.Enqueue("Fri") queueList.Enqueue("Sat") For q As Integer = 0 To queueList.Count - 1 ComboBox3.Items.Add(queueList.ToArray(q)) Next ' Case 4 - ArrayList ' ' Create a new ArrayList. Dim ItemList As New ArrayList() ' Add some elements to the ArrayList ItemList.Add("Sun") ItemList.Add("Mon") ItemList.Add("Tue") ItemList.Add("Wed") ItemList.Add("Thu") ItemList.Add("Fri") ItemList.Add("Sat") For a As Integer = 0 To ItemList.Count - 1 ComboBox4.Items.Add(ItemList.Item(a)) Next ' Case 5 - DictionaryOfString ' ' Create a new dictionary of strings. Dim DictionaryOfString As New Dictionary(Of String, String) ' Add some elements to the dictionary. DictionaryOfString.Add("1", "Sun") DictionaryOfString.Add("2", "Mon") DictionaryOfString.Add("3", "Tue") DictionaryOfString.Add("4", "Wed") DictionaryOfString.Add("5", "Thu") DictionaryOfString.Add("6", "Fri") DictionaryOfString.Add("7", "Sat") For Each kvp As KeyValuePair(Of String, String) In DictionaryOfString ComboBox5.Items.Add(kvp.Value) Next ' Case 6 - SortedList ' ' Creates and initializes a new SortedList. Dim SL As New SortedList() ' Add some elements to the SortedList. SL.Add("1", "Sun") SL.Add("2", "Mon") SL.Add("3", "Tue") SL.Add("4", "Wed") SL.Add("5", "Thu") SL.Add("6", "Fri") SL.Add("7", "Sat") For l = 0 To SL.Count - 1 ComboBox6.Items.Add(SL.GetByIndex(l)) Next thanks Omar Tag: Reading Data from Excel with all column filled gives error Tag: 117406
  - 24
    - windows vista serrvice pack1 I just formated-I was wondering if I were to install all updates before SP1 -- zeaus Tag: Reading Data from Excel with all column filled gives error Tag: 117405
  - 25
    - Binding DataGridView after Filtering Hi, I have no idea why the datagrid does not display correct information. I have a load button which loads all data based on query (i have observed 100), then I have a textbox and a button to passing in filter and it displays appropriate records. Now if i click the load button again, it does not load all data but shows only the filtered data that was used during filtering process. I am attaching the sample code. Please help, Stephen private void btn_Load_Click(object sender, EventArgs e) <--- loading all records { DataSet _dsEmployees = returnDataset(); _dsEmployees = returnDataset(); myGridView.DataSource = _dsEmployees.Tables[0]; } private DataSet returnDataset() <--- this does work { dsEmployees = (DataSet)CacheKeys.Cache[CacheKeys.EmployeeDS]; if (dsEmployees == null) { dsEmployees = OracleDataRetrieval.GetEmployeeDataSet(GetSQL()); CacheKeys.Cache.Insert(CacheKeys.EmployeeDS, dsEmployees, null, DateTime.Now.AddMinutes(5), System.Web.Caching.Cache.NoSlidingExpiration); } return dsEmployees; } private void btn_Filter_Click(object sender, EventArgs e) <-- filtering data { string filterSQL = txt_Filter.Text.Trim(); DataSet _dsEmployee = returnDataset(); DataView _dvEmployee = _dsEmployee.Tables[0].DefaultView; _dvEmployee.AllowNew = false; _dvEmployee.AllowDelete = true; _dvEmployee.Sort = "FIRST_NAME ASC, LAST_NAME ASC"; _dvEmployee.RowFilter = "LAST_NAME LIKE '" + filterSQL + "*'"; if (_dvEmployee.Count != 0) myGridView.DataSource = _dvEmployee; } Tag: Reading Data from Excel with all column filled gives error Tag: 117404
- Next
  - 1
    - Custom DataGridView and keyboard input - C# VS2005 Hello, I work in VS2005 in C#. I have a problem with my custom DataGridView and keyboard input. I am trying to catch user input and search through current column. Everything works fine with searching. The problem is when I press one of non-english letters or number from numeric keyboard I do not get character that I pressed. For example: I press key with code 0x010D but catch it as 0x00BA. One good example: when I press 'e' or 'E' (Shift+e) I get inputChat = 'E', msg.WParam = 0x45, msg.LParam = 0x120001 This is the method where I do that: protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { char inputChar = (char)((ushort)msg.WParam.ToInt32()); // msg.WParam is 0x00BA but it should be 0x010D // msg.LParam is 0x270001 ... } Here are the questions: 1. Is there a way to extract the correct code for the pressed key from msg parameter and its properties? 2. Is there a better place (method) to catch a keyboard input? I would appreciate any suggestion, Vlado P.S. When I catch keyboard input in one of my other custom controls I use ProcessKeyPreview and everything works fine, but ProcessKeyPreview is not good in DataGridView. Tag: Reading Data from Excel with all column filled gives error Tag: 117403
  - 2
    - Is there any modern way to create a DSN using Dot Net? I'm looking for a way to programmatically create an ODBC DSN in Dot Net 2.0. Has anyone done anything like this? (All of the references that I've found so far seem hopelessly dated, as old as VB4, and I'm not sure I can make them work in Dot Net. ) Tag: Reading Data from Excel with all column filled gives error Tag: 117402
  - 3
    - can not log on after removing malware After running some malware removal software to remove registary enteries put there by malware alarm 2008. my daughter can not log into her computer. she gets a welcome screen with administrator on it and when she clicks on it it does something then goes back to the screen. also, where does she go on microsoft site to down load a startup disk for the window xp media ( or multimedia) edition?? Tag: Reading Data from Excel with all column filled gives error Tag: 117398
  - 4
    - deadlock when using waitOne in a STA thread Hi, I have the problem described bellow with the calls to WaitHandle.WaitOne causing re-entrancy on main GUI thread (STA) of a .NET application and I would like to find out: - did anybody else run into the same problem? - is it a known issue? is there a fix for it? - is there a workaround for it? - if no fix/workaround I would like to find out the complete list of messages that are being handled (dispatched by ole32.dll OLE/COM message pump) when doing WaitOne on a STA thread. The problem is: I have 2 (or more) calls pending to execute on the main gui thread (I am actually doing Invoke on some control) the first call, at some point does WaitHandle.WaitOne. at this point, if a Windows message comes to the app (like WM_POPUPSYSTEMMENU - 0x0313 ) triggered by a right-click on the task bar icon of the app the following happens: - the app processes this message - the app starts processing other pending messages - like my second invoke - at this point my app is deadlocked, because it is not supposed to enter the second call before finishing processing the first one. - also at this point the entire system is not behaving properly - for example I cannot bring up any window by clicking on the taskbar icon important note: if I would not do right click on the taskbar icon of my app, and just let it work in background, everything would be ok. After investigating this issue for a while, I found that WaitOne is not actually a blocking call when called from an STA thread. The only reference I found related to this matter in MSDN pages is here: http://msdn.microsoft.com/en-us/library/74169f59.aspx . Quoting from that page: "WaitHandle..::.WaitOne,WaitHandle..::.WaitAny, WaitHandle..::.WaitAll, Monitor..::.Enter, Monitor..::.TryEnter, Thread..::.Join, GC..::.WaitForPendingFinalizers, and so on are all responsive to Thread..::.Interrupt and to Thread..::.Abort. Also, if your thread is in a single-threaded apartment, all these managed blocking operations will correctly pump messages in your apartment while your thread is blocked." If the apartment state is STA this function actually creates a message loop that is processing some events (for now I have been able to identify 2 of them (WM_POPUPSYSTEMMENU and WM_ACTIVATEAPP). The problem is that these messages triggers processing of other messages in the queue (like the registered messages used for invoke in .NET ). I have attached a simplified application to demonstrate the issue. In this app I have created a thread from where I am calling multiple times the same function which is suppose to execute on the GUI thread. I have put some console prints to show that it is executing another invoke on the main thread even if it is supposed to stay in the wait. Another thing, in my app the calls to some functions are not supposed to re-enter (and we are protecting them with the waitOnes) but if I modified the sample app (attached to this mail) to have a non-blocking re-entrancy , I noticed if I right click on the taskbar icon while the first call is in waitOne, all the other calls will be executed before the first call ends - this is actually easy to explain since the other calls are not processed by the app message loop but they are processed by the message loop created by the WaitOne. however I don't think this should be the normal behavior - that is: when I invoke 3 calls on some thread, the order of execution should be the order of the invokes. waiting forward for your replies Daniel. begin 666 DeadLockWaitOne.zip M4$L#!!0````(`&-ONSA2]6S&:0,``"@)```F````1&5A9$QO8VM786ET3VYE M+T1E861,;V-K5V%I=$]N92YC<W!R;VJ]5LUNVS@0OA?H.W"-`FF!6C*2;..T ML@#_)0W0;@([:?:0"R6.;+;\`TDUT6[WR?:PC[2OL*1,N5:<I+YL#X'#^3[. M#+\9<?COW_\D%UI^AMRB"12X9/82ZP58,^B,2LI(!]UQ)MQJ::UZ&\<F7P+' M)N(TU]+(PD:YY#&!K\"D`AUSD_EM\7ZO=]!)GS]#R/MWB*U.M2Q5;7+&L10% M790:6RH%<BM"_7^##MI[\;(%OMI#@P':VT.== )9N4CB%MPXO&#8%E+S^[X: M^X:;H:C&%U=)W$!K%UJ2,K>?0!OON!_UHE][1_M'CME&`G]>:]$8]Z->$K=- MW_UZ@4]+2M(_^^/1N'_<GW2/1V\.NH<GHU'WN#\==D_VWTR/1OW)P>'PZ*\Z MXGI/<'->6E7:RTI!.KV#)-Y8!\90J0D8NA"@3R0CH-.@/063Q-MHV#:3TOZ& M.1B%<W B8_)!YE^N,;7GPL5IPTTH8X!GK/+ ]I866C=!O-T%[<9XN@>^;16R M[H5OJU+ZHH:\:O.\XIED)K6Z=,FT3)NT6KJB9"QP-J4\5Y9R^H?#,3->[&;= M*L8%MLLTH^*FWG_3U*0VKR,55( [C;%86)-.IJ.KTW>7L^%XZL.VP;!GJK74 M,U!2VU1IR95-XDU;H%UC+:A8?/ ?7WJ8Q*UUX%P9^#1_+XUU@-,[!V.:(ST$ M_3^UF@$#;."1:M6R*Y))P:JG*K&JY@\*$4+M5(J?4X0'Y3RSP%OWX0P*T"!R M0&<B9R6!06=>&<?JH/B'G&B"+=Z-J/&MRVXG[C451-Z:Z,05TNRTXW?.&EX2 MMX^X?>*QDY2R#2=.IH7&/,I-TQ^.-2^SNAE\$NYZ#:O@(@X^GG(9KK^;YDHZ M$X7T(7;.<\HS( 3(#(PL=?Y PAK,W0,I-Y?M_;3K3E0@" A[I=R8^'YPWXR; M2'/.^SD\DCKWC8G"Z!AT7KS\.*^'^(@*_QV\NOFXGMKC^1)K%=G5L%^K\4NW MBRXEXI+0HD*5"X;J>8[4ZH)XC3 A*[O%Y@NBPE "2 KW5R"[!!0\HLP]"&X1 M%@25PCT1N#L2HC9"C0;HW+$U,NYC9E@CN+,@_-!$2E+W%3H#-?8U,@!H(VOG M2(HFZZA.>?5>07[4N#<+N&L'5B^7(-(*3[>YP\*"?HS:[;J?]1A._P-02P,$ M% ````@`8V^[.#$>KM2Z````^0```"L```!$96%D3&]C:U=A:71/;F4O1&5A M9$QO8VM786ET3VYE+F-S<')O:BYU<V5R=8]-"L(P$(7W@G<(16B[,:([,051 M<=M-#Y"VTS229$I^Q$)OYL(C>07;NG+A<K[W^'CS?KX.N<4;5)X\M#*.1:WW MW9Y25[6@N5MK65ETV/AUA9K6< >%'5BJ71FDJNEVL]E%V7)!R"0:$]]?+8:. MG-#4TDLT+"+Q*AG/1HI@^832897DBOL&K4YCPAB)SU &,1Q-?\J+F'R-H_-B M>*F@,)H;+J">6T(:D7D;X$#_QO,@^K-H9#.9GLT^4$L#!!0````(`"MRQ3BB M^H,SNP,``-,,```:````1&5A9$QO8VM786ET3VYE+U!R;V=R86TN8W.M5DM/ M&S$0OD?*?QC1RZ*F"X&^$8<0:!L)*"(4#@A59G<(+HZ]M;T)%.6_=[R["?M, MHJISV(=G/._Y[-AP.8+AD[$XWFNWXMROWU="8&"YDL;_BA(U#ZHBXTA)E/9$ MA2C*W$-F665-LRG]EI<O\-&6UZZX#-74^%^4'IO*AGN-+$PUM5N2C=%$+$ X MI-5C%3Q<,6Z_2VRWGH&HW7+/*+X5/("(:<N9@$ P8\!I[\+GY)V*/:<O1Z\T MCBA^TFKXB#+PPHDTGS"+<!!;2P*WR:N[MQ#(2:96$SO>YLMZSHRC@>3.*_X' M%TGU-E_TP<S%N="969\H'M;O;+1C[[GQ,W=A'R1.:_/MIX$57%AL'\8F0AD> MLR<5VXK(UA94%C*#*P3SOOE41>::K^ADUC_^F>(49G>G`]V=6A_G:DZI-4C% M1O:_L4QV2#FL-^<XWL?W'=CM+K5VP6X',L1'TK*]5([Z?5VO?AB\Y"9F8FB? M!!ZPX($F4VG:;G6,RW;VJ?$>X'4AHJ,)]<<W)D.!VLM+_TRDUREFTLKKE)(T MDK$56=WY1$7<^;!;F]>^DE8K8?Q>&!:\K96>USIQL#:GYVCB,6:->\>$P<V] M_&#-<K-/'5X9_[SL'!Q.GJ!/\-<PG87L>NKV%T$J&-*-N@-),7IZ9 ";)[:, M>-D7V&)2RWR/$!E'Y$<>#&K4.[)H:)C*.5UP*A.VX%2JMN"\;>2\*W-FQ=]* M:?V!<5T_TBJ684/;^T-+L+X:,>=)28MS0?X<SM-$@ (!$^)4Y;7,-QI+:!2 M$Z*:H>Z3,[8TYH7")['F=#;6EWK<*('^E>86C[E$;^/(67"E]'UXWIYM=&H< M<\3OP$L;>R GZ@'/\7?,-8:PNN0'U+PRW>6Y+BJDPOF^V634D48;:UFM8\F] M0K(NF8C=> [<BJ S&D-R.] X=B>6QKN<;-EF4XXH5,H/O('G[@PL'^,B59VR MY;+*%4/6BZTBM$";S"C@I&G:BH)UH.*(`)**1; #@1J[@($0B$J'I)2.`D$A M)=PI%X+@`8G%4K[2!!6@*#N/&,3)B1C<,SE"0V%3J*5 DI:H)'T?NFOTQ/]& MF@8SCM*=_E @1EYWFZBNS1SAQ!]B]9;A:%:+,6O 12I7A0Q')30B\]E=TJM6 MM:XM'^GSW[MR^;@<XNIQJ3_""H=4)I)_9K?4]$Y\IM5(L^IU^'IXT4L+=_.R MF.W,\#&!OA/&I6>L0[#K&V!TOJT\W8J7SUX4D<[D^N>?QS(!J.P"71-J@CNS M]'!NM_X"4$L#!!0````(`/==NSBB/YBZS@4``+86```<````1&5A9$QO8VM7 M86ET3VYE+U!R;V=R86TN<F5S>-586V_;-A1^'[#_<*:'[266XEX3PW:!IBU0 M;&V')E@+#'N@9<;B2I$J2<7V?OT.#RE9OB5QD@Y=`O@B'G[GRN\<<_AB44JX MXL8*K49)/SU.@*M<3X6:C9+:7?9.DA?C'W\8&JT=O@,,?^KUP'\`>"=RHZV^ M=/"1V\]PGA>\9'$MO/X1@.%1>MQ]?%%PJ(PHF5G"3#-I05^"*X2%2VU*Y@`_ M.0U,2CT'!E:4E>3P^=UOS7J <440+;5U<@E%73(%AK,IFTB>DI895]PPYVU@ M:@H50WO4+*CC$>:*&:%K"U/F&+AEQ2TPPV&J%4<IH^M90=(7N'2F%0;+<0.Y M9-:B:,# SSH7S/$IS(4+\BN\M.O\ZP7S[@RZS](T!3;5J>(N\VX6Z 2&#GX& M&X**`D%R:+@-JZ!8R4<)?B]%R;V>9.SXPF5EDY8>KBV&6;MCO <BIC\98YIN M(6[H2S(^7UK'RQ1SKVN3HY>^"IIO'TGH"*+0)Z&F>F[3-Y@_>^3=N86BN1'N M1D6?2.@P1929H.,]OO:3\?"*R9J/J09]12U!:JP3ZPR6RS +J\-<ER57KA5C M$)\,LV9IF'GP'8K.M-2FGU!!C))H[2O#YJ@@I<76A_@T&;]$K7L!7PI7L@H1 MF_2/$E954N14[MFBU]:!+ZM43_[FN4LG0N&I2R?,\F=/D@A+T,''/\,*@08F MP)*VW @FQ3_X,7W_^@+>&+1@KLT7"*A_-1&*5NXS^6VNU;X0^+6M"!SHV])Q M9@P[V#W*,C)'A96"2?1?&'@T(#ABG88S;A,`4MA4Q,7^8MD1KNY?2Y:&$R,Q MM015EQ,\(&A,TI9U`@9+/M A1M$QH1K.#! ^^L% 9$!A-OB(Y47@*D1I]GMS M_:XCHDW:&@C5RR!AZZY@9&-,$VC3IBPEPD0Y@X966DT#IX<`$GL&BVU=5=JT MG.X9+)B:$]=2_]A/P\SD!1) [FJ#&@/&6:1F@D<:_V6EA$ZNCV6GI+V'UFG3 MY>X`U+B"TFXM9CX2[2(BUA8W8Y5T84-EV!!!QZ6T'>1MJH0"(XL!FO+*.VT= M2<?*AJ:(\AJCJ7RW4[H)&4:,*RNHYR'M88AGXHJKE8$>*(2TK!%W0OX`RS$U MOL_+Y5HO>J^Q[GMP*)=0ST9%VQW:/]UF;(RUE$U_QCI#]SGFE*1#AX$<VWG M\0^H_.,A#$HL2(P3AGK"<5!82U#C^^!@/\+^$"Z `:4ZR'6BUR:9"F;]Y X: M$OM8(Y64/#V/XF0#-2;F, `V?1GTAK?V^28:E4^!^6SHBG3&H#>SVMV=MYI5 M_[WKYUZK?[FWVW?)]T:?.,QOH8C&.NUAT_3:A@X2@W&F2Z0_/+7OT ^9KO'7 M?9+=ZX6!?&&G@S@FBBF.9SBI)X!CO;*C)'X8H,PH*9RK!EDVG\_3^>-4FUGV MZ/BX[P?.,+HWPJ7U[0#'?Z,BL%T%LH?-:X!RO2#5]%BR`GN.)UG?.&S%<KY+ M)6K+^J>G)UDKE4#6!>&2^^;8#)OD3= U>&M?X=LY=Z/$F9JO^CMM1,.PY2U\ M?+M]F)8*+7*D/[;XD".%8F!J-=&UP@@G:XUWAP586*SKZ3KP3IT=`<N_UIBW M[=6=NJ@&FP&)MM-HXN<@U5A^O(I7!RN[5AFIPF-FQ*3&L@W*_&OB6Y<?Z;_6 M`AO@+M4[E.U"HQ\@=]_>_H:Y"X3AE[BCE(.->FK%L^MR%59C(FZJ!C]9E!.Y MO%LU;'J-E,+L/:(64GCS]@<,P'=V%"(S?/"3#).CI+\K=CL5Q"'\<!6/'O8` M;JO?.)*W<O&@,[F)^/A!CNDFZI/OZ^2N?B[]SZKW&Y;6PX0[[J(>VS[>![4- M$OVC02,\N/:.*\+$"YM=%UZKG^*;=S_[K[[64.D>[ `4LU97$>0>UV/QVG2$ M=OC_(SBKI?^!.U*\=H;)(_B]GN"4^RM?7N@O7(TFSY^SI_G39_W3QT_X\<GI M0=8WUVRWM_[Z.[=O:#U^\_?0_P)02P,$"@``````W*V]. `````````````` M`!L```!$96%D3&]C:U=A:71/;F4O4')O<&5R=&EE<R]02P,$% ````@`AER[ M.$(3,JLZ`@``_@0``"H```!$96%D3&]C:U=A:71/;F4O4')O<&5R=&EE<R]! M<W-E;6)L>4EN9F\N8W.-5,%NTT 0O5?J/XQR"A))TU)*6TZ0BBH2I:@MY8 X MK.W99-OUCK4[V]:?Q#=P0.*'^ 5F-TF=B :(#QFOW[QYXWGC7]]_Q&#<%"[; MP%@/+U!;+-F0>[V]M?XD.C8U#L=4-\:BOT1_9TH,FW 3Q^BI68%M;^WLP"DZ M],K"Q&GRM4J50!44&90$(6!=V!9,@)(<>[(6*^"9ISB=R3^"EB.Z3_4R74 & MTJ"8O2DB8QC">*;<%!,X8/<`[I2-&( ):JJ,;C.;Z51D.A% I5$L1>\-SU8U M#;>WOBSC8WBSB*X,6^SW3E!5[ZF\_:P,GSOL/?OZ)/H$0^E-D\KU>YM 8W+: M3*-7_X+5C7+M9L!'3U4L^;_%C:EIO9G.).,QA)_?`/9&H\--25=>55@K?_L7 MH=%R]+@`Y-=\B<QIA-+#M0FFL)CFHI65B=7J-HU)AL-M(Y%Q<B-^>/2&(X:[ M159FD]3Q^9D8IF[(H6/Q`$PTM!3!8;(/@2K%@L*1.?^DU)[J.9<0/<^F2@)6 MY'4^$C;V$8$2B>+,N.Z-+JV?6WIL^VK-OZ>?)B?)Z.+ 7$WNQ,G+QJTIP.BY MSL;3C2QE`N-#0V'>DTA=*WL:3=7O[:O#T>Z+HASHO0('^]61'A2X>S2H7NJ# M5WB@<4_M=X.X1A_2!J[L0=:SNHNRB,$$#DMU70>:HE_LU7&BRY3Y=Z9NA&7! MOG)L7'<,W?G;:&P%'V)=H.].+S"->9[_I+,61/W>[G"4KDT.?"??JR>QOP%0 M2P,$"@``````*W+%. ```````````````! ```!$96%D3&]C:U=A:71/;F4O M4$L#!!0````(`(=<NSA.`2^[9@$``*8#```3````1&5A9$QO8VM786ET3VYE M+G-L;J6204^#,!B&SY+P'PA>9K*2;L,-#AYHH7J8NDC4BY<.RE*M=(%B8N9^ MF0=_DG_!$K<YV&+,O/&]??M]S_>6S_</T[CD22%+F2GKCI<5%5:LJI1+*Y:B M4ESF%N&"=2TBBV>J/:PH:]%W(#2-X]:=/H2GIC$IY"-+5,=>D""";H0A&, > M`;U>. "(N A B*%+1GY$$%[:)]:998>,IF.9/-U3KJYS9G=WI(=6[23E7$^J MG0L/(^SY7@A\-!P`ER $?"\*`.D/HQ'RPH$;C):V:41YNJ(SC7,AIU28QM'W M1ZQ%O5EGO3>6><9G54'K8B*HRG0"9<TZ+]C:I&\?A6Q:S=Z"_-7"DUM]W*AK MPPT3C)9LR])2M$F#-3!VL%;8OU#)4FUC_2T3IT'K!'K8"\/9;-\>!W5$%1>I M`__1KQ56@W$WR$.[_G >\#CKW/4CS5FA.-OWGUSP=%-?R91I!PG&<;1WP$8Q MC2]02P$"% `4````" !C;[LX4O5LQFD#```H"0``)@`````````!`" ````` M````1&5A9$QO8VM786ET3VYE+T1E861,;V-K5V%I=$]N92YC<W!R;VI02P$" M% `4````" !C;[LX,1ZNU+H```#Y````*P`````````!`" ```"M`P``1&5A M9$QO8VM786ET3VYE+T1E861,;V-K5V%I=$]N92YC<W!R;VHN=7-E<E!+`0(4 M`!0````(`"MRQ3BB^H,SNP,``-,,```:``````````$`( ```+ $``!$96%D M3&]C:U=A:71/;F4O4')O9W)A;2YC<U!+`0(4`!0````(`/==NSBB/YBZS@4` M`+86```<``````````$`( ```*,(``!$96%D3&]C:U=A:71/;F4O4')O9W)A M;2YR97-X4$L!`A0`"@``````W*V]. ```````````````!L````````````0 M````JPX``$1E861,;V-K5V%I=$]N92]0<F]P97)T:65S+U!+`0(4`!0````( M`(9<NSA"$S*K.@(``/X$```J``````````$`( ```.0.``!$96%D3&]C:U=A M:71/;F4O4')O<&5R=&EE<R]!<W-E;6)L>4EN9F\N8W-02P$"% `*```````K M<L4X````````````````$ ```````````! ```!F$0``1&5A9$QO8VM786ET M3VYE+U!+`0(4`!0````(`(=<NSA.`2^[9@$``*8#```3``````````$`( `` M`)01``!$96%D3&]C:U=A:71/;F4N<VQN4$L%!@`````(``@`7P(``"L3```` !```` ` end Tag: Reading Data from Excel with all column filled gives error Tag: 117397
  - 5
    - Pass parameters to Windows Service Hello everyone, I have a Windows service that is begun, and I would like be able to tell a number of parameters or cause an event (from the outside) to do some tasks. for example, I have initiated a service windows and there is a task scheduled for some time to be launching a process which is in the Windows Service. Now, I use a Timer class to launch the task, but I want to know whether there are other options or ways to do it. Thanks in advance, best regards. Sorry my english -- http://www.alhambra-eidos.es/web2005/index.html www.kiquenet.net http://www.setbb.com/putainformatica/viewtopic.php?p=843 www.trabajobasura.com/solusoft Tag: Reading Data from Excel with all column filled gives error Tag: 117396
  - 6
    - Pick value in dropdown combo on WebBrowser page I have a WebBrowser on a form and I am automating some data entry on pages displayed therein. I know how to select/click on a radio button or checkbox. I know how to set the value of a text box. But, how do I programmatically set the value picked in a drop down? I tried the following: Dim oHtmlElement As HtmlElement oHtmlElement = WebBrowser1.Document.GetElementById("cboGroups") oHtmlElement.InnerText = "Group 1" but that doesn't work, even though "Group 1" is one of the options in the dropdown. Tag: Reading Data from Excel with all column filled gives error Tag: 117395
  - 7
    - evaluate function for WebBrowser control Consider the following line of javascript: var checkBoxes = document.evaluate('//input[@type="checkbox"]', doc, null, XPathResult.UNORDERED_NODE_SNAPSHOT_TYPE, null); Is there a way to accomplish this with the WebBrowser.Document? Is there something equivalent to the evaluate method? On a related note, is there code that I could run that would return a collection (HtmlElementCollection) of just the checkboxes on a form? Tag: Reading Data from Excel with all column filled gives error Tag: 117390
  - 8
    - Memory leak with TextBox? I have a windows app which contains a readonly multi-line textbox. This textbox is used to display "log" information as actions/events occur within the application. The contents can eventually get to be very large, as our app is often left to run overnight. We allow the user to clear the contents of the textbox by right-clicking and selecting "Clear" from a context menu. Within the event handler for this menu item, I've tried clearing out the contents using the Clear( ) method and by setting Text to "". Regardless of how I clear it, when I monitor memory usage I notice that the memory actually goes up after the contents are cleared. For example, in one particular test I let the app run overnight. The next morning I cleared it, and mem usage actually went up over 200 megabytes. I waited for a long time to see if GarbageCollection would eventually release it, and it did not. I've tried other things within my code as well such as calling ClearUndo immediately afterward. I also tried forcing garbage collection afterward. No luck. This is a problem for us because our users need to see this log information, but yet it can get very big and they need the ability to occasionally clear it. Any ideas why clearing out a textbox causes memory usage to go up? Is this an acknowledged memory leak within the .Net framework of which I'm just not aware? Thanks, Jeff Tag: Reading Data from Excel with all column filled gives error Tag: 117387
  - 9
    - RichTextBox.RTF handle Hello, I have some problem with handling the RTF type string. I have an application which must have a text box, can handle Pictures and formatting texts, etc. So I have chosen the RichTextBox control and stored the RTF property as nvarchar in my database. It works fine, but now I have to show this text in a browser and I can't convert the RTF string to HTML. And I can't get the images from the RTF string. So the question is: How can I convert the RTF string to HTML or any other form which contains images, formatted strings, tables, etc. Or which control should I use to get these features. Tag: Reading Data from Excel with all column filled gives error Tag: 117384
  - 10
    - Find/Replace dialog box I needed to use a Find/Replace dialog box in .NET and I wanted to use the common dialog that is available in the Win32 API. It needed a lot of marshalling and fiddling with window message. I have created a class that hides all these things and posted it on my blog. Go to http://blog.ramondeklein.nl/?p=21 to download the C# source-code (in). I saw some requests on the net, so I thought I should post it... Tag: Reading Data from Excel with all column filled gives error Tag: 117382
  - 11
    - WebBrowser - waiting for page to load I am attempting to use a WebBrowser on a Windows Form application, in a situation where I am wanting to automate the following: 1) Click on all checkboxes on page 2) Click on link to go to new page I have successfully coded the above two steps. Now, what I want to do is do the above two steps a repeated number of times. So, I try to do it in a loop. The problem is, step 1 attempts to run before step 2 has completed (i.e. the new page has loaded). How can I change code so that step 1 won't run until step 2 has completed? Private Sub GetEmAll() For i As Integer = 1 To 10 GetContactsOnCurrentPage() '*** WHAT SHOULD I DO HERE? Next End Sub Private Sub GetContactsOnCurrentPage() ' Check all checkboxes on page Dim oCheckBoxes As HtmlElementCollection = GetElements() For Each oElement As HtmlElement In oCheckBoxes If (oElement.OuterHtml.Contains("dgSelect_ct")) Then oElement.InvokeMember("Click") End If Next ' Click on link to go to next page Dim oNext As HtmlElement = WebBrowser1.Document.GetElementById("btnNextPage") oNext.InvokeMember("Click") End Sub Tag: Reading Data from Excel with all column filled gives error Tag: 117379
  - 12
    - How publish setup pkg that allows custom dir install Created a VB.NET winform app using VS 2008. How do I allow the users, when running setup.exe, to choose a directory to install it to, and whether it should be installed to the program groups or not? Thanks. Tag: Reading Data from Excel with all column filled gives error Tag: 117377
  - 13
    - VS 2005: webbrowser control displaying image from database Hi, There is a webbrowser control in my app. I have also a ms sql database and images are stored in. I can display a html document in the webbrowser control. I also can read an image from the database (I mean I have the image in memory as a byte array or image object). Is it possible to display such image in html document shown in the webbrowser?? How to do that? thx in advance Tag: Reading Data from Excel with all column filled gives error Tag: 117376
  - 14
    - Generate and save csv-file from C#? Hi all, I need my code to be able to generate and save an csv-file without being prompted by a dialogue box, but I don't know if such a thing is possible. I've found out how to generate the file without problems, but I cannot seem to make it save the file to a predetermined location. Is such a thing even possible? The code I use to generate and open the file is below private void CreateResponse(string QueryName, string CSVContent) { System.Text.Encoding encoding = System.Text.Encoding.GetEncoding("ISO-8859-15"); byte[] b = encoding.GetBytes(CSVContent); Response.Clear(); Response.Buffer = true; Response.AddHeader("Content-Type", "application/ms-excel"); Response.ContentType = "text/csv"; Response.AddHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("dd-MM-yyyy") + "-" + QueryName + ".txt"); Response.BinaryWrite(b); Response.End(); } can somebody please help me figure out how I have to modify it in order to make it save instead of just trying to open the file? Thank you! Maria Tag: Reading Data from Excel with all column filled gives error Tag: 117370
  - 15
    - Getting a ComboBox to "pop open" What instruction would get a ComboBox to Drop down and display the pick list as it would if somebody had clicked it? Any help is greatly appreciated. Tag: Reading Data from Excel with all column filled gives error Tag: 117369
  - 16
    - Dock Window to an external application Hi, I'd like to dock my WinForm app to other applications. What is the easiest approach for this? Thanks in advance Adrian -- Adrian Miller Tag: Reading Data from Excel with all column filled gives error Tag: 117368
  - 17
    - build context menu from menu strip Hi, I build the menu strip using the designer.I want the context menu of the form to be same as children of one of the top leven Menu strip item. Items["actionToolStripMenuItem"] gives me a ToolStripItem object but it does not have a hierarchy, no parents no children. What do i do? TIA Tag: Reading Data from Excel with all column filled gives error Tag: 117365
  - 18
    - Expired certificates in the clickonce manifest When a certificate expires, what options are available? - use an internal certificate authority where you can renew a certificate with the same private key - delete the clickonce cache from each computer - any others? Background: The ClickOnce technology requires every application update to be signed using the same private key. When a certificate expires most CAs like Verisign and Comodo will generate a new private key with the renewed certificate. ClickOnce will throw up an error when this occurs and will not download the update. http://groups.google.com/group/microsoft.public.dotnet.framework.windowsforms/browse_thread/thread/64a15850347c32df/3b85d27a8b28c451?lnk=st&q=certificate+clickonce+linda+liu+expired Thanks, Brian Tag: Reading Data from Excel with all column filled gives error Tag: 117350
  - 19
    - Need example of custom combobox inside DataGridView I'm looking for a tutorial, example, or source code sample which shows how to host a custom ComboBox control inside a DataGridView. In other words, I have a new control "MyComboBox" which inherits from ComboBox, then I create a an EditingControl for this class, which implements IDataGridViewEditingControl, as well as associated classes which inherit from DataGridViewComboBoxCell and DataGridViewComboBoxColumn. I have my code basically working, with the following exceptions: - the displayed text being shown after a selection is made is not correct - the initial drop-down is not entirely shown correctly, but all subsequent drop-downs are Anyone with suggestions or (better yet) a sample of how to do this would be great! Tag: Reading Data from Excel with all column filled gives error Tag: 117349
  - 20
    - Setup project - add uninstall In the Setup/deployment projects, how can you add an icon to the Programs menu, to uninstall your application or dll? Tag: Reading Data from Excel with all column filled gives error Tag: 117347
  - 21
    - Main form doesn't repaint until mouse moved I've got a c# desktop app with various menu items that display modal dialogs for changing app settings, etc.. Standard stuff. After a particular dialog is closed, the main form doesn't repaint the area that was covered by the child form until the user moves the mouse. I can't see how this one form is different from the others, or what I may have done to prevent the main form from repainting. Any suggestions on things to check would be appreciated. Tag: Reading Data from Excel with all column filled gives error Tag: 117346
  - 22
    - Native Chart support Hi, Does anybody know a native .net framework class for display GDI charts? Like Component1 or Interop, but it need to be .Net native. Thanks for any appointment Thiago Tag: Reading Data from Excel with all column filled gives error Tag: 117345
  - 23
    - Distinguish TerminalServer session versus XP RDP session vb.net 2005 windows app with .net framework 2.0 On Windows XP, System.Windows.Forms.SystemInformation.TerminalServerSession is returning True when connected to Windows XP via remote desktop using the /console switch. I confirmed in an XP running in VirtualPC 2004 ... Task Manager (users tab) that the session shows as "RDP-Tcp#blah" rather than console. Is this expected behavior? If this is expected behavior, how does an application distiguish if it is running in terminal services versus a windows xp remote desktop session? Tag: Reading Data from Excel with all column filled gives error Tag: 117344
  - 24
    - PostScript font support in GDI+? Is support for PostScript fonts planned, or possible through a workaround? Only TrueType fonts and OpenType fonts containing TrueType outlines can be picked for WinForms forms and controls; Type 1 and OpenType with Postscript outlines don't show up in the font selector. I'm working on a kiosk app for which part of the layout (background etc.) was designed by a graphic agency, who used a font from Adobe for textual elements. Now I'm expected to use the same font in software, but it's only available in PS and OpenType-PS. I did find a close look-alike in TTF format at URW++, but even I (not a graphic designer by art&heart) found some small differences, and I'd like to have the exact same typeface. There are tools that convert PS to TT outlines, but the results look so bad (choppy, pixelated) that they're useless for all but very large font sizes. Funny though: those PS-to-TTF converted fonts look just perfect under Linux, it's only under Windows that they get that choppy look. [I'm on Vista now, I haven't tried how they look on XP.] Tag: Reading Data from Excel with all column filled gives error Tag: 117343
  - 25
    - XP DISC SCRATCHED IF YOU HAVE ORIGINAL XP DISK WITH PRODUCT KEY CAN YOU DOWN LOAD FROM NET THE PROGRAM ? FROM MICROSOFT Tag: Reading Data from Excel with all column filled gives error Tag: 117340

Hi,
I am using ADO.NET. And JET 4.0 provider to read the data form
excel 8.0. Excel 8.0 have column limit as 255.
means A1 to IV. But when i fill all column with data including last IV
and try to read then it gives error that
"Too long field defined."All my cell have one or two character
record. But if i delete the last column IV record then it works
properly. can you give me information why it is happening.

Thanks
Neeraj Kumar

Top