SQLScott's Q&A profile

• Windows Forms Biringing a run-time created textBox in front of a treeView

  On my form I have a treeView having a contextMenuStrip. When I click an item on my contextMenuStrip I am creating a textBox with this code: TextBox entryBox = new TextBox (); entryBox.Left = ClickedX+200; entryBox.Top = ClickedY+100; entryBox.Visible = true ; Controls.Add(entryBox); and my TextBox creates just fine. But the thing is that when the coordinates of the textBox intersect with my treeView my textBox hides behind the treeView and I can not see the textBox; partially or fully. I have tried to write entryBox.BringtoFront(); but unfortunately still no change!!! How can I make my yexyBox appear above of all objects Regards. Maybe not of this event but I think I've found a way to ...Show All

• Visual Studio Express Editions would someone please give a hand?

  Well, this is really confusing me. Here is the code: #include <stdio.h> #include <stdlib.h> #include <time.h> int main() { int alea=0, min = 1, max = 6; srand(( unsigned )time(NULL)); //int alea=0, min = 1, max = 6; alea = rand(); printf( "%d\n\n" ,alea); system( "PAUSE" ); return 0; } As you can check, this is working like a charm. Now, if I comment out the variables declarations and uncomment the previously commented variables declaration, it does not work anymore, and i get the following messages... 1>c:\visual c++\projects\test5\test5\nbrealeatoire.c(9) : error C2143: syntax error : missing ';' before 'type' 1>c:\visual c++\proje ...Show All

• SQL Server Error by converting string to decimal

  Hi, I'm trying to import a text-file into SQL2005 by using SSIS. Unfortunately it doesn't seem to work in the way I thought. Because I'm using the german version of SQL2005 I need to translate the items of my toolbox, so dont wonder if their names are not exactly the same as in the english versions. Try number1: a) My datasource is a flatfile, in the connection manager I changed the DataType for the input column to DT_DECIMAL. In my destination table the data type of ths column is decimal(20,4). Name of the column is "NXT_PUT_PX". b) Running this package results in this error: "Fehler bei der Datenkonvertierung. Die Datenkonvertierung fur die NXT_PUT_PX-Spalte gab den Statuswert '2' und den Statustext 'Der Wer ...Show All

• SQL Server MDX AVG function

  Hello, I have a table with two colums Sex and Age. Sex, Age ------------- M 25 F 32 M 85 F 44 I would like to see average age for Sex. Something like this: Avg Age ------------- M 33,3 F 42,3 I tried this MDX with MSSQL 2000 Analysing services WITH MEMBER [Measures].[AvgAge] AS 'AVG(Descendants([Sex].[Sex] .CurrentMember) ,[Measures].[Age])' SELECT { [Measures].[AvgAge] } ON COLUMNS, { [Sex].[Sex].Members} ON ROWS FROM PCPCube but I doesn't work. Any idea Thank you Jindra Create a new measure in your cube for "Age" with aggregation function set to count - named it "AgeCount". Then run the following query (i assume the aggregation function for the existing "Age" is set ...Show All

• SQL Server How to apply SQL Server 2005 Express SP1 to the version of SQL Server 2005 Express which installs with Visual Studio 2005?

  When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media. How can apply SQL Server 2005 Express SP1 to update this existing instance Currently, if I run this query: SELECT @@version I get the following: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) After applying SP1, I should get 9.00.2047.00. Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1: http://msdn.microsoft.com/vstudio/express/sql/download/ Thank you, Bashman ...Show All

• Windows Forms application manifest errors

  I'm getting the following error message at on one of my customer’s pc when installing an update to a deployment. All of my other customer’s are working fine. Has anyone experienced this issues or has seen this message "Reference in the deployment does not match the identity defined in the application manifest" Here's Microsoft’s explanation. http://msdn2.microsoft.com/en-us/ms229001.aspx I also saw somewhere in the past, that you needed to deleted the local internet cache on the client’s pc which was done. I've also uninstalled the click once app using add/remove programs. So I guess I'm not sure what to do. Here's the actual error: Reference in the deployment does not match the identity defined in the application ...Show All

• Visual Studio 2008 (Pre-release) duplex http, persistent connections, callbacks etc

  Hi all, I'm looking for some advice on how best to approach a problem we would like to solve using WCF. Basically the scenario is that we want to be able to push server messages to a browser. In short, we want to try and implment the Bayeux protocol for comet-stlye web applications (http://www.cometd.com/). I already know that I would need a custom encoder to serialize the server messages to javascript packets (this _should_ be easy, and there are plenty of samples to draw from to enable this) However, I believe that I need a custom http transport. In this stlye of application, the client makes a connection to the server, but the server does not release the response: it is available to be written to as events occur on the server. So, when ...Show All

• Internet Explorer Development Scrolling up 3 Lines after a goto target has been clicked?

  Hello guy, You know those link like, goto Top or goto Section2 in the same page. I wish to my page to scroll up 3 lines after the page jumped to the target. Like The page will jump to target Section2 and scroll 3 lines up. How do I do such thing Thank you very much. Hi, That's simple. Just put an anchor - <a name="youranchor"></a> into the 3rd line and add then add this to your header - between tags <head></head> <meta http-equiv="refresh" content="0; url=#youranchor"> sorry 4 my bad english, i'm only 16years old, and i am from Slovakia ...Show All

• Visual Basic Failed to import ActiveX control

  I am using VB2005 express and VC#2005 express. With my old friend VS2003, whenever i needed to add flash to my WInforms, all i needed to do was to add the control as a com component and drag it on the stage from the toolbar. Now, when i did the same in new express version, althogh it is added in the toolbars and the references list, but still, whenever i try to drag a shockwave flash instance on my win form, i get the error: Failed to import ActiveX control, please ensure it is properly registered. does some one have any idea how to add flash comntrol as we used to do in earlier versions Please reply this ASAP. Thanks and regards. Syed Mazhar Hasan as you guys I am presenting the sam ...Show All

• Visual Studio Team System Always getting "The internal state of the database project..yada yada..."

  That quite annoying as I don’t want to always kill the project from source source and get the latest correct build from the deployment database and build everything on top what was done in the meanwhile. Any suggestion or solution for that in the meantime -Jens. --- http://www.sqlserver2005.de --- Can you provide repro steps so that we can test this internally to fix the issue mairead PM, TS Data ...Show All

• Visual C# windows service error

  Dear all, I'm very new to windows service programming and I keep getting the same error while trying to install. I followed the setup on the MSDN walk through of creating a windows service but still got an error. http://msdn2.microsoft.com/en-gb/library/aa984464(VS.71).aspx The error i get during the setup process is: 'An exception has occurred during the install phase. SystemComponentMode.Win32Exception:the account name is invalid or does not exist, or the password is invalid for the account specified' Can anyone help me is it a permission problem do I have to add some user name and password information to my program The service runs as a local service. thanks ...Show All

• Visual Studio Express Editions Exception handling with Try...Catch

  Hi, everyone! I began learning Visual Basic about a week ago. I created a small application that will produce a file with numerous sections, with each section based on user input from a few textboxes. Here's my problem: If the user doesn't input anything and simply hits the 'Build' button, I get an exception. I've solved this problem with Try...Catch, though now I get about 25 error messages, one for each section. There must be a better way than let loads error messages (message box) hit the user. Also, one other question: Is it possible to do syntax highlighting for an application created in VB Or would it be too slow You shouldn't get 25 error messages if you place your Try/Catch keywords properly. Something like: Private Sub Bu ...Show All

• Visual Studio Team System No Update Deployment in Configuration List

  I'm using CTP5 and trying to do an Update Deployment build to create a sql script with only the changes I made. When I display the properties for the project and click the Build tab, I notice that the Configuration list shows "Active (...)" but does not have any other entries in it. I expected to find Update Deployment in the list. Do I need to create configurations or is there a problem Yes the notes are correct. We'll have our help docs updated shortly. mairead PM, TS Data ...Show All

• .NET Development Please Heeelp I don't know what's wrong AGAIN!!!

    Hi Thank's for your answers. I found a way to make it work, but I don't know if it's a good way. Please let me know if it's not and why. Private Sub cmdDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDel.Click  Me.OleDbConn.Open()  Me.OleDbDAFilmKat.DeleteCommand.Parameters(0).Value = CInt(Me.txtNr.Text)  Me.OleDbDAFilmKat.DeleteCommand.ExecuteNonQuery()  DSFilm.Clear()  Me.OleDbDAFilmKat.Fill(DSFilm.Tables("Film"))  Me.OleDbConn.Close() End Sub But when I tried to use the same way to insert or update a record it didn't work. The database doesn't have the new record or the change of the record isn't made. Why is that Dim comText As New OleDb.OleDbCommand ...Show All

• Visual Studio Express Editions slideshow

  how can I alter this code so it displays a different image every minute.....like slideshow thanks PictureBox1.Image = Image.FromFile _ (System.Environment.GetFolderPath _ (System.Environment.SpecialFolder.Personal) _ & "\Shell2.jpg" ) yes I just done what u said.... but how do i get it to show..... PictureBox1.Image.Save()........ wont work ...Show All