YA say hello's Q&A profile

• SQL Server row_number() Help!

  I have a searching SP that uses the row_number() function to help out with paging. But for some weird reason Im getting duplicate results when I run the query. But if I take out the row_number() funciton I get normal results. Here is what I have got, please help me with getting this solved, im tearing my hair out! WITH SearchTable AS ( select distinct st.id, st.title, st.sub_title, st.synopsis, st.short_code, ROW_NUMBER() OVER (ORDER BY st.title asc) AS RowNumber from stock as st left join Keywords on Keywords.stock_id = st.id left join OnlinePreviews opLow ON opLow.stock_id = st.id and opLow.[type] = 1 left join OnlinePreviews opHigh ON opHigh.stock_id = st.id and opHigh.[type] = 2 left join TeachersNotes ...Show All

• Visual Studio Team System problem: checkin programmaticaly a changeset

  Hello all, I need to write a little C# program that : checkout, add a copyright and checkin source files And I'm actually having trouble when I try to check-in When I use the following command line : "tf checkin "C:\File.cs" it works fine. I mean, TFS shows me the checkin dialog. When I run the same command in my program, it does nothing. Here is the part of my code: Process tf = new Process (); tf.StartInfo.FileName = @"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\tf.exe"; tf.StartInfo.Arguments = "checkin \"C:\\File.cs\"" ; tf.StartInfo.UseShellExecute = false ; tf.StartInfo.RedirectStandardOutput = true ; tf.Start(); Console .WriteLine(tf.Standa ...Show All

• Visual C++ Reading XML File and storing into a 3 dimensional CString Array Variable

  Hi, In MFC, I have to read a XML File which is having a size of 2 MB. The contents of the XML Files has to be stored into a 3 dimensional CString array variable. The process is very slow. How I can speed up this. In the place of CString array, if I am using a struct data type will it be faster If so how I can use that struct data type. ================Suresh < xml version="1.0" standalone="yes" > <PO> <O> <N>33 BN. PAC</N> <P>110001</P> <C>b8af4de3-a66d-4a68-8d44-90a3577f5c6d</C> </O> </PO> Hi, The above XML, where the <O></O> will be repeating. I declared a 3 dimensional array, in the first dimension, ...Show All

• Smart Device Development vb.net 2005 numeric updown

  hi have a project in vb.net.it is a mobile project... want to clear the numeric up down value after focus it...but cant.. want that when it focused its text ,text must become cleared or selected...is there any way to do this...like textbox's sellenght ....pls help me! thanks Please see the following post on the newsgroups that show how this can be done. HTH, http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_thread/thread/6877ccf34755c432/6549b1d7a2ce00f7 lnk=gst&q=numeric+updown&rnum=4#6549b1d7a2ce00f7 ...Show All

• Windows Forms Click Once Configuration File

  Hi, I am developing a smart client that is connecting to a database directly for now and want to put it on a CD that can deploy the files on a server. During the deployment, I want to set some application settings on the smart client, like setting the database server name and so forth. I don't want to do this on the client side. Is there a way to do this. Please let me know. Thanks!! Are you trying to change the app.config file on the fly to point to a file server In clickonce you can always perform initial customization in the application. There is a way you can check and see if it is initial run after the install or regular application start. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA play dynamic WAV files at runtime?

  Is there a way to do this Seems to me that you have to construct the soundbank/wavebank by read them from a file. So, I would have to write the wav to a file before playing. Or did I miss some other functions/classes Thanks. You are right, XNA does not support dynamic, runtime created WAV playback currently. I am not sure if the workaround of writing to a (temporary) file will work (esp. on the 360; I always wanted to test it anyways), but you can use MDX or interop to DX on Windows to play (dynamic) sounds. ...Show All

• Windows Forms How to check all ChildItems in a TreeView??

  Hi! I have a CheckedTreeView with an event "AfterCheck". So, always, when the Check-State of a button changes, the event is fired. In the event, I want to check or uncheck all child-Items of the selected Item. So, I wrote a recursive method, that should work just fine. But the problem is, that I use the command "node.Checked = true" to check the childNodes. And always when the command is executed, the "AfterCheck"-event is executed. Is there a way to suppress this event Or is there an easier way to check or uncheck all childItems in a treeView Thanks, Barthi Try this: Private Sub TreeView1_AfterCheck(ByVal sender As Object, ByVal e As System.Windows.Forms.TreeViewEv ...Show All

• Visual C++ Failure to locate DebugCRT in DLL projects after VS2005 SP1

  I've been using VS2005 since it was released. I've learned a lot about side-by-side assemblies since then and have altered my deployment procedures accordingly and moved on. However, since I installed SP1 yesterday, the DebugCRT assembly hasn't worked properly for DLL projects, and right now I have no idea why. My first experience of this issue was debug versions of my applications failing on the machine they were built on with a 'MSVCP80D.DLL not found' error. Release versions of the application work fine. Debug and release versions built before SP1 was installed continue to function on this machine. Recognising this as a side-by-side assembly issue I started investigating. The embedded manifest in my DLLs reads as you would expect: &l ...Show All

• Visual Basic new at this...compiling my app

  Hi everybody~ I have a dumb question… I am using VB.Net 2005 Express, and relatively new at it. So far, I have “published” an app and given it to two people. I noticed right off that it was not what I expected, it was a few files (including an exe) and a folder. Anyway, both times it was installed, the user had to download and install the .net 2.0 framework which took as much as an hour to download and install. Is this right Is there another way to compile instead of publish Will all of my users have to go through this lengthy preparation Would it be different with VS 2005 Standard or Pro Please enlighten me! Thanks, Mike I had the same problem ...Show All

• .NET Development Accessing XML files via network shares

  Hi; Note: While our specific use is ASP.NET, this is a general "accessing XML" question. Our ASP.NET application allows a user to give it an XML filename and the app then opens that file as a datasource to generate a report. The issue we face is we do not want the file opened using the credentials of the user that our ASP.NET app is running under for two reasons: The ASP.NET user may not have access to \\hr\payroll\salaries.xml but the person requesting the report does. The ASP.NET does have access to Web.Config but the person requesting the report does not. Our app supports both forms and WindowsIdentity as an authtication/authorization method. So we do not have the client identity to use if they are using ...Show All

• Visual Studio Tools for Office Add control to ActionsPane

  I am developing an add-in to excel 2003 using Visual Studio Tool for Office SE. I want to add a user control to the actions pane (or task pane). Anywhere I looked for doing it says to use: this.ActionsPane.Add(theControl). My problem is I dont have this.ActionsPane I dont know why but I can't get access to that property, then I can't add controls to the actions pane. Thanks in advance I am also interested in accessing the Actions Pane from a application level addin. Would it be possible to create a document level addin with the desired modifications to the Actions Pane and subsequently call that document to be loaded as a part of an application level addin ...Show All

• Windows Forms Rowvalidating event e.Cancel Hangs

  I am using Rowvalidating event to validate and prevent user from moving out of the row unless the validation succeeds. The code looks like below if (dgdTelephones.Rows.Count > 0 && e.RowIndex < dgdTelephones.Rows.Count - 1) { if (dgdTelephones.IsCellNullOrEmpty( "TelephoneType" ) || dgdTelephones.IsCellValueExists( "TelephoneType" ) || dgdTelephones.IsCellNullOrEmpty( "TelephoneNumber" )) { e.Cancel = true ; } } I have 2 gridviews on the screen. This is one of them and has this event. When I move from this grid to any other control no issues, but when i move to the other grid, the system hangs. The processor is 100% used. Any idea whats happening. If I use the cell validating event it ...Show All

• Visual Studio Express Editions Datagrid View

  Morning all, need help with the datagridview component. I have 5 Columns: QTY / ITEM ID / DESC / UNIT PRICE / TOTAL. How can I make this do the calculation QTY*UNIT PRICE and put the result in the total column, Then add all the totals from the datagridview and display in a textbox on form1. I cant get the total of the total column to display in the textbox: I have a few rows of data like: Qty Price Total 1 22.00 22.00 2 5.00 10.00 I would then want textbox1.text to display the total for all the total column. (32.00) ...Show All

• Visual Basic Closing a form

  How can I tell whether a form is being closed because the user clicked the X in the form control box vs. code that performs me.close(). The two methods give me different results and I'd like to know if the X was clicked so that I can handle that specifically. Thanks, /jerry For the clarification of the users here: Both method keep the Menubar "x" from closing the form.... The global variable method used will only let "Button1" close the form....it doesn't however inform you of what was trying to close the form...I agree it is a simplier solution in which the programmer may impliment easier, however the solution I provide gives the programmer a wider range of accurate control o ...Show All

• Visual Basic GDI+ How do you change the coordinates to Cartesian

  Hi, I need to change my coordinate orgin from Upper Left to Lower Left and I need to have Y positive moving up the screen instead of down. Said another way I need my graphics to match the caretsian plane. Any sample code in VB would be Great CodeVb Thanks kesim, This looks promising. Thank you for the link to your thread. I will do some experimenting and respond on both threads with what I find out. My initial test shows this will work :-) Thanks alot, CodeVB ...Show All