Andy Wilbourn's Q&A profile

• SQL Server Procedure expects parameter which was not supplied...?

  I have this SP definition and below that the code to execute it from .Net. But I'm getting this error: Procedure 'GetNewId' expects parameter '@Key', which was not supplied. Saw an solution on some site which said to set the value of the output param to NULL before calling it, but that didn't do anything. Anyone have any ideas why this may be happening Thanks in advance. CREATE PROC GetNewId(@TableName varchar(32), @Key bigint OUTPUT) AS Declare @NextKey bigint BEGIN TRAN SELECT @NextKey = NewID from ID where TableName = @TableName IF (SELECT @NextKey)IS NULL BEGIN INSERT INTO ID(NewID, TableName) VALUES(0, @TableName) END UPDATE ID SET NewID = NewID + 1 Where TableName = @TableName SELECT @NextKey = NewID from ID where TableName ...Show All

• Visual C++ DeviceIoControl FSCTL_ALLOW_EXTENDED_DASD_IO returns false

  Hi, CString str = \\\\.\\CdRom0 ; hCD = CreateFile (str, GENERIC_READ| GENERIC_WRITE, FILE_SHARE_READ | FILE_SHARE_WRITE, NULL, OPEN_EXISTING, FILE_ATTRIBUTE_NORMAL, NULL); status = DeviceIoControl(hCD, FSCTL_ALLOW_EXTENDED_DASD_IO , NULL, 0, NULL, 0, &returned, NULL); The above DeviceIoControl returns false. Any one knows what , I am doing wrong. I tried this above after ReadFile failed for some sectors of a file in a single file CDROM. This happened when I tried to copy the file, it gave device I/O error. Thanks, Arun For such issues, a bett ...Show All

• Visual Studio Express Editions grrrr - registering

  For some reason the registration page says my email address is invalid so i can't get the key, but its the same one i logged on with. Help Thanks!! I am not at all familiar with this error and this is the first occurance of it that I see. I have no ideas how to help you other than try to get in contact with microsoft. At the bottom of most pages and possible the error message pages there usually is a link "Contact us" that will give you options to get in contact with microsoft. It might take a few days to get an response. If you get help or manage to find out what the problem is and how to fix it, please post it here. It will help others with similar problems. ...Show All

• Visual Studio Express Editions WebBrowser HTML files and HTML document search

  Hi, Two questions (I'm still quite new to VB, but I'm making progress...:-) )...firstly, is there a way to display in a webbrowser box inside a form an html file that I have added to my project - as opposed to having to give a file directory link This is probably really simple.... Secondly, if I've added a few html documents to my project (these could be easily changed to txt files if it makes the situation easier), is it possible to set up a form that will allow these files to be searched with a keyword that is entered by the user I would really need the name of the file that it is in to be given in a resulting dialog box, and then, if possible, for this file to then be opened with the appropriate area highlighted. Or any variation ...Show All

• Windows Forms How can I pass datas from a windows form to a webpage in a AxWebBrowser

  I put a AxWebBrowser into a windows form. How can I pass the data of windows form into the webpage.Thank you. If you use .Net 2 they come with Web browser control use it instead to pass value to item in web bage you need to get reference to it you can write some thing like //Get the Document HtmlDocument hd = webBrowser1.Document; //Get the inpute which has id= txtID of course change it yours HtmlElement he = hd.GetElementById( "txtID" ); //Set the value attribute to the value in winforms textBox1 he.SetAttribute( "value" ,textBox1.Text); ...Show All

• Visual C++ What #include<file> is necessary for using namespace System;?

  The Visual Studio 2005 MSDN Help Search doesn't explain the prerequisite #include<file> needed before the System namespace can be called, for example, in the case it were needed to execute the following statements: using namespace System; Console::Clear(); Does anyone know this necessarily perchance Thanks. Need #include<file> for Console::Clear(); function using namespace System. Does anyone know this information Thanks. ...Show All

• Software Development for Windows Vista Lasermouse 6000 scrolls too fast

  I have Vista RC1 version 6.0.5600 (32 bit) running on a HP Nx7010 laptop with 1 gig ram. I am using a Microsoft lasermouse 6000. The problem is that the wheel scrolls way, way too fast in the vertical direction. If you have a large document, you only have to breather on the mouse wheel and it's zoomed off about 3 pages (minimum). In the wheel options in the mouse settings of control panel, I've got it set to only scroll 1 line at a time, but it's still stupidly fast. It makes the wheel unusable and you end up resorting to dragging the sliders around. Cheers, Glyn. Is there anyway I can get the updated driver for this lasermouse 6000 It's driving me up the wall. Another symptom is that if yo ...Show All

• SQL Server INSERTING Data From Server to Server

  hi there! Well i have two Servers on this two Servers i have the Database with the same Tables. But the Database in the Server_2 consists no data, I want to fill the Tables in Server_2 from the Data in Server_1. What i want to do is to is liked this. -- I performing this on the second Server. SET IDENTITY_INSERT [Server_2].[Database].[user].[Table] ON INSERT INTO [Database].[user].[Table]({COLUMN_NAMES}) SELECT * FROM [Server_1].[Database].[user].[Table] WHERE id=25 SET IDENTITY_INSERT [Server_2].[Database].[user].[Table] OFF This did not work and i have the following Error Message its in German but the ERRORCODE is 7391. I already check out the help section in MSDN but it doesnt really helps... Any Ideas Thanks Die Oper ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where can I download DirectX9/10 SDK for VB ?

  I found one , however it documentation was for C++. Is a documentation of DirectX9/10 for VB exist My problem as a newbie starting out with directX is to Know what version to start with.Im confused about the new Directx10 which supports Vista as some forum stuff I've read suggests it does not support XP So I'm wondering if I should download the direct 9 version ( which is how I came upon the above URL) I'm using XP home and VisualStudio 2005 Express  C# --- Would the new DirectX 10 be compatible with this or should I start out with DirectX9 SDK If anyone can point me in the right direction would appreciate it. ...Show All

• Visual Studio Missing Parameter Field Current Value...

  Hi every body, I am supplying a value to a parameter inside a subreport and still shows this error message below: Missing parameter field current value. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: CrystalDecisions.CrystalReports.Engine.ParameterFieldCurrentValueException: Missing parameter field current value. I have written the codes I used to fill the parameter with value. TestReport is Main Crystal Report. Thanks. [code] Private reportDoc As New TestReport() Dim subreport As ReportDocument = reportDoc.OpenSubreport("Sample") D ...Show All

• Software Development for Windows Vista Sequential workflow and ASP.Net

  I am trying to create a sample for myself of using a sequential workflow and a simple asp.net page. I know how to use the manualschedulerservice, runworklow etc. I also know that I can get the input data from the webpage, then put that into a dictionary and pass that into the workflow. What I'm not sure about is how to get any kind of response back out of the workflow. For example, if all I have in the workflow is a code shape that calculates two numbers and I want to return the response, how do I return it to the asp.net host Should I just create a workflow property and then when the workflow becomes idle, read the property I believe there are also output parameters from workflow instances but I'm not sure off the top of my head on ...Show All

• SQL Server basic SQL question

  I'm not sure if this is the correct forum or not, but I have a basic question. Currently we have are doing calculations via stored procedures and then returning the results back to the client in either a web page or a winForm style application. There are times that the stored procedure takes 20 minutes or 3 hours to run. Now, our database person says that all the calculations needs to be removed from SQL and put in either the web applications code or the winForms code (based on what is calling it) the db person also states that SQL is not intended to do any kind of math (calculations) and they should all be done in the application. I think the calcs should be done on the db and its going to take 20 mins to 3 hours for these things to run n ...Show All

• Windows Live Developer Forums Method to change map "fixed" property on the fly?

  When you load a map you can set the fixed property as per: VEMap.LoadMap(VELatLong, zoom, style, fixed, mode, showSwitch); Most of those props you can alter on the fly. I cannot seem to find a method to alter the fixed state... which means locking down the map no zooms or pans. Jeff, I believe thats correct, there exists no available method to alter the map fixed state. A workaround would be to regenerate the map if you want to turn off the fixed mode. ...Show All

• Visual FoxPro How to manipulate BROWSE NAME objects?

  I am trying to manipulate a browse object. I'm doing a browse nowait and then I make changes to some properties of the object. But then, I can't set focus to the browse window. The following runs through the code all the way to the 'Done'. How can I activate the browse window Thanks. CREATE CURSOR tmprug (rugno c(6) ) INSERT INTO tmprug VALUES ("000001") INSERT INTO tmprug VALUES ("000001") GO top define wind rugs from 06,0 to 18,90 font "Tahoma",10 grow brow fields item=recno():4:w=.F.,rugno NAME oBname wind rugs nowait oBname.AllowAddNew = .T. oBname.column1.setfocus() ACTIVATE WINDOW tmprug WAIT "Done" wind Alen-let me say it again. DON'T use Browse in applications. I ...Show All

• Visual Studio 2008 (Pre-release) WindowState.Maximized hides the TaskBar

  Hi, I was wondering if this was intended or not, but when you set a WPF Window's WindowState property to WindowState.Maximized, it hides (overlays) the taskbar. In WinForm's, when you set the WindowState property to WindowState.Maximized, the taskbar is still visible. If this is the way WindowState.Maximized is supposed to operate, how would I go about retrieving the position and the size of the taskbar, so that I can adjust the size of the Window appropriately Thanks. Kevin I had more or less the same problem http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=336542&SiteID=1 I fixed this with an ugly Win32 Hook private static IntPtr WndProc( IntPtr hwnd, int msg, IntPt ...Show All