ArunM's Q&A profile

• Windows Forms Accessing Cells in Excel Spreadsheet

  How can I retrieve value from cells in excel spreadsheet using vb.net In short, the answer is Excel Automation.  In your Windows Forms Project, add a Reference to "Microsoft Excel 11.0 Object Library".  Now you can control Excel in code. I have an example that I will post below.  This is an old report writting routine from o ...Show All

• Windows Forms toolstrip panel bug ?

  Hi, When I move my toolstripbars from one toolstrip panel to another, it might work fine, but after a while there is always something that goes wrong, either a toolbar overlaping another so that we can't grab the grip part of the overlapped toolbar anymore, or sometimes a toobar that just disappear... Is it bugged or is there some properties I've missed Regards If you have a simple repro, please post this up to product feedback: http://lab.msdn.microsoft.com/productfeedback/Default.aspx   ...Show All

• Visual Studio Team System Fail Team Project creation

  After installing TFS Beta 3, everything seems ok. Can connect to it, manage it, etc. However I cannot create projects sucessfully. When I try to I get this (excerpt from log): Event Description: TF30162: Task "SharePointPortal" from Group "Portal" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: Unable to connect to the Windows SharePoint Services at TEAMSYS1 Exception Details: The Project Creation Wizard was not able to connect to the Windows SharePoint Services at TEAMSYS1. The reason for the failed connection cannot be determined at this time. Because the connection failed, the wizard was not able to ...Show All

• Windows Forms How could i use the usercontrol to call the Window Form's Componet.

  I create a user controls and added it on a Form. There are also an textBox on the same Form. But i can't assign an text string to the textBox on the Form by codding  in the user control . How could i do it. As we know , very window form application has some buttons collection, like "Previous","next","first","last" and so on... I want to make a usercontrol to re-usedable on very window Form . I thouht that would be the best way to create  application. ...Show All

• Windows Forms Control buttons

  In the form I had set the following properties as minimise = true maximise = true locked = False Still these three small buttons does not appear on the upper  right hand side of the form ...Show All

• Visual Basic how to update rows in an mdb data source??

  hi everybody , I'm a beginner student in vb.net,and I'm working on a very small project as a homework,and I've some questions which I ought to search for their solutions via any   source . I need to make an (Update )button in most of my VB forms,which enable me to update any row elements in the datasource in Access through each form , for example: I've a form about CustomersData as (Cust_No,Cust_Name,Cust_Address,Cust_Phone...etc) when the user want to update one of the customer data ,s/he will display this customer data through the search method in the form and this customer data will appear in the textboxes in the CustomersDa ...Show All

• Visual Studio Team System Cloaking question

  What's the best way to cloak 19 out of 20 dirs from a given directory.  I kind of wish I could cloak the parent directory but then "uncloak" the single child directory.  Having to cloak 19 dirs just so that I can access a single directory seems a bit of a hassle. I can't think of an easy way within TFS itself.  Here's a quick & dirty workaround script: @echo off del /f /q cloakdirs.tfc for /d %%a in (*) do (echo workfold /cloak %%a >> cloakdirs.tfc) echo workfold /decloak %1 >> cloakdirs.tfc tf @cloakdirs.tfc del /f /q cloakdirs.tfc Usage: CloakAllBut1.cmd FolderY ...Show All

• SQL Server move file task using variable

  Hi, Using the 'for each' container, I am setting a user variable (type = string) which will hold the source file name and path of files to process and then move to an archive directory. In the move file task (which is in the for each loop container) I have set the destination to a file connection, and the source to : Issourcepathvariable=True;  sou rcevariable= user::sourcefilename BUT when I run the package, I get the following error : Error at File System Task : "Source Path" is not valid on operation type "move file". I have tried all sorts of things relating to expressions etc. but cannot get this to work. I ...Show All

• Windows Forms Security exceptions running a .NET 2005 application from a mapped network drive

  Hi, Why is it that I'm able to successfully run a .NET 2005 exe from the local hard drive but when I copy the same EXE to the network it fails with a whole lot of security exceptions Regards Michael The problem is that it is running in a different security zone when running on the network share, a much more restricted one than what it runs under on your desktop. One quick way to fix this is to use the .NET Framework Configuration Tool to increase the trust of the network location or the assembly at that location. ...Show All

• Windows Forms DataGridView how to bind to a textbox

  I have a DataGridView on my form binding to an Access table showing all the contents How can I make it just return the value in TextBox1.Text If someone has a simple example they could show in VB I would realy apreciate it I am not sure if I understood the question. But if you want to know how to bind the textbox'x text  ...Show All

• Smart Device Development How to increment time picker interval in CF2.0

  Hi: I find out today we can use the new control in vs2005 date/time picker to set it as a time picker ( spin box ) by change it's Format poperty to time or custom....which is great. But what I want is I can able to set a increment interval like the numricUpDown control... Does any one know how to do that I try inherit and override the onValueChangeEvent but seems quite difficult find out is there on button up or down, any suggestion will very appreciate! There is no way to do this directly with the .NET Compact Framework. You may be able to P/Invoke to some native code to do this for you. You shoul ...Show All

• .NET Development Looking for something other than Ping class...

  Other than the Ping class in the System.Net.NetworkInformation namespace, is there a way to tell if a computer exists on the network Thanks... Scott I appreciate the response, but that method is obsolete in .NET 2.0. However, for your information, the new method is called GetHostEntry. Scott ...Show All

• SQL Server AMO "Scripter" Class - Help

  Has anyone ever used Microsoft.AnalysisServices.Scripter class to programtically script SSAS objects I am looking for a little bit of sample code to get me started. My goal here is to script some of the SSAS objects out into XML and store the XML in a table that can be queried to produce some meta data reports. I plan on doing this using AMO inside of a Script Task of a SSIS package. So here are my two main questions: Can anyone provide me with some sample code (I am not that good with .NET) using the Scripter class to script an SSAS object Can anyone tell me a better way to build reports based on the meta data of my SSAS objec ...Show All

• Smart Device Development ARMASM (version 13.10.) in THUMB mode generates wrong code for ldr Rx, =const

  Hello, I am working in WIN CE 5.0 development environment for ARM 9 processors. I am trying to compile an assembler code, that uses ARM & THUMB code together. I am using the ARMASM Microsoft compiler. Using ARMASM ARM Macro Assembler, Version 13.10.4236, Build for Windows CE (Release) (Built on Jul 24 2004 09:41:48) When using the ldr R1, =CONST_VALUE , in the THUMB CODE area, I am getting wrong address in the disassembly. It would seem that the address resolution is calculated relative to code start, instead to the required relative to PC. following code demonstrate the problem :  AREA testcase,code   ...Show All

• Smart Device Development tts Text to speech

  Any one have a sample of  a program whit voice syntese. "I'm working whith an Ipaq 6300" ...Show All