Krysys's Q&A profile

• SQL Server Insert / Update Trigger based on a column's value

  I am new to triggers and surely could use some help. I can create a trigger to insert related records based on the main tables ID and insert that value into other related tables fine... but... How do I create a trigger that can insert a record into one table for a columns given value and then insert a record into another table for another given value For instance: New row... Table1, Column1 (PK) has a value of 101 Table1, Column2 has a value of 'Blue'. // When a new row is created in Table1 and Column2 has a value of 'Blue'... I want to insert a new row into Table2 - with Table1 Column1's value. // Now if Table1, Column2 has a value of 'Re ...Show All

• Visual C# Unhandled error

  I wrote in C# simple web browser with the following code for the Go button: webBrowser1.Navigate(new Uri(comboBox1.SelectedItem.ToString) With this code if I type an address that is not on the list of the comboBox or if the address would be for example: " www.aspireusa.net " I hit with the following error: "Object reference not set to an instant of object". And on the top of that box it says: NullReferenceException was unhandled Can anyone help jbattat It works thanks but I am once in a while getting some other errors and i am trying to understand them. Than ...Show All

• Windows Forms Host variable in My.Settings

  I am trying to put a variable in My.Settings. For example If I want to put variable Application.StartupPath in My.Settings and when I retrieve the value back in the Application, the value is retrieved as string like "Application.StartupPath", but I want Application.StartupPath as such. Can someone help me what I am doing wrong ...Show All

• Windows Forms Refreshing DataGridView when I close Detail Form

  I'm a newbie and I'm trying to use VB.NET 2005 beta 2. This is my problem: I have 2 forms, the first form contains a datagridview bound to a table. When I double click on a record, I open another form (detail form) bound to the same table where I can modify the record I selected. Everything works fine. The problem is: when I save data and close the detail form, I want to refresh the datagridview in the first form so that I can see the modified data. Actually the only way I succeeded to do that is using again the Fill method of the tableadapter but I hope there is a better solution. Thanks Stefano Joe: I built a dual form app that ...Show All

• Visual Studio Team System How do I fix the TfsOlapReportDS user problem?

  I am currently unable to run any TFS reports. The error message is: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'TfsOlapReportDS'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors Is it possible to delete and recreate the 'TfsOlapReportDS' user account You have to add the TFSREPORTS Account as local Admin to the application tier server. This will solve the problem. ...Show All

• Windows Forms combobox in menu/toolbar line

  Even in visual studio.net the toolbar consists of both button's and comboboxes. I can't find any reference in the help how to add comboboxes to the toolbar, all I could find is how to add a dropdown-button, and hence where I wanted a combobox I implemented a dropdown button with some extra simple dialog. Does anyone know how to implement a combobox ont ...Show All

• Visual Studio Express Editions Screenshot

  Hi, I am formerly a VB6 developer and have been having problems with Visual Basic 2005 . What I want to do is take a screenshot of a form, and put it into a picturebox. This needs to be done while the form I am taking the screenshot of is hidden. Here is some code I have tried: Thanks so much, this code worked exactly as I needed it to! ...Show All

• Visual J# New Release of J# Browser Controls

  I havent seen a new release of J# Browser controls for a while. Is it dropped We have been making investments on it, so I was wondering if it is about to be dropped or if we are going to see a new release soon Thanks and regards, Bora Ertung Hi Brian, These are excellent News, Thanks for the reply. Bora Ertung ...Show All

• Windows Forms Performance bug in TableLayoutPanel

  This has been briefly covered before ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=278770&SiteID=1 ), but not emphasized as much as it should be, I think. There is unacceptable performance by the TableLayoutPanel control. To reproduce my situation, do the following. On a form, create a fill-docked tab control with two tabs. On one of them, place a fill-docked TableLayoutPanel, with one row. All rows and columns from now on are auto-size, as are all TableLayoutPanels created. Place a Label in the left cell and another TableLayoutPanel in the right having one row. Again place a label to in the left inner table cell ...Show All

• Windows Forms keydown repeats keys?

  Hi Any property/way for the keydown event to receive a number about repeats  due to key being held down Use the lParam bits as follows: Bits 0 - 15 Key Repeat Count Bits 16-23 Scan Code Bits 24 Extended Key Flag Bits 25-28 Reserved Bits 29 Context Code Bits 30 Previous Key State Flag Bits 31 Transition State Flag Make use of the Repeat count to&nbs ...Show All

• .NET Development SqlDataReader & an SQL statement problem

  Original issue went unanswered (well, unsolved) Using returned value from SqlDataSource1 so I'm trying a different route. Instead of writing to Profile, I'm going with Sessions. Here's my issue and some code. The select command won’t let me conditional Where LoginId = the value of the login textbox and Where LoginPwd = value of the password text box. The query when tested does return 164 when I enter in a test user's username and Password into the Query Bulder's "Test Query" but when I put those values into the WHERE area in the Select, it says “no TESTUSERNAME column” “no TESTUSERPASSWORD” column. I have to use WHERE ...Show All

• SQL Server Excel pivot table

  Hi, I have created an OLAP Cube in SQL Server 2005 CTP2 and can browse it fine in the Analysis Studio / Browse tab. When I use the pivot table feature in Excel (2003) I get: XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a value. Any help is appreciated. Cheers, Adam Hi, I realise that this is an old post but as we had this issue for some of our users january 2006 it might help someone... We had an old version of IntelligentApps installed (4.5.0.29) on the clients where we had the XMLA-LocaleIdentifier issue. When we disabled that plugin the probl ...Show All

• Visual Basic VB 2005 Compile Error

  I have an existing VS2K3 solution that contains a mix of C# and VB.NET projects. I've upgraded the solution to 2K5 Beta2 and I get the following error when compiling the solution. This error occurs when building a VB.NET project. InternalMyTemplate.vb(173) : error BC30002: Type 'InvalidOperationException' is not defined. This file is not part of my project, it appears to be related to the 'My' namespace. I can't find any information on this particular error on the net. Does anyone have any ideas Best Regards, Travis G. I found the problem. In the previous version (2003), the VB project's references were all ...Show All

• SQL Server Implementing message queue in SQL Server 2000

  I am implementing a message queue system in SQL Server 2000. My queue table looks something like this: [MessageId] [uniqueidentifier] NOT NULL, [MessageType] [uniqueidentifier] NOT NULL, [Status] [tinyint] NOT NULL, [SubmittedTime] [datetime] NOT NULL, [StartTime] [datetime] NOT NULL, [DispatchedTime] [datetime] NULL, [CompletedTime] [datetime] NULL, [MessageData] [image] NULL This is how I retrieve the next message for processing: SELECT TOP 1 * FROM [Queue].[MessageQueue] WITH (ROWLOCK, UPDLOCK, READPAST) WHERE [StartTime]=@pStartTime AND [MessageType]=@pMessageType AND [Status]=@pStatus ORDER BY [StartTime] and mark it as bein ...Show All

• Visual Basic Console Application Question

  I recently purchased a VB.NET 2005 reference book where the sample code is in console applications. I have done a bit with windows forms, but am unfamiliar with console apps. When I try run the sample code, the command prompt window closes and the application terminates as soon as "Sub Main" executes. I got around this by adding strInput = Console.ReadLine Do While Not (strInput.ToUpper = "QUIT" ) strInput = Console.ReadLine Loop to the bottom of sub main so that I can just type in quit to terminate the application. This works, but I'm wondering if there is some other standard way that this is nor ...Show All