orangy's Q&A profile

• SQL Server How to Delete Files on Maintenance Plan

  Hello, I am creating a Maintenance Plan in SQL Server 2005. The 'Back Up Database Task' has the choice 'Create a sub-directory for each database' as SQL Server 2000 does. But when I add a 'Maintenance Cleanup Task' I do not see a choice to delete files on subdirectories. Looks like it only deletes the files from the directory I specify. So, looks like SQL Server 2005 is removing some functionality already available in SQL Server 2000. Is there a way to delete those files without needing to specify each directory I do not see any documentarion about xp_delete_file either. Thanks, Ben Nevarez I am ...Show All

• Windows Forms Datagrid clear

  Hi, I use a datagrid to show a query's results. (datasource=datatable). But I need to clear rows before I get new query results. How can we do that Thank you... I cleared DataSet instead of DataGrid. It worked. Thank you. ...Show All

• Visual C++ MFC scroll bar control

  I am making an MFC application and I want to have a dialog with a scroll bar.  I have added the scroll bar control from the tool box to my dialog, but it doesn't actually do anything.  Are there any additional things I need to do to make my scroll bar scroll In short words, you've got to deal with the message WM_HSCROLL (or WM_VSCROLL for a vertical scroll bar control). You may refer to Inside Visual C++ 6.0 ...Show All

• SQL Server 64 bit TextFile ConnectionString unable to dynamically change??

  Hello, On a 64bit Itanium cluster, I'm having a problem dynamically setting the ConnectionString of a TextFile Source using the "EvaluateAsExpression" = True and setting the ConnectionString using an expression from a variable. I get the error message: -1073647612,0x,The result of the expression "@[User::vFullFilePath]" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property. This is not a problem at all on a 32bit machine. I can run the same package on 32bit and it runs fine. The funny thing is, I'm able to dynamically change the ConnectionString of a Logf ...Show All

• Visual Studio 2008 (Pre-release) How to get control location in screen coordinate system

  I want to show dialog over control. So, I need to get control location in screen coordinate system. Window parentWindow = Window.GetWindow( myControl ); Point point = new Point( 0, 0 ); point = myControl.TranslatePoint( point, parentWindow ); point.X += parentWindow.Left; point.Y += parentWindow.Top; myDialog.Owner = parentWindow; myDialog.Left = point.X; myDialog.Top = point.Y; myDialog.Show(); But this code is not correct because parentW indow has caption and border. Please teach me a correct means. We're looking at adding API for this, since its not trivial to get right, especially if you want ...Show All

• SQL Server DB Mirroring Monitor and querying the "other" db?

  So I successfully got the mirroring to run and now I'd like to see what's going on between the two servers ( i'm not using a witness). I launch the Database Mirroring Monitor and its showing the two servers but when I go to the history column I'm not seeing any data movement. I've done a an update on a db with 1500 rows so I was expecting to see this show up. Also, is there anyway to query the database thats acting as the mirrored db thanks daniel Can you verify that you are connecting to the Partner server as SA or in the DBM_Monitor role You leave the monitor up and running, corre ...Show All

• Visual Basic How to terminate a running dll from within the dll in VB. (VeryUrgent!)

   Hi, can anyone help me and let me know how to terminate a dll from within the dll when an error occurs and return to the calling app.   If it's a subroutine   - Exit Sub If it's a function - Exit Function If it's a property - Exit Property. If you have resources which need disposing.. use the Using statement. ...Show All

• SQL Server dynamic images in sql reporting services 2005

  Hi all,  I am currently working on some reports where I need to display images dynamically. there is one total field whose value ranges between 0 and 100 %. amd I need to display different images depending on the range of the value. for example, if the range is between 80% - 100%  smily face. 60% - 80% normal face 40% - 60% sad face. Can any one help in approaching this. Initially I worked with only static embeded images. It also helps me in solving another problem. I need to change the company logo (header image) as per the company in the common report template provided by the provider dynamically. ...Show All

• .NET Development How to Serialize a non Sertilizable object into Binary?

  Hi   ,   I have an object ObjXML of type XmlDocument (object may be of any non serializable class). I have to Serialize it into Binary. I know that XmlDocument does not implement ISerializeable.   That's why according to framework we cannot serialize it.  So is there anyway around to get this object (ObjXML) into Binary.   I will be   highly   obliged to your help.     Regards Muhammad Waqas Bashir The following uses a MemoryStream (just another way of doing it) [ Serializable ()] public class Custom ...Show All

• Visual Studio Team System TeamSystem Server December CTP or Beta 3?

  I am wanting to finally try out team system. This will just be for my home system and i won't be using it for anyone other than myself. First of all; i would like to use December CTP because it would have all the latest additions but im worried when the final version comes out that i won't be able to upgrade it. Should i be worried I will be using it for primarily my source control system. I will just be playing around with the other features. I have stuff at home that i don't want to loose of course. Also will i have to rebuild the machine to put the final version of team server on So should i go with December CTP or just stick to Beta3 ...Show All

• Windows Forms How can I create an object based on a type ?

  Hi I have a type of an object, something similar to: Type x = typeof(Button); How can I create an instance to a button (new button) using the type stored in x instead of the class name Something like:  x MyButton = new x(); Of course this code is wrong, but I think you’ve got the idea Hi LiveTheLife Try with the Activator For example in& ...Show All

• Windows Forms How can I call a function in parent form from within user control?

  Hi all, Can someone please fill me in on this.  I have created a composite control for my windows application and on this control I have a link label. In the parent form, where the composite control resides, I have a function I would like called when the link label clicked.  For example, user clicks the link label on the composite control and ...Show All

• .NET Development Display data from multiple tables into datagrid

  I am using visual studio 2003 and was able to create a dataset and bind it to sql adapter but the data is from one table. I want to view the data from multiple table when i add the tables to dataset it only shows me 1st table. Not sure how to accomplish this... Any help will be appreciated. You have to use different datagrids or if you want it in the same grid you can create something called a view in the database & then bid it to that view. See below I created a view using enterprise manager for sql server called "bid21" & bind it to the adapter. thanks vj Example in C# ---------------------------- ...Show All

• SQL Server SELECT INTO using a data-flow

  Hi, A T-SQL INSERT INTO operation inherently expects that the destination table already exists. However, the T-SQL SELECT INTO operation works by creating the destination table as it inserts the data. Like INSERT INTO, an SSIS data-flow inherently expects that the destination table already exists. Can anyone figure out how you might be able to do the equivalent of a T-SQL SELECT INTO operation using a data-flow I'm thinking a custom destination adapter might be able to do the job. -Jamie Bob Bojanic - MSFT wrote: our Triage has not looked at this yet. They are not looking at DCRs at thi ...Show All

• Visual Basic sending mails

  Hi, I'm trying to send mails from within VB6 code referencing outlook.application references. I've got 2 queries: 1. How can I modify the sender or sender's email address 2. Everytime it tries to send the mail, a message pops up saying...an external program is trying to send mail on my behalf & if I'm sure to send it And this message will not go away unless I okay it!! I require to send out regular mails at fixed intervals, without any intervention. Hi Jasneet, Please read through the following Knowledge Base article: Description of e-mail security features for developers http://support.microsoft.com/kb/290500/EN-US/ It gives a c ...Show All