nancy77's Q&A profile

• Visual C# Subtracting Times with Date

  I thought this might have been a simple task...I need to subtract 4 hours from the current datetime that is input.  The datetime format is mm/dd/yyyy hh:mm and the hours are a 24 hour clock.  After it's input, I then take and parse this string into a strDate array and strTime array by doing args[0].split('/') and args[1].split(':').  After this is where I try to subtract the 4 hours, but there's a whole lot to account for as in if the hour is 1, you'd have to go to the previous day and if the day is the first day of the month, going back one day would take you back another month, etc.  Is there an easier way to do this   The month is really what's throwing me.  Thanks in advance for the help! ...Show All

• SQL Server Data Flow Task & Exception Join

  Hi, I need some suggestions how to achive the followings using Data Flow Task I have a csv file containing some logs from a different system. CSV file contains columns Code & ErrorMessage. I also have a SQL table called filters. This table also contains code column. I need to do the following two things 1. Get all record from csv file where code does not exists in Filters (SQL table) 2. Gell all record from csv file where code does exists in Filters(SQL Table) and ErrorMessage contains a specific keyword. I can add a derived column with the following function IsExists = FINDSTRING(ErrorMessage,"MyKeyword",1) which will tells me if MyKeyword contains in the message but I donot know how to filter IsExist ...Show All

• Visual Studio Express Editions how do i execute a command when i press a button

  hello i am new to this language and even a simple code in a button i can't make it..please help here is my problem. when i click a button i wanted it be disabled and change its text too, i try it like in VFP coding but it won't work... help is highly appreciated thank you very much to c-sharper Hello All. Madix_t: In the Designer view of your form: Double-click the button in question. This will automatically wire up the event handler for the button.Click event, and open the code editor so that you can enter code in that event handler. Then, enter the code to disable the button and change its text, like so: button1.Text = "whatever"; button1.Enabled = false; HTH. ...Show All

• Visual Studio 2008 (Pre-release) FindResource and User Controls

  I have a user control, that has a number of merged resources. When the control is being rendered its uses this.FindResource() to build the layout because how the control looks at run time is depended on an xml configuration file. The problem I am getting is an exception is being thrown by the find resource saying it cannot create an instance of the parent window. I am assuming that is is because the FindResouce is trying to navigate up the Visual Tree because it hasn't found the required resource. Is there any way of controlling how far up the Visual Tree, for example I'd like to stop it from going outside of the resource that are allocated to the user control. Thanks in advance. Andy If you wa ...Show All

• Windows Forms different form height shown in the screen of notebook and desktop?

  I set the form height 730 in the screen of desktop, but shown 780 in the screen of notebook. How should I got the same height in both screen ...Show All

• SQL Server WHAT NEXT AFTER INSTALLING SQL SERVER EXPRESS?

  I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases. However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed. Could I have downloaded the wrong package Ok well I'd install the tools next. You ca ...Show All

• SQL Server Unsupported HTTP function call was made error.

  Hi experts, I'm new to this forum. I have been searching around for the solution to the problem that i'm having, and I can solve it. I'm having the same problem as the title say....unsupported HTTP function call....The thing is that it worked on my development server. When I transfer all the source to a new pc and execute it, it failed with the error in the subject. I uninstalled and reinstalled everything. I ran the http://iissvrname/iisvirtualdir/sscesa20.dll and I get this "SQL Server CE Server Agent" which tell me that IIS & SQL CE are setup correctly. Here is the error log: Source: Microsoft SQL Server 2000 windows CE edition Number: 80004005 NativeError: 28017 Description: An incorrect or unsupported HTTP func ...Show All

• Visual Basic Missing ApplicationLog.exe

  I am learning Visual Basic 2005 and I am going through the WalkThroughs in the MSDN documents. Today I was working on one that was writting to the application log. The program aborted because it could not find the program ApplicationLog.exe. The complete path is c:\Document and Settings\Robert\LocalSettings\ApplicationData \TemporaryProjects\ApplicationLog\bin\Debug \ApplicationLog\bin\Debug\ApplicationLog.exe. When I looked for the path it wasn't there. Well, everything up to and including Robert was there. Bad install Thanks Bob Hmm - the doubled ApplicationLog\bin\Debug\ApplicationLog\bin\Debug is strange. Did you build the application without errors -- SvenC ...Show All

• .NET Development My database doesn't update !!!???

  I wrote a simple program with ASP .NET that modify data in a table and I'm using SQL server 2005 Express edition as my database engine. But when I modify data in a table (in the webpage) and then when I try to update the database, nothing happends, it even doesn't give me any error, and when i try to see the table again nothing is updated in the table. These are the things that I have done: 1- I gave permission to ASPNET and NETWORK SERVICE so they can Select, Update, Delete,... on that table. 2- I gave permission to ASPNET and NETWORK SERVICE to the table itself. 3- I evern assign the ASPNET and NETWORK SERVICE as the db_datareader and db_datawriter and db_owner. What else should I do Is there anything that i missed ...Show All

• Visual Studio Team System Migration, common code- Sync between VSS and TFS?

  Are any new tools available that would help with the migration period from VSS to TFS. We want to move product teams over one at a time, but they rely on common code that spans teams. So we want have VSS changes sync'd with TFS so that the team migrating to TFS can work on TFS and teams still using VSS can continue to do that. Are there other ways people are dealing with common code during a migration Thanks Hello, The Migration and Synchronization Toolkit that we are currently developing will facilitate the development of a tool to sync files between TFS and another source control system (i.e. VSS). You can check out the TFS Migration blog for more info: http://blogs.msdn.com/tfs_migrati ...Show All

• Visual Studio EnvDTE80.TextDocumentKeyPressEvents.BeforeKeyPress randomly not working?

  Hi, I have hooked up the EnvDTE80.TextDocumentKeyPressEvents.BeforeKeyPress in an addin I wrote to check out from Perforce when a read-only file is modified. It works fine most of the time. But after a while, I just stop getting the event. It doesn't seem related to switching solutions or anything like that. The only way to get the functionality back is to restart the IDE. I register the event handler in Connect.OnConnection, and the addin is constantly loaded. Anyone have any ideas I can circumvent it by re-registering the event, but that's a hack. Could this be a problem to do with the Connect class being destroyed after some time Cheers, Rory Hi, Well I checked, and I don't think this ...Show All

• SQL Server select based on repeated numbers

  i have telephone numbers in my table and i want to select based on numbe of repeated numbers.. for example.. 39657777 39111132 36399991 The first has foue 7s, second has four 1s and the thrid has four 9s. Jassim: I am not sure how to filter the data. Are you looking for a predefined number of 7's Are you looking for records with an aggregate digit count of 4 or more A you looking for numbers with four digits in a row that are all the same I cannot be sure of exactly what pattern I am looking for. What follows might be what your looking for; do any of these look like the idea Dave set nocount on declare @phone table (phoneNo varchar (10)) insert into @phone values ('39657777') insert into ...Show All

• SQL Server EASY! Trim string?

  I have values in a matrix takin too much space. Since they are just used as the matrix column header, cant i trim it or something. To display just the first 3 letters of the the attribute, and not the whole string Whats the code for that =Fields!Collision_Type.Value thats my field right now. Please help! thanks! There is no difference really, the Mid function allows you to give it a starting position and how many characters to return. Jarret ...Show All

• Visual C++ Accessing Image resource (bitmap)

  Hi, I tried but without success to access a bitmap file which I added in my application resource file as following: "resource.h" #define IDB_LOGOBWVISU 107 "app.rc" IDB_LOGOBWVISU BITMAP "Dessins\\LogobwVISU.bmp" How do I access this resource from within managed C++ code taking into account that I want to assign it to following Image object: System::Drawing::Image* Logo_Visu; Many thanks in advance, Stephane Hi,   In fact, I'm using Visual Studio 2005 standard edition.  Do I still need to install that Platform SKD or just add " User32.lib" to my linker dependencies like suggested by Kenny   Or maybe both ...Show All

• Visual C# Getting an interface implementation from a type

  Hi There, I have an assembly which contains a type which I know to implement a specific interface. I can retrieve the interface from the type but whenever I try to cast the type directly to the interface (to get its implemented properties) the cast fails. Here's the code: Type plugInInterface = type.GetInterface( "IPlugIn" ); // This succeeds and I get plugInInterface back. if (plugInInterface != null ) { // Found the a type that implements the IPlugIn interface. // Load it up! IPlugIn plugInType = null ; if (type is IPlugIn ) // This fails. { plugInType = type as IPlugIn ; } } Does anyone know what I'm doing wrong here It seems that if I can successfully retrieve the ...Show All