Michel Rotteleur's Q&A profile

• Visual Basic how to read system or user variable

  Is there API function to read system or user variable Thanks ...Show All

• Visual Basic Database Developing

  Hello Developer Team..This is Demetrius Powers i am writing you in regards to a situation that i have acquired in entry level database developement.  I am a Database Administrator for a medium level construction company in chicago..They have hired me and a team to complete a database using Visual Studio .Net and Ado .Net...I was wondering if you could share a lil bit of your expertise with me... Here is the problem:  This construction company has 3 storage garages filled with all kinds of tools, equipment and vehicles, since this is a big company they have problem keeping up with all the tools that come in a go as they please some ...Show All

• Visual Basic ControlBox

  How would I execute code when the user clicks the controlbox (little x in the upper-right corner). for an example, if i wanted to display a form that prompts im the user really wants to exit when the x is pressed; or if i wanted to end the program instead of just closing the form when its pressed Putting the following in the form closing event should give you what you need. Private Sub MainForm_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing  If MsgBox("Are you sure you want to close ", MsgBoxStyle.YesNo) = MsgBoxResult.N ...Show All

• Smart Device Development Filtering SQL Mobile

  I have been tryingh to initiate a dynamic filter on a WM 5.0 PC - SQL Mobile (*.sdf) file with no luck. In previous editions of SQL (7/2000) I could specify the filter off of the recordset such as rs.filter = "Title LIKE '" (filter_text) "'" but this doesn;t seem to be available. I am using C# Visual Studio .NET 2005 -- targeting the WM 5.0 PC Smartdevice Any help would be most welcome. As far as I remember there never was any "dynamic filters" in SQL CE/Mobile managed providers and there's no "recordset" class. To filter data please execute query with respective where cla ...Show All

• Software Development for Windows Vista how to detect lost windows network connection?

  I have established a connect and disconnect functionality using the WNetAddConnection2 and WNetCancelConnection2. Everything works fine and I can detect and cater for the errors whenever they occur with connection and disconnection. The problem came when I wanted to add a function to detect whenever a connection is lost, and attempt to reconnect. I've reviewed the msdn library and it turned up a sizeable variety or 'get' type functions which retrieve provider, resource or login attributes pertaining to a connection. Which one should I use, or is there another more appropriate method Thanks. The windows folk ...Show All

• Visual J# ODBC error message: [Microsoft][ODBC SQL Server Driver]00107002COUNT

  I'd like to execute a stored procedure on SQL server 2005 through the com.ms.jdbc.odbc.JdbcOdbcDriver driver but i get an error message: "[Microsoft][ODBC SQL Server Driver]00107002COUNT mez vagy szintaktikai hiba" On SQL server 2000 it works. Best regards, Ferenc I don't know, wich stored procedure executed, when i call the the ResultSet's getMetaData method. ...Show All

• SQL Server Unable to read local eventlog (the parameter is incorrect)

  In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date:  03.11.2005 Time:  17:14:47 User:  N/A Computer: RESYSHADOW Description: Unable to read local eventlog (reason: The parameter is incorrect) Does anyone know what could be causing this.   I have tried it on Windows XP SP2 with local Admin account and on Windows Server 2003 with Domain Ad ...Show All

• SQL Server SQL Server 2005 Management Studio can't be found

  Sorry if someone already covered this, but I can't find anything about it. I just installed (3 hours ago actually) SQL2005 Standard Edition (from the Launch event) on my machine, and i don't seem to have a shortcut to the SQL Server 2005 Management Studio anywhere. I looked for a likely executable, but couldn't find it anywhere.  This wouldn't bother me as much if I could use Enterprise Manager from 2K, but SQL2005 will not allow it to register. How do I get this going   There are people here that want to inspect it's features, etc.  I haven't got anything to show them.   By ...Show All

• Windows Forms How to creat nice flat control without highlight bug ???

  I’m building control library which contains flat style controls. Elements of my library are highlighted when mouse is over and highlighting is off when mouse is outside of the control. The problem is in turning off the highlight. OnMouseLeave event don’t work properly In my opinion and because of that control is highlighted even when mouse is outside of the control. I thought that I fix this with IMessageFilter but problem still exist when control is on the corner of Application window. When this situation occurs I still don’t have solution to catch mouse leave event. Is there any good solution for this problem Btw. I thought about mo ...Show All

• SQL Server cannot convert between unicode and non-unicode with SQL Server

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I believe that the encoding of the text file is ANSI. If it is relevant the database collation is Latin1_General_CI_AS (the same as it was when 2000). Any help anyone can provide will be greatly appreciate ...Show All

• Visual C++ Multiple Resource Files

  Hello. I have been "told" that my app may need to operate in multiple languages. As far as I can tell this will need me to create another resource file, with all the same dialogs, menu's etc just with different languages. So "File" is something else in spanish. I realise that this is a labourous task etc. I was wondering where it is in Visual studio that you can specify to use a different .rc file As I understand it is a .res file thats actually used in the build (i assume its a compiled rc file). I know where this can be changed in visual studio but is there somewhere that i can say instead of using "some path\m ...Show All

• Visual Studio Team System View not checked out but modified files

  How can I do this in TFS Regards, Zsolt Soczo Our command line powertoy tfpt should do this. It would be tfpt online /preview (probably you add also /recursive) ...Show All

• Software Development for Windows Vista How to access a published webservice in hosing web application

  Hi, I am new to WinWF, I have done a Sequential Workflow in Beta 2.2 with WebServiceInput, InvokeWebService and WebServiceOutput Activities and published that as a webservice. Now any body can help me how to access that webservice by making a WebReference to that in a webapplication and where the Interface needs to be implemented which is specified in InterfaceType property of WebServiceInput Activity. Can anyone please help me in this. This is also demonstrated in Hands on Labs HOL 6. Download these from http://msdn.microsoft.com/workflow Regards, Paul ...Show All

• Visual Studio Team System Question about changesets gathered for Team Build.

  I just noticed a behavior which I had hoped wasnt the case. I have a TeamProject with two branches. I have two Team Builds - one to build Branch1, the other to build Branch2. I make a change in Branch1, fill out the comments and check it in. Then make a change in Branch2, fill in the comments and check it in. Then I start the Team Build which builds Branch1. When the build happens it gathers up both changesets and associated them this build (which is supposed to be specific to Branch1, but now included changesets and comments for Branch2). Is this intended Am i doing something incorrectly Can I change some setting so that the chan ...Show All

• Visual C# ListView 'SelectedIndexChanged' situation

  I've got a ListView on my Windows Form that displays information from an Access database. I am trying to show the data in textboxes when a row in the listview is clicked. The code I've typed so far works, to an extent . . . When I click on a row, the lase record in the database is displayed in the textboxes. I know that I need to use the ListView_SelectedIndexChanged event, but where I'm getting confused is how to select the correct item index  I've tried several properties/events/ to get this to work and I'm about to go bald trying to figure this out, can someone point out to me just what I'm doing or not doing   ...Show All