Becker2's Q&A profile

• Visual Basic TabPage

  Hi, I am using a tab page docked in a form, how do i change the background colour ANdy You can change the background color of the TabPage's page area (where all of the controls sit) itself with the BackColor property... however you cannot change the color of the tabs themselves or the overall TabControl control without painting it yourself. ...Show All

• Visual C# Loading MFC DLL in C# Windows Application

  I am trying to learn how to call an MFC dll from C# (both are developed under the .NET 2003 platform) and I'm having problems with getting the C# app to recognize the compiled .dll. After creating the proper classes in both code bases I complied them and tried to include the .dll in the C# app, but I continuously get an error. I have gone so far as to use the wizard to create an unaltered C# windows app and an unaltered MFC .dll, complied the .dll (in both debug and release), and then tried to include the mfc .dll as a reference in the C# app (both the debug and the release versions). Everytime I try to include the MFC .dll I get the following error: "A reference to ..\test.dll could not be added. This is not a valid as ...Show All

• SQL Server XML sample gets error: "CREATE ENDPOINT" not supported

  I installed the latest version of SQLX and tried to run the XML sample. C:\Program Files\Microsoft SQL Server\90\Samples\Engine\xml\XmlManuInstructions\ReadMe_OnlineManuInstr.htm The first part of the install.sql ran ok, but it chokes on the CREATE ENDPOINT line: is this really a limitation on the Express edition or did I miss something on installation or configuration Msg 7878, Level 16, State 1, Line 3 This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server. hi, I did not investigate the provided sample in detail, but AFAIK, SQLExpress provides limited support for Service Broker (only if a Standard or higher edition is present in the message chain) and n ...Show All

• SQL Server MS Access' IIF function in a MS SQL Server view

  I am translating some of my Access queries to SQL views. In one of those, I had a very convenient function called "IIF" (e.g. IIf(IsNull([Remark]),"NULL","NOT NULL"). How is this function called in the MS SQL Server 2000 Apparently I cannot use either "IIF" nor "CASE" in the query/view..... I'm used to using COALESCE instead of ISNULL, so that's what I was thinking (but it still won't help his problem).  You should be able to use CASE in a view. Maybe he was thinking from the Access query.   ...Show All

• SQL Server SSIS Expression result limit of 4000 bytes

  I have a package with an input column that is varchar(8000). I want to strip the first byte off of this column and put it in one result column and the remainder of the field I want to go to a second column. If the input column is an empty string, I want to return NULL. Pulling the first byte off works fine, no issues, however putting the remainder of the input column into an output column is giving me a little trouble. If I use this expression: LEN(FLD1) == 0 NULL(DT_WSTR,1) : SUBSTRING(FLD1, 2, LEN(FLD1) - 1)) I get an error that says my expression evaluates to a string of greater than 4000 bytes. If I do this instead: LEN(FLD1) == 0 NULL(DT_WSTR,1) : RTRIM(SUBSTRING(FLD1, 2, 7999)) The expression passes muster but ...Show All

• Windows Forms Is there any chance to modify contents of Form InitializeComponent permanently using Designer?

  Hello,   I'm trying to modify InitializeComponent of Form. But every time, form reload or change something, InitializeComponent discards my editing. I wish to know if it is possible to do permanent editing using Designer functions, and how The point of my problem is to replace line where is created ComponenetResourceManager  with custom ResourceManager. System.ComponentModel. ComponentResourceManager resources = new System.ComponentModel. ComponentResourceManager ( typeof ( MdiForm )); Using this change I will can reuse other automaticly generated code by designer, where it apply resources to objects. For example: InitializeComponent . . . MyComponentResourceManager resources = new My ComponentReso ...Show All

• SQL Server Database Mail does not work from SQL Agent Job

  Receiving Message: [264] An attempt was made to send an email when no email session has been established Just installed Service pack 1 and that did not help. http://blogs.msdn.com/gopsdwarak/archive/2006/04/25/583434.aspx Take a look at the above blog and this should address the problem you are running into. Thanks, Gops Dwarak ...Show All

• Visual C++ Components in an assembly and the Windows form designer

  In an assembly I have components whose only purpose is to serve as a base class for the actual components I want the user of my assembly to manipulate. Evidently the C++/CLI compiler does not let me specify that the base class is a 'private ref class' since this invokes a compiler error which tells me that the base classes for any public CLR class must all be declared as public classes also. How then can I get the Windows form designer to not list any base class components in my assembly in its list of components which can be dropped in a Window form or into a component container No. I got a suggestion that I can use the attribute System::ComponentModel::ToolboxItemAttribute(false) prior to the base clas ...Show All

• Visual Basic Culture date format and system dat format conflicting

  my VB.net 2005 Application is My .Application.ChangeCulture( "en-GB" ) the problem is, my OS dateformat may be will not be matching my application culture. e.g. 7 april 2007 at my application = 2 July at my OS my prblem is: when I send 07-02-2007 to my database it will save depends on my OS format then when I retrieve the value it will be 02-07-2007, it changed from april to july I'm really not sure what the problem is: a date is a date regardless of the culture. I don't use Access, but it should be irellevant. Simply inserting/modifying date/times as universal format inserts the data correctly. It doesn't matter what the application culture is, the OS culture or the Database culture. Insert the date as a ...Show All

• SQL Server How to write a T-SQL script to replace Val() in MS Access?

  I am converting an MS-Access DB to SQL-Server, and one of the queries I'm converting uses the VB Val() function in the ORDER BY clause. Is there any T-SQL function that can mimic this CAST and CONVERT return errors because some of the data is non-numeric. The column I am ordering is a varchar(5) with ID number 'ZZ0001', 'CC0002', 'AA0003' etc . I would like the dataset to be sorted by number only : 'ZZ0001' 'CC0002' 'AA0003' Thank you The actual best thing to do here is to have (at least) two columns for the data. Just the numeric part, and just the letter part. Anytime you have to do a substring (the left and right functions are technically forms of substring) you are putting undue pressure on the SQL engine. ...Show All

• Visual Studio Team System TFS Not sending emails anymore

  Everything was working fine and then no more emails were being sent. This is the message in the Event logger: TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 9/6/2006 6:44:32 PM Machine: DALENG01 Application Domain: /LM/W3SVC/3/Root/services-2-128020418508424285 Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727 Process Details: Process Name: w3wp Process Id: 6760 Thread Id: 7184 Account name: JDA_DOMAIN\tfsservice Detailed Message: TF50282: Could n ...Show All

• SQL Server Creating a Database

  Hi. Im brand new to using SQL. I downloaded the SQL Server 2005 Trial Edition (Enterprise Evaluation Edition) and installed it. How do i create a database The only thing i can seem to open is the SQL Server Configuration Manager which just lets me start the Server. Did I install it wrong or open the wrong program If someone could help I would greatly appreciate it. you should be able to find the enterprise manager probably you have downloaded the Express edition or you failed to set up the database engine and the client tools ...Show All

• Visual FoxPro Update Form by clicking Grid record

  Is there any way to see the same record in Form by clicking the grid's record when I click on grid's record within the Form, it won't show or refresh/update the Form. (It's a one Table Form that has a grid on one side) Thank you very much, it works the half! because the text fields won't refresh...ANY help appreciate  ...Show All

• .NET Development FTP ?

  Does C# have FTP Methods that are easy to use I will be starting on a project soon and have the choice of using VB, C#, or Java. I think the FTP issue will be my biggest hurdle and I want to make it as easy as possible from the start. Any hint, ideas, tutorials I could be pointed too would be great. Post any issues I might encounter if you have experience in working with theses methods. Thanks! Thanks for all the links! I'm sure they will all come in handy. I've never messed with FTP before and just had no clue as to what I was getting myself into. I'm sure I'll be posting new questions soon. Thanks again! ...Show All

• Software Development for Windows Vista Using many USB Audio Devices

  I am starting to see various issues with USB Audio Devices. I am using a significant number of USB Audio devices. The devices are Turtle Beach Audio Advantage Micro and use the USBAudio standard driver. They are connected with a D-Link DUB-H7 USB 2.0 hub. 1) Using more than 5 USB devices on hub I am writing an application using the Core Audio APIs. I discover all the audio endpoints using EnumAudioEndpoints. Then I loop thru all devices and initialize an IAudioClient for each device so I can control the sound for the app per device. When there is more than 5 devices, the subsequent devices on the hub fails when calling IAudioClient::Initialize returns HRESULT 0x80070001 2) CPU Usages with multiple USB audio endpoints Without even playing a ...Show All