RemcoJVG's Q&A profile

• SQL Server ActiveX and SQL Server question?

  Apologies for posting this in the wrong section, now pointed to here. I have the following AciveX script set up as a DTS package which I would like to alter so that the output is sent to another server. :- Function Main() dim oCmd, sSql, oDom set oDom = CreateObject("Msxml2.DOMDocument") set oCmd = CreateObject("ADODB.Command") oCmd.ActiveConnection = "Provider=SQLOLEDB; Data Source=MyServer; Initial Catalog=MyDB; Integrated Security=sspi" sSql = "<ROOT xmlns:sql='urn:schemas-microsoft-com:xml-sql'><sql:query>SELECT * FROM VW_Projs1 FOR XML AUTO</sql:query></ROOT>" oCmd.CommandText = sSql oCmd.Dialect = "{5D531CB2-E6Ed-11D2-B252-00C04F681B71}" oCmd.Properties ...Show All

• Visual C++ image in dialog box

  hi, i have just started c++ .net programming coz its a requirement in my course, i need help on how to display an image in a dialog box........ anyone please hello Re: image in dialog box There are many ways to do this, depending on which technique you choose. If you choose MFC, then post this question in MFC newsgroup , if you choose winform, then post this question in winform forums . Please also note that VC forums are dedicated to Visual C++ problems, see the scope of this forum . regards, rico ...Show All

• Windows Forms Using an icon for the assembly file AND the form

  Hello, when I want to add an icon to my application, I need to set it as the assembly icon in the project properties and then again in the form where it should appear. If I only set it in the project, the .exe file has the icon displayed in Explorer and the application's taskbar item also shows the icon, but when switching tasks with Alt+Tab, it's missing; not sure about the form title bar itself right now. When I only set the icon for the form, then it's displayed everywhere but not with the .exe file itself. So, to get this icon everywhere, I need to insert it twice, resulting in the double filesize, regarding the icon size. I've tried to use a resource file, but I couldn't add one to my project settings because the Designer only lets me ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Draw() called before Update()

  I noticed Game.Draw() is being called before Game.Update(), which doesn't (seem to) make sense. Is there any suggested way of dealing with this If Update() is supposed to, umm, update the state of the application to a certain local time, before the first Draw() there is no state ready to be painted to speak of. Update() should definately be called as often, or more, than Draw(). Physics should be decoupled from draw rate anyhow and there are lots of logic which needs to be done as often as possible; putting network reads in Draw() just doesn't feel right... ...Show All

• Windows Forms Accessing variables in form from user control

  Hello, How do you access variables that are declared in a form from a user control that is used in that form For example, I have a windows form A. A displays a user control B. When a button on B is pushed, I would like to decrement a variable that was declared in A. Thanks in advance! RC make a class....declare the variable in this class as: public static (data type) (name of variable). then access this variable in user ctrl as : classname.name of variable I know i am late answering this but might help som1 else..... ...Show All

• Visual Studio 2008 (Pre-release) Add Service Reference Error

  The following error occurs if i try to add a service reference from a Windows Service. However if i tried to do the same from a class library, it works fine. An error occurred creating the configuration section handler for system.serviceModel/extensions: Could not load file or assembly '<Assembly Name here>, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An operation is not legal in the current state. (Exception from HRESULT: 0x80131509) (C:\Documents and Settings\<User Id>\Local Settings\Temp\hntabmzh.hon\newapp.config line 47) Could not load file or assembly <Assembly Name here>, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An operation is ...Show All

• SQL Server Remote Source and Destination Performance

  Given the following scenario, what kind of performance should be expected in transferring about half a million rows We are seeing about a 9 minute execution time. Is this reasonable for about 460,000 records moving from source to target, with 3 inner joins from the source Source: Server A.OLTPDB Target: ServerA.DataMartDB Server A is running SQL Server 2000. SSIS is running on a different machine, Server B. The reason for this is that we are distributing the SSIS package for use with a BI product built on SSAS 2005 and the requirements are such that the client could very well have the source OLTP database on a different physical machine than the data mart. My understanding is therefore that: 1. SSIS will do all of the hea ...Show All

• Visual Studio 2008 (Pre-release) Creating FrameWorkElements in async calls?

  Is it possible to create a FrameWorkElement in an async call. I've tried but get an InvalidOperationException - "The calling thread must be STA, because many UI components require this" My code: public static void LoadPage() { ConstructNewPageAsync test = new ConstructNewPageAsync(ConstructPage); test.BeginInvoke(new AsyncCallback(Completed), null); } private static void ConstructPage() { Canvas c = new Canvas(); //Here i get the exception } Is there no way to throw the object over to the main-thread. In my real app it is not a canvas i'm creating but a much more complex control that inherits from canvas. It takes about 3secs to create t ...Show All

• Visual Studio Express Editions Copy DataTable 'data' into msaccess using OleDb?.

  I have an excel file with customer information that needs to be added to existing table of customers in access. I have created an OleDbAdapter to grab the data from excel and add it to a dataset. from here I am stuck, how do i get the data from the "Table" in the dataset into the access database table //Add connection string for OleDb connection to Excel spreadsheet. string xlConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\GNWEST_DATA\Western Customers List.xls;Extended Properties=""Excel 8.0;HDR=YES;""" ; //make the oledb connection to Excel Spreadsheet, and use it to fill dataset with dataadapter. using ( OleDbConnection xlConnection = new OleD ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectInput8::ConfigureDevices with D3D10?

  In order to continue supporting older controllers, we're trying to maintain our DirectInput8-based input handling system while building a D3D10 renderer. Unfortunately, once we've created a D3D10 device, the ConfigureDevices function returns an error "Class not registered". ConfigureDevices works fine with a D3D9 device on Vista, just not with D3D10. I'm passing in NULL for the LPDICONFIGUREDEVICESCALLBACK parameter, depending instead on the default behavior - could the reason this function is failing be related to the default behavior not working with D3D10 Is this a known issue Is there a workaround I'd rather not implement our own LPDICONFIGUREDEVICESCALLBACK if we can get away with it. Tim Preston ...Show All

• Windows Forms Delegates

  Hi, what is the difference between Delegate Sub ReloadGrid( ByVal dt As DataTable) Private Sub UpdateGrid() DataGridView1.Invoke( New ReloadGrid( AddressOf SetDataSource), dt) End Sub Private Sub SetDataSource( ByVal dt As DataTable) DataGridView1.DataSource = dt End Sub and Private Sub UpdateGrid() DataGridView1.DataSource = dt End Sub can somebody please explain. i know its about delegates.. i dont know what this is about then and whats the difference in the above code ...Show All

• .NET Development How to Access Private Fields of Base Class through Reflection

  Hi , I want to get FieldInfo of private field of base class through passed object.How can i do that eg. I am using this : FieldInfo[] fields = objectInstance.GetType().GetFields(BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public ); But it is returning only public data members of base class , how to get private data members of base class. Thanks, Nitin I hope that this can be useful Derived d = New Derived(); Type ty = d.GetType; List< FieldInfo> l = New List< FieldInfo>; l.AddRange(ty.GetFields(BindingFlags.Instance | BindingFlags.Public)); While  ty != Nothing {     l.AddRange(ty.GetFields(BindingFlags.Instanc ...Show All

• Windows Forms ActiveDocumentHost

  Does AnyOne Know if the "ActiveDocumentHost" Control was added the Visual Studio "Sevice Pack1" or will be provided later or Will be a part of Visual Studio "Orcas" Thanks, Troy Service Packs never have any classes/components added or removed. an SP is just a collection of hotfixes/patches bundled in one package. from what I understand, as you may have guessed, it was removed from .NET 2.0 unfortunately. I dont think its included in .NET 3.0 but maybe 3.5 Sorry I couldnt help much but just wanted to correct you/give you info about it being included in the SP1 for VS2005 ...Show All

• Visual C# How do I refrance an object after I have created it ?

  I have created a class called clsserver and it inherits from the Picturebox class. Basically it is a picture of a server and displays as different colours as the status of the server is found, ie green is good, yellow might be a problem and red is can not access. With the Gui I can display multiple server on the screen ie 15 of these clsserver classes left to right, top to bottom. In the code I have called the instances of the class server. for each server I run this code. Server = new SQLServerMonitor.Server. clsServer () Server.Name = ThisServerName //IP of the server Server.Parent = pnlbackPanel; //calculate where to place the picture box on the screen if (ServerCount !=1) Calculateposistion( ref Left, ref ...Show All

• .NET Development Loop SelectSingleNode

  Hello, I need an example of how loop correctly in ASP.Net 2 to get each Xpath of ShippingAPIResponse/AddPacakgeResponse/PieceTrackNo PieceTrackNo will be from 1 to many depending on the number of packages shipped for each order, I would need to get each TrackingNo, PeiceNum etc for each PieceTrackNo Element(I guess it is called Element) < xml version="1.0" > <ShippingAPIResponse> <AddPackageResponse> <SONum>941823-1 </SONum> <Status>OK</Status> <StatusDesc>Transaction Successful</StatusDesc> <OrderProbill>36</OrderProbill> <Carrier>USPS </Carrier> <Service>5 </Service> <PieceTrackNo> <PieceNum&g ...Show All