Wanderermy's Q&A profile

• SQL Server How can VB look something up in an SQL Table?

  How can a Visual Basic Application Lookup information from an SQL table database (all of this in the Code Window, not with the Application User seeing this). e.g.: Making a VB Application verify that the text in a TextBox is the same as the text in an SQL Table/Row (Like when verifying a password.) hi, ok... the provided trivial sample can do that... put a button on the form and execute the provided code... if you get "1" the entered text is present in your table.. regards ...Show All

• Visual Studio Tools for Office Mo A more thorough question on VSTO deployment

  Hi all, I'm backing down to make sure I find a way to deliver to my customer the next few days: I have developed an Excel template with some .NET code behind using VSTO 2005. Not the SE, the first version. My solution uses another .NET assembly (helper.dll) besides the code assembly data.dll "behind" the document (data.xlt). I added a setup project to the solution. Which isn't enough of course. I created to separate install classes, one to install a policy code group thats gives Full trust to data.dll and one to bind the data.dll path to the data.xlt document (via ServerDocument). I added the custom Action to Install the CustomSetup.dll with these installer classes. Now to my questions: Are there any walkthroughs to t ...Show All

• Visual C++ FCLOSE() very slow in appending after a certain point in debug mode in VS2005

  Hi When opening a file for append binary mode with fopen(), and using fwrite(), fclose() takes a long time after a certain number of times of doing this in a loop. To be more specific, in a loop, we open the file, append 5 doubles to the file, and close it. After iteration 203, the time to close the file takes significantly longer. You can see the output of a test program here. The 3 digit number is the iteration, and the two larger numbers are the output of QueryPerformanceCounter() before and after the fclose(), and the line of dashes is the end of the loop iteration. As you can see, the time across fclose() calls from iteration 203 to 204 jumps from 63750 to 1039035 and this jump is a) consistently at this iteration number and ...Show All

• .NET Development Printing Datagrid from ASp.net -- Error Message is displayed

  Hi All, I am using this coed for printign a DataGrid in ASP.Net --- The DataGrid is stored under the DIV tags....but whenever i am running this code, i get teh error strOldOne is undefined... I am not exactly getting wht is teh use of the last statement prtContent.innerHTML=strOldOne; ---- Also if i remove this from teh code snippet, i am still facing this problem (Error Message : "strOldOne is undefined") -- Can u please help me on this.....it's really urgent..... Below is the code snippet i am using currently... <script language=javascript> function CallPrint(strid) { var prtContent = document.getElementById(strid); var WinPrint = window.open('','','letf=0,top=0,width=1,height=1,toolbar=0,scrollbars=0,statu ...Show All

• Software Development for Windows Vista Parental Controls

  I have a 16 year old who is beating the parental controls or has found a way to obtain my login password. Please help. If there is a password file please tell me how to make it unavailable. If he is just beating the controls please tell me how to stop that from happening. Your teen could be connecting to the internet, even without the password and then using Internet Explorer to browse the web. He just opens the window to connect either through network connections or even on the window for the browser program. The connection will connect and he won't be signed in to your parental control program. Once he is connected to the internet he can browse without being signed in (say to MSN.) That way he side steps the parental control and any ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Texture without shaders

  Is it posible to texture a primative without the use of a shader (Like in managed DirectX) All the tutorials seem to use a effect to accomplish this. I'm asking this becouse I want to keep the system requirement for my program as low as possible. ...Show All

• Visual C# GlobalHotKey help - newbie programmer.

  Hello! I'm new to c# and programming in general. I'm trying to create an app that will use global hot keys (only the F1-12, function keys) to display text where-ever the cursor is. For example, if 'F1' is pressed by the user when on MSN messenger, "asdf..or whatever" is displayed. I'm trying to use the RegisterGlobalHotKey function I found on a website for my app, but I have a problem. It takes an extra parameter... modifiers. void RegisterGlobalHotKey( Keys hotkey, int modifiers) { try { string atomName = AppDomain .GetCurrentThreadId().ToString( "X8" ) + this .Name; hotkeyID = GlobalAddAtom(atomName); if (hotkeyID == 0) { throw new Exception ( "Unable to generate un ...Show All

• SQL Server Unable to connect

  I am unable to connect SQL Server Management Studio to any of the databases on my computer. At this stage I am simply starting the Management Studio and asking it to connect to a database I made a few months ago before this connection trouble arose. I'm specifying the server name "BENCHLAP" which is the name of My Computer, using Windows Authentication. The error I get is: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The client is local. At least, it is if I unders ...Show All

• Visual C++ Can't exclude items from file open common dialog

  This is from MSDN: The CDN_INCLUDEITEM notification message is sent by an Open or Save As dialog box to determine whether the dialog box should display an item in a shell folder's item list. When the user opens a folder, the dialog box sends a CDN_INCLUDEITEM notification for each item in the folder. The dialog box sends this notification only if the OFN_ENABLEINCLUDENOTIFY flag was set when the dialog box was created. If the OFNHookProc hook procedure returns zero, the dialog box excludes the item from the list of items. To include the item, return a nonzero value from the hook procedure. Remarks The dialog box always includes items that have both the SFGAO_FILESYSTEM and SFGAO_FILESYSANCESTOR attributes, regardles ...Show All

• SQL Server Invalid Column Error - Any ideas

  Hi, Can anybody point me why I get the error "Invalid Column Name - emp" error. Thanks. Table structures are: Tree create table tree (emp Char(10) Not Null, Boss Char(10)); Stack CREATE TABLE Stack (Stack_top INTEGER Not Null, emp Char(10) Not Null, Lft Integer NOT NULL UNIQUE CHECK (Lft > 0), Rgt Integer NOT NULL UNIQUE CHECK (Rgt > 1)); I am trying to convert the Tree (Adjancency Model) to Stack(Nested Model). CODE BEGIN DECLARE @lft_rgt INTEGER, @stack_pointer INTEGER, @max_lft_rgt INTEGER; SET @max_lft_rgt = 2 * (SELECT COUNT(*) FROM Tree); INSERT INTO Stack SELECT 1, emp, 1, @max_lft_rgt FROM Tree WHERE boss IS NULL; SET @lft_rgt = 2; SET @stack_pointer = 1; DELETE FROM Tree WHERE boss IS NULL; ...Show All

• Visual Basic How to activate "Track Change" facility for Excel 2003 using vbscript

  Hello friends, I'm facing a problem and not able to find out the solution. The problem defination is as follows: After opening the excel file from the vbscript, I want to enable the "Track change" property of the file directly through the vbscript code. The code is as specified below: Workbooks.Open ("c:\33619.xls") ActiveWorkbook.KeepChangeHistory = True ActiveWorkbook.HighlightChangesOnScreen = True With ActiveWorkbook .HighlightChangesOptions _ When:=xlNotYetReviewed, _ Who:="Everyone" .ListChangesOnNewSheet = False End With ActiveWorkbook.Save The problem is that when i explicitly set the " Track change while editing. This also shares your workbook " option in the Tools &g ...Show All

• SQL Server Reporting Services for SQL 2005 Standard

  How do you enable reporting services in SQL 2005 When i initially installed SQL 2005 i allowed everything to be installed, but now i do not see how to get into reporting services to get it started. I also look in the Surface Area Configuration Tool to see how to enable it but did not find anything. Can someone please help me To check if RS was installed successfully, you can look at the following two locations. %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt - Check if RS was installed successfully. Also, if it was installed in the default location, %programfiles%\Microsoft SQL Server\MSSQL.x\Reporting Services. Thanks, Sharmila ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 2D Sprite Mirroring

  Hi everyone, another noob question I'm afraid After creating my first XNA game (the usual...Pong ) I am now underway with my first "real project", still trying to keep it simple I thought I'd attempt to program a 'clone' of Jetpac (an old ZX spectrum classic). I'm well underway but I'm also trying to go back and improve code I've already done....anyway, to my question: I have created my character using a png which contains different poses. At the moment it contains for example, a left facing walk and a right facing walk... I was just wondering if there was an easy way of mirroring the left walk instead of also having to add the right walk to the sprite image map. Thanks. As stated above ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Assign to Vector2?

  This is probably an easy question, how do I assign to a Vector2 This was my first bad guess: Game1.Players .Position = (0f,0f); but it didn't work, I know I can assign to the .X and .Y of the Vector2 but I want to do it in one simple step. Also can you do it without creating a new Vector 2 Cheers Alfons Is there a performance difference between using... position.X = X; position.Y = Y; ...and... position = new Vector2(X, Y); ... There shouldn't be any difference in allocation on the heap because Vector2 is a struct and structs are allocated on the stack (so no GC problem with the Xbox360). But is the compiler able to allocate directly to 'position' rather than a temporary stack variable ...Show All

• Visual Studio Express Editions PictureBox position

  I would like to change a PictureBox position with a button click. It must be possible but has so far eluded me...thanks Private Sub Button1_Click ( ByVal sender As System .Object, ByVal e As System . EventArgs ) Handles Button1 . Click Me . PictureBox1 . Location = New Point (0, 0) End Sub ...Show All