willajo's Q&A profile

• SQL Server can I create a VIEW on the sesult of stored procedure ?

  I have a store procedure which select/calculate fields from multiple tables, can I create a VIEW on the sesult of the stored procedure     I want create a cube fact that is base on the result of a stored procedure, but the cube cannot accept SP as a source, so I want to create a view that can be the source of cube fact ...Show All

• Visual C++ VS2005 C++/CLI Syntax

  I've been told that Managed C++ is a dead end and that C++/CLI Syntax is the way to go. From what I've read, the Common Language Interface is essentially referring to all of the non-ISO C++ libraries that MS has made available. Can anyone point me toward additional background material that introduces CLI and discusses how it is different from ISO C++ Also, I'm wondering where I can get some tutorials on programming .NET apps using this as well as a good collection of sample code. -Zero MSDN does provide the basic information on the syntax. There is a problem with the MSDN web site content right now, which should be fixed soon. For more tutorial style information, I'd suggest my book: C++/CLI : T ...Show All

• Visual Studio Tools for Office Failed to update customization from the specified deployment manifest.

  I'm trying this again. I've successfully created an Excel App-Level addin that supports automatic updating (details below).  The issue is that I want to ensure that the addin loads from the local copy when the remote copy is unavailable. My app.dll.manifest file is as follows:   <assembly xmlns="urn:schemas-microsoft-com:asm.v1" xmlns:asmv2="urn:schemas-microsoft-com:asm.v2" manifestVersion="1.0"> <assemblyIdentity name="PriceTools.dll" version="1.0.0.18" /> <asmv2:entryPoint name="Startup" dependencyName="dependency0"> <asmv2:clrClassInvocation class="ClassName.AppName" /> </asmv2:entryPoint> <asmv2:dependency asmv2:name="dependency0"> <asmv2:dependentAssemb ...Show All

• SQL Server Script task

  Hi, I am new in SSIS development. In the script task of the Control Flow, how to use my custom classes (that use SMO and DTS for building a package and are written in C## ). If not the Script Task then which tool I have to use Thank you - all are working! The problem was I put mine into C:\WINDOWS\Microsoft.NET\Framework\v3.0 and do not have VS SDK yet. In C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 works well! thanks again ...Show All

• SharePoint Products and Technologies Programmatic Audience Compilation

  Is there a way to fire off the audience compilation process through c# Specifically, if I wanted to compile just one audience but not the rest, is it possible to do this through code Thanks in advance for any help offered. Dez Actually, it seems that the audience compilation is possible through the object model. The AudienceJob class has a static method called RunAudienceJob that provides a way to start and stop incremental and full compilation. Althoug, it requires some parameters I can't find. Here is the SDK : public static int RunAudienceJob ( string [] args ) Parameters args Takes the following four arguments: ApplicationID ...Show All

• Software Development for Windows Vista change delay timeoutduration

  Hello guys, I have a state machine workflow, and to create a timer, I used a delay inside an event driven. Is there anyway to change timeoutduration of this delay to a new value, while the instance of the workflow is running, so the timer expires at that new time. I couldn't find any code samples for that. Any help would be greatly appreciated. Please read the thread more carefully, Iris. The problem is in resetting the duration during the execution of the delay activity itself. I am looking into a similar situation (though with only one delay). One problem I have with the existing delay activity is that it is a delay with a Timespan, not a delay until a certain DateTime, which is more apt to ...Show All

• Software Development for Windows Vista custom sql persistence

  What I'm basically doing is deriving from the SqlWorkflowPersistenceService: public class SqlWorkflowStepPersistenceService : SqlWorkflowPersistenceService { protected override System.Workflow.ComponentModel.Activity LoadWorkflowInstanceState(Guid id)         {             Guid StepID;             byte[] State;             if (RetreiveNextStepData(id, out StepID, out State))                 return WorkflowPersistenceService.RestoreFromDefaultSerializedForm(State, null); ...Show All

• Visual Studio 2008 (Pre-release) Loading data from the hard disk

  Hello, I have got some questions about loading data from a hard disk: 1) How to load a text from a .txt file on the hard disk to the TextBlock control 2) How to load an image on the hard disk to the Image control Thanks in advance. 1. TextRange tr = new TextRange (rtb.Document.ContentStart, rtb.Document.ContentEnd); StreamReader sr = System.IO. File .OpenText( @"c:\dir.txt" ); tr.Text = sr.ReadToEnd(); sr.Close(); 2. ms-help://MS.MSSDK.1033/MS.NETFX30SDK.1033/cpref34/html/T_System_Windows_Media_Imaging_BitmapSource.htm ...Show All

• SQL Server HELP WITH DATABASE SAVE FOR MINING PROGRAM

  I use the code following to insert new data to my database. I have two tables in my database DEMOGRAFICS AND VISIT, related each other one to many START OF CODE Dim s trSQL As String 'Check for sql problems Select Case StateFlag Try ' Build Insert statement to insert new demografics into the demografics table strSQL = "INSERT INTO VISIT (CODE, CODE_VISIT, DATE_VISIT, STAFF_YES, STAFF_NO, STAFF_NOT_SURE, OZOS_NUM_ONE, OZOS_NUM_MANY, OZOS_POS, OZOS_TYPE_CYST, OZOS_TYPE_COMP," & _ "OZOS_VOL, OZOS_COLOR, OZOS_RESULT, D_G_OZODIS_IPER, D_G_HASHI," & _ "D_G_OXI, D_G_ST_THYRO, D_G_IPOXI, D_G_EIDIKI, D_G_NO_TAKSI, D_G_AYTO," & _ "D_B_THILO, D_B ...Show All

• SQL Server Data SWITCH partition fails with primary key constraint Error

  Hi champs, I am trying to use SWITCH partitions from one fact table out to another identical table. On some tables this does not work as I get an ERROR conserning primary key constraints; is there a way around this without deleting the primary key constraint ERROR: "SWITCH PARTITION 1 TO my_switch_out_table PARTITION 1 " failed with the following error: "ALTER TABLE SWITCH statement failed. SWITCH is not allowed because source table 'my_fact_table' contains primary key for constraint " /Many thanks I have one table that has a two colums as a PK and this table has a PK constraint to one other table and other constraints to 5 other tables. I've constructed the ...Show All

• .NET Development invoke through command prompt

  Hi, Im new to this, need to know how to execute commands on DOS prompt using C# apps. any info would be appreciated. thanks. abhi See Process class in System.Diagnostics: Here is a quick example: Process.Start("cmd"); You can also add paramter to it like: Process.Start("shutdown", "-r"); You can also See ProcessInfo class for more control over all this. Best Regards, Rizwan aka RizwanSharp ...Show All

• .NET Development How can I detect muliple rows in dataset using XSL ?

  Hi I have the follwing dataset(Tbl1 and Tbl2 with two rows).I have xsl file(given below) to restructure the xml file. Tbl2 may have more than one row and the dataset may change time to time(Tbl2 will be 1 or more rows) If Dataset with 1 row of Tbl2 I can handle xsl file to manage it. But If Dataset with more than 1 row in Tbl2 (please look at the xml file below) How can I write the code(xsl)to detect the rows and place the data in between the elements in the output(look at output xml file) Scenario Dataset <Dataset> <Tbl1> <A>aaa</A> <B>bbb</B> <C>ccc</C> <D>ddd</D> <E>eee</E> </Tbl1> <Tbl2> <1>one</1> <2>two</2& ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .x maya exporter problems

  I am trying to load a .x model into my engine and im having a bit of trouble getting it to render properly. if i load in an x file my friend sent me it will work fine, but when i try to export my own model out of maya 7.0 the mesh renders all black. the confusing part is that the mesh works fine in the directx viewer, and my code loads other .x files fine. has anyone encountered this problem before here are some screenshots i took debugging, my material is set up fine, but in pix you will see that theres something really funky going on. black rendering Pix screenshot Materials seem good *edit*   i forgot to mention that the texture is also getting loaded in and returning S_OK The problem h ...Show All

• Windows Forms Autocomplete ComboBox

  Is there a way to set the size of the autocomplete dropdown You know when you type in a text in the combobox it will suggest come values in a dropdownlist. Can the size of the thing be set Thanks, ive finally found a way to bind a numericupdown using a bindingsource. id have to subscribe to the valuechanged handler to update the position in my bindingsource. cuz when i click on the up/down control of the numericupdown ... the bindingsource doesn't follow it. weird though.... ...Show All

• Windows Forms Where's my data?!!!

  Hi all, I'm beginning to feel like a dufus here with vb2005. I have a form with a bindingsource, bindingnavigator and bindingtableadapter and I need to find the value of one of the fields in the underlying dataset to perform a custom function. In VB6 I would simply use a datacontrol, and use syntax like : If data1.Recordset("DesiredField") = "This" then ... How on earth do I do this in VB2005 VB2005 has a lot of good points but some things I find ridiculous! Somebody please help as I need to continue my work and this (Should be simple) problem has me at standstill. The Recordset closest counterpart in .NET is DataReader; however, Dataset is more commonly used ...Show All