Ferdinand Kuiper's Q&A profile

• SQL Server Help plz - need query to get the following kind of output

  i want result to be in the required format given below: here is the result column A ---------------- 5 7 10 14 22 30 .... i want output to be in this form with a single sql statement: column A column B ---------------- ---------------- 5 2(difference b/n the current record and the next record) 7 3 10 4 14 8 22 8 30 0 can any one plz post the query which gives the above kind of result.. thnx in advance.. And who knows that you're talking about 2000. select t1 . columnA , ( select min ( columnA ) from myTable t2 where t2 . columnA ...Show All

• SQL Server SQL Server does not allow remote connections

  I downloaded VS studio express, and created a personal website using the wizard to test drive the thing. When I hit ctr + f5 to run the sample provided, then I get this message: " An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) " I tried disabling the firewall (Norton's firewall because Windows is disable always). Any suggestions This is a brand-new machine, running XP sp2, just downloaded the VS studio express. I really appreciate your inputs. Regards, Car ...Show All

• Visual Studio Tools for Office Suitable Close event fur Word, Excel and PowerPoint documents

  Hello, I am currently developing an add-in for Word, Excel and PowerPoint. My problem is the following: If a user creates a new document and closes this document without saving it before, it appears the SaveDialog. If the user saves the document, I want to know, where he saved it. For this problem I can't find a suitable close event. The Application class just has a BeforeCloseEvent and the document does not have any close event. Thx for any hint. Jens The best place to get this kind of information is from a group that supports each individual application, as they know the object model best. This forum is primarily for discussing the VSTO technology, and not for supporting the individual Office o ...Show All

• Visual Studio 2008 (Pre-release) Xbab applications not running from the internet

  Hi there, I am trying to run an xbap application from this URL http://www.valil.com/winfx/Valil.Chess.WinFX.xbap (other xbab apps from the internet are not running either e.g http://www.charlespetzold.com/wpf/JeuDeTacquin/JeuDeTacquin.xbap ) IE 6 gives me an error message and wont let me run the app even though I have added the site as a trusted site. It runs if I get the source and compile and run it locally. It looks like a security issue. Can some one kindly tell me what I need to do get the app running from the internet The detailed error info is as follows: Startup URI: http://www.valil.com/winfx/Valil.Chess.WinFX.xbap Application Identity: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ ...Show All

• Visual C# how to endure only one object instance exists

  i am adding a user control to a form programmatically but before i do i want to check if that control already exists, if it does exist i will instead just make it the active/visible control. How can check to see if a control already exist and how can i find a reference to it and make it active/visible Do you mean just one object per form Or one for the whole application E.g. if you have two forms, and Form1 already contains an instance of your control, and you try to add it to Form2, what do you want to happen Do you want Form1 to be brought to the foreground and the control to be made visible Or do you want to permit up to 1 control per form If it's one per form, then you'll need to iterate through ...Show All

• Software Development for Windows Vista OnTaskChanged is not triggered

  I created a SPS workflow which has a OnTaskChanged activity, the onTaskChanged activity is contained in a while activity. all conditions (taskproperties, condition for while loop......) are set prorperly. i am expected the workflow will wait in the OnTaskChanged activity for infopath document (task form). but what really happens is the workflow just complete without waiting. using System; using System.ComponentModel; using System.ComponentModel.Design; using System.Collections; using System.Drawing; using System.Workflow.ComponentModel.Compiler; using System.Workflow.ComponentModel.Serialization; using System.Workflow.ComponentModel; using System.Workflow.ComponentModel.Design; using System.Workflow.Runtime; using System.Workflow ...Show All

• .NET Development Mysql connection

  Hey everyone i had a question if i could access a mysql database without having to make my users install odbc connection or what not. My app will retrieve search values from a database and allow them to follow a link of the file they want to download from that database search. Im a newbie so Any help is appreciate! The users are going to need the database engines drivers installed onto there machine, also you could use odbc connections to build the connection string. Doing this all you would have to do is publish the odbc driver inside your setup file (You can get this driver from mysql) and then the users would not have to worry about configuring the system as you would do it in code. Also not that ...Show All

• Visual Basic "*" Question

  Hi again everyone, I am back once again working on a new project. For some reason I cant seem to find the info I need so, I am back here. :) Anyways, my project... I made a text file parser... it basically opens a text file of your choice, then it searches the document for any word you specify, afterwards, it places that info in a new textbox that you can save as a new file. What I really need this app for is to parse emails. Since the emails arent the same... just the same domain... I need to be able to use the * as a wildcard. Any info on how to do this would be much appreciated. Thank you in advance, Wow, that is pretty confusing to a newbie. lol It does make some sense to me tho. So far, my program will find all the matches wi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3d games 101

  Ok, once one has mastered the art of 2d games, what are the best tutorials out there to jump into the 3d world Learn to use a shader based language. The rendering is 100% shader based in XNA I guess this is good in a weird sort of way you don't have to worry about being stuck in yesteryears of 3d game programming. I'm coming from OpenGL and its a bit odd to not have anything like a quadlist or quadstrip. I suggest reading around on scene mangement and animation basics. Which if you've masterd 2d you should have framed based animation down which will most likely what you'll use. Also prepared to get creative there seems to be no way to transform things at least not with my playing with it. The way i' ...Show All

• Visual Studio Tools for Office Digital signature

  How can I digitally sign a document either a Word or a PDF file using Visual Studio 2005 How do I assure it's integrity Thanks. Hi, It is understood that .NET has reach packagesignature object that can be used to Digitally sign Word 2007 Documents (.docm etc) however is there a way to write a program that would sign a series of .DOT (word 2000 word ...word 2003 Macros) whenever invoked. I get from time to time around 50 to 100 Word macro to be signed, currently the process that I have is manual hence it is time consuming and cumbersome, I have looked at SignatureSet object in VBA but it is meant to sign the Document (.DOC) only not .DOT Any help is appreciated. Josh ...Show All

• Windows Forms Datagridview combobox after update

  All, I have a datagridview bound to a datatable with a combo box column and a text box column. When the user selects a value from the combo box I need to update the text box column with a value based on the selection from the combo box. Can anyone help Thanks in advance Here is one more piece of code that seems helpful when working with dgvcbc's object objFormattedValue = cboc.DataGridView.CurrentCell.EditedFormattedValue; object objValue = cboc.DataGridView.CurrentCell.ParseFormattedValue(objFormattedValue, cboc.DataGridView.CurrentCell.Style, null, null); In the previous post example you could probably use sender from the event arguments. Happy coding. ;)~ ...Show All

• Visual Studio 2008 (Pre-release) Request for a non-generic IGrouping

  It would be great to have a "classic" IGrouping (ie non-generic), upon which IGrouping<K,T> is based, i.e. public interface IGrouping : IEnumerable { object Key { get; } } public interface IGrouping<K, T> : IEnumerable<T>, IGrouping { K Key { get; } } In the absence of IGrouping classic, does anyone know of a simple and non-grubby solution to this: void Print (object data) { if (data is IGrouping<,>) Console.WriteLine ("Key is: " + ((IGrouping<,>) data).Key); } It doesn't compile, but you can see what it's trying to do :) Thanks Joe Hi Joshua. What you suggest relies on static compile-time binding. This is not always an option - an example is if you want the Print method to ...Show All

• Visual Basic using windows service... urgent help

  hello, This is my first time in Window service... I've written my Window service... well my windows service is running already, i assume... coz my windows service can be seen already in server explorer... however... I want to use my window service in another application... I 've declared one protected event in the window service... is there any way i can raise that event in my external application well here is my code... of the window service... Public Class MyService Protected Overrides Sub OnStart( ByVal args() As String ) Timer1.Enabled = True End Sub Protected Overrides Sub OnStop() Timer1.Enabled = False End Sub Protected Event ReturnTime( ByVal TimerReturn ...Show All

• Visual C++ recv won't return on socket close

  Sorry to make my first post a cry for help but I'm running out of places to look. I have a TCP server that accepts connections and than handles the new client sock in a new thread. Everything is working fine except when the client closes ungracefully the socket stays open and my recv is still blocking instead of returning SOCKET_ERROR. I've shutdown the remote client box but my recv won't return and netstat still shows the TCP socket to be ESTABLISHED. It's not a huge deal but I'm leaving threads laying around and not realeasing my socket handles. Any ideas Thanks. Hi, my understanding of TCP is, that it tries to handle network problems gracefully. E.g. if you have a telnet connection to some o ...Show All

• Windows Forms Updating an unbound DataGridView at Runtime

  I am a beginner programmer, so please bear with me. Say you have a DataGridView. You dock it to a Window Form. You set some properties such as AllowUserToAddRows and AllowUserToDeleteRows. So far, so good. Now, according to MSDN, a DataGridView can be eighter bound to a Data source, or it can be used as is. If it's not bound, you simply add rows, fill them with data and it should work just fine. My problem is this. I build the solution, add a Setup project to it and then I deploy it ( that is, install it ) on my machine. Now, I open the application and start populating the rows with data. Everything is fine. I close the application. When I open it again, bingo! All the data is gone. There must be some king ...Show All