gafrank's Q&A profile

• Smart Device Development Hide textbox cursor

  Hi! I have an application in which I use a textbox merely to display data so I have no need for the cursor. Does anyone know a way of hiding it Thanks The ReadOnly property only prevents the text to be altered. It doesn't remove the cursor. The line textBox1.Cursor.Dispose() does the trick in a WinApp. Unfortunately I'm writing for a device app and that can't be done. ...Show All

• Visual C++ Possible bug with interior_ptr<> in C++ CLI

  I hope this is the correct forum for this sort of question. It is repeated on my blog in case the formatting gets in a mess. I encountered some strange behaviour when using interior_ptr in a generic function. It appears that, for the purposes of pointer arithmetic, the byte size of the template parameter is always assumed to be 4, regardless of whether it is a char or a double. This doesn't happen when interior_ptr is given a concrete type directly. The following example is a generic version of the online help example that demonstates the problem: // interior_ptr bug example // compile with: /clr generic < typename T> void ProbeFirstTwoElements( array <T>^ arr) { // create an interior pointer into the array ...Show All

• SQL Server How do I move a project between machines?

  Hi, I'm an SQL Server  novice. After developing some websites (VS 2005 VWD), my machine started to  crumble. (e.g, SQL Server won't uninstall and lots of other software problems) So I bought a new machine and set up a clean installation of SQL Server 2005 Standard and Visual Studio 2005 standard. I copied my old "projects" folder to the new machine but I cannot use it. 1: When I try to import  I get a "cannot import external files" error. 2: When I click on a project, it launches VS 2005 and I can edit etc. However, when I try to run the website in VS 2005, I get the following error. An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this f ...Show All

• Architecture Architecture for Notification based application

  I need to develop a notification based system in .Net. Basically as and when certain data gets updated, the client machine is informed about it. There would be a windows based application running across all these clients. One way I was thinking of was to have the clients poll the server for any updates at frequent intervals. Whenever the Server does an update it would post the update into a queue. Every client would poll the queue for any updates. Would like to know if this approach is alrite or suggest an alternative architecture. Thanks Sai Hi Bineesh, I also hae to design the application quitre similiar to SAI. Is the way proposed by you same as that of SAI. please explain somewhat in detail ...Show All

• Smart Device Development Breakpoints do not get hit...

  Hello,   a colleague has big troubles debugging compact framework 2.0 applications from his VS2005 environment (to be more specific: he has hijacked my PC because the troubles do not occur there ). The problem is that every CF2.0 application he runs will not break when run on a device, but the same application runs and hits the breakpoints on the device emulator. It doesn't matter if it is a big multi-project solution or just a simple little HelloWorld project, the debugger just isn't interested in breakpoints anymore.   We searched over this forum, but none of the solutions work for him. Some of the things we found and tried are: Deleting de bin/obj folders. Showing the Debug toolbar. ...Show All

• Visual Studio Team System TSD3006 Warning - Why?

  I have the following T-SQL fragment: Declare StepCursor SCROLL CURSOR FOR select GroupID from sdbsOpportunitySalesStep inner join SalesProcessStep_Group on SalesProcessStep_Group.SalesProcessStepRowID = sdbsOpportunitySalesStep.SalesProcessStepRowID Where sdbsOpportunitySalesStep.clientRowID = @ClientRowID and sdbsOpportunitySalesStep.OpportunityRowID = @OpportunityRowID and sdbsOpportunitySalesStep.OpportunitySalesStepRowID = @OpportunitySalesStepRowID and sdbsOpportunitySalesStep.StatusRowID = 1001 This fragment generates the following warning. Can anyone tell me why Warning 1 TSD3006: The relationship from [Procedure] dbo.Federation_OpportunityDataProcessing cannot be resolved between the following possi ...Show All

• SQL Server nvarchar(max) gets truncated at 4000 chars(?)

  I’m trying to call sp_ExecuteSQL with a query that exceeds 4000 characters. DECLARE @sq NVARCHAR ( MAX ) DECLARE @from NVARCHAR ( MAX ) SET @sq = N 'SELECT Quite, AFew, Columns' SET @from = N ' FROM NumerousTables WHERE LotsOfConditions=''very big query...''' SET @sq = @sq + @from PRINT @sq -- This appears truncated at 4000 chars in the Messages tab. EXEC sp_ExecuteSQL @sq , @params , @Param1 , @Param2 , @ParamN , @Param10 -- gets errors Any suggestions Thanks. The PRINT and sp_executeSQL only take up to 4000 chars. I have solved this problem by using: SET @sq1 = ...... SET @sql2 = ...continue... EXEC sp_ExecuteSQL (@sq1 + @sq2) ...Show All

• .NET Development How to read the result of a dynamic SQL query??

  Hi, I am new to C# and I would like to know how I could read the result from an SQL statement dynamically. Basically we have some XML files mapping tables on distinct databases... by reading that XML we create the SQL query and execute the statement. After we get the IDataReader, but I don't know how to read the values dynamically from the reader. The data type for each column is described in the XML file, like Int64, String, int... and so on.... Thanks in advance Hi jfbaro, If you feel the issue is resolved to your liking...mark the post(s) that helped you as the answer(s), so when others search the forums, they might be more inclined to look at a successful post than a non successful one... in the search ...Show All

• Microsoft ISV Community Center Forums Sum of hours using select statement & VBA

  Hi - ok here is my question: I have an activity recording form that records hours logged against a company. I have added a field called 'sumactivityhours' to the table and the form.  what i would like to do is when a user selects a company from the drop down list (thanks derek and duck thing for your fantastic help with that problem) it automatically populates the 'sumactivityhours' field with the total number of hours worked thus far with that company  so that the user can see the total hours and then writes that information into the 'sumactivityhours' field in the table. as i gradually begin to learn a little more about VBA im guessing that i should create an on exit event on the companyname combo box that re ...Show All

• Visual C++ string::find_last_not_of

  While running a 64 bit version I came over this: find_last_not_of does not return npos, it seems to be returning the 32-bit value of npos rather than the 64 bit ( __int64 i assume ). Hello Re: string::find_last_not_of I am going to mark this thread as answered since you have not followed up with any further information on your problem - I assume you solved the problem yourself or one of the suggestions in this thread helped you solved the problem. If you have a solution you could post it so others can find it. If you do not have a solution then please submit further details and then mark the thread as unanswered. Thanks Damien ...Show All

• Visual Studio Team System TFS Source Control Restore

  Hi, We moved our TFS from one machine, to another machine. We backed all our databases up and restored them on the new Server according to the procedure explained on MSDN. Anyway, I saw all my portal documents and Work Items but when it somes to the files stored in Source Control part, I get TF30059:Web Service Initialization Error and nothing shows up. Is there any missing configuration or restore procedure I have made Here are the error descriptions in detail from event logger TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 13.11.2006 14:53:33 Mac ...Show All

• SQL Server making Report Parameters optional

  I’m currently working on a report (SSRS 2005) with parameters which I want to make optional. In other words: when I open the report in the preview or IE, I’m always forced to enter values for every single parameter. But I want to have them optional so I can decide whether to choose values (as the option "Multi-value" is enabled) or leave them blank. (ignore in selection result) is this possible - I hope;-) thanks in advance pamike What we did to achieve this is to create a parameter with a (valid) default value. Say, the parameter @filter of type 'integer' is allowed to have a 'null' value and has default value 'null'. We use this same default value in the query, like (very simple ...Show All

• Visual Studio Express Editions Cancel deletion

  I have a FormView on my ASP.Net page with EDIT, DELETE and NEW command, connectet to SqlDataSource1 I want a MsgBox to pop up when I click DELETE to confirm deletion. How do I cancel deletion in the MsgBox code The other thing to be very careful of on ASP.net pages is the use of things like msgbox methods which will occur on the server and not on the client. This is almost certainly not what you actually want but whne your are developing and you machine and the web server are the same machine - it can present you with a illusion that the messagebox will appear on client machine when you run the application.... Any Asp.net questions best answered on asp forums. ...Show All

• .NET Development about serial port programming

  hi all how can I dial my modem which is connected with the serial port and after connecting how can I show the connection status ...Show All

• Visual Basic very strange dependency problem with DLL's VB.NET

  This is a very weird issue I just recently had happen and am totally stumped by it after a day of trying everything I can think of to fix it. Here is the scenerio I have one master function library dll written in VB.NET 2.0 framework. It references adodb primary interop assebly (originally it was vb6 dll that has been fixed over time and expanded for my purposes, and thus has a dependency on adodb still being used for data access). This DLL is used in almost every project I have written in the past 2 years in .NET and has worked wonderfully. It has no other important references other than system.data, system.configuration, etc... I have one large solution that contains 5 projects not including the function library above. 1 EXE Fro ...Show All