SJH22's Q&A profile

• .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. modify your code like below: Dim path as string path = (get it from an file dialog box) Provider="Microsoft.Jet.OLEDB.4.0;Data Source=("+path+" & Database.mdb)" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Waiting is booooooring....

  Do you think somebody at Microsoft is reading these posts Are they making us wait on purpose The XNA Team Blog has a video showing some of the content pipeline stuff in C# Express. Not much, but I think the GameFest video showed a bit more of GSE IIRC. ...Show All

• SQL Server Repetitive SQL Tasks

  Thanks in advance. I am new to sql script area. Below is my ugly program. Help, please) There should be a better code to handle these repetitive tasks. /* DECLARE Part Omitted */ SET @Job_ Code_A = '(Job_Type = ''A'')' ; SET @Job_ Code_B = '(Job_Type = ''B'')' ; .... And so on SET @SQL1 = 'Select Count(*) FROM tblWorkorders WHERE' + @Job_Code_A; SET @SQL2 = 'Select Count(*) FROM tblWorkorders WHERE' + @Job_Code_B; ..... And so on EXEC ( @ SQL1 ); EXEC ( @ SQL2 ); ..... And so on Why do you need dynamic SQL You can do: select o.Job_Type, count(*) from tblWorkOrders as o where o.Job_Type in ...Show All

• Visual Studio Team System 2 questions about Automation Build / Build Types.

  Hi folks, these are very blond questions - i'm trying to figure out what this Build Automation stuff is in TFS. 1) Are there any url links to that explain what this is and how to get started with it 2) How does Build Types differ from Web Deployment projects Basically, i have some class libraries, a web project and some test cases (unit tests and later on some web tests). I'm guessing the build automation that comes with TFS is used to build my solution, test cases and code coverage and then deploy the website to the iis machine thanks in advance to any help. :) Hi Aaron - I would be forever in your debt if you could post a few blogs about the various wishes i requested (above). I understand that i have been greedy and a ...Show All

• Windows Forms radiobutton event set coordinates for image?????

  ok, newer to developing (at least in C#), but I want to have an array of 81 radiobuttons at specified coordinates (done), when clicked they will go to my "placepiece" class (does what it says), BUT i want to input the coordinates of the clicked radiobutton into the placepiece class, in the event code [note, b5 is just ONE of the buttons]and also i do not know how to implement it into the playpeice code after that...where should it go in this code/how should it go there, i tried to set a variable for each button, but got an error...help!( b5.AutoSize = true ; b5.Location = new System.Drawing.Point(330, 90); b5.Name = "b5" ; b5.Size = new System.Drawing.Size(37, 17); b5.TabIndex = 61; b5.TabStop = true ; b5. ...Show All

• Visual C# How to use the custom assembly deployed it in the GAC

  Sorry to ask a very basic question here. I have created an assebly and deployed it in the GAC. Now how can I use that assembly I deployed in any type projects, I mean how to add reference to that assmbly just like we add reference to System.Windows.Forms.dll. How can I do that Given below are the steps I done to deploy an assembly 1. Created an SN Key . sn -k "c:\Keys\ver1.snk" 2. Create a dll, and in the assemblyinfo.cs, I have given [assembly: AssemblyKeyFile("c:\Keys\ver1.snk")] 3. Deployed the assembly using gacutil -i <Mylocalpath of assembly> . I checked for this assebly name in c:\windows\assembly, its present there, so the deployment is successful [Edited] Set a registry key to ...Show All

• SQL Server Date format in a merged field

  In the footer from a report I want to print the UserID and the Date. I added a textbox with de following code: =User!UserID & " " & Globals!ExecutionTime Now I want to change the date format in dd-MM-yyy uu:mm. This is not possible in the textbox properties because I added the UserID to the same textbox. Is there a way to change the format You need to use the .NET String.Format method e.g. =User!UserID & " " & String.Format(Globals!ExecutionTime, "dd-MM-yyy uu:mm") ...Show All

• SQL Server federated query architecture advice

  I'm involved in a project building a federated query app. There is an ASP.NET web app talking to a central SQL Server 2005 db. Users input query parameters to the web ap, the request is submitted as a stored procedure to a central db, and from there it is distributed to the selected remote SQL Server 2005 db servers with similar but not necessarily identical schemas where the actual data resides. We must wait for all servers to execute the query and return the results, then aggregate those query results and present them to the web app user. The question is, what is the best way to design this with Server 2005 We need to be able to initiate multiple concurrent queries, then wait (up to some max timeout value) for all responses to ret ...Show All

• Software Development for Windows Vista "The owner SID on a per-user subscription doesn't exist"

  I'm trying to convert this one AVI (XVID) to DVD using Windows DVD Maker. Every single time (tried it 4 times), I get this error at 99.0%: The owner SID on a per-user subscription doesn't exist What is this error I tried with multiple DVD, and still get this. I'm using an NEC DVD-/+R burner (don't know the exact model). No Joy..... The old AVI still does not work, so it seems to be movie specific. HSChronic, set his "date" back, that sounds interesting. Werner ...Show All

• Visual Studio Express Editions Always Round Up in Visual Studio 2005

  Okay Ive gone threw the forums many times and I have yet to find a clear beginner answer. I would like something that has any number that has a decimal to round up..no matter what the number/decimal is. Sorry if I sound rude Im just a little bit annoyed and not being unable to understand a lot of this. Quibbling a bit: the compiler will complain about this code with Option Strict On and it will generate an OverFlow exception for very large numbers (1E19). Avoid this with: Module Module1 Function RoundUp(ByVal Value As Double) As Double If Value < 0 Then Return Math.Floor(Value) Else Return Math.Ceiling(Value) End Function Function RoundUp(ByVal Value As Decimal) As Decimal If Value < 0 ...Show All

• Visual Studio Tools for Office "The project cannot be created" error

  I’ve installed the software in the following order: MS .NET Framework Version 2.0.50727 MS Office 2003 Professional SP 2 (before I had 2002 but uninstalled it) MS VS 2005 Version 8.0.50727.42 (RTM.050727-4200) (before I had VS 2003) MS VSTO 2005 OS is Windows XP SP2. When I try to create any of the Office projects (in VS) I get the following error “The project cannot be created”. I’ve tried to reinstall all the components and run vstor.exe. But still get the same error. The interesting thing is that I can open and run a VSTO project which has been crated on another box. Yaroslav I removed VStudio, Access Extensions, VSTO, then installed only VSTO, hoping it would work as a stan ...Show All

• SQL Server Cannot start SQL Server Browser

  Hello, I use SQL Server 2005 for multi-user access. In the Surface Area Configuration, I changed the protocol from TCP/IP to Named Pipes and restarted the service. Then I went to SQL Server Browser, stopped it and clicked on Start to restart. I am getting a message "An error occurred while performing this operation". I am not able to get the Browser started. Any help would be greatly appreciated. Hey Matt, thanks for the response, The browser service keeps repeating this error: The SQLBrowser is enabling SQL instance and connectivity discovery support. and this error The SQL Server Browser service terminated unexpectedly. It has done this 45 time(s). The following correcti ...Show All

• Visual Basic MP3 FILE FILTER NOT WORKING? with wma activex

  this is the filter for my fileopen dialog: ("MP3-Files|*.mp3|WMA-Files|*.wma|Music Files (MP3, WMA)|*.mp3+*.wma") what is wrong with this it only works for the wma by itself "|WMA-Files|*.wma" and doesnt find any mp3 files when MP3-Files is selected and it doesnt find ANY files in the (MP3-WMA) can someone give me a correction/working filter thanks ...Show All

• Smart Device Development Breakpoints do not get hit...

  Hello,   a colleague has big troubles debugging compact framework 2.0 applications from his VS2005 environment (to be more specific: he has hijacked my PC because the troubles do not occur there ). The problem is that every CF2.0 application he runs will not break when run on a device, but the same application runs and hits the breakpoints on the device emulator. It doesn't matter if it is a big multi-project solution or just a simple little HelloWorld project, the debugger just isn't interested in breakpoints anymore.   We searched over this forum, but none of the solutions work for him. Some of the things we found and tried are: Deleting de bin/obj folders. Showing the Debug toolbar. ...Show All

• Visual C# Assign a bmp resource to a bitmap variable

  I create a resource bitmap as bmp. I can not assign this resource bmp to a Bitmap variable. What I would like to do is change or swap between two bmps every second in a picturebox image. thanks in advance for your help and time, Edward Try this, to extract the bitmap from your embedded resource: Stream theResource = System.Reflection. Assembly .GetExecutingAssembly().GetManifestResourceStream(Application.Name + ".test.html" ); this .pictureBox1.Image = Image .FromStream(theResource); does this help ...Show All