Dietz's Q&A profile

• SQL Server Processing SSAS2005 from DTS

  Hi, I have a requirement to process SSAS2005 cubes from DTS. Anyone know how to do this or does anyone have any recommendations I've done a search on this forum and came up with teh following which was no help at all unfortunately: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=198374&SiteID=1 -Jamie Did you download ASCMD.exe from this link or was it already on installed for you in the location specified in the ReadMe I've installed the developer edition on my machine and can't find the file in the location specified. ...Show All

• Commerce Server Problems With Backorderable Products

  I have entered values into the inventory catalog that I believe mean the product should be on backorder. I have played around with these figures but the Product.IventoryConditon property just returns in stock / out of stock, never backorder (or pre-order for that matter).   When I look at the inventory condition logic here http://msdn2.microsoft.com/en-us/library/aa545595.aspx (the section that starts with Else If Stock Handling = 1) I can’t see how the logic could work. If the on hand quantity is greater than the threshold it will always be in stock. If the on hand quantity is less than the threshold then how can it ever meet the following "else if" conditions The only way I can see it could work is if the values other th ...Show All

• Visual Basic Referencing Text on another form

  How can I make a reference to a textbox on one form to another so that it's text will show up in a textbox on my other form. Example: on Form1 I have textbox1 with information typed in, and on form two, i have textbox2, where i need that information to appear. I just need the reference from that form so I can use it on my other form. Thanks Now that I've use Visual Basic enough, I realized that just doing this: textbox1.text = "Hello" + My.Forms.Form1.Textbox2.Text & " World!" does exactly what i wanted. Thanks ...Show All

• Visual Studio Express Editions Fill an array from a text file.

  Sir/Madam, I need to fill an array from a text file. My text file looks like this for different people. First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone First Name|Last Name|Address|Phone Do you know of any way to put these into an array from a text file where the "|" symbol seperates the columns Any help would be greatly appreciated! Each cell will contain only 1 value.  For instance, in the first row, the First Name will be cell (0,0)  The "Last Name" that corresponds to the "First Name" will be cell (0,1)..... In the second row, the First Name will b ...Show All

• SQL Server Cannot display database properties windows in Sql server management studio.

  I use sql server 2005 developer edition with service pack 1. When i right click on a database and i select properties an error occured with the folowing stack trace =================================== Cannot show requested dialog. =================================== Cannot show requested dialog. (SqlMgmt) ------------------------------ Program Location: at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc) at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument ini ...Show All

• Software Development for Windows Vista Skip StateInitialization in StateActivity

  I have the following StateMachineWorkflowActivity State1 (InitialState) StateInitialization1 State2 StateInitialization2 State3 StateInitialization3 At first stage (initialization) I need to set current state to State2 (I use SetState method of the StateMachineWorkflowInstance), but without executing StateInitialization. After initialization I need to use state machine in the normal case (with enabled StateInitialization). How to disable/enable or skip StateInitialization in runtime Thanks Alex Thank you for quick reply. >why not adding an IfElseActivity in your StateInitialization Activity where test if it's the first time or not ( a simple flag)... I did it. it works. But how ...Show All

• Visual C# How to display the caret in textbox?

  Hi, Here is a question. I create a textbox in a window form. However, i can't see any caret indicating in this textbox. I checked some websites which said i should set TabIndex = 0 to make caret display. I followed the suggestion, but it doesn't work. Please give me your advice. Thanks in advance. Can you give us the code and/or scenario to reproduce this Because I can't reproduce this. I just click on the Textbox and the caret appairs, this is the same when I navigate to it with the tab key. ...Show All

• Visual Basic Error in Using API functions... help

  When i use a API function, it raises an error regarding protected memory.... Need help... Im new to vb.Net programming. Thanks... My API is Public Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" ( ByVal lpApplicationName As String , ByVal lpKeyName As Object , ByVal lpDefault As String , ByVal lpReturnedString As String , ByVal nSize As Long , ByVal lpFileName As String ) As Long ======================================== Here is my code... Try strPathName = Trim(strPathName) lvalue = GetPrivateProfileString( "WINPATH" , "PATH" , "" , strReturnValue, 255, My .Application.Info.DirectoryPath & "\SYSINI.INI" ) If lv ...Show All

• Windows Forms Restore combobox items

  I've got 2 comboboxes, cmbStatT and cmbEndT respectively, both with items added manually at design time. These comboboxes have the same number of items that are of the same value, these are time values to be precise. Depending on the index of the selected item in cmbStatT, I would like to remove a range of items in cmbEndT. If a user selects an item at index 3 (09:00 AM, starting from 07:30 AM till 16:00 PM), cmbEndT should only show items from index 4 (09:30 AM, starting from 07:30 AM till 16:00 PM). Meaning remove items in cmbEndT starting at cmbStartT.SelectedIndex back to index 0. This works just fine the first time. 09:30 AM of cmbEndT is now at index 0 and the user decides to change the value in cmbStartT say, to 10:00 AM which ...Show All

• Visual Studio Express Editions how do we update our program?

  how do we update our program for example i have a finish product and i install it to user's computer...in form1 i have datagridview and a button!!! i want to update my program and put some search button and textbox... how do we do that i saw some option when i publish my work to update... it require's a server... can we do that in shared computer how can i update my software install it again This option allows your compiled program to check for updates on a given folder which contains the solution files and updated versions. During initialization (program startup), once it sees that you have done an updated version it will ask you if you want to update your program. Not necessarily that you have a "server", you can also ...Show All

• SQL Server Hide columns in a table and subreport based on parameter selection

  Hello, I am using SQL reporting 2005. I have a main report in which the user selects parameters from drop down boxes. Later I pass couple of parameter values to a subreport. If a user does not select any parameter(leaves blank) in the drop down box from the main report, I need to hide those columns in the main report. Later when the values are passed to the subreport, I need to hide the columns in subreport too. How do I do the above Is there a vb function I could use Thanks in advance. You could use an expression for the hidden-property of the columns like : =iif(Parameters!par1.value=nothing, true, false) ...Show All

• SQL Server Long parameter list for stored procs

  Hi All, I've got a problem with increasingly long parameter lists for SProcs... Especially when one calls another SProc, and so on. Is there any way around this Like can you dynamically construct a string and pass that I'm just looking to see if more experienced players have found ways around this, or have just dealt with it by using well formed code. Thanks Chris thats a useful link carlop has given... u can construct any synamic sql statement dynamically..using string and variables...and execute it..including calling an sp.. look for execute and sp_executesql in books online.. ...Show All

• Visual C++ Disposing a connection

  Hello everyone, I'm writing a data access object, and when I compile the attached code I get the following error: error C2039: 'Dispose' : is not a member of 'System::Data::SqlClient::SqlConnection' c:\windows\microsoft.net\framework\v2.0.50727\system.data.dll : see declaration of 'System::Data::SqlClient::SqlConnection' You should invoke the destructor, '~SqlConnection' instead What's the correct way to dispose a connection Thanks a lot... Center^ CenterMsSql::GetItem( int id) { SqlConnection^ conn; try { conn = ConnectionFactory::CreateConnection(); SqlCommand^ cmd = gcnew SqlCommand(GET_ITEM, conn); cmd->Parameters->Add( "@cntId" , SqlDbType::Int); cmd->Paramete ...Show All

• Windows Forms combobox

  Hello A problem! I am trying to do the tutorial about two tables (master/detail) lookup. but it will not work. Everytime when i changing a value on combobox (child table is updated corectly) but combobox (parent) datasource is updating also. like this combobox list at start 1 test (displaying item in combobox) 2 test2 3 test3 then when i change to "test2" the list will look like this: 1 test2 (displaying item in combobox) 2 test2 3 test3 someting is wrong here! please help. BonnieB wrote: Post the relevant code please. Hi I am doing the binding with designer so there is only code that designer i generating. ...Show All

• Software Development for Windows Vista build failure

  Hi, I run into the following problem building my project using WWF Beta 2: After the first successful build, it isn't possible to build the solution again. Build ends with an error, not described in detail. are there any ideas about soving this problem Best regards, Andreas this is the output of the build process: ------ Build started: Project: Diagnostics, Configuration: Debug Any CPU ------ Diagnostics -> D:\_work\S3\src\S3.root\S3\Tools\Diagnostics\bin\Debug\Upper.S3.Diagnostics.dll ------ Build started: Project: NHibernate.Generics, Configuration: Debug Any CPU ------ NHibernate.Generics -> D:\_work\S3\src\S3.root\S3\Tools\NHibernate\NHibernate.Generics\bin\Debug\NHibernate.Generics.dll ---- ...Show All