GradeAstudent's Q&A profile

• SQL Server Query help - get last username?

  Hi, I hope this is the right place to post this. I am pretty much stuck but think I am doing pretty good so far as I am getting more and more into SQL using SQL Server 2000 here.   I want to be able to get the last username who replied to a topic. The "DateOfLastReply" works great, it gives me the last date of a reply to a topic so pretty much along with this, I want to get who it was that replied last. Any ideas so far, I have thi ...Show All

• SQL Server small scale (light weight) SQL search engine (basically a stored procedure) to search through Products Table

  Hi, I am attempting to build a small scale (light weight) SQL search engine (basically a stored procedure) to search through Products Table. I am passing a search string, which i break up by the ' ' (space) delimiter. next for each [value] (after breaking up) in the search string I want to be able to count the number of occurences of each [value] in the [ProductName] [ProductDescription] fields of the [Products] table. However I am confused as i ...Show All

• Windows Forms Background thread accessing main thread controls

  Hi, In my form load I am creating a background thread which listens on a particular port for some message. When a message is received, I have to refresh the form display for which I have to access some controls of the form's thread. When I try to access these controls I get a cross threading exception. Can someone please point out a workaround for this. Thanks & Regards, Kunal Here is an e ...Show All

• Software Development for Windows Vista Workflow<->Workflow Communication within Beta 2

  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 swe ...Show All

• Visual C++ How can I get a notification about a "display turn off" event (WinXP)?

  Hi, I would like to write a program that gets a notification for when the laptop display is turned off, either manually by the user or automatically by the system power management. Is this posible, and how Thanks, Osnat Below URL might give you some idea http://msdn.microsoft.com/library/default.asp url=/library/en-us/power/base/about_power_management.asp ...Show All

• Visual Basic VB and database question

  currently in process of producing a system. Im stuck. Basically what i want the system to do is to call the information of a selected item from a drop down box. How would i structure an SQL statement to call the information of the selected item from the drop down box You will write a use the selected Item in the drop down listbox to pass a value to a SQL command. This can be via the SQL command parameters ...Show All

• Visual Studio Team System TFSDeleteProject and Error TF30076

  I've used TFSDeleteProject before with limited success (you're not allowed to create a project with the same name as you just deleted), but now when I run it I get the following error: TF30076: The server name teamserver.int.bre.com provided does not correspond to a server URI that can be found. Confirm that the server name is correct. Anyone have any ideas on this That is correct, both were failing.  ...Show All

• Windows Forms How to get a control of other application using my application

  I want to hide other application using my application. Hide ins the sense they(their windows) should not be visible on the desktop. How can i do this in C#     ...Show All

• Architecture Database Bytes per LOC

  In a project estimation program, an input for the database bytes per LOC was required. I searched the web for this term and I couldn't find an explanation for it. can any one help me thanks You'd find that in sites that talk about COCOMO (and its derivatives) That is how many bytes do you have per Lines Of Code (LOC) - divide the estimated database size by the estimated lines of code (sometimes you'd find that as SLOC source LOC) ...Show All

• Windows Forms ToolStripContainer and MDI

  Is it possible to use ToolStripContainer in an MDI application It seems that the ContentPanel does not have the IsMdiContainer property and thus can not be parent of an MDI child. Any work-arounds When you add an MDI child form to your main form by setting the MdiParent property (childForm.MdiParent = MainForm), a lot more is actually going on under the hood. The MainForm creates a new child window of class Mdi ...Show All

• Windows Forms datarowview.isedit always returns true?

  Hi I have a win form with a couple of databound textboxes. it's set up as follows: 'fill the ds 'bind the textboxes txtUsername.DataBindings.Clear() txtUsername.DataBindings.Add( "Text" , _TheDS.Tables( "Users" ), "Username" ) _TheCM = DirectCast ( Me .BindingContext(_TheDS.Tables( "Users" )), CurrencyManager) -------------- Dim dr As DataRowView dr = CType (_TheCM.Current, DataRowView) ...Show All

• SQL Server Export Wizard generates errors

  I am trying to export data from my local server to the hosting server. However I get errors when executing it:   Validating (Error) Messages Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "ID". (SQL Server Import and Export Wizard) Error 0xc0202045: Data Flow Task: Column metadata validation failed. (SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task: "component " ...Show All

• SQL Server SQL Express - can't change language setting

  I've got a problem in Server Management Express CTP - in the SErver properties dialog I can't change any of the properties on the 'General' page. At the moment the Language is set to English(United States), which is giving me a problem with datetime formats, but I can't change it. Am I missing something obvious In order to change the collation on a database open the properties dialog, switch to the "Opti ...Show All

• Visual Studio Tools for Office VSTO Deployment

  Hi all We have just started our work with VSTO enabled documents. We have made our first Proof-Of-Concept solution, which works in our development environment. So now we have come to the next level, deciding and implementing our deployment strategy. So I was wondering if any of you could provide some help, links to guides, or just general comments on "how-to". Our primary deployment strategy is to store both the actual templates and ...Show All

• .NET Development Collection subset

  Have can I return a subset of collection by using one class memeber as the filter criteria Ok. That's why I'm not going to do in this way as it makes the code seems too complicated. Moreover, I'm using BingList (Of T) instead of List (Of T). I found that the BindingList (Of T) doesn't provide the FindAll method. ...Show All