Theodore Chen's Q&A profile

• SQL Server Report Project and Report Designer

  When we want to create reports for report server, we create a report project in Visual Studio.  However, is it possible to add a report project as a sub-project or a nested project in a Visual Studio solution   Does it matter Thanks! I do not think this is possible. Reporting Services Developer simply uses the Visual Studio IDE its connection to other visual projects ends there. I'm not sure what you are trying to do here, but a report would be usless in another program since it requires the report server to run and cannot run alone. ...Show All

• .NET Development easiest way to make a variable thread safe

  I have two variables accessed simultaneously by following two threads. What is the easiest way to make it thread safe Thanks, It's important to remember that when you lock on types, you're exposing your application to a denial of service attack (or worse) if you allow any third party code to run in your application.  For instance, if I know that your app will take a lock on typeof(string) before doing some critical work, my malicious code can just grab that lock first .... then I've effectively stopped your app from ever doing the work it was trying to perform.   -Shawn ...Show All

• SQL Server Performance problem with SQL Server Express

  My current database is running in MSDE. I setup a new server and installed SQL Server 2005 Express. I then copied the database to the new server and attached it. After testing the new server, I noticed that one of my stored procedures that uses a forward_only keyset cursor is running about ten times slower. I’ve compared all the setting between the two servers and everything looks good. I also installed a trial copy of SQL Server 2005 on a spare PC and ran the same test. Again, the stored procedure is running about ten times slower. I’m not experiencing any other performance problems. Any help would be appreciated. Thanks ...Show All

• Visual Studio 2008 (Pre-release) Database projects

  is it possible to create a database project that uses DLINQ Or retarget a previous project to use linq I should say i was able to create a retargeted DB project that deploys successfuly to my DB. I dont have access to the libraries i need to use extention methods. Also the DLINQ mapping tool is missing. Are there plabs to integrate this into the db ps - As an alternative, Is there a way to add assemblies to the 'trusted' set of assemblies that are part of the sql server CLR integration ...Show All

• Visual Studio 2008 (Pre-release) obtain client address inside service

  Hi I wish to get hold of the clients IP address, mac address and computer name within a service that is exposed using a net.tcp binding. Is this possible and, if so, how can it be obtained Thanks in advance Ant Well I don't know about the ip and mac but you can get the machine name using System.Environment.MachineName. The other networking data is probably available through some other class, although I couldn't tell you what it is off the top of my head. Thanks, Scott ...Show All

• Windows Forms SqlClientPermission

  OK.....I have been searching and haven't found much helpful info on this topic.  I am hosting a winform (user control) on a website.  The form makes a call to a stored procedure...:     Public Function getxxxxx() as dataset         Dim sqlCmd As New SqlCommand         Dim da As New SqlDataAdapter       ...Show All

• Visual Studio Tools for Office Excel - changes and sheet protection

  We are using a ListObject on a worksheet bound to a bindinglist. When the sheet is NOT protected and we either drag edit or copy & paste a range of cells, then we see that all of the value changes are propagated down to the bindinglist. However, when we protect the sheet then ONLY the first value change is propagated to the bindinglist. Does anyone know why this might be the case.. Don Hi Don, To understand more about the problem, could you please provide details such as code snippet of binding and repro steps on drag/edit listobject with/out sheet protection Thanks -Qiong Ou   ...Show All

• SQL Server array as parameter for IN statement

  Hi, I thought TSQL of yukon would have a way of passing an array of values to a SP which can be used by it in an IN statment. ie: List<int> idList = new List<int>(); idList.Add(5); idList.Add(7); SqlCommand cmd = new SqlCommand("sp_Core_GetDetails"); cmd.Parameters.Add("@idList", idList); cmd.ExecuteReader(); ... SP would look like (fragment) select id, name from DetailsTable where id in (@idList) is there such a feature in yukon Here is the demo code in C# from MS: http://msdn.microsoft.com/library/en-us/dnsql90/html/sqlclrguidance.asp frame=true#sqlclrguidance_topic4b using System.Collections; using System.Data.SqlTypes ...Show All

• SQL Server process cube

  I am using analysis server 2000. I have a cube on one of the databases which i am trying to process through the Business Intelligence Development studio. i have specified the Server and the database name in the 'connection managers' through 'New Analysis Services Connection' I added the 'Analysis Services Processing Task' to the Control flow but get the following error when i double click on it: "A connection cannot be made. Ensure that the server is running' Does anyone know what am i doing wrong Any help is appreciated. Unfortunately you will not be able to use AS 2005 tools agains ...Show All

• Smart Device Development Setting loacle to UK when installing a CAB file

  I have an app which needs it's device to be set to English-UK so that the time formats are right (yes I know I should have used .toUniversalTime but it's too late now). So in a CAB file, I'm going to set theses values in the registry when it is installed [HKEY_LOCAL_MACHINE\nls]DefaultLCID to 1033 And this seems to work. :-) Anyone know what these settings in HKLM\nls are for "DefaultOCP" "DefaultACP" And is this a safe method for changing the locale Registry information for the device Regional Settings are found in HKEY_LOCAL_MACHINE\nls. The nls key has three values: ...Show All

• Visual Studio Express Editions Is .NET Framework necessary in the client m/c for running a c#.net project?

  Hi I have a c#.net project in hand....I have to run my this project in the client m/c .... I will be giving only dlls files to the client.... so Wht are the necessary requirements for my project to run on the client m/c Is .net framework compulsory in client m/c Plz let me know. ...Show All

• Visual C++ calling a WINAPI function from a managed main creates linker error

  OK, here is the latest saga from this newbie: Whenever I try to call EnumDesktopWindows or GetWindowsText the linker vomits out the following: LocateWindow.obj : error LNK2028: unresolved token (0A00000D) "int __stdcall EnumDesktopWindows(struct HDESK__ *,int (__stdcall*)(struct HWND__ *,long),long)" ( EnumDesktopWindows@@$$J212YGHPAUHDESK__@@P6GHPAUHWND__@@J@ZJ@Z) referenced in function "public: void __thiscall LocateWindow::setPopulateWindowArray(void)" ( setPopulateWindowArray@LocateWindow@@$$FQAEXX Here is the code: (Yeah, its ugly. I am coming at this slow so I get as much of the concepts down as I can) // LocateWindow.cpp : main pr ...Show All

• Windows Forms AcceptButton like property

  I'd like to add a "Target" property to my UserControl that lists all textboxes on a form and allows me to pick up one and assign it to that property. Something similar to Form's AcceptButton property that list all buttons available on container form. Any hint TIA Corrado   Corrado Cavalli wrote: FYI: Default value does not indicates what type your property accepts but just its default value and how it should be serialized... Hi corrado, Thanks for the correction. I actually want to say the same thing, but I find it difficult sometimes to speak in a foreign language like the language of this forum which is&n ...Show All

• Windows Forms UpdateUI

  I have made .net client, and I have got from server very ofthen changments. And my application is stucking. How avoid this problem. You don't provide very much detail on your environment or what exactly you're trying to do, but in general you can make a Windows Forms application more responsive by including the following statement in any tight loops: Application.DoEvents() This will give your application the chance to handle other events, such as pending repaints. Note that the need for DoEvents may indicate deeper design problems, particulary the need for multithreading/background processing. But ...Show All

• Visual C# Custom control draws incorrectly when moving another window over it.

  This issue has seriously frustrated me. I am overridding OnPaintBackground to draw a gradient background in my custom control. It resizes great - very smooth, no flicker. When I try to move another window across it, it will repaint itself repeatedly... but it will repaint the area that was hidden by the window as if it was the entire control. So if I am starting the gradient from blue to green...When I move a window over half of the control, and then start moving it off, it will start painting the blue in the middle of the control. So after I have the window off the control...the first half of the control looks normal. The second half looks ...Show All