alesqlserver's Q&A profile

• .NET Development One place to catch server-side remoted object exceptions

  Is there one place I could catch exceptions from my server-side objects in .NET remoting I thought I would use my remoted web site's application_error event handler, but that is never called when an exception occurs in one of my MarshalByRef classes. I want one place to catch exceptions for logging purposes, and I really hate to have to tell my team to make sure you include a try/catch in all of your public class library methods so that we can do server-side logging in the catch block. John You can write a channel sink to do that. You can also give AppDomain.UnhandledException a try. Note that in 2.0 an unhandled exception will kill the process. ...Show All

• SQL Server Any other way but Cursors or While loop

  Hi all, I have a bit of a challenging on my hands with this, i have a result set in a table which i am trying to iterate through the rows one by one i.e Values Values Dates 1.10 1.20 1.30 1.40 2006-03-31 00:00:00.000 2006-06-30 00:00:00.000 2006-09-30 00:00:00.000 2006-12-31 00:00:00.000 go to each row get the value and the date perform some calculation with the value and the date and insert it into another table(which sounds easy enough) my problem is how do i iterate through the result set one by one without using a cursor or a while loop do i have any other options at all Hi Thanks, For your reply below is ...Show All

• Software Development for Windows Vista Problem Integrating WF with Visual Studio

  I have just set up a clean installation of Vista Beta 2 64 bit ()build 5384) with the intension of testing out WorkFlow I have followed the instructions to install Visual Studio, the SDK and Orcas. Starting up visual studio I get no WF option in the project types And when I try and install Visual Studio 2005 extensions I get the follwoing error message: Platfor Prerequisites Missing -- Windows Workglow Foundation version 3.0.4125.0 I have checked the WF components are turned on in control panel and it is. "Interestingly" if I create one of the new Windows(winfx) project types I get a load of new WinFX items I can add but they all display as a black window without any tools that can be dragged on... which is m ...Show All

• SharePoint Products and Technologies WildCard Error in Application Definition File Error with custom application

  I am trying to execute a application definition file through webpart .The filter has to be done based on UserID which is of Type Int64. But it gives error as " A Wildcard filter requires a TypeDescriptor that resolves to a String: Hence i tried to change the Filter descriptor to type Comparison and exactMatch ,Even then it did not work. Following is the app def file < xml version = " 1.0 " standalone = " yes " > < LobSystem xmlns = " http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog " Name = " GetTransactionLOBSystem " Version = " 1.0.0.0 " Type = " Database " > < Properties > < Property Name = &quo ...Show All

• Commerce Server BasketHelper: Object does not match target type.

  I've run into a weird exception on checkout now that I do not understand. At this point, when the starter site is calling CheckoutData.BasketHelper.RunBasketPipeline(), the following exception is thrown: " System.Reflection.TargetException: Object does not match target type. " I have breakpoints both on that line as well as in the RunBasketPipeline method, and it is getting the basket helper but unable to call the method. Any help you can provide is greatly appreciated. Peter *hangs head in shame* So, for future reference, if you don't change /all/ of the references to use your new CreditCardPayments class, it will use the old one sometimes, and when you use the o ...Show All

• Visual C++ VS .Net 2005, how to disable intellisense...

  Hi I am really frustrated with the performance of VS .Net 2005. This is because I always see at the bottom "updating intellisense..." and it uses 60% to 70% of CPU. How to disable this updating of intellisense... Please this is making Visual studio unusable. Thanks Chandra Try going to Tools menu -> Options ->Text Editor -> C# -> Intellisense and uncheck the option "Intellisense pre-selects most recently used members". Then click OK. Does this help It does not disable Intellisense, but it should turn off background upates to the recent list. If you are fcing more problems please mention what's your machine configuration, and how large a project size you are working upon. Regards, Saurabh Nan ...Show All

• SQL Server Getting the latest data from different fields in one SQL

  Hi, I'm trying to write some SQL which will give me the following result from the table below.. Currently I can do each of the PRICEx fields in a seperate query then join the results together. I do this by getting the MAX(Date) WHERE PRICEx IS NOT NULL then using that date to get PRICEx, and then repeat until I've done all the PRICE fields. This is acceptable for a small selection, but for a large selection this can get quite slow. I was just wondering if there is there a way to do this in one single SQL without having to join the table to itself 3 times (for all 3 PRICE fields)   fusi0n wrote: Hi HPEvju , Hmm thats not what I'm looking for as it gets the MAX(PRICEn), if PRICEn was lower on a later da ...Show All

• Windows Live Developer Forums How to create a geo-fence

  The PolyLine feature is a great feature in V3. I can now create a polygon for my geo-fence. However, I don't know how to figure out whether a new LatLong is within my previously defined polygon. Can somebody help Thanks. obviously if your polygon is rectangular, it's an easy task... but I don't know how you would accomplish it with the current set of available methods if it is not rectangular. ...Show All

• Windows Forms Real Transparent Panel

  I created a class that inherits from panel. The idea is to put it in front of the form to avoid the user from using the controls while an async function is taking place. I managed to make it completely transparent by turning on WS_EX_TRANSPARENT as in the clase below. public class TransparentPanel : Panel { protected override CreateParams CreateParams { get { CreateParams cp = base .CreateParams; cp.ExStyle |= 0x20; // Turn on WS_EX_TRANSPARENT return cp; } } Now, I'd like that when the TransparentPanel is over the form, it looks grayed-out. Is it possible to do that Thanks a lot in advance Create a new Image in Microsoft Photo Editor: Col ...Show All

• Windows Forms Simple ComboBox / ListBox property question

  Hi, I can't seem to find anywhere in the help menu how to create a drop-down menu that doesn't allow typing input. To be very clear, I want the user to choose either A, B, C, or D. I do want a drop-down menu (like a standard ComboBox). I don't want the user to be allowed to type anything (like a standard ListBox). Is there a property I'm missing or something Thanks! Mike Change the DropDownStyle property from "DropDown" to "DropDownList". The user won't be able to type in any value and can only choose from your list of items.   msopnet wrote: Hi, I can't seem to find anywhere in the help menu how to create a drop-down menu that doesn't allow typing input. To be very c ...Show All

• Visual C# Using C# dll's as plugins at runtime

  Hello, Me and a friend have just started a project to make a main graphical application which should be able to import dll-files that once started, would implement gui-panels and specific functions. We are both fairly new to .NET but feel more comfortable with programming in Visual C# compared to Visual C++. I've been browsing around all day trying to find a solution to our problem but have not found one. I was hoping we could get some help here, or at least find a way to implement the problem. What we want to be able to do is to create C# dll files. The dll files should implement a gui panel to be displayed inside the main application and some functionality (like rs232 communication etc). The problem is that the dll's can not be included ...Show All

• Visual Studio Can you connect to VSS 2005 database with VSS 6 client?

  Can you connect to and use VSS 2005 database with VSS 6 client I setup everything and confirmed that I can indeed connect to VSS 2005 databases using VSS 6.0 client. If anyone knows of any issues and/or limitations with this please post them here. Thanks. ...Show All

• Software Development for Windows Vista Creating Account on Windows Mail

  Hi, What is the way to create the windows mail account using pop3 and smtp server name. I knew that I think IImnAccountManager could do this,but this interface has been deprecated now for vista and also login of creating account been changed in vista. Vista is creating one .oeaccount file for each account into "%UserProfile%\Local Settings\Application Data\Microsoft\Windows Mail". folder. but here I am facing issue of setting binary password and setting as a default account. Please help me if anybody knows anything about this,that would be great for me to know something more about windows mail. Thanks, Prakash. ...Show All

• Visual Basic Manually populate a combobox

  All I want to do is manually populate a combobox with a displaymember and valuemember.  I would've hope something like this would of work; combobox.items.add(new listitem (dr("Name"), dr("ID"))) but there is not listitem in VB.Net.  So what would I use Thanks, Mike The easiest way I've found is make your own structure that you can store in the combo/list box.  This is the structure I load into the combo/listbox items: ' generic structure to use in combo and listboxes to link a text value with a pointer Public Structure ListItem      Public Text As String      Public Value As Integer      Public Sub New ( ByVal ...Show All

• SQL Server Where to build client application for SQL 2005 standard edition

  Hi, I have a database working on SQL Server 2005 Standart Edition and i want to create a client windows form aplication. My problem is where to do it Im trying to use MS visual basic 2005 express edition but it doent support SQL Server 2005 Standart Edition, it only supports SQL 2005 express edition. What should i do And in the visual studio 2005 that comes with the package of SQL Server 2005 standart edition there is no project of a winodws form. Please help No, MSFT is not dumb lol financially speaking lol. It is easy to see that the Express products provide you with alot, but anything further you must purchase a copy of either sql developer and/or Visual Studio 2005 Std+. We are lucky to get what the ...Show All