kennm's Q&A profile
SQL Server Writeback through report
Hi, is there any way to write back values to an SSDS DB or SSAS Cube through a reporting services report Best regards Hannes Chris, if you are still looking for feedback.. I was looking up this topic as I had a situation where I thought it might be useful. A finance team I am doing a contract for have been doing forecasting on Excel sheets up until now and wish to create a more secure solution, less manual entry etc. The spreadsheet is currently very similar to the matrix control with drill down both vertically and horizontally etc. I thought a solution provided as a RS report would provide what they need - if - they could update their forecast data back to a DB. Instead I guess I will need to develop a complete ASPX page ...Show All
Windows Live Developer Forums Any examples of new SDK's custom tile layer, but loading a mapcruncher created layer instead of the custom tile layer?
I didn't seem to find any references to how the mapcruncher layer object precisely "maps" to the new VETileSource object in the new SDK reference. It seems it would need to reference the layer's crunched xml file instead of the tile images directly, right Thanks for any help on this! Hi Caleb, I guess what thru me off is that I don't see any reference to the Layers crunched xml file URL or any reference to activating the alpha layer, both which are steps in the mapcrucher layer load I'm using now. Am I right that I can just point to my mapcrucher gernerated tiles directly and it will work here's my present code using the mapcrucher provided example: var layers = MSR.CVE.ImportLayersFromAnchorHRef("Cru ...Show All
Windows Forms ListBox control changes selection on MouseDown, not MouseClick - can this be changed?
Hi all, I have a class that inherits from ListBox and provides drag/drop functionality. I'm finding that selecting multiple items to drag is frustrating, because ListBox doesn't handle a "multi-select-followed-by-drag" operation in quite the same way as ListView (or, eg. Windows Explorer) Try this: Open your "My Documents" folder, select a file. Hold down Ctrl and click a few more to add them to the selection. Now - if you mouse-down (ie. click but don't release) the left button on one of the selected items, it'll allow you to pick them up and drag them. The item selection doesn't change until you release the mouse button. The WinForms ListView control also behaves this way, but the ListBox control appears to u ...Show All
Audio and Video Development RTM version of Windows Media Player 11 is incompatible with HDiSim
Just a quick note that the final release version of WMP 11 causes video playback to stop working in the HDiSim Beta. If you have already downloaded the beta of WMP 11, avoid upgrading to the RTM version if you also want to run HDiSim. Obviously you should upgrade to the RTM version on all your mission-critical machines that don't have HDiSim on them, but nobody is running beta software on their production machines, are they :-) I have two machines (one laptop, one desktop) which are both working with WMP 11 RTM. My third laptop does not work with any version of WMP. My research indicates that it is the lack of hardware T&L support on my third laptop. So, you may want to give the RTM a shot if you have hardware T&L. Otherwi ...Show All
.NET Development Generating xml file for external application
Hello community I'm currently working on a project which interacts with a external printing and archiving application. For this app, an xml file is delivered, which will be parsed and processed. Until now, this xml file is generated manually. Due to its complex schema and size it's quite a heavy task to do this manually. That's why I'm looking for a better solution for generating this generation. So far, my idea was to build an xml schema (xsd file, there is not such a schema yet), generate classes from this schema using xsd command and build a small engine/framework to build an object tree programmatically (filled with custom date, ->parameters) and more comfortable, which would be serialized as xml file at the end. For me, this seems ...Show All
SQL Server Moving data from SQL 2005 to SQL 2000 daily
We need to upgrade our HR system from SQL 2000 to SQL 2005. Support for SQL 2000 ends 12/31/2007. We have a third party vender that do not currently support SQL 2005. Employee's data is transfered from our HR database to the third party database for the purpose of yearly performance evaluation on a daily basis. Both databases are currenlty on a SQL 2000 server. Can data be transferred from a SQL 2005 database to a SQL 2000 database A better solution would be to put the database on 2005 and set the database to 80 (2000) compatiblity. That should fix 99.9% of your issues with conversion and get the database on 2005 where you want it. ...Show All
Visual Basic How to clear browser history
Hello I am trying to figure out a way to clear browser history from my dektop application, ideally for both FF and IE. Anone know of a resource or some code to help me out Thanks! It's actually in C# and won't be of any use to you, it was just a question like yours on how to delete the history and was pretty much concluded that nothing much can be done about it http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=799879&SiteID=1 pretty much severe Windows hacking on trying to do what you want would be done which is of course not recommended especially when distributing your application to clients ...Show All
Visual C# IHTMLDOMNode doesn't have onClick event :(
Hi, everybody! I have inserted a dom node(representing an image) in a web page by c #, but how could I manage the click event of the node(i.e.the image) IHTMLDOMNode doesn't have th onClick event :(, some ideas thank yuou all in advance. Lulaleila Try adding it by using the attributes element. Set a new attribute with the name onclick and the value to the function to run. Michael Taylor - 12/7/06 ...Show All
.NET Development Creating and writing on files
Hello all, I am creating and writing on a .rtf file using c#.net.but what i want the data on the file is to be displayed on style(eg. bold,font etc). How is it possible My code is as follows. System.IO. Directory .CreateDirectory( "C:/Receipt" ); TextWriter tw = new StreamWriter ( "C:/Receipt/Receipt12 .rtf" ); tw.WriteLine( "This is the text to be bold before writing on the file" ); I'm by no means an RTF guru, so bare with me, please. RTF uses a number of escape sequences to apply formatting. I created a blank RTF file and put the bold text " Some bold text " in it. This is what i got when i re-opened the file in notepad: {\rtf1\ansi\ansic ...Show All
.NET Development sorting data in tables
as abv, how can i do it im using sql server express 2005. my situation.. i had retrieved data and sort them before i add them into a combobox. so the problem now is that the ID at the combobox doesnt tally with the ID at the database. the data in the table will continue to increase as time goes.. eg. combobox 0. apple 1.orange 2.pear table 0.orange 1.pear 2.apple i would like to sort the data before i can use the ID for another purpose. SelectedIndex is just the number of the selected item in the listbox. So instead of using selectedindex, use the SelectedItem and cast this to a DataRowView and extract the value, like so: DataSet ds = null; DataTable t = null; private void button2 ...Show All
Visual FoxPro Foxpro memo field in ado (or ado.net)
I see that this question in various forms has been asked and answered here before, but none of them address my needs...:-( What I need to do is a simple vb6 or vb.net (or even c#) oleDB read from the foxpro database where the table contains memo fields. I get data in the field, but its garbage. I suppose I need to get the field contents in another way but have no idea how to.. I have the latest foxpro drives sfrom MS Any help out there example code VB6 sConnString = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;" & sSourceDB & ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;" Set oConn = New Connection oConn.CommandTimeout = 300 oConn.ConnectionTimeout = 5 o ...Show All
Visual Studio Express Editions how to read text from a bitmap file(hand written document) in c#
hey this is madhuri actually i need to read text from a hand written document(bmp file), how to edit a bmp file.I thought to get pixels first but then how to match those pixels with raw data in order to read the exact text from the file. Do i need 2 have any knowledge of pattern matching Any idea of pattern matching in c# i need this very urgently,,, thanx bye Hi Madhuri. I am looking for a sloution to the same problem Did you find out anything Would you like to share what you found with me I look forward in hearing from you. Thanks ...Show All
.NET Development How can I let a user select the location of a database?
Hi, I've created a program that uses a database. The problem I have is that the drive names and or directory names change true time. How can I let a user select the current data base location when it has been changed Like: Dim path as string Provider=Microsoft.Jet.OLEDB.4.0;Data Source=(path & Database.mdb) path = (get it from an file dialog box) Any idee I'm working with vb 2005. The connectionstring I use is made with the wizard of vb2005. It looks like your have the general idea, but it sounds like you want the users newly chosen path to persist over time, so you will have to save it somewhere. Here is how I would do it: 1. Create an entry in the Setting (Properties --> settings) with the name _ ...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
Visual C# A little bit stupid question..Sorry
Excuse me but I`m a beginner in C#. My question is: I have a string s = "xxx xxxxx xxxxx xxxxxx xxxx", How I can convert it to: "xxx", "xxxxx", "xxxxx", "xxxxxx", "xxxx" Thanks ! Best Regards ! Hmm, looks like it worked perfectly to me. The 'elements' string array indeed contains the 5 sub-strings from 's'. What else would you want ...Show All
