endersshadow's Q&A profile

• Visual Basic Getting the last number of a column

  How can I get the last number of a column in a certain table of my database.I had a form that was bounded to this table that has an autonumber field.To be able to add another record and automatically add the autonumber, I want to get the last value in the table to be able to increment it by one when i click the add new button.thanks.... I have no idea, they are new, as you say, and the way I've described is the way I've always done it, and will continue to do it ( because the designer stuff does not allow you to write scalable or secure code ). The fact that the designer stuff is new probably tends towar ...Show All

• Visual Studio EnvironmentEvents Event thrown after a tool has finished executing

  Does anyone know if there is an event to handle in the EnvironmentEvents class after an external tool has finished executing I would like to search the output window after it has finished being updated by an external tool. I copied the address into my browser and got The page cannot be displayed ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.KB.v10.en/enu_kbvcsharpnetkb/vcsharpnetkb/810230.htm ...Show All

• Smart Device Development Dlls sometimes not found

  Hello, in my C# application I use P/Invoke (DllImport) to import native functions from some extern dlls. At runtime the dlls are linked dynamically and the functions are called. The problem is that it works only sometimes. Sometimes everything is ok and the dlls are loaded correctly and sometimes a message "Dll xxx could not be found" is prompted. The dlls are all located either in the application directory or in the windows directory, so it shouldn’t be a problem to locate them. For testing purposes I have even put them both into the windows and in the application directory - no success. Sometimes a restart of the application is e ...Show All

• SQL Server error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

  hi, i'm using SQL Server CE 2.0 in my application. When i try to synchronize my database by calling replicator.Synchronize(); errors :   Initializing SQL Server Reconciler has failed. process could not connect to Distributor SQL Server does not exists and access denied. what i did right now is i try to register regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll" regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20.dll" both of the DLL files were succeed register. However, when i try to re-do the synchronization. The same error still happened!!! I do not know what's going wrong..=( Who can help m ...Show All

• Software Development for Windows Vista CallExternalMethod to Terminate a Persisted Workflow

  I have a sequential WF with a CallExternalMethod Activity attached. I am wanting to tell the host to terminate another persisted workflow. I have a method in the workflow codebehind that uses the SqlTrackingWorkflowInstance class along with SqlTrackQuery to return a specific workflowInstanceId from the tracking/persistence store. I am attempting to terminate that specific workflow from my current workflow. I know in beta2 it is not possible to directly cancel another workflow. I must create an interface to talk back to the host. I've done this, added the dataExchangeService to my host and added the new service to it. My ...Show All

• SQL Server 2 identically databases - 1 is fast and 1 is slow

  Hi! we've got a curious problem. we've two identicall databases, same tables, same date, same indexes, same server, both replicated. One of them is our life database and the other is our development database. If I execute the following query at the development database the query takes less then one second. If I execute the same query at the live database the query takes about 4 seconds to complete. This is very unsatisfactory!! What I've noticed is, if I try to analyze the query in the tuning advisor on the developement database it completes without tuning tips. If I do the same on the live database I get the following error: TITLE: DTAE ...Show All

• SQL Server Trying to create a Maintenance Plan through SQL Management Studio kicks SSL error

  SQL Server 2005 Beta 2, fresh install onto Server 2003.  When I try to create a new maintenance plan, it throws the following error: TITLE: Microsoft SQL Server Management Studio ---------------------------------------- Exception has been thrown by the target of an invocation. (mscorlib) ---------------------------------------- ADDITIONAL INFORMATION: An OLE DB error 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.) occurred while enumerating packages. A SQL statement was issued and failed. ---------------------------------------- An OLE DB error 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClien ...Show All

• Visual FoxPro Memo File Corruption on VFP9 ONLY

  I am just beginning work for a new client.  This client wanted a VFP5 app upgraded to VFP9..they're using Novell (lastest version).  After the conversion (very little changes needed to be made), they started getting file and memo corruption errors as well as indexing errors.  I took a copy of the data and tried a recopy using SCATTER MEMO MEMVAR to a new fresh data file (using GATHER MEMO MEMVAR) in VFP90.  I got the same errors. (Running XP Professsional) So, just to be sure (my version of VFP9 is new), I tried the same thing on VFP8.  NO ERRORS!  Then I took the new data file (8.0) and ran it through the same ...Show All

• SQL Server Gantt chart in SQL reporting service

  Hi all, I need creat a gannt chart for project server report in SQL reporting service. Is somebody know some good third party tool can help to implement or how to creat by hand Thanks in advance! I use Dundas Chart for Reporting Services and can thoroughly recommend it and it supports Gannt Charts ...Show All

• Visual C++ Fatal error when copiling my first program

  Ok, I'm just starting to learn C++ because I'm taking a class on Object-Oriented next semester and want to know the background info.  I'm trying to compile the source of a Hello World example I encountered in the tutorial I'm using, but it's not working.  The code is: #include <iostream.h> #include <stdafx.h> int main () {     cout << "Hello World";     return0; }   This (with the exception of the stdafx.h inclusion) is exactly what is in my tutorial.  I first got an error saying I needed to include stdafx.h, so I did, tried to compile again and got this error messag ...Show All

• SQL Server Joining two fields to single field

  If I have a database table with the following columns: ID Other_ID Description And I want to join the two ID fields to one field in another table that contains the following fields: ID Name How would i do that Here is some sample data and what I would like returned TABLE1 ID Other_ID Description row 1 1 2 Number1 row 2 3 1 Number2 TABLE2 ID Name row 1 1 John row 2 2 Bob row 3 3 Bill I want to query TABLE1, row 1 so that I pull back the N ...Show All

• Windows Forms Getting Bindings

  upfrontinfo = (XP Sp2 | VC# Express Beta2 | SqlExpress Beta2) I have a form with many controls, several of which are TextBoxes. The TextBoxes are bound to a SqlExpress Database using a DataSet, BindingSource and TableAdapter. Everything works fine as far as the bindings are concerned. The question I have is this ... Is there any way to get a list of the bin ...Show All

• Windows Forms ** Urgent ** - Time

  I have a statusbar1.panel(0).text that displays minutes in string form. Could someone explain how i can convert these minutes into hours and then display in the same place. Many Thanks. Petang Many thanks for your time Omlet, Code is as follows:-Dim idays as single 'Gets how many days time span should be added idays2 = Val(TextBox2.Text) 'Using two datetimepickers  ...Show All

• Windows Forms BUG - Controls disapear

  In a C# project with VS 2005 pro, I have a TabControl with 5 TabPages. From that, in the 3rd TabPages and 4th TabPages I have a TableLayoutPanel which contain a ToolStrip in the upper panel and a ListView set at Details in the lower panel. After a Build with a DEBUG system configuration, the TableLayoutPanel with its controls from the 4th TabPage just disapear from the Designer View . The controls still exists in Source Code and work fine when I execute the code (the controls exists and work well). What is annoying is that I must rely on the Source Code only and can't use the Designer View anymore to set my controls. An ...Show All

• Software Development for Windows Vista Long run business process

  My question is re: how to resume the flow after a queued step. In a simple case, user goto web to create a PO request, since the transaction also need to sent to a legacy system for processing which is queued thru MSMQ. after this is done, then we need to resume back to next step ,say for shipping or mail a invoice to user. How to implement this using WWF. Appreciate any inspiriting thought. Paul , thank for the reply. I can see there are two issues in your suggestion: 1. In order to receive the return msg and move to next step, the host has to be alive for a long time which is risky , ...Show All