Raymond.W's Q&A profile

• Visual Basic Access 2000 Macro

  How can I connect to an Access database using ADO and execute a stored access macro General document about using the Access Object model using VB.Net http://support.microsoft.com/kb/317113/ With the following thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=64703&SiteID=1 Showing calling an Access macro from VB.Net. ...Show All

• .NET Development Column Names

  Hi, I have an Excel data sheet that I need to read and select the pertinent rows to load into a dataset. The data will then be checked against a database and the new data will be added. I have several questions/problems, the first of which has to do with Column names: My Excel sheets have column headers, BUT the header names are not located in the first row, rather they are located in the 5th row of the sheet, always. I would ignore this issue altogether and simply use column position as a locator for the data, but the sheets do not always have the same number of columns (ie sometimes columns are missing). Therefore I need to know which columns contain which data. How can I specify the columns such that the correct data get inserted into ...Show All

• Visual C# How to create exe file from my program

  Please help me quickly !Thanks . Hi, Use CodeDom Apis for that, [I assume that you are using existing cs code files or you are inputting code in c# from your application and then creating exe] Compile code using csc with the command line arguments to create and exe HTH, ...Show All

• Windows Forms Determine how control has the focus.

  Hi! How determine wich control has the focus in the app I'm test with: [DllImport("user32.dll")] public static extern IntPtr GetFocus(); Control.FromHandle(GetFocus()).Handle But the Handle is always diffent than the real focused control Thanks in advance. Regards. Odd problem and I can't reproduce it. Try using the native Windows Forms properties: Form.ActiveForm to find the active form and Form.ActiveControl to find the active control. ...Show All

• Visual C# Beginner question about method overloading!

  Can someone please explain to me what a method overload actually is and maybe possibly give me a code example in C# for me to see I am looking to land an entry level dev job and need to know this question! Thank you! Method overloading is when you have two or more methods with the same name, but different parameter signatures (excluding the return type), for example:   using System;   namespace ConsoleApplication1 {     class Program     {         static void Main( string [] args)         {           &n ...Show All

• Smart Device Development Dll method problem

  Hi Guys I am new bie in Windows mobile platform. I am building a smartphone application using c#. It uses our own NetwrkAction.lib. Can you guys help me how can i use this lib in the project. I have follwoing functions that has to be used in the application. EXPORT CNetwrkAction* CALLBACK CreateNetwrkAction(); EXPORT void CALLBACK DeleteNetwrkAction(CNetwrkAction* obj); EXPORT int CALLBACK Configure(CNetwrkAction* obj,LPVOID aErrorNotifier,LPVOID aEventNotifier, const char *aPrimaryGateway); EXPORT int CALLBACK ConnectToServer(CNetwrkAction* obj); EXPORT int CALLBACK RequestToServer(CNetwrkAction* obj,const char *aPrimaryGateway); Can anybody tell me how to use this DLL with my program. Here's a classic example of call back if ...Show All

• Visual Basic Formatting date in vb.net when the date comes from Excel 2003

  I'm trying to parse a date to the format 'yyyymmdd'. The date comes from an excel cell that is formated for dates like mm/dd/yyyy. I read the cell into an arraylist and try to format it something like this Dim a as new arraylist Dim xl as excel.application xl.workbooks.open ... Dim s as string Dim i as integer = 0 s = Ctype(xl.cells(r,c).value,string) a.add(s) Dim d as new datetime d = a(i) Dim ds as string ds = d.tostring("yyyymmdd") if I read 10/22/2006 from the spreadsheet, the value d will contain the value #10/22/2006#, but ds will contain 20060022 if I replace d=a(i) with d=ctype(s,datetime), I get the same result. VB's format function does the same thing. Any suggestions ...Show All

• Visual C# launch default app (for file type) with arguments

  Hi all, I've been trying to get this to work, but haven't found a decent solution yet. What I need is to open a pdf file, in a maximized window, at a certain page. From the command line, it looks like this: <path to acrord32.exe> /A page=N "<path to pdf file>" However, I don't know the location of acrord32.exe on the client machine, so I use the pdf file as the parameter to run by Process.Start. The problem is that I cannot pass command line arguments anymore... Anyone has any idea on how to do this Thanks in advance, Cosmin.   cosminb wrote: it's actally the same as: Process.Start(filename, args); That would be correct. It seems acrobat doesn't support arguments ...Show All

• Visual Studio Team System Can't delete folder from the Source Control (get the folder on gray)

  Hi, I get sometimes very weird error when I'm trying to delete some folder from the source control. I get the folder on gray and I can't update the source control window to show me the source control tree without this folder. I tried to do many things to solve this problem - refresh the page, close and open the IDE but nothing really helped, the only thing that really helped me was to sign - in as tfssetup and then to delete again the problematic folder and get entrance again as default user. Just to mention that I am administrator on this machine. Can any one explain why does it happen Thanks in advance, That's right they are set in different places over the file system, Beca ...Show All

• .NET Development Connecting to internet directly by c# code

  Hello we have a winApp project with c#.net 2.0 , my app must be connected to internet while user doesn't notify this action.I mean I need to connect to internet directly by c# code. first I tried wininet but this technic was not good, because it displayed dial-up dialogbox. thus I tried rasdial , but I couldn't work with that really. sample codes that I found for this dll doesn't work correctly. I searched into internet to solve this problem. but I couldn't find any things that help me exactly. what should I do thanks in advance. Thanks but I want it to be connected to internet automatically (if it is not connected) and a web page open without dial-up dialog box when user clicks a button in my windows applicat ...Show All

• Smart Device Development Error InvalidOperationException unhandled - help needed urgently

  hi, I have implemented the code for cameracapturedialog using WM 5.0 and VS 2005 and Windows 2000 professional OS .I m getting error using the ShowDialog() method of the CameraCaptureDialog. Code is like this CameraCaptureDialog cameraCapture = new CameraCaptureDialog(); cameraCapture.Owner = this; cameraCapture.Mode = CameraCaptureMode.Still; cameraCapture.StillQuality = CameraCaptureStillQuality.High; cameraCapture.Resolution = new Size(175, 150); cameraCapture.DefaultFileName = @"test.jpg"; cameraCapture.InitialDirectory = @"\My Documents"; cameraCapture.ShowDialog(); Stack Trace ========================== System.InvalidOperationExceptoion: {"An unknown ...Show All

• Visual Studio Print Layout mode showing incorrect # of pages at first

  Sometimes when switching to Print Layout mode, it will say page 1 of 1, switch back to Interactive Mode and back to Print Layout mode again, and then it will display the correct # of pages. Anyone have any idea how to correct this FYI: I am using the report viewer in local mode. Most reports work just fine. This is a known bug that has been fixed in Visual Studio 2005 SP1. See this thread for more information: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1032267&SiteID=1 ...Show All

• Visual Basic Use the BindingSource Control to bind the control to the class

  Requirement: I need to create a VB.NET front end that has a Microsoft Outlook style calendar control. The very basic thing would be a calendar control in which you can add TEXT to each day. An advanced version would be a calendar control in which i can add appointments to each day. Another good enhancement would be a calendar control in which i can add a VB.NET control (like a DGV) to each day..... Can anyone recommend me to any control like that.... Thanks !! TkNeo, Have you tried too bind the Controls like DataGridView control to the class not bind to the object The following source shows the method that use the BindingSource control to bind the DGV control to the Class: Imports System Impor ...Show All

• Visual Basic COM Object BeginInvokes at Program Close?

  We're writing a program where we have a COM object that is created and used several times through the runtime of the program. I'm finding, though, that I get this bizzare error after closing the program. I've verified that this error comes after an Application.Exit() call, and the stack trace doesn't involve any of our code, so I have no idea how to diagnose this (if I could just supress it, I'd be fine, since the program can finish closing after I hit F5 when the exception comes up in the debugger). The only handlers attached to the COM object are done through Handles statements on methods. Is it better practice to manually do it on COM objects through AddHandler and RemoveHandler ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using Float16's

  Hi. I am trying to pack my vertex data using data types other than 32 bit floats. Using Normalized Shorts and bytes has worked great, However i cant find a way to convert from float32 to float16 (called half in HLSL) when using C#. Can anyone help May I ask why you would want to do such a thing Using float16s may take less memory, but a plain float (float32 on 32-bit Windows, float64 on on 64-bit Windows) is faster. I would say that speed is usually more important than memory usage, especially when using .NET. ...Show All