Bruce Baker's Q&A profile

• Windows Forms How to add two numbers from two text box? VB.net

  Please read and help... Hi I have 8 tabs in windows form. I have a text box (test1) in tab5 and textbox (test2) in tab8. Both accepts only numbers. If the total value of the two box is greater than 99, then the messge box display and focus on one of the control box. it works fine only in the following condition: 1. Run the windows form and click the first textbox in tab5 and then click on the textbox on tab8 - works fine if the total reaches 99. It fails and crash under the following condition. 1. Run the windows form and click directly the textbox in tab8 - it crash when I leave the control. The code I am using is given below. Function PurchNoAddition( ) As Boolean If (Test2.Text) + +(Test2.Text) > 99 Then MsgBo ...Show All

• Windows Forms Displaying Database information in ListView

  I created an address like database with first and last names and include a photo location in the database. Now I want to use ListView to display the photo and name of each row(person) in my database, but I don't know how to retrieve a string from a single cell in my database. can anyone help hang on - I'm confused now with the requirements. the code I had demonstrated was to go through each row of the selected column and add the current row column value into the listview as a normal item - is this not what you wanted The reason for this approach is because you cannot really databind the ListView control with the dataset ...Show All

• Visual Studio How the let Studio 2005 break in source code if there is a C++ first-chance exception?

  I am running my application from Studio 2005 and I can see the first-chance exception (C++), but it doesn't break anywhere in source code. As a result, I can't find out where is the place in my code cause the exception. 'IdsDoWebServer.exe': Loaded 'D:\CurrentVersion\Apps\DataConsole\WebServer\ReleaseMinDependency\IdsDoWebServer.exe', Symbols loaded. 'IdsDoWebServer.exe': Loaded 'C:\WINDOWS\system32\ntdll.dll', Exports loaded. 'IdsDoWebServer.exe': Loaded 'C:\WINDOWS\system32\kernel32.dll', Exports loaded. 'IdsDoWebServer.exe': Loaded 'D:\CurrentVersion\Support\IdsErrorHandlingSupport.dll', Symbols loaded. 'IdsDoWebServer.exe': Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.MFC_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_dec6ddd2\mfc80 ...Show All

• Smart Device Development .NET compact framework 3 / WPF

  Hi, i've been looking for info about this but with no success, when will the .NET compact framework 3.0 be available (i am not taking about netcf3.5) .To be more precise, i would like to know when will the support for WPF be available on mobile devices, is it planed with Windows Mobile 6 or sooner thanks You're right, i will take a deeper look at WPF/E but the problem is that the device i'm working on is simply WindowsCE5.0, not Windows Mobile, so i'm not sure to be able to install the WPFE plugin ... Regarding Direct3D for Windows Mobile, it's nice, but with Managed Directx 2 being cancelled due to all the XNA stuff, i think i'll wait and see what will be Microsoft solution for Windows Mobile, maybe XNA also as it was originally pl ...Show All

• Internet Explorer Development Internet Explorer 7

  i have internet explorer, the original one. i have been trying to download IE7 for 2 weeks. is there any ways to solve this problem Like Myles, I'm having problems installing IE7. Microsoft Upgrade started to install IE7 by removing existing IE. Unfortunately it crashed part way through installation redenering existing IE inoperative and refusing to install IE7. Now I cannot remove IE by remove software on Control panel and I cannot install IE7 as everytime I try it tells me it wants to remove previous IE but that there is a file missing and it crashes. I'm using Windows XP home edition. regards Richard ...Show All

• SQL Server How to pass command line parms to the Execute Package Task

  I have a ForEachLoop parent pkg that reads thru the file system of dtsx to be executed. I would like to pass CLI parms to the command itself (dtexec). I'm not looking at passing values to the child pkgs but rather additional command line values such as: /CONFIGFILE "C:\myconfig.dtsConfig. In my expression builder for the PackageName I added the additional string but during the execution, the reference to my dtsconfig is ignored without any errors and the child pkg runs using the default values provided at design time. @[User::PackageToRun] + " /CONFIGFILE C:\\myconfig.dtsConfig ". How does one add additional CL values during the runtime for Execute Package Task Thanks, Anatole ...Show All

• Windows Forms GDI+ filling with transparent color

  Hi. I have user control which has its background color set to Transparent. I do my own painting and I need to clear what I draw - but how If I fill the area for clearing with Transparent color, it does not work... thanks Well...the problem is, how to clear the lines...eg. to draw small rectangle where do you want to show the background. second question... how is the overriding user control you mentioned different than setting its DoubleBuffered to True ...Show All

• Visual Studio Retreive Project location

  Is there a way to retrieve the location entered by the user when creating a new project similar to $safeprojectname$ ie File > New Project Or will I have to use EnvDTE to determine the path of the project Kosmo Hi Kosmo, Sorry I wasn't clear enough. The version of the Clarius SFT that contains this provider is not out yet (that is why I pasted the source code so you can use it right away before waiting for it). The error you're getting is because "base.VisualStudio", this assumes your ValueProvider type inherits from "ValueProviderBase" (which is a base type for all value providers in the SFT providing extra features). So you have two options: 1) add a reference to Clarius.Guid ...Show All

• SQL Server Server: Msg 170, Level 15, State 1 in stored procedure

  Hi all, Please help!!! I'm quite new in SQL Server and this is the problem i face. I've written the below stored procedure in SQL Server 2005 and when i'm trying to install it in a SQL Server 7 platform it keeps giving me the error: Server: Msg 170, Level 15, State 1, Procedure BrowseServiceUsers, Line 11 Line 11: Incorrect syntax near '('. Server: Msg 170, Level 15, State 1, Procedure BrowseServiceUsers, Line 11 Line 11: Incorrect syntax near '@p_nPageNr' . I suppose it's a platform problem but i really don't know what exactly is the problem. Below you may find the stored procedure: CREATE PROCEDURE dbo . BrowseServiceUsers @p_nRecordsNrPerPage INT , @p_nPageNr INT , @p_sLastName TLastName = '%' , @p_sFirstNa ...Show All

• SQL Server why not showing nulls?

  Hi, I have two tbls joined via a varchar field.. which in tbl I have to use a CASE statement to format it correctly for the JOIN.. All works well.. however, if I add a WHERE clause to the statement, with the WHERE clause affecting only one of the JOINED tbls.. All the NULLS are not shown. I should get results like: Postcode Count tf4 0 tf5 23 tf6 15 tf7 0 etc Whereas, when I add the where clause, none of the "zeros" are shown, so I get: tf5 23 tf6 15 Why is this Here's the SQL: SELECT ISNULL(COUNT(CASE LEN(REPLACE(dbo.Customers_Trade.PostCode, ' ', '')) WHEN 5 THEN LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 2) WHEN 6 THEN LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 3) ELSE LEFT(REPLACE(dbo.Customers_Trade.Po ...Show All

• SQL Server Copy table Structure including primary keys, index etc.

  Hi all, I was wondering if there is a SQL command to copy the table structure of a table that includes primary keys, foreign keys, indexes, etc. Thanks and have a nice day to all Hi, The easiest way to create the script is to right click the original table within SQL Server Management Studio and select "Script Table As ...\ Create To\ ..." . This will create a script for the table and its indexes. Then you need to run the script but with the new tablename. After that, you need to copy the records using a insert/select command. (it is best to set the constraints/indexes afterwards). Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal B ...Show All

• SQL Server positive and negative signs

  i have account_entries table which has the following fields: debit_or_credit entry_amount and I want when inserting every field to check if the inserted row was assigned to (D)ebit and (C)redit it should change the entry_amount accoridanly. maybe something like trigger plz help... I think it's better to keep the credit as - and debit as + in the database otherwise i have to place check routines everwhere, all screen and reports.. ...Show All

• Visual Studio Express Editions Another Newbe How to question

  What configuration or code would I use to insert for 2 radio buttons. In other words, I have a label that ask the user to choose only one radio button(or person) amoung two radio buttons (the other person). When the user selects one radio button, this button or person becomes the main focus of the program. However when the user chooses the other button or person then that person or button becomes the main focus of the program. Is it possible to set a code for this Any help please and thankyou You can add radio-buttons both at run-time and at design-time, you must sit their Text property then get their value by Checked property. Is this helps you ...Show All

• Visual C# problem with IS operator for types loaded thru reflection

  Novice question. I have this piece of code: if (attrObject is MyCompany.Work.AccountGuidAttribute) In the debugger, I stop at this spot. attrObject is of type "MyCompany.Work.AccountGuidAttribute". However, it wont step into this IF . Then, i added testing statements: Type t1 = attrObject.GetType(); Type t2 = typeof(MyCompany.Work.AccountGuidAttribute); They're identical when examined in the debugger. MyCompany.Work.AccountGuidAttribute is referenced in thru a project reference in VS2005. attrObject is loaded shown in below psuedocode: System.Reflection.Assembly pluginAssembly = System.Reflection.Assembly.LoadFile(pluginFilename); Type[] pluginTypes = pluginAssembly.GetTypes(); foreach (Type innerTyp ...Show All

• Commerce Server Guidelines for Marketing Reports

  Hello, I'm using CS2007 to serve banners on a website. I'm looking for some guidelines to provide my client advertising statistics, mostly concerning Ad Requests. I already setup a SQL Server 2005 Report Server, but i can't get any info on how to configure it to get the CS2007 banner information. Any help will be greatly apreciated. Thanks. Hello Alan, My log files are located on two different servers. I'm now processing the files locally on the Report Server and trying to automate the task. For now i have one more question: the DTS import tasks include the Datawarehouse processing on the Analysis Server, or this has to be done after the DTS execution Thanks, -- Jorge ...Show All