rhansen's Q&A profile

• Visual Basic Generating A Unique Number Using Date and Time

  I'm trying to create a function that will generate a unique number based on the date and time a record is saved to a SQL Server database. I would like to get the number in the following format: yymmddhhss (i.e. year/month/day/hour/sec). Anybody know how I might go about creating this function Thanks in advance for any help! Tony Wont this give you the time from the client. Not the time on the server. So if the two are the same machine no problems - but if the two are different then they may not be the same, and if you have multiple users accessing the database then the times on the clients may be out of whack (of local time in timezones) and therefore you would run into even more problems. The time on the server would be ...Show All

• Windows Forms Speeding up background image

  I am using c# & .NET to try to make my version of the classic snake game, where the snake eats things and gets longer. I am using the GDI to do everything. My problem is that when I added a background image for a textured background instead of just using a solid background color, it slowed everything down a lot. I have tried putting the image in this.BackgroundImage, I have tried embedding the image instead of loading the file (which didn't help), and I have tried drawing the image from the OnPaint handler (which sped it up a little, but not nearly enough). I have also tried using bmp files instead of compressed jpg's and that didn't make any difference. Is there any way to have a background image without slowing things down this much, ...Show All

• Visual Basic Change the 'Selected' Day in the 'MonthCalendar' object

  Hi - I'm after a way to alter the 'selected' day (and value) of a monthcalendar object. For example, have a MonthCalendar object on your form and below have a NumericTexbox that alters the 'selected' day and value on the calendar. Cheers, Nathan. I believe you can get or set the start date or end date. Lets take the start date property, selectionStart. you basically create a datetime object giving it the new values such as year, month or day. So say if we had a numerictextbox and it was to set the month. We simple create a new datetime object and get the current year and day chosen and alter the month to the numbertextbox: Me.theMonthCalander.SelectionStart = new DateTime(Me.theMonthCaland ...Show All

• SQL Server If all values of dropdown parameter are selected - show ALL in report header

  Hi, I have dropdown parameter with multi-values allowed. In my report headed I want to show all the dropdown values that were checked by the user to run the report. But since there could be a couple of hundred values I want to show ALL when all the values are selected instead of listing them one by one. How can I do that Thanks, Igor Igor, I recently had a similiar problem. While I'm sure that there is a more elegant solution, this seemed to work for me: In the textbox where you are displaying the selected parameters you can write an expression that compares the selected item count from the parameter dropdown to the total count of the dropdowns data source. For example, if you have a multi val ...Show All

• Smart Device Development Startup Registry in PPC

  I assume this exists, similar to that of the desktop. Where do I put a registry entry so an application will run on startup Thanks! This is what i found at pocketpcdn Run after soft reset Place a shortcut to your application into \Windows\AutoStart folder and this application will be run every time just after the shell is started. Plase note that this folder is language depended. So you should use use SHGetSpecialFolderPath function with CSIDL_STARTUP parameter to get actual folder name on the device. Here is a sample code: CString strProgramPath = _T("\"\\MyApp.exe\""); TCHAR szStartupFolderPath[MAX_PATH]; ::SHGetSpecialFolderPath(NULL, szStartupFolderPath, CSIDL_STARTUP, FALSE); CString strLinkPat ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpaceWar demo: .NET Runtime 2.0 Error

  I'm having a bit of trouble getting the SpaceWar demo to run. It compiles fine (I made no changes) but when I try and run it I immediately get a dialog box asking if i want to send a report to Microsoft (I always say 'Yes'). Below is a copy of the Event Log entries generated: Event Type: Error Event Source: .NET Runtime 2.0 Error Reporting Event Category: None Event ID: 1000 Date: 8/30/2006 Time: 7:41:21 PM User: N/A Computer: IO Description: Faulting application myspacewar1.exe, version 1.0.0.0, stamp 44f5d7e7, faulting module kernel32.dll, version 5.1.2600.2945, stamp 44ab9a84, debug 0, fault address 0x00012a5b. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Data: 0000: 41 00 70 00 ...Show All

• Commerce Server About OrderGroup

  Hi Guys I am directly working with Basket object that is, adding forms into the basket and adding lineitems into the forms and saving it. its working fine .. But now i want to create a wish list(Favorite List) and order template, According to some blogs, OrderGroup is used as a template and wishlist and later that can be converted to basket and purchaseorder. How to create an basket from the OrderGroup . it will be very helpful for me.. But there is no option in OrderGroup class to save as basket.. What is the next step to proceed.. and alos what is core differcence between OrderGroup and Basket . then how the basket was diffrencted from the OrderGroup.. Please provide any link to study about more... Hi Joe shall we ...Show All

• SQL Server FTP Task - Delete Remote files Issue

  We are Downloading files from FTP Site using "FTP Task" and we need to remove those files after downloading. We need to delete files of specific names, like "Names_*.TXT" (All the txt files and Names starting from "Names_") so We are using Delete Remote Files and Remote path we are specifying as "/Names_*.TXT" This doesn't work its not able to delete the files so, We tried using "*.*" and also given the specific filename like "Names_A1.TXT" then also its not deleting the remote files. Please let me know the solution. Thanks, Priaynk Gajera This problem is specifically with the Unix servers only. The ftp task(File Delete) works fine with Windows FTP Server but ...Show All

• Visual Studio Team System How to implement continuous integration using TFS Server?

  Hello, I need to implement continuous integration using TFS Server and TFS Build. How to utilize TFS Build to implement CI in your company Do you have any experiences how to do this Thanks! cyberjoe Hi, take a look at this post where they talk about some solutions http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=942481&SiteID=1 ...Show All

• .NET Development programmatic access to sqldatasource dataset

  i'd like to take advantage of all the benefits of the new sqldatasource control to do quick queries & bindings, but also retain the flexibility of the previous ways of data access (i.e. sqlcommands/sqldataadapters) to fill datasets. is there a way to have programmatic access to the dataset that is filled after a sqldatasource queries a db i dont want to display all the columns queried in my gridview, but i want that data available for further manipulation without having to run another query. am i going about this the wrong way, or have i just not stumbled upon the solution thanks, david thanks for the suggestion. ive looked at it for a couple of days now but have not been able to come up with a ...Show All

• Visual Basic Run-time error '3137' Missing Semicolon at end of SQL statement - What's Wrong?

  Hello, First, I realize I am dealing with an unnormalized database. Here is the code generating the run-time error of a missing semicolon. I am trying to run this code as an event procedure in Access. The Debug.Print shows the translation I want. What's wrong with the code or my thinking Any help will be greatly appreciated. Dim dbAny As DAO.Database Set dbAny = CurrentDb() Const cQuote = """" Dim strSQL As String strSQL = "INSERT INTO [DatesofService] (CustLN, CustFN, CustDOB) " & _ "VALUES ('" & Me!CustLN & "', '" & Me!CustFN & "', #" & Me!CustDOB & "#) " & _ "SELECT CustLN, CustFN, CustDOB FROM [Custome ...Show All

• Windows Forms SignTool error - Certificate is not valid for signing 0x80880253

  We got this error the other day when trying to publish. After some searching I came across the Certificate for signing ClickOnce manifests. It has an expiration date of 10/06/2006. So we thought we could just create a new test certificate and then publish. This got us past the error but then the next day a user brought over a detail report. System.deployment.application.deploymentexception -the deployment identity does not match the subscription This is a VB 2005 app that gets publish to a network share so I don't know if I need all this signing security. But I eneded up having to set my machines clock back prior to Oct 6, roll back to a earlier version and then rebuilding the project and redeploying Otherwise I'd have to do a unisnt ...Show All

• SQL Server How to Add an event to CRI controls

  Hi all, I am trying to develop a CustomReportItem similar to Matrix control. Is it possible to add some "OnClick" sort of events to a section of this CRI (As a drilldown button of matrix control allows to expand the respective column). Please help me if there can be any solution. Hi Robert, Thanks for ur response I am asking it for runtime. How can I encode the toggle state in parameter values and how will it help to solve my problem Please explain, as I am new to this tool. ...Show All

• Windows Forms Try catch standards

  Hi friends.. In a single button click, I am calling two services which will return two different exceptions. for this i need to implement the 'Try Catch block". do i have to implement two try blocks for each service calls and two catch blocks for handling those exception or i have to implement a single try block for both the service calls and two catch blocks for handling the two different exceptions Is there any difference between this approches.. which is the standard one Thanks in advance, Ram Babu since my calls are chain actions.. i have to ultimately follow single try and multi catch approach. thanks for ur valuable reply Ram Babu ...Show All

• Visual Studio Express Editions From *.vb to *.exe, how?

  I have tried to search google and the forums here on how to make your program an exe but to no avail. I have the 2005 Express version and would like to make my test program into a .exe that I can install. Any assistance on this or how to do it I would apreciate :) No 3rd party required to compile application, VB will build you an executable. Something to consider is that although it generates an EXE file - you cannot just copy and run this necessarily as it has a dependency upon the .net framework being installed. You should look at the Publish option which would create you a setup which will install any requirements such as the .net framework on a machine if its not already on there, A good little ...Show All