LarryETL's Q&A profile

• Visual Studio 2008 (Pre-release) Changing the selection style of a ComboBox

  How can you change the dark blue selection color when an item is selected in a combo box Changing the ComboBox's template doesn't do it. Changing the ItemTemplate doesn't do it. The ComboBox, when a text item is selected, changes the background color to a dark blue and changes the text color to white. I'd like to know how to change this behavior and also how to remove any sort of selection indication all together. Thanks. < ComboBox Name = " myComboBox " Width = " 140 " Height = " 25 " > < ListBoxItem > < Rectangle Width = " 50 " Height = " 10 " Fill = " Blue " ></ Rectangle > </ ListBoxItem > < ListBoxItem > Test ...Show All

• Visual Studio Express Editions Messages From site

  Hi All, Does anyone have anyideas on how to display latest news from a website into a vb.net app basicly I want to keep people updated when a new playlist is availiable etc. ive looked at rss, but dont need loadsa catagories etc. Is it possible to display a txt file on a server for example in an app Hope someone can help, Stuart Sure, debate is good. I just use my SQL server to stop the table from wobbling . Seriously, both approaches have merit: it really depends on some factors such as: how extensive is the updates list, are multiple users going to be updating it, how often, how many downloading, etc. My feeling is, get it working in some way to see how useful it is then if it's proving t ...Show All

• Visual Basic ms-access and vb.net

  hi, i am sandeep bhawsar , i develope a s/w by using ms-access as back end and vb.net for front end. but when i use this s/w on intranet i use appr. 15 pc to connect one database then the s/w run smoothly but when i try multiple form on each machine and try to run application then error occurs so please help me to this problem. if any restriction to ms-access then tell about this thanks sandeep bhawsar sandeepbhawsar wrote: ...but when i try multiple form on each machine and try to run application then error occurs WHat is the error(s) ...Show All

• Visual Basic Calling an exe multiple times

  I have to develop an application where I need to generate PDF from HTML. I am using ABCPdf component for the same. Now I am giving my users a web interface where they can select the HTML documents (lets say HTML1.html,HTML2.html,HTML3.html ...so on) and then the PDF gets created by invoking an exe which does all the work in the background. Now i want a scalable and robust solution to accomplish this task as my users can be any number and there can be n numbers of html documents to be converted to pdf. For example my user1 schedules 20 HTML files to convert to PDF like wise my user2 also schedules his 20 html files to be converted to PDF and there is no limit to the number of users. and so on .. so if I develop an exe to do the task ...Show All

• .NET Development sorting sortedlist by value?

  i'm sure some of you have run into a situation where it makes sense to sort the elements of a sorted list by value rather than the key itself. Does anyone have any ideas on how this can be achieved. Simple swapping of key/values won't work in my situation. eg. srtList as new SortedList srtList.Add("AZ","Arizona") srtList.Add("NY","NewYork") srtList.Add("MO","Missouri") after sorting I want: AZ - Arizona MO - Missouri NY - NewYork Thanks, -PaTwo Is that strictly true I will give you a working example in something I am doing right now: Suppose you do not know what keys you are going to receive, and that you are seeking through a document and ...Show All

• SQL Server SQL Server Management Studio Reports "Column Prefix" errors on fields such as [First.Name] and [Last.Name]

  Hello, I have an existing SQL 2000 database that I am now accessing from SQL Server Management Studio. In the past, I've created specific tables using dot notation within the field names. I've used Enterprise Manager to edit and update these specific tables without problems. As far as I am aware, the dot notation is legal for SQL Server 2000, 2005, XML, etc. The following example table illustrates the problem I am having. CREATE TABLE [dbo] . [TestTable] ( [First.Name] [varchar] ( 50 ) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Last.Name] [varchar] ( 50 ) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED ( [First.Name] ASC , [Last.N ...Show All

• Visual Studio Team System VSS Migration hanging TF60047 - how to move forward?

  I am in the middle of running VSSConverter to migrate our source (~2GB) from VSS to TFS. It has been hanging for an hour or so with error # TF60047. The error message says there could be a problem with the network connection or TFS connection. I am running in a single server setup so TFS and SQL Server are all on the same machine, and all are running, incl. all SQL Server service - I checked in Configuration Mgr. One problem earlier was that there was huge (~800K) memory usage by w3wp.exe which was being run by the TFSService account. So I shut down IIS. Now, even though memory usage is down to acceptable levels, the migration is still not moving forward. Any ideas on how I can proceed here Or if I were to start afresh, how do I do that ...Show All

• Visual C++ indexed property definition in .cpp

  Hello I can put the split the code for a simple property between the h. and .cpp as follows: // .h file public ref class MyClass { property int Capacity { int get(); } } // .cpp file MyClass:: Capacity::get() { ...// Possibly lots of code here. return cap; } However, I can't find the syntax for similarly putting the code for an indexed property in the .cpp file. I've experimented without success. For example, if I have the following in a .h, property double default [ int ] { double get( int index) { ... // Lots of code here, say. return value; } } I would like to reduce the the above to something like the following and put the rest in the .cpp. property do ...Show All

• Microsoft ISV Community Center Forums Highlighting cells within a worksheet

  Several of us in our office have a fantasy golf league and we administrate it off-line using an excel spreadsheet (we haven't found a free website that lets us tailor the rules to the way we like it.) Anyway, it is a salary cap format, meaning that only one golfer can be on one team at a time. To keep track of this, one of our worksheets has a list of all the golfers. That same worksheet also has every team's roster. For all golfers that are on someone's roster, I manually highlight that same name in the master list of golfers so it is easy to see who is taken and who is available. What I'd like to be able to do is have it automatically highlight that golfer's name in the master list when it appears in the individual team roster's page (an ...Show All

• .NET Development Putting try-catch everywhere. What about peformance ?

  Hi, How does try-catch affect performance If I start putting it in each and every function I have, does it affect performance What if I put a global catch in Main Well, I think its better to write if(null == VarFoo) return; than putting a try-catch block around it. What do say Hi, I'm very new to VS, and am using VS2005. So maybe I'm not doing this correctly, but so far have not had any problems. (touch wood). I make use of the Multiple Active Results Set, with one connection string handling 3 or 4 Sql Statements, and put one Try Catch around the lot, which seems to be OK. Apart from anything else, its a lot less code to have to write and maintain. I'd be interested to know if I ...Show All

• Windows Live Developer Forums Keeping map view with GeoRSS

  Is it possible to load GeoRSS - Data with keeping the map view I use following code: function AddMyLayer(type, source) { VEPushpin.ShowDetailOnMouseOver = true ; VEPushpin.OnMouseOverCallback = null ; var veLayerSpec = new VELayerSpecification(); veLayerSpec.Type = type; veLayerSpec.ID = layerID; veLayerSpec.LayerSource = source + ' RandomKey=' + Math.random() * Date.parse( new Date()); veLayerSpec.Method = 'get' ; veLayerSpec.FnCallback = OnFeedLoad; map.AddLayer(veLayerSpec); layerID++; } Nothing else is done but my map changes the view. Because the loading of the layer is Asynchronous you don't know when it will finish. Adding the alert guarentees it runs after the layer loa ...Show All

• .NET Development Possible to register a C# program to the R.O.T. for OLE automation?

  Hi all, I was wondering if it was possible to "register" your own created c# program for OLE automation This would be the equivalent of accessing something in Excel via OLE. Like: Dim ExcelApp As Object ExcelApp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Edit: and just to clarify, I understand how the GetActiveObject works (by looking up the object in the Running Object Table). I guess I need to know if it is possible to register a program with the Running Object Table. If it is an access problem you could try the value ROTFLAGS_ALLOWANYCLIENT during registration to allow processes of other users to see your COM object. Without further information it is quite difficu ...Show All

• SQL Server query logic

  Hi there Could you help me with rewritting below query in ANSI format-- for sql server 2005 SELECT VSL.VSLNM, VSL.UVN, VSL.UnqCoNo, Co.CoRootNm, Vsl.VslSt, VslTy.VslTyNm, VslSt, Vsl.FlagCd, Vsl.YrBld, Vsl.YrBld, Vsl.Grtge, Vsl.DdWtTge, Vsl.FmaDdWt FROM VSL, Co, VslCo, VslTy WHERE VSL.VSLNM = @VslNm and Vsl.VslTyCd = VslTy.VslTyCd and VSL.UVN *= VslCo.UVN and Co.CoNo =* (Select VslCo1.MainHdgOwrCoNo from VSL VSL1,VslCo VslCo1, VslTy VslTy1 where VSL1.UVN = VSL.UVN and Vsl1.VslTyCd = VslTy1.VslTyCd and VslCo1.UVN = VSL1.UVN) Regards Rahul The general form would be: SELECT t1 . Col1 , t2 . Col1 FROM Table1 ...Show All

• SQL Server Replace Non-Numeric Values With Zero

  Hi All, I have a problem that I have no idea how to fix, not even sure if its possible but hopefully you can let me know. So I am pulling data from one table to another table in a DTS. But I need to check if data in one of the columns contains a non-numeric value and if so change it to a 0. This is basically the code i'm using: SELECT Product, Descript, Qty FROM Products ORDER BY Product, Qty, Descript Does anyone know how to check for non-numeric values and perform this change Rgds, Paul Just needed a slight change to the way you worded the Case statement but that is basically exactly what I needed. Thanks a million Anas ...Show All

• Visual Studio Tools for Office MailItem.Open event handler..which Item??

  My VSTO Outlook add-in registers a handler for the "Open" event of certain email messages. This handler has no parameters, so when executed, how do I recover a handle to the MailItem object that was opened Many Outlook events send no arguments to their handlers...am I missing an obvious way of obtaining the object that is the source of the event being handled -Allen, new to VSTO Someone in support pointed me to a 3rd pary product Add-in Express. My add-in is now pretty far along based on that technology, and it wraps the events and passes the relevant objects to the handlers. BTW I just posted a question to this VSTO thread about accessing a MailItem's "Internet header" which MailItem doesn't ...Show All