Marsha4830's Q&A profile

• SQL Server Auto increment help

  Is there an auto increment feature for integer key fields.  I'm using VS2005 to configure my DB and I do not see a way to set this. Thanks in Advance MoonWa DataColumn type has a property AutoIncrement: dtEmployees.Columns[0].AutoIncrement = true; dtEmployees.Columns[0].AutoIncrementSeed = -1; dtEmployees.Columns[0].AutoIncrementStep = -1; SQL Server table may also have one identity column, as Christian mentioned. But yo ...Show All

• SQL Server how long need ALTER DATATABLE (DATABASE) SET ENABLE_BROKER ?

  I am try to start with SQL BROKER service, When I lunch from sql Management studio the following query, this don't finish never. ALTER DATATABLE dbname SET ENABLE_BROKER   Where I am mistaking   I've written some article about SB here: http://www.dotnetfun.com/Articles/sql/sql2005/SQL2005ServiceBrokerProblems.aspx   Essentially: -- Enable Service Broker: ALTER DATABASE [Database Name] SET ENABLE_B ...Show All

• Software Development for Windows Vista OpenProcess for service PID from user app

  We have a server application that can be run as a service. In order to communicate with with the server app, our client application, which runs under a user account, uses: OpenProcess( PROCESS_DUP_HANDLE, FALSE, server_pid ) This has worked with earlier windows versions, including Win 2000 and XP. With Vista, if the server runs as a service, when the client calls OpenProcess, it always fails with system error 5 (ERROR_ACCESS_DENIED " ...Show All

• Microsoft ISV Community Center Forums After_Save Event???

  Hi to all. I have a problem. For some sheets, I set to invisible before save. Now, I need set to visible the sheets after save, but there aren`t a After_Save Event... How can I solve my problem Any idea Thanks & Regards. I would try to use the BeforeSave event to cancel the users request to save, and do your own saving routine. I suspect you may need to set a global variable so that you can determine if the save reques ...Show All

• Windows Forms how to pass parameters to query that is build in access

  Dear all, I am using MS Access Database. I am building the queries in Access Database and Executing them using stmt "Execute QueryName". Is there Any way to pass the parameters to Access Queries. That is i want to Execute the query by passing a ...Show All

• Windows Forms Close multiple forms

  I've create a no. of Windows Forms and they are related in the following sequence. FormStart --> FormA1 --> FormA2 FormStart --> FormB1 --> FormA1 --> FormA2 The problem is when I reached end of FormA2. I need to provide a method to close all the Form and back to FormStart. How can I achieve this I can't simply use me.owner.owner.close as the no. of level is not equal. hi, thanks a lot alex for speedy reply and ...Show All

• Visual Studio 2008 (Pre-release) Why will LINQ fail ?

  Microsoft tries to helping object developers to close the gap between the relational world and the object world.And they call this " object modelling approach " Dlinq. Using " custom business entities " in enterprise programming with Dlinq might seem the best thing after " sliced bread " but it isn't. For my part I have written my Mappers and used commercial OR/M tools. They mostly provide the same thing. __Read the table from the datab ...Show All

• Visual Studio Intellisense Manager

  Intellisense Manager does not appear in the Tools menu on my Visual Studio 2005 set up... any one come across this Nevermind I found this... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=138278&SiteID=1 ...Show All

• Microsoft ISV Community Center Forums How to preserve the date format while reading Excel cell (Date) in to combobox?

  Hi, How can i display a range of date values from a sheet (A1:A200) in a combobox and preserve the format. When i set the RowSource property to A1:A200 in the combobox, and click on the dropdown arrow it displays the the date values in the correct format, but after i pick a certain value, it chnages it into a number. - Srini. This appears to be a known problem from Excel 97 and still not fixed ...Show All

• Software Development for Windows Vista SqlPersistenceService and Oracle

  Does anyone know if I can use Oracle for Workflow sqlPersistenceService (and trackingService) and How Thanks in advance! You'll have to write your own persistence service which stores the state to oracle. You'll be able to easily configure or add this service through code. You'll derive from the base peristence service provide the mechanism to write and read from Oracle. Matt ...Show All

• Visual Studio Team System Goal Base Load Test using Response time

  I wish to set up a goal based load test based on the response time average. which counter do I point this at in the LT properties Ken That's great. thanks for the help! the goal based load testing feature using response times averages will better aid me in answering the age Conversation that goes something like: Q: So how many user can I get on a box A: What are the end users usage patterns and what is accpetable performance in ...Show All

• .NET Development Problem accessing Connection String in code-behind

  Attempting to follow a code example in a text book: Chapter 13 - Business Objects as a Source of Data Beginning ASP.NET 2.0 Databases Beta Preview by John Kauffman and Thiru Thangarathinam   Wrox Press c 2005 which says to retrieve a connection string from web.config with this piece of code: Dim connectionString As String =          Configur ...Show All

• SQL Server Retrieve the next auto-increment number

  HI, I have one master table and multiple detail tables. The primary key of the master table is an auto-increment number, which is a foreign key in those detail tables. I am wondering if SQL Server allows us to get the next available auto-increment number of the master table up front. Thanks a lot. No, you can only get it after it is created. To do this you would have to lock the table until you used the v ...Show All

• Visual Studio Express Editions SendKeys Only Sending Once...

  Okay, I'll be quick. What I'm trying to do is use SendKeys( My.Computer.Keyboard.SendKeys(String, Boolean)) to sent text to one of my online games so I can play and not type all the time. Here is what I am doing: Declare Auto Function FindWindow Lib "USER32.DLL" (ByVal lpClassName As String, ByVal lpWindowName As String) As IntPtr Declare Auto Function SetForegroundWindow Lib "USER32.DLL" (ByVal hWnd As IntPtr) As Bool ...Show All

• SQL Server CLR Enabled

  Can anyone tell me what this means and how to fix it I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error.... Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option I changed the 'clr enabled' property to 1 using sp_configure but I still get this error. Thanks Mike This works very well! But if I ...Show All