israeliteknight's Q&A profile

• SQL Server Ignore Grouping

  I'm trying to place 2 matrices on a list. The first matrix I want to listen to the grouping of the list, and the second I want not to listen to the grouping of the list. In other words, I want the scope of the second matrix to be at the same level as the list. Is this possible Basically I want the second matrix to always show the same results regardless of the list's group.  - List groups on PersonID     - Matrix1         -Count for Person     - Matrix 2         - Count for all People I tried making to set the datasource on the second matrix to it ...Show All

• SQL Server How to connect to remote database using MS SQL Server 2005

  i'm using sql server 2005 developer edition. In sql server 2000, when i connect to my remote database, i just need to provide my IP address, server name with password in Query Analyzer. However, i do not know how to connect to remote database in SQL Server 2005. I did allow local and remote connection using Surface Area Configuration. However, after setting this, i do not know where to input the IP add, server name and pwd as well...>_<. Who can help me Thanks for ur expertise. So you want to connect to another sql server instance through sql server 2005 query Are you not able to type it in on ...Show All

• Windows Forms Problem with visual inheritance

  Hi folks I'm trying to develop a simple heirarchy of dialogs. The base form contains standard OK/Cancel buttons whose parent is a panel docked to the bottom of the form. I've checked the generated code, and they have been placed correctly as children of the panel. When I build the project, the positioning of the buttons on the derived forms changes somewhat randomly within the panel. Sometimes they place themselves partially or entirely off LHS the form. I've tried this with the buttons unanchored, anchored to the right of the panel, and anchored to the top, bottom, right of the panel. Same result :-( Any tips would be most welcome. I've com ...Show All

• .NET Development ThreadPool to perform 70 processes

  I am using the following code below and i have set max threads to 10 in the threadpool and it stops after 8 i values.How to make it execute upto 70 iterations. WaitCallback callBack = new WaitCallback ( UploadFileEx0 ); for ( int i = 0 ; i < 70 ; i ++) { if ( true == isThreadAvailable ( true )) { ThreadPool . QueueUserWorkItem ( callBack , GetFileName ( this . listView1 . Items [ i ]. ToString ())); } else { MessageBox . Show ( "Worker thread not available " ); } } Why are you only queuing the work item if a thread is already ...Show All

• Smart Device Development Can't change Label BackColor in designer (VS2005 Final)

  Hello, The environment Visual Studio 2005 Final, Smart Device Application for Windows Mobile 2003, using .NET Compact Framework 2.0. The problem I have uninstalled VS2005 Beta 2 (using the automatic uninstall tool) and then installed VS2005 Final. When I add a Label control to a blank form in the designer, I can't set the Label BackColor to a Web or Custom Color. It seems that when the underlying Form has the System BackColor "Window", it affects the Label controls. If the underlying Form has a Web or Custom color - the BackColor of the Label can be changed - however the BackColor in the list of Properties  ...Show All

• Visual Studio Express Editions Please Help with installation error 2905

  I had insatlled Visual Web Developer 2005 Express edition beta 2 then, had some problems with the db connection, then I unstalled it, now i can not install it again no matter what I get error 2905 about apackage that I have no idea what package . Is there something that can tell me that package I have run vs2005 cleaner but there was nothing to clean. as I have unstall is there a way to know wish packages that has to be installed before installing Visual Web Developer 2005 Express edition beta 2. I had the same problem before then i reinstall my xp-prof then I could install Visual Web Developer 2005 Express edition beta 2. but thi ...Show All

• Visual C++ How to spawn a thread from the main one?

  Dear all, I am new to Visual C++ and I would like to get supports on how to write a multithreading application. In fact I came from UNIX/Linux background and I am trying to write a network application using winsock2. The idea is that in the main function program "main()", the application is listening do data from the network. The moment the winsock API function (recv or recvfrom) receives data and fill the receiveing buffer "Array", another thread will immediately be spawned to process the received data of the buffer, while the main function thread will continue to listen to new coming data, again, once data have been ...Show All

• Visual Studio Express Editions localized ISO images

  Today Microsoft released German versions of the Express Editions. However, I can only find the "bootstrap installer". For the English versions, there are ISO images available for download -- are there to be found somewhere for the German versions as well Or is there any other means to install the software without or with slow internet connection Thank you in advance! Yes, I was looking for that as well.... haven't found those localized images yet, unfortunately. Furthermore, I don't know if installing a localized version of the fine express products after or even beside the original english version, ...Show All

• SQL Server Move data from backroom to frontroom

  I need to know the quickest way of moving/copying data from a backroom/import/qualitycheck database to the production environment. The databases reside on the same server instance, the tablestructure is identical and I'd preferably like to use T-SQL procedures, rather than DTS/ETL. Can I make use of bulk loading, openrowset or ... from one table to another Hi Erik, I would have suggested BULK INSERT, but as your source data resides in another mssql db, the quickest way (without using DTS as you stated) would be to select the data directly from your source into the destination: insert into t_Destinatio ...Show All

• .NET Development Can't xml serialize type of [,]

  Hi, Im using class XMLSerializer to serialize my class that includes a field of type Object. This field can be any type i want. In order to be able to serialize and deserialize my object i wrote class named ObjectSerializer that handles all types, here is the class: public class ObjectSerializer: IXmlSerializable { #region Constructors public ObjectSerializer() {} public ObjectSerializer(Object Data) { this.Data= Data; } #endregion Constructors #region Properties public Object Data{ get { return Data; } } Object Data; #endregion Properties #region IXmlSerializable Implementation public XmlS ...Show All

• Windows Forms Performance/Binding problem?

  Hi, We came in a performance/binding issue when we want to return the refreshed data from Webservice to the client . The first one(A) has performance issue with very high cpu usage and the second one(B) lost the data binding.   A) To return the refreshed data from the web services to the client we used Merge method As follow: clientDataSet.Merge(“…..call a& ...Show All

• Visual Basic Set Font for Text enclosed within < and >

  I want the user to be able to select the font for text (in a RichTextBox) enclosed within < and >, and be able to select the font for all text that is not enclosed within < and >. For example, if I had: visual<basic>.net <framework> I could choose the font for everything enclosed withint < and >, which would include "basic" and "framework", and the user of the program could also choose the color of everything else, which would be "visual basic" and ".net". Right now, I'm trying to do:         Dim Font As FontDialog = New FontDialog()         F ...Show All

• SQL Server calculated sum

  I have a dataset that returns a measure and a bunch of dimensions. What I need to be able to do is calculate a sum of this measure based on one dimension. ie.. Sum(measure) where dimension = "Top". Any ideas on how to accomplish this. Not sure if this solution will work for you, but you can add a Calculated Field to the Data Set, say: "FilteredQty", defined as (assuming Quantity is an integer): CInt(iif(Fields!Country.Value = "USA", Fields!Quantity.Value, 0)) Then in your report you can use this expression: Sum(Fields!FilteredQty.Value), wich should return 4 rather than 10 To make it dynamic, "USA" can be re ...Show All

• SQL Server For security reasons DTD is prohibited in this XML document

  I have seen one other post about this and using IP addressing rather that DNS names - I am using DNS. I have a large report that runs fine in report manager, but as soon as I try and export it to Excel it takes an age to run and I get the above error. Any ideas anyone Oh, and I export loads of other reports to Excel with no problems on the same server. More info: Curiously, I can output to pdf, xml, in fact anything except Excel. I'm stumped ...Show All

• Visual Studio VS wont load package

  Good morning all, I have a 2005B2 package written in VB, with a native sattelite dll. When I run my project in the experimental environment my command table is loaded (my menu item shows up), but when I click on it VS wont load my package. If I register the package to auto-load it loads fine on startup (I can break in Initialize()), so it seems that it is registered OK. Anybody have any suggestions how I can troubleshoot this problem Here is my ctc file: [removed] NEWGROUPS_BEGIN guidMyCmdSet:MyMenuGroup, guidSHLMainMenu:IDM_VS_MENU_TOOLS, 0x0600; NEWGROUPS_END BUTTONS_BEGIN guidMyCmdSet:cmdidOpen, guidMyCmdSet:MyMenuGroup, 0x0100 ...Show All