Jackslu's Q&A profile

• SQL Server OPENROWSET Vs Linked Server

  Hi all, OPENROWSET Vs Linked Server Which method is better than other in terms of performance Thanks, Sourabh It really depends. Both allow pass-through query. So, performance wise, the same query would cost you the same. However, Openrowset/datasource is really meant for one time ad-hoc query. You should consider using linked server which provides much more functionalities. ...Show All

• Visual Basic regarding textbox..... one question

  hi, I have a textbox in my project and when i set the enable property to false the color of the font in the text box changes.... i don't want this to happen.... please can anyone help me to disable this color change...   thanks, sathyan This is standard windows system behaviour - when controls are disabled. This lets the user know immediately without trying to enter text that this is not permitted. So chnaging it breaks a standard windows visual cue used in many applications and makes you application work differently - OK if you dont mind users having to trial and error to see if they can enter text in certain controls. Also you would have to think about allowing this control ...Show All

• Visual Studio Team System Proxy Server for Single Remote User?

  I can see the obvious benefit of caching files on a local proxy that will be requested by multiple remote users. I'm unclear if this buys anything for a single remote user. Was the intent to simply serve files locally whenever possible or does the cache proxy streamline things in other ways that make it worth setting up for a single remote person If the answer is no, should we in fact avoid setting it up for a single user Will it strictly add overhead Thanks, Martin! I agree with your assessment. I merely wanted to understand better what I'd be asking another user to setup at that remote site. Thanks also for the fyi on the service you're writing. I'll be watching for it. ...Show All

• Visual C# How to use LPBYTE in RegEnumValue registry function - win32 api programming

  HKEY hTestKey; long res; LPTSTR vn[255]; DWORD vl=255; LPBYTE data[255]; DWORD dl; long i=0; res=RegOpenKeyEx( HKEY_CURRENT_USER,"SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Policies\\Explorer",0,KEY_READ,&hTestKey); if(res) { msgb("nof found");return; } while(res!=ERROR_NO_MORE_ITEMS) { res=RegEnumValue(hTestKey,i,(LPTSTR)vn,&vl,NULL,NULL,data,&dl); data[dl]=0; i++; msgb((LPTSTR)vn); // msgb((char *)data); } RegCloseKey(hTestKey); when the variable data is provided the return values are not proper. when it is given null the function giving the proper result. i want to know how to make use of LPBYTE . argument number 7 for ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Storing game data in database

  I am a casual programmer and have recently, since express was launched, started using SQL databases in my app. These have been very convenient to store and manage datatables etc. I understand that with XNA we can also access other VS components, such as networking, but these components might not be available on the Xbox. Is database integration a purely VS component or can we use it for Xbox applications as well So will we be able to use the Dataset classes for interacting with XML I would be really happy if this was possible. I created a state engine for my last program using datasets which made it really easy to save data and read externally for errors, as well as managing the formats and table structures. ...Show All

• Visual C++ How can i make my editing auto completed?

  I use vs2005 to write cpp code A class is defined in a .h file, and I refer to this class in a cpp file including the .h. when I type "->" following a pointer of that class, no hint is showed about the members How can I make it work, thanks Make sure that the .h file included correctly and it's error free. Sometimes the intelisense database not updating properly. Do the following 1. Close the solution 2. Delete ncb file of the project 3. Reload the project. Hope it work. ...Show All

• Windows Forms Webbrowser Help needed

  This Script i found on msdn site is meant to update the url in the textbox u put a url in to i got it to work in visual basic but it won't work in c# and its the right code  update: also the enter button when pressed is mean to take u to the url but dosen't work either. [code] // Navigates to the URL in the address box when // the ENTER key is pressed while the ToolStripTextBox has focus. private void txtURL_KeyDown( object sender, KeyEventArgs e) { if (e.KeyCode == Keys .Enter) { Navigate(txtURL.Text); } } // Navigates to the URL in the address box when // the Go button is clicked. private void cmdGo_Click( object sender, EventArgs e) { Navigate(txtURL.Text); ...Show All

• Visual Studio Team System Report Server Connection Strings

  Recently we rebuilt our TFS Server. We're trying to add new projects, but it's not letting us. I read somewhere that the problem could be within our connection strings, TfsOlapReportDS and TfsReportDS. The problem though, is that when we rebuilt the server we lost those connection strings. Could someone please provide me with the connection string data for these sources to get this working again Thank you. Oops, I didn't even realize anyone posted a reply, I didn't get a notice.... Anyways, that worked! I added those connection strings and I'm able to create my projects now. Thank you! ...Show All

• Visual Basic DataGridTextBoxColumn

  I'm inheriting from DataGridTextBoxColumn so that I can hook into the KeyPress and Validating events... problem, the Validating event doesn't fire if you tab out of the edit, only if you mouse out. Any ideas (VS 2003) I don't recall any problems with the Validating event in VS 2003. Is it possible that the next control in the tab order just does not have "CausesValidation" set (That is what defines whether or not the Validating event is generated...) ...Show All

• Visual C# Does anyone know how to use Validation Summary Control with Custom Validator ?

  I am trying to use Custom Validator which causes server validation and Client validation for the FileUpload Control. But if i put Validation Summary Control to show the error message then the message is not showing up in MessageBox. All other Client Side validations messages are showing up in the Validation Summary Message Box except the message of Custom validator. Anyone has idea on how to do this -Thanks Satya Hello Javier, I tried adding the client validation to Custom Validator but even then the messages are not showing up in the Validation Summary message box. All other Client Validation scripts are showing up except the one attached with the Custom Validator. Thanks Saty ...Show All

• Visual Studio 2008 (Pre-release) svcutil.exe datacontract only is not generating minOccus='1'

  Call "C:\Program Files\Microsoft SDKs\Windows\v1.0\Bin\svcutil.exe" /dconly /out:..\..\DataContractXSD.cs /t:code "$(ProjectDir)Data.xsd" Data.xsd file has < xsd:complexType name =" AccessInfo "> < xsd:sequence > < xsd:element name =" User " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" Password " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" ApplicationID " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" ClientIPAddress &quo ...Show All

• Visual Basic Working with arrays

  hi, i'm currently working with a function that queries a database for a number of employee id's. i'm trying to save all results in an array and pass then to another function via return. how can i add to an already populated array since i'm using data reader and how can i pass the whole array in return. my code is something like this: dim employee_ids() as string while reader.read ' data for storing to array is reader.GetValue(1).ToString() ' how do i add to the existing array with existing values end while return employee_ids ' how do i pass the whole array in return thanks in advance, dave You don't need to pass the array byref. Lars has the correct answer (in theory, anyway). Yo ...Show All

• SQL Server How to make Application.LoadPackage() and Package.Execute() to run asynchroniously?

  Hi, I am trying to execute a SSIS package programmatically. When a user drops a file in a shared folder, we execute the package based on that file. I am using SqlServer.DTs.Runtime.Application.LoadPackage() and SqlServer.DTs.Runtime.Package.Execute() functions each time to do this. The problem is, when, say two people drop a file, the second one will not execute untill the first one is completed. I also tried only calling LoadPackage() a single time, and then storing the instance and calling Execute() in a different thread on each file drop; although the blocking still occurs. I assume the Package object is the one doing the blocking then behind the scenes. Is there any built in functionality to make these functions (Application.LoadPackag ...Show All

• SQL Server AD Hoc Query - SQL 2005

  I can get an Ad Hoc query to run on our SQL Server 2005 Standard SP1 server with some exceptions. For our environment, Ad Hoc queries only seem to execute against network shares if the query is run under a SQL login. If I attempt to run the Ad Hoc query under a domain account (one that is an administrator on the server and db owner) they fail with the following error: Msg 7399, Level 16, State 1, Line 2 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 2 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked s ...Show All

• Visual Studio 2008 (Pre-release) WCF and Generics

  Hi all, I'm currently experimenting with using WCF and .NET generics together, in an attempt to have a service that exposes the following service contract: [ServiceContract] public interface IGenericServer { [OperationContract] void MakeRequest<IService>(); } Is this possible Upon trying my driver for this service the first time, I received a System.NotSupportedException--"Method MakeRequest is not supported on this proxy, this can happen if the method is not marked with OperationContractAttribute or if the interface type is not marked with ServiceContractAttribute." Has anyone else tried this with different results, or is this simply not supported in WCF Thanks! Well, ok. To ...Show All