No-spam Sam's Q&A profile

• SQL Server Watching an incoming directory for files to process

  Here's the senario:  We have 3000 stores each sending detail sales data polling files to our FTP site. Most of these files arrive between 10 pm and 4:00 am, with stragglers coming in all day.  We receive several different files from each store, containing different types of data (payroll, order header, order detail etc...).  Detail files could be up to 5000 rows per store. We have built several test SSIS packages that will process these files using multiple flat file connectors to load each file thru to one or more destination tables in our data warehouse.   My question:  What is the best way to execute the ...Show All

• Windows Forms How can Implement a string Collection Editor in a property Grid

  Hi I have done some reserch how to implement the above,however I get lost in more complex examples I have found in codeproject and so on. What I want to do is when showing my propertyGrid I want to have the ability to have a collection editor of strings. For example sake lets say I want to have a collection of car Models. THe problem i have is that i see the collection editor but when I press Add I get "Constructor on type system.string not found" AM I missing something If so could somebody show me with a bit of code Thanks in advance for any suggestions. I have done as follows: '//Collection class #Region "Imports Directives" I ...Show All

• Visual C++ build errors in vc++

  Hi,             I am new to vc++. I have one vc++ source code. I am running this on vs2005. for me it is giving the following errors. I saved the source file in the following path. "c:\programfiles". The errors are 1)Error 1 error A2022: instruction operands must be the same size   the lines where i am getting the error is: TIGERROUNDSSE2 5 TIGERKEYSCHEDULESSE2 TIGERROUNDSSE2 7 TIGERKEYSCHEDULESSE2 TIGERROUNDSSE2 9   The lines highlighted with red color are causing the error. 2)Error 13 error PRJ0019: A tool returned an e ...Show All

• Visual Studio Reference to UserControl with CreateToolWindow2

  Does any one know how to get a reference to the Hosted UserControl when creating a tool window   If not is there a way to pass the DTE2 object used to create the tool window to the Hosted UserControl Problem Solved.  My user control was in a different assembly.  When I moved it into the same assembly as the Addin it worked.  I am not sure why it doesn't work the other way since I had referenced the assembly with the user control in it.  Since I have no particular need for a seperate assembly for the user control your solution works fine. Thanks Erick H. ...Show All

• Windows Search Technologies Querying the Vista Index using ADO

  (I originally posted this in the Search, Organize and Visualize in Windows Vista group on 6/16) Interested in searching the Windows Vista index using standard DB queries It's easy, but I can't find much documentation on it anywhere (please correct me if I'm just missing it). After searching a lot, I discovered/guessed the connection string and can successfully query the new index. Very fast, very nice! I posted about it on my blog ( http://www.ariankulp.com/archive/2006/06/14/1315.aspx ), but basically, your connection string should be (escape quotes as necessary): Provider=Search.CollatorDSO.1;Extended Propertes="Application= ...Show All

• .NET Development track downloading from website

  hi my website contains some pdf files to be downloaded. is there any way that detects whether the downloading is completed or not. details: i have to make a website which sells ebooks. ebooks are downloadable. now wat i want is when a user pays for a book, the downloading starts automatically. a temporary path(folder) for every user is created after paying. and after the downloading is completed that path(folder) gets deleted. now how can i know that have the user completed its downloading or not because some ppl user download managers(soft) for download which downloads a file in a number of resumes. so please help me out. ...Show All

• SQL Server import hierarchical data

  hi folks, I have to import hierarchical text files like: 32;country;city;postalcode;street 21;name;firstname;salutation;title;age;nickname 21;name;firstname;salutation;title;age;nickname ... additionally I have to eleminate doubles. what is the best way for this problem I have set up a flatfilesource with two columns and a conditional split on the first column so now I have an output with [country;city;postalcode;street] and one with [name;firstname;salutation;title;age;nickname]. How do I split this in columns, put it in a dataset keeping the relations and remove doubles Iam looking forward for any helping idea. rgrds, matze 1. Use ...Show All

• Architecture Message vs Service.

  EmailValidation message vs EmailValidation Service. SOA is mostly about services and messages. Rather than create a number of services with different names would it be recomended if we create 1 generic service and have it request/reply messages. For ex: EmailValidation service. Instead of creating a service for email validation, create a validationService and have it process all the validation messages for the application. Just wondering how others are approaching this. Thanks Sailu Hi sailu, I think SOA is more about bringing people, business processes, policies and technology more closely aligned by using loosely coupled ...Show All

• Windows Forms Can ClickOnce deploy resource directories and update files inside them ?

  If my application has a resource file inside a directory such as: .\bin\Debug\en-US\AvalonControlLibrary1.resources.dll Will the "en-US" directory be published   If yes, will that directory be created in the customer computers and the files in it updated If no, does that mean ClickOnce doesn't support culture specific resources   Thanks in advance, Roberto. Roberto, You can download your culture specific resources with ClickOnce.  There are a couple of ways to do this using Visual Studio. 1. Set 'Publish Language' property to 'English' or 'English (United States)' on the Publish Op ...Show All

• Smart Device Development UserControl in .Net Compact Framework v1.1

  All who can help, i'm making a small .net application for a windows Ce .NET device, but i was wondering, is there any change to make a custom control or use usercontrol and add them at design time to one of my forms   So 2 questions: 1. Usercontrols are not supported in v1.1, do they in v2.0 If not can i use something else The reason i ask is that, i wrote an multi-panel application (One form which is always updating his panels (with usercontrols), depending on what data was received). But if i can't use usercontrols i'm in big trouble... 2. I made a custom button which add's an image to it, but can i add this custom control to the to ...Show All

• Visual Studio Express Editions support windows95?

  i am beginner of vb6, but haven't use vb.net before. If I using VB 2005 Express to build an application, Can any one tell me if that application i build can running on windows95 and windowsNT4 If can, what important thing i must know eg. install .net framework 2, but it do not support win95 If cannot, any suggestion eg. using back vb6. Thanks for all reply. Hi, Sadly, Windows 95 and Nt 4.0 is not in the list of supported OS by the .Net framework, which is required for your program in VB2005 Express to run. Here's the requirements for the .Net Framework. cheers, Paul June A. Domag ...Show All

• Visual C++ XML reader for native C++

  Hi! I'm looking for a small C++ XML SAX reader, similar to XmlTextReader in .NET. The most important thing is that the library is small can be statically linked. Can anybody recommend me anything Thanks in advance! Just look at www.codeproject.com and search for MSXML. You find enough samples there! Also search in the MSDN for MSXML and sample, also there is enough stuff. ...Show All

• Visual Studio Express Editions Browser source,

  i was wondering if anyone had a premade browser i can download and editing and play around with im a new VB guy and im trying to learn plz I played with a browser and you can download it here ...Show All

• Software Development for Windows Vista msi.lib not found

  I have a project that needs link with msi.lib and I got the following linking error: LINK : fatal error LNK1181: cannot open input file 'msi.lib' I have the following paths in the library directories: $(VCInstallDir)lib $(VCInstallDir)atlmfc\lib $(VCInstallDir)atlmfc\lib\i386 $(VCInstallDir)PlatformSDK\lib $(VCInstallDir)PlatformSDK\common\lib $(FrameworkSDKDir)lib I only found the msi.lib in $(VCInstallDir)PlatformSDK\lib\IA64 and $(VCInstallDir)PlatformSDK\lib\AMD64. I installed Visual Studio 2005 Version 8.0.50215.44 (beta2.050215-4400). Should that platform SDK be updated Thanks a lot! I am movin ...Show All

• Windows Forms How can I hide the caret of a RichTextBox control?

  Hello, Can you please tell me how can I hide the caret of a RichTextBox control completely while my app is running Thanks. Just pass the handle for your control and the API will hide the caret inside the control ... You can use dllimport to use this api and then pass the appropriate handle to get the desired effect. [DllImport("user32.dll", EntryPoint="ShowCaret")] public static extern long ShowCaret(long hwnd); [DllImport("user32.dll", EntryPoint="HideCaret")] public static extern long HideCaret(long hwnd); Now call these methods and then pass the appropriate handle ...Show All