doener's Q&A profile

• SQL Server SSIS and the Receive Command

  I built a system where I am sending batches of messages using a single conversation. I want to pull these messages out of my queue using Service Broker. I may have more than one batch sitting in the queue waiting to be picked up, so.... In my SSIS package i started by getting a unique list of conversation_handles where the message type is my end of batch message ( should only be one per batch). Then I used the foreach loop construct thinking I could pass the conversation_handles around and into the data flow. In the data flow I want to pull all of the messages at once. It looks like the receive statement is designed to do this with the concept of using a table variable. So I built this SQL to use in for the SQL Command of my OLE ...Show All

• SQL Server Combining Reports

  I'm trying to create a report that is actually 4 reports. Each has it's own page headers and Footers. I can't use sub reports because I need the headers and footers to show for each indivual report. My output is going to be PDF, and I know how to write code that i could use to combine the PDFs but I really want to do this in the report. I don't want to have to use some outside process to get my wanted output, If I can get away with it. Any help is appreciated!! Thanks. Brad, Your response not only lacks details but leaves me with the impression that combination reports will never be supported in Reporting Services. I have been developing reports for more years than I like to admit and I can s ...Show All

• SQL Server Regarding Accessing on every objects within the sql 2005

  Hi guys , can I know is that any way to set up some authentication for user access all the objects within the database after login successfully. For example, after access login into the database server and would like to click on certain database (eg : A) , then pop up the user access login page again. Thx could you explain this a bit more, I did’n’t get your point from the explanation. Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Saving Image to Db using ADO. Crystal v6 Problem

  Hi folks, I am really hoping there is someone out there with the answer to my problems I need to save customer signatures to our SQL DB and then display them on a Crystal Report. The problem is that the client uses Crystal v6. I am saving the image to an Image field using an ADO rs on a VB6 application. It saves fine and will read back fine. Crystal however has a problem and throws an error "Not Supported".(Later versions of Crystal erad the images fine) Northwind Database has a Table 'Categories' which as images that crystal v6 is able to display. As of yet I have been unable to save images in this format. I have tried .bmp,.jpg ...... I have also tried appendChunk.. All the images on Northwind start with '0x151C2...' ...Show All

• Visual Studio Express Editions How to lock a file from unauthorised readers

  hi, I am sending a file through mail in a C# application. I want to lock the file so that the only person who knows the key can read it. How can I do this using C#. Please help me out. I dont want to go for encryption decryption. Please let me know whether is there any file locking mechanisms available. Is it possible to compress a file using GZipStream or DeflateStream and give a password protection to unzip it I will be thankful if you clarify my doubts. Thank you, Ravinder Reddy.K Ravinder Reddy.K I know you can create some password protected PDF in C#, I also some paid components available on the net. This is just a pointer, y ...Show All

• Smart Device Development ActiveSync connection detection using RAPI.

  Hello. I found an example how can I detect connection mobile-pc with ActiveSync without second thread working and using only notification. I read a lot about RAPI and I found an example from book. But there is a strange problem which I don't understand (I know what it means but I don't know how to resolve it). When I use CoCreateInstance() procedure in Init() it always return an exception (Incorrect parameter). Here is the code (it comes from .NET Compact Framework Programming with C# and .NET Compact Framework Programming with Visual Basic .NET_ Authored by Paul Yao and David Durant. - if I broke some rules please delete it) : // File Name: RapiConnectDetect.cs - Creates an ActiveSync COM // object of type IDccMan and an Advise Sink o ...Show All

• Visual Studio Team System Is there a tool to create class diagram

  Using Guidance tool with VS 2005 team version, I created a web service solution. When coding is done, I need to create a class diagram. Is there a tool can do this based on my Vs 2005 solution and project, or binaries Thanks No, the class designer is not supported for C++ projects, unfortunately. Some limited support was included in the early VS2005 betas, but the VC++ team had to pull support for C++ due to resource constraints. Hopefully it'll come back in a future version of VS with the kind of support that C++ programmers would expect. ...Show All

• .NET Development how to programmatically detect the .NET Framework

  Please some one help me to detect the .NET Framework programmatically.i am writting a application where i want to detect .NET framework before i install the application.I dont konw how to do this. Please can you help thanks. I was assuming that the main reason he wanted to check whether the .NET Framework was present is that he has a program that requires the .NET Framework... ...Show All

• Silverlight (formerly WPF/E) Attributed Syntax for Transforms

  Hi all, Maybe I didn't look hard enough, but I cannot find a reference on how to use the attribute syntax to declare transforms. For the one sentence review, there are object syntaxes and attribute syntaxes. For the object syntax, w.r.t. transforms in particular, we have the familiar: <Rectangle Height="100" Width="100" Canvas.Left="70" Canvas.Top="10" Fill="Black"> <Rectangle.RenderTransform> <RotateTransform Angle="45"/> </Rectangle.RenderTransform> </Rectangle> However, the WPF/E documentation ( http://msdn2.microsoft.com/en-us/library/bb188554.aspx ) implies that an attributed syntax is also available Looking at the Rectangl ...Show All

• Visual Studio Team System Finding check-in policies and check out settings

  Hi, Through my application I want to fetch (using object model APIs) the check-in policies and check-out setting of a team project. I checked out classes like PolicyList, PolicyType from Microsoft.TeamFoundation.VersionControl.Client, but none of them give the list of exisiting check-in policies or check-out settings (ie. whether multiple check outs are allowed) Manasi Hello, you need object of class TeamProject. It contains: property ExclusiveCheckout method GetCheckinPolicies() method GetCheckinNoteFields() A few ways to get TeamProject is Workspace.GetTeamProjectForLocalPath or VersionControlServer.GetTeamProject or VersionControlServer.GetTeamProjectForServerP ...Show All

• .NET Development How to use folder path to find pathnames of certain files

  Hello, For a windows application I have created I have used the FolderBrowserDialog to retreive the pathname of a desired folder. Now that I have that pathname I wish to look in this folder for all files with a certain extensions (.html and .htm to be specific), after I find each file I would like to store the file's path name in an array of strings. Also I wish not to look into subfolders, but just at the root of the folder. Is this possible I have looked all over the web and just cannot find anything that will help. I have looked at filestreams and have not gotten anywhere either. Can someone please help me with this matter Thanks, Tareq Ismail sure its possible. you need to use ...Show All

• Visual FoxPro Emailing newly converted reports.

  Hi; I have converted some older Foxpro reports to VFP9. Everything looks great, but: Before the conversion I could very easily save the report to file and then email it. After the conversion, obviously, I can't do that anymore. I have tried the ASCII option but it is not very good with spacing and columns don't line up etc. What is the best way to solve this issue Do I need to create a pdf/rtf/tif etc or is there a built in VFP feature that can help me Thank you all. Wow!!! What I wanted and much more. Thx. I didn't venture into report listeners yet, but I guess that gives me native graphic functionality for report output files. Thank you so much!!! Alen. ...Show All

• SharePoint Products and Technologies Workflow created in SharePoint Designer doesn't work ...

  Hi, I created a custom workflow using SharePoint designer. It is okay when the system admin (the one who created the workflow in sharepoint designer) submits an InfoPath form to the library and then the workflow has been started. However, when a normal user (even with Full Control Permission) submits the InfoPath form to the library and the workflow cannot be started. Any additional security setup has to be configured when workflow is created in SharePoint Designer Thanks so much. Paul I've fixed my issue. I've added Log to action into workflow to debug and see where it fails. Basically, in sharepoint groups that I was using to send emails and assign to do's, I had option enabled "Allow members of the group see ot ...Show All

• Windows Forms The selected rows aren't displayed

  Hi I have a DataGridView control in my C# application and i want to select some rows in this control in the Load event of the containing form of the grid. The problem is that the rows aren't displayed as selected. The same code i use when a button is pressed (after the page is loaded) and it works fine. Is this a normal behaviour What should i do to select some rows before display de window with data grid Thank you Yes, the ImportedFileCollection class is not a part of .NET Framework. It represents a collection of ImportedFile objects. The ImportedFile class is part of the data access layer and it represents a SQL server table record. This class was generated by a special program that generates C# c ...Show All

• Smart Device Development Emulator says corrupt DB

  I am trying to figure out the emulator so that I can demo my software to my boss. Everything works except the database. The emulator keeps telling me that my DB is corrupt, but I can put the same file on the actual handheld, and it works fine. Could the emulator be corrupting my db or something. Has anyone ever seen or heard of this before. Are you putting your database on a DeviceEmulator shared folder There are known bugs related to CE databases residing on shared folders. Barry ...Show All