Rapier685's Q&A profile

• Visual Studio Express Editions Adding datatable to dataset

  Hey to one and all I made procedure in VS express to create tables in my access 2003 database. With the help of the dataset wizard, i made a dataset call "Customer_Dataset". The tables i created in my access 2003 database, i would like to add these to "customer_Dataset" without using the wizard. I tried doing the following programmatically.. Dim ordersTable As DataTable = Customer_Dataset.Tables.Add( "Orders" ) Dim pkOrderID As DataColumn = ordersTable.Columns.Add( _ "OrderID" , Type.GetType( "System.Int32" )) ordersTable.Columns.Add( "OrderQuantity" , Type.GetType( "System.Int32" )) ordersTable.Columns.Add( "CompanyName" , Type.Ge ...Show All

• Windows Forms Class level variable initializers stopped working at Design Time

  Hello all, I have the following line of code as a class level variable. This code has been working but recently stopped. Private m_DirectorySeparatorChar As String = Path.DirectorySeparatorChar If I single step the code in Design Mode, it is initialized to Nothing even though I can go to the Immediate Window and Path.DirectorySeparatorChar displays \, as I would expect. Has anyone else encountered this situation Path.DirectorySeparatorChar is a character, not a string. If you want to put it into a string, use the correct string constructor, or the Convert class. string sep = Convert.ToString( Path.DirectorySeparatorChar ); // for example, in C# ...Show All

• .NET Development Help request on how to optimally link VC++.NET applications?

  Hi! I posted this question to a wrong forum earlier, now I am reposting it to the right forum. My problem is that I write C++ aplications in tradional form, e.i., the programs include one header file (.h) and one implementation file (.cpp). Compiling is going very smoothly. However, I get problems with the linker and most of the time I get the notorious LNK 2020 error, "token could not be found etc". The reason that I am getting this error message is that the linker cannot locate the implementation files and therefore cannot see where the "tokens" are implemented. It entails that you are supposed to load these .cpp files into the associated projects. My solution to this problem have been like this, because unti ...Show All

• Architecture Data Access layer generation tool query

  Hi Everybody, I am evaluating on various optimistic locking mechanisms for implementation in a DAL code generating software. First Approach : All column based locking .I see following demerits: 1.Can't compare CLOB and BLOB columns 2. Every column of the database entity(table) should have a value set. 3.We have to preserve the old values so extra memory overhead. Second Approach: Timestamp column based locking : I see following demerits: 1.If we go for timestamp based locking ,then we have to create an extra column or an extra table for timestamp of all tables.I think by introduction of rowversion in sql server, the problem of extra column is solved now atleast for oracle and sqlserver.Not sure about access a ...Show All

• Software Development for Windows Vista Timers Persistence with Default and Manual WorkflowSchedulerService

  A while back on this forum there was a post regarding Timers, PersistenceService, SchedulerService. We were at the Beta 2 stage then. Here is part of it: "I'm wondering if there are any best practices regrading architecting ASP.Net workflows which contain delays.  The delays are used to send notifications at different intervals and to timeout "waiting for approval" kind of activities.  These workflows have tracking and persistence enabled. I ran some tests to mimic a potential web server outage and it seems each persisted workflow needs to be loaded and touched in some way (eg, handleexternalevent) in order for the delayed timers to fire (timers that would've fired had the server kept running).  Things don't appear to ...Show All

• Visual C# The considered solution.

  That will only work if the array is a squared array (same height and width). I figured it out lastnight, atleast it has worked on everything I have tested so far. currentShape is the original array and rotatedShape is the new array. The new array's width and height must be opposite that of the original's (if the original array is [3,4] then the new array will be [4,3]). Then its a matter of incrementalling walking through the x and y coordinates of the new array while only incrementing the x coordinate of the old array and then decrementing the old array's y coordinate. // Use our 2D array to rotate the game piece. bool[,] rotatedShape = new bool[currentShape.GetLength(1), currentShape.GetLength(0)]; for (int y = 0; y < rotatedShape.Ge ...Show All

• Software Development for Windows Vista Advise on creating Oracle Persistence

  Hi Everyone, I've started to attempt an oracle persistence service as i've no choice on database. I've taken the schema scripts from the sql server persistence and mapped them into a set of oracle tables. Now its the stored procs. For now i'm not wrrying about locking or anything like that but am looking purely at getting the data in. The signature for the sql server sp is: Create Procedure [dbo] . [InsertInstanceState] @uidInstanceID uniqueidentifier , @state image , @status int , @unlocked int , @blocked int , @info ntext , @ownerID uniqueidentifier = NULL, @ownedUntil datetime = NULL, @nextTimer datetime , @result int output , @currentOwnerID uniqueidentifier output Wha ...Show All

• Visual C# Reading from a client-side CAC

  I'm developing a web app and I'd like to be able to populate data in a web form from a client side CAC/Smart card. I'm using .NET 2.0 and C# and I thought that there had been some improvement in how to do this since .NET 1.x, but I can't seem to find any documentation on how to do it in the new environment. Has anybody done this kind of thing in 2.0 and can you help me find documentation for it I'm no expert in CAC/Smart card but here's one scenario that I know it would work: If you want to enable your user to authenticate against your website using a Smart Card, read on, otherwise I'm sorry I can't help... Make your web application to accept an InfoCard as authentication method. The "Manage ...Show All

• Visual Studio Express Editions combo box

  Hi, I'm trying to use the SELECT DISTINCT Query in combo box in a form i've created by draging the table in data grid view......where do i put this query at..........is it somewhere in the edit column area Thanks I'm trying to get the values in my combo box to show only once instead of showing the same value 10 or 20 times. I know that i need to use the SELECT DISTINCT query, i've used this query before in Access 2003, i inserted the query into the row source. I have an Access database linked to my project. I have dragged a Table into my form using the dataview and now want to use a combo box with one of the fields using the SELECT DISTINCT query to show values in that field only once. How and wh ...Show All

• Windows Forms Use of the deploymentProvider property in ClickOnce application manifest

  MSDN states that the deploymentProvider property is mandatory for updateable clickonce applications. I wonder why this is the case, as the codebase attribute of the deploymentProvider property always points to itself. eg, my deployment manifest is located at http://localhost/ClickOnce/test.application inside this file, I have the following tag: <deploymentProvider codebase="http://localhost/ClickOnce/test.application" /> If I generate the deployment manifest without the deploymentProvider property (and updateEnabled set), I get an error while launching the clickOnce application. This is indeed what could be expected when reading the documentation, but it is something I do not understand. Why is the property mandatory, even if it simp ...Show All

• SQL Server cannot create jobs on x64

  Hi all, Just installed sql 2005 x64 (DB Server + Client Tools incl. management tools) and encountered the following problems: 1) Could not create jobs Getting Error: Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent. JobObjectKey '. (Microsoft.SqlServer.Smo) Tried several different job types always same result Installing SP1 does not help Any help is highly appreciated TIA Dan Please post this to the " SQL Server Tools General " forum. Thanks, Peter Saddow ...Show All

• Visual C# Reflection - unloading assemblies !

  How can i unload an assembly from memory after reflecting on it I need to move the file. I'm loading the assembly using Assembly.LoadFrom(some_path). 10x Once an assembly is loaded in an AppDomain, it is there to stay until the AppDomain is unloaded. This article might be helpful... ...Show All

• Visual C# Security - normal practise? Please reply

  Hi, I'm building an app in C#. I won't bore you with the details, but basically I have two security questions. Any help would be much appreciated! 1. I will be saving files on a external server. I would like to encrypt the files before sending them. Different 'users' will be using this app. What are the best practices regarding C# to encrypt files Public/Private key encryption Where would I store the keys...in the registry I'm well versed with regards the cryptography in theory, but do not have much experience in practise. What API's....where Etc, etc...Any ideas .. 2. The application be will be using a third-party service, which requires a username/password. I suppose this username and password will be kept on a database somewh ...Show All

• Visual C++ Program database manager mismatch

  I have been working with vc++ express for about a month, and all my projects were fine but now whenever I compile anythingi get the following error: fatal error C1902: Program database manager mismatch; please check your installation I searched for a solution on Google and MSDN but neither showed anything i could make sense of. I just spent 4 hours with the most bizarre problem. I have VS 2005 Pro installed, & it's been working fine for over a year. Suddenly this evening I started getting C1902 errors, for everything I built. Nothing worked! I searched forum after forum, and then found this post here mentioning running dumpbin. Well, I had just done that, and started suspecting it. Other posts ...Show All

• Visual Studio Retrieving Project's $(OutDir) from an VS Automation Macro

  Hi, I'm writing a VB Macro for automating the build process of a VS solution. From that macro, how do I retrieve the value of the $(OutDir) property for a C# project, as it is referenced from the Pre-Build and Post-Build events Also, I need the output directory value for a Setup project. Thanks! The following code retrieves $(OutDir) for current configuration (debug/release) of C# project. The prj variable points to desired project. For example: Dim prj As EnvDTE.Project prj = DTE.ActiveDocument.ProjectItem.ContainingProject Then the code is: Dim path As String path = prj.ConfigurationManager.ActiveConfiguration.Properties.Item("OutputPath").Value If you want the values for other configura ...Show All