Dave Fackler's Q&A profile

• Visual Basic Calculate Age. Use a VB.NET Function from Crystal Reports

  Hello. I have the following problem: I have a Workers table on my database, which has the typical age of Birth field.  On the mainace form, to show the age I use a function that I've made: Public Function CalculateAge( ByVal bdate As Date ) As String 'Pre:-- Dim result As String resultat = Decimal .Truncate(DateDiff(DateInterval.DayOfYear, bdate, System.DateTime.Today) / 365.25) Return result 'Post: return ...Show All

• Visual Studio VSS diff

  I need to compare 2 VSS6.0 projects using a script. The diff command in VSS6.0 does not have the option to compare 2 projects. How do I do that I suspect you want to use the VSS command line (ss.exe) to compare 2 projects $/Project1 and $/Project2 in the database. The "ss.exe Diff" command for projects can only compare a project in the database with a folder on the local disk. So, you have 2 choices: ...Show All

• Visual C# DLL Files

  You can create an DLL so that you can easy deploy this with more projects. There are no performance penalties, when a DLL is needed it will be loaded and it stays loaded untill the application ends. For your development it can be handy to have multiple projects (DLL's) and for the update process it can be usefull to. The user doesn't have to download a very large .EXE file when you only updated one class for example. You can sepperate them ...Show All

• Visual Basic Error when trying to XML serialize list-arrays

  Hi. I'm working on a project where I have have an array of lists: Public Orders(7) As List( Of clsOrdersSaving.sOrder) (sOrder is a structure...) When I try to Serialize this information into a XML document, I get this error: System.InvalidOperationException was unhandled Message="Unable to generate a temporary class (result=1). error CS1026: ) expected error CS1002: ; expected error CS1525: Invalid expressio ...Show All

• SQL Server The Trash Destination Adapter - Really needed?

  Quick question... I have a conditional split transform in a dataflow... One of the outputs of the conditional split will take records that are just not needed... Do I have to send that output into the Trash Destination adapter Or can I just let those records hang Will there be a memory leak if I don't use a trash adapter I'm just thinking about if I move the package I'd have to go reinstalling the trash adapter every time... ...Show All

• SQL Server CLR Trigger to write file.......

  Hello, theres, I have a request to write to a file whenever new record added to the table. When records insert row by row, it goes well. but when more than 2 session insert at the same time, sometimes it duplicate some record in the file. I try to add synchonize code ( like lock , Monitor) but it doesn't work. any idea Regards, Agi I assume you are using this to generate an Audit log or something s ...Show All

• Visual Basic OTP: Urgent !!!!!!!!!!!! Services Status...

  Hi All, Now again I stuck at an interesting point... I want to know that specified service is running or not... Like if I give the name of the service than I want to know that its running or not or hanged or stopped... STATUS Please Help me out of this probs. As Nat said, these forums are not for VB6 questions. VB6 is out of date, obsolete and unsupported. You should specify that you're using VB6 in whatever forum you find to ask this ...Show All

• Software Development for Windows Vista Vista Install 5342 problems

  I have downloaded vista 5342. I start installing it and it manages to rech phase 2 of the install. Now after the first restart during phase 2 of the install my screen eventually goes Black. It has an underscore "_" flashing at me in the top left corner of the screen. This also happens to me on build 5308. I heard that this black screen is where the hardware is checked. I have left it on this black screen for 1hour and still no look. I ...Show All

• Visual Studio Team System Help with FxCopCmd Loading an Assembly Dir

  Hopefully this is a stupid question (as in, there's an easy answer.) Background:    Using FxCop v1.32    My project file indicates to only check against 1 rule.    It also indicates to ignore 3 Interop dll's that exist in the assembly dir. I'm trying to run FxCopCmd with the following arguments...    /p:C:\Build\MyProj.FxCop    /f:C:\Build\Bin    /d:C:\Buil ...Show All

• Visual C# Detection of thread executing

  I have read up some on utilizing threads, being a newbie to programming in C# and converted a major function in my application to execute in a background thread (to stop the display from freezing up if I switched to another application). The threading worked perfectly and it even terminates itself after completion. The only complication I have is that I cannot update the various text boxes on my form because they are part of other system thre ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectInput or WndProc?

  I've noticed the in the August SDK (and previous ones) that all of the samples use a WndProc function to handle keyboard and mouse input. I assume there is a good reason that DirectInput is not being used. Could someone please enlighten me as to what it is.... Does using WndProc give better performance than DirectInput   Jason Barrett wrote:   Jack Hoxley wrote: I would use DI ...Show All

• Visual Studio Team System Install Testing Tools

  Hi, I installed VS 2005 Beta 2 (not from Team Suite dvd, but from VS 2005 DVD) and then installed Team Foundation Client. I can connect to Team Foundation and make most of the PM tasks, but I don't have the Testing tools. What is necessary to get those tools Thanks a lot For convenience, let's end this thread here and shift to: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=5088   --- Eric Jarvi http://blogs.msdn.com/ejarvi ...Show All

• Visual Studio Tools for Office Most flexible deployment is to GAC?

  Working on a VSTO Word application. Users will need to be able to pull documents from a Sharepoint site that use the app as well as email them to each other, and also be able to work offline... Right now I have decided to install the assemblies into the application folder. However, I assume that if two users install into different app folders (or if Program Files is on D: for one user...) then they cannot email the document from one user to a ...Show All

• SQL Server Calculating distance based on latitude and longitude

  I need to be able to take the latitude and logitude of two locations and compare then to determine the number of miles between each point. It doesn't need to account for elevation, but assumes a flat plane with lat and long. Does anyone have any algorithms in T-SQL to do this if this were easy to do, esri/mapinfo wouldn't charge big bucks for their GIS libraries. People get PhD's in geodesia! Now, there is a solution. Search your ...Show All

• Windows Forms Change the checked and unchecked value of a DataGridViewCheckBoxColumn

  Hi, What I'm trying to do is quite simple..... 1. I've created a empty DataGridView 2. I add a DataGridViewCheckBoxColumn using the following code- colToBeAdded = New DataGridViewCheckBoxColumn colToBeAdded.FalseValue = 2 colToBeAdded.TrueValue = 1 colToBeAdded.ThreeState = False colToBeAdded.valuetype = GetType ( Integer ) colToBeAdded.HeaderText = headerText colToBeAdded.Name = colName colToBeAdded.DataPrope ...Show All