Alan Robbins's Q&A profile

• SQL Server There is data but no report

  What, in general, can cause a problem that when SQL code creates a dataset, but when report is run, nothing is shown. Here is a little bit more of detail. I am using CROSS APPLY in my SQL code. I have another post about it with a code sample. If you dont mind you can take a look at it. Basically it works without CROSS APPLY and does not with it. ...Show All

• SQL Server How to use coalesce function in derived column component?

  Hi all, You know the coalesce function is not offered in the derived column component. how can I use the coalesce function within the component And how can I use a user defined function within derived column component Would you be kind enough to give an example Thanks! Any reply or comment is highly appriciated. Robert You can simulate a simple coalesce by using the conditional operator. ISNULL(@[User::StringVar]) "Value is Null" : @[User::StringVar] You cannot add user defined functions to the expression syntax. ...Show All

• Windows Forms how to bind an arraylist to listbox??

  I have this method here that binds my combobox to a DataSource...BillTo is an arraylist..but the combo box items are named after the type which is Tracking.BusinessObjects.Order; private void btnBuildBillTo_Click( object sender, System.EventArgs e) { if (Tracking.UI.Dialogs.AddBillToCustomers.DisplayAddBillTo( this ._Order, this ) == DialogResult.OK) { this .cboBillToCustomers.DataSource = this ._Order.BillTo; } } this is the method that passes the Object to instantiate the Dialog form public static DialogResult DisplayAddBillTo(Tracking.BusinessObjects.Order _Order, System.Windows.Forms.Form ParentForm) { Tracking.UI.Dialogs.AddBillToCustomers frmAddBill = new AddBillToCustomers(); fr ...Show All

• Visual Basic Looping

  How do I setup a for next loop array to open files if I don`t know how many files are in the folder Sorry I forgot to mention that I am trying to get image files for a slide show to open in picturebox and the only way that I have been able to do it is to specify the number of files in the folder. ...Show All

• SQL Server Store Directory Structure in a Database

  I am building a web based application and need to store directory strucuture (folders and text documents) in a database. Each folder can have subfoders and/or text documents. I was wondering if there is a standard way of storing such a structure in an SQL database. As much as I know, the directory structure is a tree, so each element can have a children and a parrent (root does not have a parrent). So this could be stored by definig a table that would store the directory name, "pointer" to parrent and "pointers" to children.... But this is my own idea... Maybe there is something standard and better. Thanks in advance, Marko Vuksanovic. ...Show All

• Software Development for Windows Vista fdi.h missing in July CTP SDK

  I downloaded and installed the July CTP SDK (6.0.5472.2.1.WindowsSDK_Vista_idw.DVD.Rel.img) and I am missing fdi.h, which used to be in the include directory. The respective library fdi.lib is present and is different from the previous SDK (5383.1.1). I used the old version of fdi.h and everything compiles ok, but I would like to have the latest revision. BTW: fci.h is missing too, but hopefully I don't need this one :-) ...Show All

• .NET Development How message is transferred from Imessagesink to IClientChannelSink?

  Hi, IMessageSink is the first sink to be called from the client, How the message is transferred to ICLientChannelSink. Regards ...Show All

• Visual Studio Tools for Office F5 -> "File already exists"

  Hi, I'm new with VSTO development and been experiencing this really annoying issue. Everytime I hit F5, it launches the Excel document associated with the project. However once Excel launched, it often (not all the time but quite often) gives me the "File already exists" error message. I then must open the Excel file manually from File -> Open. Everything works then. Strange that it doesn't do this all the time, just occasionally. Any ideas Cheers, Victor Yes, for both Word Doc & Excel. Once loaded 'properly' they're working just fine though, so no drama there, but still really really annoying that I have to keep clicking OK and re-open the Office doc. ...Show All

• Visual Studio Team System Performance counter miss-match Result Store and Graphs/Legend (missing data/bugs??)

    I ran a load test, which contains one coded web test, which navigates to a bunch of different uris. What I am interested in is the response time it takes to load a uri(aspx) page.   In the run settings of the load test I have set the timing details storage to “AllIndividualDetails” And My sample time is 5 seconds   The name of my Scenario and Web Test is Navigation     When viewing the results in the Test Results pane in Visual Studio, I click on the counter set that represents the page I am looking for   Updated image File: Google didnt like me linking them   http://picasaweb.google.com/jakeb16/Questions   The page I am looking at is called default.aspx ...Show All

• .NET Development Exactly what I needed

  I am using VB in VS2005 Pro to create a dll for distribution. The dll is created in the bin directory but when I try and register it with regsvr32 I get: DllRegisterServer entry point was not found. This file can not be registered. Depends shows missing dwmapi.dll What is the fix for this First I have to say it was a pleasure using this tutorial! Great advice, it is obvious you know your stuff! Second I would like to enhance what you provided by clearing up some questions I had: 1) I had to add "using System.Runtime.InteropServices;" so it would compile. 2) Naming my project "ClassLib" would have made the article and my project cor ...Show All

• Software Development for Windows Vista InkCanvas exception

  Help! I am using .NET 3.0 Beta 2 and VS2005 on Windows XP Tablet PC 2005 edition. Whenever I try and use the <InkCanvas> element I get an unhandled NotSupportedException as soon as the mouse/pen is moved into the ink canvas area. Full details of xaml used and exception below. The exception occurs in the app.Run method. < Grid >< InkCanvas /></ Grid > System.NotSupportedException was unhandled Message="DLL version not correct." Source="PresentationCore" StackTrace: at MS.Internal.HRESULT.Check(Int32 hr) at System.Windows.Media.FactoryMaker.get_ImagingFactoryPtr() at System.Windows.Media.Imaging.FormatConvertedBitmap.FinalizeCreation() at System.Windows.Media.Imaging.Fo ...Show All

• SQL Server looping through table tom exec an SP many times

  Hi, If i have an SP called mySP that accepts one parameter @param If I have a table of paramaters with only one column like this: Param1 Param2 .. ParamN How do I do if I want to execute the SP on all the table fields: some thing like this: Exec my SP 'Param1' Exec mySP 'Param2' ... Exec mySP 'ParamN' I want that automatically since the parameters are going to be in a table called myTblParams Notice that I don t want to pass all the parameters to the SP just once but only one value each time I execute the SP since mySP ccepts only one parameter. Thanks a lot for guidelines If I understand you correctly, you want to execute mySP for every row in the myTblParams table. To do this, you could write another sp that has a cursor to l ...Show All

• Visual Studio Tools for Office Displaying Word Documents Within C# Forms

  Hi everyone. In our project, We have the following scenario: We create Word 2003 XML documents on the fly from certain data, And present this document to the user for preview in the following way - A form containing an AxBrowser control is loaded (basically wraps the IE engine unless im wrong) and we navigate that control to the location where the .xml sits. Now, With word 2003 and the registry value EditFlags set-up correctly, The control does successfully render the document inside it. Lately, We have been testing word 12 out to see if it fits us and migrating does not hurt current business logic, And we were unable to mimic this behavior - The class Word.Document.12 does not contain the same registry value and the document, When n ...Show All

• .NET Development MailSlots and FileStream

  I'm trying to create a MailSlot and use FileStream using BeginRead and BeginWrite to do async operations, but running into some issues. using Microsoft.Win32.SafeHandles; using System; using System.Runtime.InteropServices; using System.Security.AccessControl; using System.Collections.Generic; using System.Text; using System.Diagnostics; using System.Threading; using System.IO; [DllImport("kernel32.dll")] static extern SafeFileHandle CreateMailslot(string lpName, uint nMaxMessageSize, uint lReadTimeout, IntPtr lpSecurityAttributes); [DllImport("kernel32.dll")] static extern bool GetMailslotInfo(SafeFileHandle hMailslot, IntPtr lpMaxMessageSize, IntPtr lpNextSize, IntPtr lpMessageCount, In ...Show All

• SQL Server Copying table records - Best approach?

  We're using MS Sql Server 2005 in development but very likely will be using MSSQL 2000 in production. The platform is Windows Server 2003, .NET Framework v1.1, C#. I'm in a situation that involves T-Sql queries. I have a table called "tblSections" that contains the fileds: id, parent_id, caption. The ID is the auto-number identity of the record, and the PARENT_ID is the ID that this record considers to be its parent (in most cases it is set to NULL since the record has no parent -- it is the top of the tree-heirarchy). Basically the tblSections table is used to keep track of a user created tree view that can have nodes with children nodes (sections with children sections). I would like to make a copy of a node that may or may not have ch ...Show All