jamesIEDOTNET's Q&A profile

• Visual Basic Welcome to the Visual Basic IDE forum!

  Hi Paul, I am an old Basic language user for about over 25 years , i Have been through all the versions since Basica to Visual Basic 6. However I do not have experience using VB for Database application development or Pocket PC programming. I need at least one complete example that will teach me how to do VB programming with databases of at least two related tables (Parent and Child) , I have tried to find a complete Northwind example for VB, that will show me how to Add new records to the Parent and Child, How to Edit records (Parent and Child), Delete records (Parent and Child), etc. Can you help Thanks. Luis The topic "Walkthrough: Displaying Related Data on a Form in a Wi ...Show All

• Windows Forms Primary Key, Table Adapter and Details

  I have a table that will contain up to 10,000 rows. The data will remain unchanged for long periods of time but will be read often. Users need the ability to create, delete or edit rows of data. Another program will be feeding my program data based on physical events. My program needs to read row data and make decissions based on that data. I do not want 10,000 rows of data sitting in ram unused. The TableAdapter seemed reasonable until I limited the query to one row...then I bagan to learn. GenerateDBDirectMethods presents problems and questions. If my Primary Key is not bound to a Form Control how do I determine it's value I need the Primary Key which, acts as the row designator, to delete that row in the source. If I unders ...Show All

• SQL Server MDX Dynamic Query - how to convert a string to date using Left, DateValue, Format...

  Hello, Basically I have a string parameter for a date (and I do not want to use DateTime parameter type). The entry format is yyyyMMdd. I would like to parse that, transform it in a date, subtract "delta" months of it (where delta is another report parameter), and format is as yyyyMM to get the month key, and finally take the descendants of it. I hardcoded the following query in a test dataset, which works fine: MEMBER [Measures].[testDate] AS ' Format( DateAdd("m", -1, DateValue( Left("20060915", 4) + "-" + Mid("20060915", 5, 2) + "-" + Right("20060915", 2) ) ), "yyyyMM" ) ' Also, the following dynamic query works nice too: set [Ship ...Show All

• SQL Server sp4 on dev edition 2k

  I'm running SQL Server 2000 (Developer Edition) on an XP machine. I'm trying to apply Service Pack 4, which, though I haven't service packed SQL Server 2000 in a couple years (most recently working more in 2005), I have installed SPs against SQL Server without difficulty in the past. I've downloaded the x86 SP4 exe. I extact the package ... but when I got to run setupsql.exe from a command prompt, I get nothing -- no dialog, no apparent install. silent switch is NOT specified. I used add/remove programs to attempt to remove vs2003 EE. we're reloading my machine today, so I hope to avoid recreating the issue. ...Show All

• Software Development for Windows Vista Error handling on running workflows

  Hi, during the last days I looked at error handling in wwf in more detail. Browsing resources like june ctp sdk, the forum, blogs and doing some tests there are some questions: 1. Is there some known "best practice" for dealing with exceptions in runtime 2. When an activity is executing (methode Execute) it seams like the thrown exception can be handled by the activity's overloaded HandleFault methode. If this methode handles the error and returns ActivityExecutionStatus.Faulting the defined FaultHandlerActivity (and the sequence inside) has no effect. Can someone describe the detailed behavior using both mechanisms 3. What happens if the defined error handling workflow throws an exception In my tests I defined ...Show All

• SQL Server Conversation Timer versus LIFETIME

  I need to follow up on a message and check on its status. I am planning on using Conversation Timers (self addressed). I've tried it and they do work well. I am wondering if the LIFETIME parameter can be used for the same purpose. If the dialog has not been closed and the LIFETIME expires, will a message be queued into the service's queue It does not seem that this is the case, but it is worth checking, as it could be a much desired feature. Thanks, If there are specific sections of the documentation that need more explanation, please submit feedback to our support website: http://connect.microsoft.com/site/sitehome.aspx SiteID=68 Thanks, Rushi ...Show All

• Windows Forms Trying to close a form following a loading error

  Hi, Using VS2005, writing in VB. I'm trying to have a form dispose of itself because of a load error where it fails to find its settings files. Problem is, if I call Me .Close() , there's an unhandled ObjectDisposedException referring to the form itself. I'm guessing that this is because of something along the lines of "I'm calling the load code during the constructor, but the error is occurring during the load code and so my constructor is then returning a dead object." but I could easily be wrong. Can anyone recommend me a way to work around this problem so that I can properly have this check Thanks, KF I worked out a solution before I saw you were already happy with an ...Show All

• Visual C++ StrCopy

  Any one can tell me whats de function do StrCpy(not strcpy).MSDN also gives security wanring in its documentation.I want to know details about that function. Why microsoft given security warning regarding that function.Thanx in Advance Can you tell me plz how dis function llows other people to make my application do things that it's not supposed to do.I mean in practical excample where we need to use dat function.What is de fundametnal defference between strcyp and StrCpy. ...Show All

• Visual C# remove from startup

  How do I stop a program from running when I start windows ...Show All

• Visual Studio Tools for Office Why do MS Word Automation return different values with and without Debugger?

  range.Select(); //line 1 float X = ( float ) ((Microsoft.Office.Interop.Word.ApplicationClass) _application).Selection.get_Information( WdInformation .wdHorizontalPositionRelativeToPage); //line 2 If I set breakpoint at line 1 and stop in debugger, I get another value in line 2. Selected range is located in table cell. May be I have to invoke some refresh function or something else before line 2. I don't really understand why I get different values for the same file and the same range in Debugger and without debugger. I want to declare what I found. If I add some delay between loading of word document and processing the objects - all works fine. I think MS Word do some loading asynchronously, s ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating Effect Classes From Pipeline

  Hey, I have a BasicPaletteEffect, which is like basiceffect, except it also contains a matrix palette.  In my processor, if mesh has bone index and vertex weight channels, and if it doesn't already have an external reference to another effect, I want to set it's effect to an instance of BasicPaletteEffect (inside the content pipeline).  Is there any way I can do this Thanks. Alright, thanks. I had figured out that I can just load the file, but was using the filename attached to the external reference. effect.Texture = input.ReadExternalReference< Texture2D >(); Is a neat trick though. ...Show All

• Visual Studio Team System Making the query find items without a review

  I have a query that on the first line says "Assigned = @Me" and that works great I also want to only work items that do not have a review created as a related work item for that item. In otherwords, I only want my items to appear that I have not created a review for. Can someone help me Thanks, Nick Is there a way to build a query to show all items related. I could somehow build a conditional statement and look for a review item. Could that work ...Show All

• .NET Development Is it possible to have a Config file per component?

  If I have an application that refers to 3 .NET dlls, can the .EXE itself have an app.Config file as well as each component I need to store some configuration information for each component, but it would make more sense and be easier to maintain if I had a config file for a particular DLL rather than only 1 config file for the whole application. If this is not possible... any substitute ideas Hi ItchyAshcrackistan, Non possible! Javier Luna http://guydotnetxmlwebservices.blogspot.com/ ...Show All

• Visual Studio Team System Not able to connect to MS Team Foundation Server

  I had installed MS Team Explorer Standard edition in my system and tried to connect to the Team Foundation Server. But I was facing an error TF310003. Then I was advised to uninstall the Team Explorer and install a 180 day trial version of a Team suite through the link http://www.microsoft.com/downloads/details.aspx FamilyId=5677DDC4-5035-401F-95C3-CC6F46F6D8F7&displaylang=en and install Team Explorer again. But when I installed this suite and tried to run it, I faced the error "The Beta period is over". Please let me know what could the problem be, what could this be related to. I would also like to know what are all the list of softwares I need to have installed to connect successfully to the TFS. Please provide a ...Show All

• Visual Studio Matrix Sum doesn't handle multiple rows of same value??

  Using this table: ID Date Prod F1 F2 F3 __ ____ ___ __ __ __ 1 2007-02-15 11:13:09.890 ABC 5 10 20 2 2007-02-15 11:26:28.873 ABC 8 5 66 3 2007-02-15 11:34:00.967 DEF 88 5 3 4 2007-02-15 11:39:56.577 GHI 7 6 5 5 2007-02-15 11:46:14.217 JKL 4 3 2 I attempted a matrix report whose rows are grouped by Date (just the the date part 2007-02-15). The I wanted to Sum up each field(F...) for each Prod. I ended up with this matrix report: ------------------------------------------------------- |=Fields!Prod.Value ------------------------------------------------------- [Gruop On] | =FormatDateTime |F1|=Sum(Fields!F1.Value)| -------------------------- ...Show All