TeleRiddler's Q&A profile

• Visual Studio Tools for Office InfoPath 2007 Dynamic DataBinding

  How does one go about binding an InfoPath 2007 form to a dynamically generated DataSet I am hosting an InfoPath form inside a Winform application using a FormControl object. I want to display a result set obtained from a query issued against a remote WCF service. When the collection is returned, there are some business logic operations that must be performed, and then the data collection is shoved into a DataSet. The next logical step is to databind the DataSet to the InfoPath form, but I haven't found a clear way to do this. Your suggestions are welcome and appreciated. Sorry for the delayed reply. There are two different ways to approach getting data from an external source into an infopath form. ...Show All

• Visual Basic how do you insert a product key

  Ok this is going to sound dumb But whats the code to incert a product key for your project or is that in a publish wizard that you put that into Please help Thanks! This question doesnt make much sense. Are you asking how to create an product key into an application that you have written. ...Show All

• Visual Studio How to support the Code Defintion Window

  Hello, I want to support the code definition window, in our editor. The interface reference documentation does not contain documentation so it's hard to start it right now :) Is there a whitepaper on the subject Can other languages support the CodeDefWindow Finally, can I generated code in the windows to match the language I'm using the MPF, can it be done using it Thanks, Paul. Hi Paul, This is offcourse supported. Basically, one needs to implement IVsCodeDefView Context for context objects and push them to the CodeDefView service (SID_SVsCodeDefView) using the IVsCodeDefView.SetContext() method, at reasonable interval associated with the insertion point change. Please look up the other methods ...Show All

• Windows Forms simple reinstall

  I am just beginning with Setup projects. I created a setup project that works fine for my app. I as develop the app and release new versions, I would like to be able to install the new version directly over the old of by having the installer simply overwrite the files it installed in a previous version. As of now, it says another version is already installed and to use Add/Remove programs to remove it first. Is there a simple way around this Thanks. I was changing that property along with the product code when prompted with the RemovePreviousVersion set to true and it wasn't removing the old version's entry in the add/remove program (ARP) window. Once I rebooted it seemed to have fixed something on my PC a ...Show All

• SQL Server Problem in Trigger

  hi I write a trigger (if users add new records, exec SP): CREATE TRIGGER [R_I_active] on [dbo] . [active_t] AFTER Insert AS set @codef =( select ida from inserted ) -- > Identity(PK) Declare @tname as nvarchar ( 50 ) -- > Tabel name set @tname = N 'Personal Info' exec sp_report @code_f = @codef , @ch_mode = N 'Add new record' , @t_name = @tname but when user add a new record, the new data added to the database but not displayed . and to display data , user most close and open form (my database in SQL2005 and i read that by Access).if my PK field not identity , the tigger worked correctly !!!! Triggers are fired per statement NOT per row, you will have to encapsulate this in ...Show All

• Visual Studio 2008 (Pre-release) NetTcp with RM not being kept alive

  Hello all, I have been trying to get a client/server channel in WCF that is kept alive even when inactive. Basically, I want to have a pool of connections open that will be shared on my application. I have written some sample code that looks like the following: Service: [ServiceContract(SessionMode = SessionMode.Allowed, Namespace = " http://tempuri.org/Services/IServiceContract ")] public interface IServiceContract { [OperationContract] string DoSomething(string arg); } [ServiceBehavior(Namespace=" http://tempuri.org/Services/ServiceImplementation ")] public class ServiceImplementation : IServiceContract { #region IServiceContract Members public string DoSomething(string arg) { return str ...Show All

• Visual C# Applying Property Attributes decorating a class to its member properties

  I am using attributes to supply range values for properties of an object being displayed in a propertyGrid. This works great when I am dealing with primitive types like int and float. However I have more complex data types that I want to decorate with a range attribute and have the attribute applied to member items of the object that was decorated. It should be noted that I have created custom type and property descriptors so that I have control over those description passed to the property grid. This allows me to control how the property grid displays properties dynamically. To apply the range constraints to the property I have overridden the SetValue Method in the property descriptor. The problem is when you are changing the value t ...Show All

• Visual C# unicode Characters and Sql problem

  hi there is a excel file that uses unicode characters with special language! (farsi) I have imported the file to Sql, every thing is OK now I am trying to work with the database in C# but nothing can be match with the characters in database. for example I have added the language in my windows and try to find all the rows that the name field matches with specific name (with farsi characters) but they can not match together. just uppose that I am looking for 'John' and I have at least 10 rows with this name. in select statement I check with 'John'. both in code and sql have the same look but they can not match together and trust the condition. so (0) rows will selected!!!! on the other hand, when I try to insert a new row or upda ...Show All

• Visual C# Subtracting Days From Date

  I know that this should seem simple, but I can't seem to be able to figure out how to subtract days from a particular date using C#. For example: 9/11/06 - 7 Days = 9/4/06 So how do I do this in C# I used to use the DateAdd function to do this with VB, but can't seem find any way to do it with C#. Thanks in advance for any help, Russ Hi Russ, manipulating dates is even easier with .NET. Try this: DateTime today = DateTime .Today; DateTime sevenDaysEarlier = today.AddDays(-7); Andrej ...Show All

• Internet Explorer Development IE7 icon Problem

  Firstly, let's clear up the icon definitions. Favicons are those that are downloaded from the linked website and show the websites logo or whatever. The icons that we are all concerned with here in this fourm that are in error are the windows icons. These icons along with an array of others are usually contained in system dll files. Indexes into these files are kept track of in the registry and in the shortcut or favorite itself under properties. For example if the dll has 256 icons and windows calls the dll as shell.dll, 255 the 255 is the index into the icon file. In this case the last one (base 0). The problem here is with IE7. The registry entries under HKEY_CLASSES_ROOT (url and internetshortcut) appear correct. I ...Show All

• SQL Server Convert DT_14 to DT_18

  Hi! I have a Fact_data flow with several Lookups. In one there's OLE Db source DT_14 (persons id's) which need to be compared to a column DT_18 from Dim_salesperson. Thats how I could collect the ID's from Dim_salesperson into OLE DB Destination. How could I compare, DT_14 data with DT_18 First converting DT_14 to character. Secondly char to DT_18 I would be so grateful if someone could give an idea... curiousss wrote: First converting DT_14 to character. Secondly char to DT_18 Assuming you are talking about DT_I4 and DT_I8; that approach sounds reasonable. Have you try it ...Show All

• Smart Device Development Convert this please. Windows Form app to SmartDevice app

  I have snipet code from Windows app, but also I want to build SmartDevice app. could you convert my code please 3 codes : 1. code for browse network folder only Dim NetDrives As New List( Of String ) Dim drives() As System.IO.DriveInfo drives = System.IO.DriveInfo.GetDrives For Each dr As System.IO.DriveInfo In drives If dr.DriveType = IO.DriveType.Network Then NetDrives.Add(dr.Name) End If Next Dim dir As String = System.IO.Directory.GetParent(System.Environment.GetFolderPath(Environment.SpecialFolder.Personal)).FullName dir &= "\NetHood" Me .OpenFileDialog1.InitialDirectory = dir Me .OpenFileDialog1.FileName = String .Empty While Me .Open ...Show All

• Visual Studio 2008 (Pre-release) What is it in VB

  I am struggling to figure out which dependency properties that can be used in .BeginAnimation in VB There seems to be a real difference between C# and VB in this respect. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1152919&SiteID=1 Not sure why VB is different and there does not seem to be any list of .BeginAnimation dependacy properties I can use. The documentation is extremely C# biased and of near no help. :-( Like why does C# use Image.LeftProperty (most logical I would say) and VB uses Canvas.LeftProperty. What does the canvas have to do with it and why does the documentation not mention anything about the C# Image.LeftProperty. According to the documentation Image does NOT have a LeftProperty property. ...Show All

• SQL Server Can You Use Variable Column Names in an Update Statement

  I'm Creating a Table named Forecast with variable column names from month to month... This month Column 13 might be November; next month Column 13 would be December... After building the table, I need to Update the column's value (to start) to zero.... I would like to use " UPDATE Forecast SET @MonthName = 0; --- But, of course it doesn't work.... Anyone's help would be greatly appreciated. DECLARE @MonthName NVARCHAR ( 20 ) DECLARE @MyCounter INT SET @MyCounter = 12 USE Solaar ; WHILE @MyCounter < 24 BEGIN SELECT @MonthName = c . name FROM sys.columns AS c JOIN sys.types AS t ON c . user_type_id = t . user_type_id WHERE c . object_id = OBJECT_ID ( 'DBO.Forecast' ) AND c . col ...Show All

• SQL Server Rebuilding the system merge repl indexes

  Hi, We have a client that has a large (5Gb) database replicated to 13 subscribers, the publisher is Sql 2005, the subscribers are Sql Express. The publication has as few filtered articles too. I have found that after several months of continuous running Replication Monitor is taking a long time to report history on each subscriber. Do people tend to rebuild the indexes on the system merge replication tables on production servers, or should the standard replication jobs take care of this Thanks for your help Graham 1. Did the replication Monitor running all the time (on the subscriber) 2. If you stop and re-start to launch it, does it still take a long time to refresh "sync status" ...Show All