Delp3's Q&A profile

• Visual Studio How to set VS 2005 so that the Output tab is the default one chosen/displayed when debugging

  I'm not sure where to ask this or how to best to explain it, but I'll give it a shot. When I press F5 to run an application, several tabs show up at the bottom of VS (Call Stack, Break Points, Command Window, etc.) One of those tabs is called "Output". I use the output window more frequently than the others because I use a lot of Debug.Writeline() statements in my code. The bottom line is that when I press F5, VS always defaults to the "Command Window" tab, and I want it to default to the Output tab. Is there a way to do this I don't know why it didn't show up for me before, but it did when I looked again. The output option was already checked in the settings, but removing the extra tabs did the trick. Most of ...Show All

• SQL Server Concatenate Rows into Columns

  I have a table 2 columns (Object and Weight) with data like below: Object Weight(lb) table 5 Chair 6 Computer 3 Computer 5 TV 20 TV 15 Radio 10 Computer 10 Question: I would like to create a new table with one column that would join the above two columns like below Object table 5 Chair 6 Computer 3, 5, 10 TV 20, 15 Radio 10 Thanks for your help in advance. In SQL 2005, you can try like this Create table tbl ( Object varchar ( 100 ), Weight int ) insert tbl Select 'table' , 5 union all Select 'Chair' , 6 union all Select 'Computer' , 3 union all Select 'Computer' , 5 union all Select 'TV' , 20 union all Select 'TV' , 15 union all Select ...Show All

• Visual Basic Internationalization. Try setting the Culture .

  Big word, hopefully small problem... I am in the process of internationalizing my application. I have created a string resource file so that I can create all the required language translations but how do I go about changing the shortcut keys on menus etc to correspond to each language Is there an easy way to do this Cheers Mark Hi, See this thread please.>> http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1247101&SiteID=1 Regards, S_DS ...Show All

• SQL Server Top 20 totals and aggregates

  I've got a reasonably efficient query that gives me a count of the top 20 daily values in my database. Now I'd like to figure out the daily total of top 20 values. Then analyze this information to work out the average, min, max and standard deviation of the daily total of top 20 values. My best effort is horribly slow - does anyone have a better idea how to do this Thanks! The schema of the database it accesses: create view eventView (timeStr, msec, host, process, dbName, point, description, rtu, groupName, message, type, sevInt, time) as select dateadd(second,time+60*offset,'01/01/70'), msec, host, process, dbName, ptName, description, rtuName, groupName, message, type, sevInt, time from summary CREATE TA ...Show All

• Visual Basic Validate textstring as DateTime

  Hello , Can this be done in VB2005Xpress Form elements: one TextBox, one Label (TextBox is used to receive Birthdate input, Label displays "<1", "1" "the age which is calculated from Today's Date - Birthdate" or " "). The age formula and the If statement for "<1", "1", "age" and " " is done. Here the TextBox is the choice for Birthdate entry. It is the most cost effective. DatePicker is excellent choosing a future date where the user want to be sure that the Day picked out do not fall for example on Sunday. Click event should be not necessary to display the result in the Label. Birthdate correct form is: ddMMyyyy Cases: 1. User type lette ...Show All

• .NET Development TCPClient

  I have created a POP3 class which I use to connect to a pop3 server. When I send the username as : wf.service@sbcglobal.net , and my password it connects just find and I can retrieve my messages. But if I use a "non-sbcglobal.net" account name, there is an error. Can someone help me or point me in the right direction. You’ll have to be much more specific in what you are seeing. When are able to log in successfully, are you doing so to a pop3 server on which the account you are using exists When you receive an error, are you logging into a pop3 server where the attempting account exists I would expect that if you attempted to log into a pop3 server on which the desired account doesn’t exist that it would return an error ...Show All

• Windows Forms Resize interface to accomodate all user monitor settings...?

  My problem is that I cannot guarantee that the way I see an application interface will be how all the users that install it will. Some users say the interface gets cut off and not all the controls are visible. Can anyone suggest a means of ensuring that the forms can adjust themsleves accordingly to a users monitor setting Or point me to some relevant help sites... Thanks. I've also recently read about the TableLayoutPanel http://msdn2.microsoft.com/en-us/library/system.windows.forms.tablelayoutpanel.aspx Is this a control that may be worth looking into to acheive what I am looking for ...Show All

• Visual Studio Loading a crystal report file gives this errormessage: Load report failed.

  Hi all I've read through quite a lot of posts and threads regarding this issue but haven't found anything that matches mine to the point. I have problems when loading a specific .rpt file. It opens and runs in Cystal Reports and I have opened many other .rpt files without any problems. Therefore I assume that there is no path issues or access problems. So, the line which makes my head ache: CrystalReportDocument.Load(InputFile); // Loads the Crystal Report It gives me the following errors when I list out the exceptions (sorry for the spam, not too sure what is of importance and what is not): Final update: If there is more than 80 Group Headers in the .rpt file, the file won't load. 80 or less, it loads fine ...Show All

• SQL Server Executing packages in a specific sequence

  I am facing some issues while working on SSIS in VS2005, The Scenario is we have 35 excel files from which we have to import data to Sql 2005. We have to execute these packages in a specific sequence so we are not using For Each Loop Control. Now the Problem is this that we have 35 executables as an output that is corresponding to each package, and from each executable we can Change excel path and Sql Connection String. The problem is that one has to open each executable to set the path; we wanted to keep them Configurable like , as if we can have any variable define in the packages for path, and in the packages we use that variable and append the XLS file name to it like .. @PathVariable+ test.xls A ...Show All

• Visual C# Unicode Byte to string

  I need to print some greek characters like αβδ from my C# program. By using Hex Editor, I know their HEX (or byte) value is CEB1, CEB2 and CEB3. So now, how should I construct the data and print it from my C# program I can't do this anyway. String temp = "" + 0xCEB1 + 0xCEB2 + 0xCEB3; It printed out as some numeric value. Ps. I don't want to hardcode the αβδ characters into my source code. What can I do Please help me. Urgent. I will grade you. Promise. Thanks Hi MVP, Thanks for your answer. I am getting closer to the answer I wanted. Other than the puzzle you have solved for me above, I also found another mistake I made in my printer class. Below is the original code: ...Show All

• Visual Basic Voice Recognition

  I've been reading a lot of web pages that tell you how to do voice recogntion things, and all of them say to select the Microsoft Speech Recogntion component thing, but I can't find it! Where is it, and can someone point me in the direction of a good article on how to do voice recogntion things in Visual Basic (Unless someone wants to list the code here, but I doubt that. ) Thanks! Thanks, Kyle. You told me what I needed to know. I'll tackle the coding later, I just wanted to find the component selection thing. I have the SDK AND the .NET framework V3, so I should be okay. Thanks again everyone. ------------------------------ UPDATE: Actually, it doesn't work. I got sent to the same place I was at before. ...Show All

• SQL Server Sql Server Clr Assembly "deploy" taking over 20 minutes!

  Hi all, I have a Sql Server Assembly that contains some Clr stored procs for some of the more complex operations I wish to perform. When the number of these stored procs was low then the assembly deployed nice and quickly but as the number rose the deploy time began to take a huge amount of time. Deployment took over 20 minutes for 167 stored procs. I have done some checking and monitoring and found that it seems to be visual studio that is taking its time and eating up a large amount of cpu during the deploy. I have tried installing the assembly manually via DDL in Management Studio and it took less time than Management Studio could display (00:00:00). Any suggestions/fixes or am I going to have to make my own deployment system ...Show All

• Windows Forms project publishing in visual studio

  hello, I am in desparate need! I've writen a visual basic .net program that I can build/run locally, install/run after publishing to a file share but others cannot install or run (form bin directory). From project properties window: All references are copied local true, all namespaces are checked as imported, all images are set in a resource folder, prerequisites (.net framework 2.0 and windows installer 3.1) are downloaded from application location, .deploy extension is used (if it matters), and application files are include (auto). How can others run my program Please help, thank you. not really if the error is coming up as the standard Windows error messages (program encountered an error) - you can mayb ...Show All

• Visual Studio Team System baseless merge not creating a folder relationship?

  Hey guys, I think I understand most of the caveats of a baseless merge, but I saw some behaviour that I wasn't expecting. I have 2 folders that look something like: Main - file1.cs - file2.cs - file3.cs Release - file1.cs - file2.cs - file3.cs I did a 'tf merge Release Main /baseless /recursive' to merge the 2, resolved conflicts and checked in. But, when I select a folder like Release and choose Merge in the source code explorer, I don't get any merge target branches. I was expecting to see Main . If I select a file in Release like file1.cs and choose merge, I get a target file1.cs in Main like I expect. So when I do a baseless merge, the branch/merge relationship does not seem to extend to the f ...Show All

• SQL Server Restoring SQL2000 after upgrade

  I performed an in-place upgrade of my SQL2000 database to SQL2005. I am having too many problems at the moment with compatability issues between SQL 2005 and VS2003 and need to roll back SQL 9.0 to 8.0. Are there any white papers, or published procedures for doing this I have a tape backup of the 2000 system, but there have been various updates to the databases during the past 3 weeks since the upgrade. The structure of the databases have not changed. Please help! There is no vehicle to rollback. You will want to reinstall sql2k as a different instance, restore data from your tape backup and then use data import/export to update sql2k data with sql2k5 data. If you're looking for a way to mount a sq ...Show All