muelle60's Q&A profile

• SQL Server How SQL Server handles slowly changing dimension

  In our application we have created a SSIS package which extracts data from staging table and places the same in destination table. We have created a slowly changing dimension for the same. Slowly changing dimension uses a composite business key of two columns to decide whether it is a old record or a new record. Problem : On execution of the package it copies duplicate records with same business keys instead of updating the same. Also the same does not happen for all records. For few records update works fine but for others it inserts a new duplicate record. I will appreciate if anybody can guide me where I am doing something wron ...Show All

• Windows Forms Custom Control on ... webpage problems

  Alright, wasn't sure where to put this since it's about WInforms, and webpages. I tried to make a custom control for use on a webpage.  I'm new to this idea, but according to what I've read I should be able to use the < OBJECT > Tag and take any control I complie into a DLL and have it appear on a web page. So I made a simple test control, a button.  then added a webpage to my solution, placed the object tag (and yes it's formatted correctly) on the page and I get a box the designated size with a "picture" logo.  Not the missing picture logo.  The control never apears. Since I'm new, I figured I must h ...Show All

• Visual FoxPro migrating VFP app to .net (architecture question)

  Hello everyone! I'm a fairly experieced database developer (SQL Server primarily, and Oracle quite a bit less). My experience with .net is primarily vb.net to built asp.net applications, using web services as my middle man. I just started at a new company which has a few legacy systems, one of which is a rather large FoxPro application. There are a host of problems associated with it, primarily data conflicts. Because the company has grown so much, there are a few copies of the data floating around (different parts of the country), and a custom data replication tool was built to try to keep all the copies in synch. From what I understand, th ...Show All

• Visual Studio ReportViewer Drillthrough Problems

  Using VS 2005 B2 and C#. I'm attempting to create a UserControl that includes the ReportViewer.  The UserControl is in a dll. From what I can tell, if you use a dll, the viewer can't find the embedded report resource.  I've overcome this by loading the report resource manually. My problem is that I can't seem to configure a drillthrough to another report embedded in the same dll project.  (I've tried the report name ("Report.rdlc") and the qualified name ("Project.Report.rdlc")).  When I run the report, the report doesn't recognize the drillthrough--I don't see the pointer (no little hand) and whe ...Show All

• Windows Forms HTML in controls

  I haven't done Windows programming for a while, and am just getting back to speed, in the mean time reading about the features in .NET, Longhorn, and Whidbey. I see the Whidbey release supports a .NET based WebBrowser control, which should be good. However, what I've wanted for a while is just the ability to use HTML within any control and have it ...Show All

• Visual Studio Grouping by a date

  I tried to group the report by shipping dates, the group value would be "MMM-yyyy" format of the shipping dates ( or group by month ), could anybody tell me how to do it correctly I couldn't find the fucntions to do it. Thanks in advance. Long  Something like: =CDate(Fields!MyDate.Value).ToString("MM-yyyy") in "group by" should do the trick. ...Show All

• Visual Basic Crystal missing from Clickonce Preq

  I do not have Crystal available on the publish/prerequisite screen. Only Framework ans SQL Server. Anyone know why The app does not run on deployed machines. Thanks Hi, In deploying projects with Crystal Reports. You'll have to include the merge modules (*.msm) from crystal reports ( try downloading it here ). specify the license of your crystal in the merge module and your done...       cheers, Paul June A. Domag ...Show All

• Smart Device Development topmost window

  Hi, I want to have a non-fullscreen window that can be displayed anywhere on the screen and at the real top of the z-order, even above the task bar. How can I do that Hi, Set forms TopMost property to true. Your form will be topmost on all other applications but i am not sure about task manager. Best of Luck. ...Show All

• Visual C++ Thread again!

  I changed my code. to this and it's work properly . but I can't to add " str " to a listobx. what should I do void CThreadTestDlg::OnRunThread() { BOOL T=TRUE; Suspend(T); } UINT CThreadTestDlg::ThreadSimple(LPVOID pParam) { CWnd *pWnd=new CThreadTestDlg; CTest *pTest=(CTest*)pParam; BOOL b=pTest->SetTrue(); while(b) { CString str =pTest->RandString (); pWnd->MessageBox ( str ); ///----m_listbox.AddString(str)----------------error. /// CListBox m_listbox is bublic member in CThreadTestDlg } return 0; } void CThreadTestDlg::Suspend(BOOL bSus) { if(!bSus) { if(m_pThread) { HANDLE hThread ...Show All

• Smart Device Development VS 2005 Express and WM 5.0 SDK

  Hi, Is it posible to develop aplications for Windows Mobile 5.0 on Express editions of Visual Studios 2005, or you have to use full Standard / Profesional Editions. I am moustly interested in C++ / C# development. Thank You. Unfortunately, the express editions "Mobile Device Support". You need VS2005 Standard or higher and there is also a stand alone SDK. For more on the features of each VS2005 flavor see this: http://lab.msdn.microsoft.com/vs2005/productinfo/productline/default.aspx Cheers Daniel ...Show All

• Windows Forms How I can make a Code for Delete this row when it loaded? (Select and delete)

  Hi I need help about this I have a data grid view like this: Index Code Name Price + Price _ 1 1 BMW X5 1000000 $   2 1 BMW X3 500000 $   3 1 BMW Z3 250000 $   4 1 SUM   1750000 $ Row 4 add by code automatically I can do it. There is no problem. But when my user want to edit the data (some row OR price) I have a Problem. How I can make a Code for Delete this row when it loaded (Select and delete) Or I can do some thing better than delete the row and write it again And one Other Question: How I can write Invisible columns in Data ...Show All

• Visual Studio DigitalPersona SDK.

     Hi, everyone. Could anybody tell me where can I download the DigitalPersona SDK Was digging at www.digitalpersona.com , but didn't find a bit of useful info, only a few of useless .pdf files.    I'll appreciate any help on this topic.    if possible please post your answers to never_again@nana.co.il or miros_lav@mail.ru.    Thanks. This SDK is very expensive. But the guys at www.griaule.com has a FREE SDK that supports the MS Fingerprint Reader, just download it! ...Show All

• SQL Server Migrating SQL Server 7.0 to 2005

  I am in the process of migrating from [Source] SQL Server 7.0 sp4 on windows NT to [Target] SQL Server 2005 on Windows 2003 Server. Please suggest me what should be the migration approach it this case. Would De-attach and attach of DB still be valid if OS changes (both are 32 bit OS). regards I too am migrating from SQL Server 7.0 on NT to SQL Server 2005 on Windows Server 2005. Is Detach/Attach the best way to do it or are other methods better (e.g. backup/restore). If so which one I have let to run Upgrade Advisor, will this recommend a method What kinds of changes are necessary to Tra ...Show All

• Visual Studio 2008 (Pre-release) WCF & AzMan (Authorization Manager).

  Hi, AzMan is a great Windows authorization provider. And, from my understanding, WCF is capable of supporting any type of authorization provider. My question is: how could the two be integrated For example, ASP.NET provides an implicit AzMan membership provider. I would like to do the same with WCF, I mean, get a hold on my AzMan groups & roles directly from the ServiceSecurityContext, or better, use it declaratively in .config files, just like ASP.NET. However, the WCF doc is not finished and lacks some important points so far. I am a bit lost between all possibilities (legacy, permissions, behaviors, tokens, XSI, etc...). S ...Show All

• Windows Forms Using ClickOnce with download managers

  Hi, Just wondering what the position is with ClickOnce and download managers like IDA. Presumably since these typically download files to a folder like c:/ida/downloads this will interfere with a ClickOnce install which needs to go to a pre-determined location in the users account. It's causing me some grief because users are downloading my ClickOnce enabled app from my site with download managers and then trying to run the manifest. Obviously the ideal situation would be if ClickOnce could detect a download manager and post a warning message to disable it before downloading. But in the meantime I guess a warning on my download p ...Show All