Dave987654321's Q&A profile

• SQL Server Ordering and rearrangement records.

  Hi, I have a table records like below. name priority ------------------------------ John 2 Mike 10 Soo 5 Jane 8 I want rearrange the table records like this. name priority ------------------------------ John 0 Soo 1 Jane 2 Mike 3 In other words, rearrange order by priority and change the value to zero-base. Are there simple queries for this function Use this generic query ... Update PriorityTable Set  priority = NewPriority From ( Select  MainTable.Name,  NewPriority  From  PriorityTable as MainTable   Join    (     Select      Main.Name,      Count(Distinct Sub.P ...Show All

• Visual Studio 2008 (Pre-release) XMAL to C# question (2)

  Hi, Again i don't know how to translate XAML to C#... :\ so i have this XAML code: <Grid x:Name="MyGrid" > <Viewport3D Focusable="true" Name="myViewport3D" ClipToBounds="true"> <ModelVisual3D> .... as you can see this is a Grid that contain Viewport3D that contain ModelVisual3D. how i write it in C# you dont need to specify < Transform3DGroup.Children > the content in the Transform3DGroup will be added as children ...Show All

• SQL Server Parameters in WITH part of MDX

  Hi, I need a parameter within the WITH part of an MDX Statement in Reporting Services. I tried several types, but all will bring an error. I will do it like: WITH MEMBER [Measures].[Amount] AS STRTOMEMBER(@MyMeasure) SELECT { [Measures].[Amount] } on columns, ...... The @MyMeasures should be a combobox with the values like Name: Sales Volume (kg) Value: [Measures].[Sales Volume KG] Name: Sales Volume (m2) Value: [Measures].[Sales Volume KG] ... and so on. What's my failure Thanks Hans Hi Adam, The error is: The query will not be retrieved from the query builder. Check the query for syntax error. The syntax of WITH MEMBER [Measures].[Amount] AS STRTOMEMBER(@MyMeasure) ...Show All

• Software Development for Windows Vista multiple instantiation of workflow

  Hi all, I'm implementing a WS based 'manager' based workflow. In turn this will call several 'child' workflows. I'm calling the 'child' workflows by raising events from the 'manager'. Question: I'm wanting to wait for the child to finish the request (from the manager), then continue in the manager . There may be several managers running at once . In beta 1 I raised an event back from the client to the manager and all worked sweet. This appears to have changed in beta2 slightly (handleexternalevent has different params) I'm wondering: (a) is there a way I can 'inherit' from one of mycustom workflow classes to create the child wfs. This 'notify back' functionality would be built in and each child workflow wouldnt have ...Show All

• Windows Forms Retrieve Object from ListBox

  I've got a OleDBDataReader object whose values I want to store in a ListBox for user interaction. The values I'm storing in the ListBox are the users first and last name (this is the displayed values). And I'm storing in the ListBox the users Social Security Number. I have done this by way of creating an object: class ListBoxStorage { public object data; public string display_string; public ListBoxStorage(object data_stored, string display_val) { data = data_stored; display_string = display_val; } public ListBoxStorage() { display_string = "Empty String"; } public override string ToString() { //MessageBox.Show("User " + display_string.ToString() + ", has the SSN of: &qu ...Show All

• Visual Studio Team System Using MSSCCI provider with VS 2003

  I am trying to use the MSSCCI plug-in in VS2003 but I am having problems trying to bind my projects to the TFS projects.  It seems no matter what kind of Team Project I create it will not recognize it.  In the Source Control dialog I just get <unable to display> in the Server Binding column. I can convert projects to 2005 and add them to a Team Project all day long. How does VS2003 with the MSSCCI plug-in bind to a Team Project   Hello, I see that everything is fine on the screenshot - the projects are connected and status is valid. The Browse may not work as expected (you are prompted only for the server and that's it) because TFS Msscci does not allow to create new mappings if the project is already ...Show All

• Smart Device Development Bluetooth anyone???

  Does anyone have or know of where I can obtain exaples of bluetooth communication set up in vb.net I am attempting to set up communications between a bluetooth mobile printer and a handheld device, so if the example where compatable with the compact framework I would be that much more excited. I have been looking for a while now and have hit a few dead ends (dead links) and am begining to get frustrated. I am suprised at the lack of information on the topic considering how great the technology is and how many hardware solutions are out there. There are a comercial managed wrappers for Bluetooth available which do support Windows Mobile: http://www.franson.com/bluetools/ http://www.high-point.com/ They both work support Microsoft ...Show All

• Visual Studio Tools for Office Very odd excel list object issue

  I have a list object that is bound to a data set. For technical reasons I have a few extra columns in the list that i don't want the user to see (the first and last columns), so I hide them away by making the columns hidden (Format -> Column -> Hide) so they have a width of 0.00. If I then use the filter on the list to filter out some of the records, editing a value causes the data cells to shift one to the left, so say I had User ID (hidden) |First Name | Surname | DOB, and edit the DOB value once commited to the dataset the cells have UserID (hidden) | User ID (now shown in First name column) | First Name (in surname col) | Surname (in DOB column). The dataset hasn't been altered as if i commit it back to the database it saves t ...Show All

• SQL Server attaching DB without .ldf file ???

  hi !! I want to attach database to SQL Server, but I'hv only .mdf file. I lost .ldf file, how should i attach this DB to server Thanks SP It may work if you update sysdatabases which has status data directly like this article . Make sure you have to execute undocumeted DBCC REBUILD_LOG instead of DBCC CHECKDB on SQL2K. ...Show All

• Visual Studio Express Editions banner grabber with split container and HTNL page???

  im trying to dyanmically add results to a datagrid, similar to a port scanner, but diff project.. I used to use the list1 additem, but that was in vb6 and ive never used ti datagrid control. also, i dont want to use the listbox, i could even use the treview but, whatever is easiets and displays the info better.... thank you Your question title makes very little sense, and bears no relation to what you are asking about in your post. Perhaps you are asking about a DataGridView No one can tell you what displays info better [sic], that's up to you to decide. I think you need to be a bit more specific in your question, perhaps showing us what you've tried and why you do or don't think it works. ...Show All

• Software Development for Windows Vista Are WDP files openable in XML Paper Specification viewer?

  Hi , Can anyone please let me know whether XML Paper specification Viewer Beta version can open the xps document embedded with Windows Media Photo Image (WDP) files. Thanks in advance, Santhosh. Hi Santhosh, I have read from the Window's media photo blog that Viewer has some bugs and will not support WDP files.please follow the link below for more details: http://blogs.msdn.com/billcrow/archive/2006/07/06/657457.aspx.The below line clearly says this: (There are a few bugs in the Beta 2 release which have since been fixed and will be available with the upcoming RC1 release.) Regards, sivakami ...Show All

• .NET Development continuing file search after UnauthorizedAccessException error

  I want to search an perticular .exe file on all the fixed drives (c:, d:, ....) and then replace it with another same named file. I am trying to get it but could not. With try catch method the search is stopped with 'UnauthorizedAccessException'. I have given the following code Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim folder As String = "c:\" Dim pattern As String = "example.exe" Try For Each file As String In My.Computer.FileSystem.GetFiles(folder, FileIO.SearchOption.SearchAllSubDirectories, pattern) MessageBox.Show(file) Next Catch ex As UnauthorizedAccessException MsgBox( ...Show All

• .NET Development ".NET Runtime Optimization Service has encountered a problem and needs to close" V. 2.0

  Hi, having lots of problems installing vs 2005 proff on Win Server 2003. After going through the process of installing and uninstalling vs 2005 a couple of times with varying degrees of failure, I decided to try just installing .net framework 2.0. After uninstalling all VS components and all .net Frameworks I downloaded .net Framework 2.0. While going through the install process I get: ".NET Runtime Optimization Service has encountered a problem and needs to close. We are sorry for the inconvenience." This occurs while: Installing native images Executing: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ngen.exe install "System.Drawing.Design, Version=2.0.0.0., Culture=neutral, PublicKeyToken=b03f5f7f11d50a3 ...Show All

• Visual Studio 2008 (Pre-release) Problem opening an WinFx Browser Application

  I have created a WinFX Browser Application. I can run it from Visual Studio 2005 with no problems. I've copied all the files from the release directory to the root of the server's Web server. I've also turn on content expiration and registered the necessary MIME types. When I try to bring the application from the browser I get the following error in the error log file: * An exception occurred while downloading the application. Following failure messages were detected: + Downloading http://localhost/XAMLBrowserApplicatoin/PresentationDesignCore.dll.deploy did not succeed. + The remote server returned an error: (404) Not Found. The file PresentationDesignCore.dll is one of the files in the Web site but not the Presentatio ...Show All

• Windows Forms Loading Image (Visual C# 2005)

  Hey, I after these lines of code what should I put to make it load the image into a PictureBox openFileDialog1.DefaultExt = "*.gif" ; openFileDialog1.Filter = "Gif Images (*.gif)|*.gif|JPG Images (*.jpg)|*.jpg|TIF Images (*.tif), (*.tiff)|*.tif|PNG Images (*.png)|*.png|BMP Images (*.bmp)|*.bmp" ; openFileDialog1.InitialDirectory = "MyDocuments" ; openFileDialog1.CheckFileExists = true ; openFileDialog1.CheckPathExists = true ; Thanks :) oh..thats why...lol ok it works, butanother runtime error, now when I load a .gif and then save it as a .jpg I get a runtime error on the same line of code..it is: A generic error occurred in GDI+. I have to make sure it will save them as other formats thoe, becuase it ...Show All