JD653687's Q&A profile
.NET Development Insert Command Problems
I am trying to get this to run an insert into the database. I keep getting an error saying that it is missing a ;. I don't really get where that would go. Any one The actual method works in other places of the application so it must be a syntax problem. ' Creates the OleDb connection Dim connect As New OleDb.OleDbConnection connect.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Holiday.mdb" 'Creates a variable to store the sql says look for the value in the parameter 'Always specify the field names that you want the data to be entered into Dim sql As String = "INSERT INTO tblbooking (totalcost) VALUES ( ) WHERE [BookingID] =" & booking 'Creates a variable ...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
Visual C++ built-in variables for VC?
Hello everyone, I always notice that some guys are using some VC built-in variables to specify some properties, like OutDir, ProjectName, SolutionName, etc. Then we can use the built-in variables to specify, for example, the generated library name, like $(OutDir)/$(ProjectName).lib. I think this way is very convenient compared with hardcoded names. I am wondering where can I find a list of all such built-in variable names and meanings thanks in advance, George AaronGo wrote: I have Visual Studio 2003 and 2005 installed on this computer, but I would like to be able to build my projects created in 2003 on a computer that has only 2005 installed. I can't seem to buy another copy of 2003 a ...Show All
Windows Live Developer Forums Reading excel file with Lat Long and Label
Hi all: I would like to know if there a way to read an excel file with Lat, Long, Label data and display them directly into VE Thank much! -Peter A couple of ways that I know of: 1) Directly read in the file, parse the lat/longs and output it into html using stringbuilder. A sample application of that would be: http://blogs.msdn.com/mappoint_b2b/archive/2005/12/06/500751.aspx (You can ignore some of the AJAX techniques mentioned there, since your not grabbing from MWS, but the stringbuilder thing is there) 2) Find a way to convert your excel file into a GeoRSS xml file. More details on what it looks like here: http://msdn2.microsoft.com/en-us/library/aa973241.aspx You'll also need to uploa ...Show All
Windows Forms 3rd Party Apps cover a full screen form
I have been developing an application in Visual C++ 2005. I have been using a Full Screen (maximized) form as a root window for my program, and launch a set of forms (menus) which in turn launch forms (sub-menus). I use ShowDialog() to show the forms as this locks control/focus onto the current form. The root window needs to stay visible and full screen under all menus/sub-menus, however a menu form must not be visible once a sub-menu form has been shown. Sample from MENU_Main_Click function: SUBM_Conf ^conf1 = gcnew SUBM_Conf; Hide(); conf1->ShowDialog(); Close(); For this I have used a Hide() function before showing the child form, and a Close() after the child has exited. However using the Hide() ...Show All
Visual Studio Express Editions Get data row from SQL Db & allocate variables to each item.
(2005 express vb edition with sql server 2005 express edition) Hi, I have a Table: WordSurvey, with around 10 fields. Primary Key = wsID I can identify the wsID, but I now need to get all the 10 SQL data fields that relate to it and assign variables to them. I have set up a TableAdapter Query to SELECT * FROM WordSurvey WHERE wsId = @wsID. That is fine. But, I cannot work out how to: 1. Code the call to trigger the SELECT to get the fields (I cannot use SmartTags for this) 2. Allocate each field's string or value to a variable This is so that I can utilise that data to draw a graph and add specific descriptions to a templated Form. (I will also be doing this separately for two other Tables & their resp ...Show All
SQL Server Creating Partions on Developer Edition
Hi, I was trying to partition my cube built in MSAS 2005 Developer Edition based on time dimension, however I was running into a lot of issues. I just read an article which states that cube partition is only possible on Enterprise Edition of MSAS 2005 can someone verify if it is true and if thats the case then why do they provide an option to partition the cube in the developer edition. Thanks If you are using one of the supported providers you should not have any problem. If you are not, it may be that some things are supported in sub-selects but other things are not so some queries may succeed while others fail. You should be able to see the queries the server is generating them and t ...Show All
Visual Basic Master-Detail User Input Form...
Hi, I am quite new to VB in general. I am trying to build a database application using Access tables and create a user interface for it using VB2005. The first form I am strugeling with is the Input form that should allow the users to input invoice type records into the two tables, lets say, Invoices and Items. The form shouls use simple forms elements like TextBoxes, ComboBoxes, CheckBoxes and Buttons that will insert the records into the tables when pressed. Could any of you give me a best practice example that would allow me to acomplishe this (Since I am new to VB, I would prefere to do everything as "visual" as possible, I mean during design time.) Thanks a lot in advance, Regards, Gep. ...Show All
Smart Device Development Is there a reolution limit on creating a bitmap in CF1.0
Is there a resolution limit for created Bitmap images in CF1.0. When I import a small (320x240) type image, it works fine. But when I try to bring in a higher resolution photo, the Bitmap creation fails. I can take the same code, resize the embedded image to something smaller, and it works fine. I can also take the same code with the big images, run it on the desktop, and it too works fine. I check the memory on the device and there's plenty. It almost looks like the CF has some limit to the size of how big an image you can bring in. Thanks There's a limit on available memory. On Windows CE process is limited to 32MB of virtual RAM and usually only about 25-26 of it is normally free. Also keep in min ...Show All
Visual C# support for SuperVGA graphics in system
Hello All , How can i know that my system has support for SuperVGA graphics or not....Programatically C#. and also Support for DirectX 9 graphics and about how much is Graphics memory Any Help Regards, Aamir Thanks for replying.. i have mentioned that i wanna do it progrmatically throug c#.Like one can know about the Processor info through select * from Win32_Processor.. is there any Api for it which show me ..... Regards, Aamir ...Show All
Windows Forms TreeView scrolling
hi, i need to have a scrollable treeview with custom scroll up/down buttons. so i do not need windows scroll bars and need to hide them. by definition treeview.scrollable is "Gets or sets a value indicating whether the tree view control displays scroll bars when they are needed". if it is set to false it is not only hiding scroll bars but override lowlevel trigger to scroll. so if i call [DllImport... static extern IntPtr SendMessage it does not scroll anyway. so how to scroll programmaticaly a treeview with hidden scrollbars. any ideas thanks Peter Ritchie wrote: You can change the TreeView.TopNode property to "scroll" that node into view--thus faking "scrolling". nope. i tr ...Show All
.NET Development Difference between 2 dates in a database
I got a dateReturned and dueBack in a Rent table in my database. I want to know how i can have my program to work out the number of days difference between the two. Cheers for any help in advance ...Show All
Windows Live Developer Forums Quote of the Day Plugin
I wrote another plugin today for inserting a Quote of the Day from a free web service. More details and download on my blog. http://www.myblog4fun.com/dmohorn/archive/2006/10/12/28.aspx Enjoy! Bonnie, a developer on the Writer team, put together a blog post describing how to make an installer using WIX. Check it out! http://bplo.spaces.live.com/blog/cns!CF2831C0AE64E81B!210.entry HTH! Charles Teague - MSFT ...Show All
Software Development for Windows Vista Free E-Learning on .NET 3..0
Microsoft Learning has released 3 2-hour e-learning clinics on .NET 3.0 which are free until .NET FX launch. Collection 5134: Developing Rich Experiences with MicrosoftR .NET Framework 3.0 and Visual StudioR 2005 This collection of 3 2-hour premium clinics teaches about the new capabilities provided by the .NET Framework 3.0. These clinics are for experienced Developers and Software Architects who are looking to adopt Microsoft's next generation technology within their solutions. Topics covered within the collection include: Windows Presentation Foundation Windows Workflow Foundation Windows Communication Foundation Link: https://www.microsoftelearning.com/eLearning/offerDetail.aspx offerPriceId=109340 I did the WF. I ...Show All
Smart Device Development .DLL & ActiveX
I'm relatively new to the development field, so please forgive some of my ignorance. I have a propriety win32 .dll that was written in C++ 6.0 and another written in eC++ for PocketPC by a former co-worker. The win32 version would allow me to create an activeX control that was addable to the form in VB 6.0. The PocketPC version would be compiled and registered on the remote device. References in code to the activeX control would be carried out at runtime by the .dll installed on the PocketPC. (I'm trying to cover everything I can think of, so if I leave something out or need to clarify something let me know.) Now we come to Visual Studio, and the .NET Framework... I started a new SmartDevice project for the PocketPC 2003 ed. The tool ...Show All
