Susan Still's Q&A profile

• Visual C# Noob: What would be the best way to create an unattended batch process?

  I've been tasked to do a program (C# VS-2003) that reads data from ASCII files and uploads them to SQL Server 2000. I created a WinForm as a demo, where I can select an ASCII file from a folder, process it and upload to SQL Server. There will be different files in the incoming folder of slightly different types, intended for different SQL-Tables. Job was acomplished and works fine. Now I have to get rid of the visual interface (WinForm) as this will be run daily from a scheduler (logging errors to a file as it wil lrun unattended), As a newbie to .Net I'm unsure on what would be the best practise here. Should I create it as Console app ...Show All

• Visual Basic Null Binary Field

  I have a photo field (image) in MSDE. Some records have photos, others have null. If it is null, I want to exit sub. If IsNothing(dtTry.Rows(lstPhotos.SelectedIndex)("photo")) Then Exit Sub But the problem is that the above VB 2003 code always returns False even for records with photo being null . How can I modify it to return True for records with null photo AtinLango wrote: I have a photo field (image) in MSDE. Some records have photos, others have null. If it is null, I want to exit sub. If IsNothing(dtTry.Rows(lstPhotos.SelectedIndex)("photo")) Then Exit Sub But the proble ...Show All

• SQL Server Calculations in a subcube world

  I'm having trouble getting my calculations to work with query tools that use subcubes in the WHERE clause instead of a normal slicer. Both Excel 2007 and SSRS (when using the query designer) use this technique. This is an example of a calculation: CREATE MEMBER CURRENTCUBE .[MEASURES].[YTD] AS SUM ( PERIODSTODATE ([Time].[Y-Q-M-D].[Year], [Time].[Y-Q-M-D]. CurrentMember ), [Measures]. CurrentMember ), FORMAT_STRING = "#,#" , VISIBLE = 1; A typical query through Excel 12 will use the following MDX to filter when selecting March 2006 from a time hierarchy: .. FROM ( SELECT ({[Time].[Y-Q-M-D].[Quart ...Show All

• .NET Development Updating Data Via Web Service

  I have a database on SQL Server that contains a table called USERPROFILE. I also have a web service that has a method called UpdateUserProfile. The web method may update only parts of the user profile at a time, and not necessarily all of it. How should I go about doing this 1- UpdateUserProfile calls a data layer method which returns a UserProfile object populated with data from the USERPROFILE table. UpdateUserProfile then updates only the necessary data and then writes the object back to the database using a different method in the data layer. 2- The whole process should be managed by the data layer. (How ) 3- The whole process should be ...Show All

• Visual C++ converting float to string and string to float

  I know this is getting kinda repetitive but...how would I convert a float to a string and also a string to a float..Thanks a lot..(Code samples would be awesome). A simple search on http://msdn2.microsoft.com will reveal that you can use atof -->  http://msdn2.microsoft.com/en-us/library/hc25t012 . It is really recommended that you check out the msdn documents and leave the forums for specific issues that you might face. Thanks,   Ayman Shoukry   VC++ Team ...Show All

• Visual C++ deallocating memory

  Hi! I've allocated a memory block to a object. So, when I destruct this object, I need to deallocate this block, right ! But, I've gotten a message error when I try to do this: Unhandled exception at 0x7c901230 in form_console.exe: User breakpoint. My code is below: //begin of teste.cpp #include "StdAfx.h" #include ".\teste.h" #using <mscorlib.dll> teste::teste( void ) { this ->array = ( char *) malloc (10 * sizeof ( char )); } teste::~teste( void ) { } void teste::funcao( void ) { this ->array = "123"; free( this ->array); } //end of teste.cpp //begin of teste.h #pragma once class teste ...Show All

• Visual Studio Team System Adding new Values to "state"

  We're looking at the "state" field in the Work Items. Currently there are: Active, Resolved and Closed. We would like to Add: On-Hold, Obstacle. Would there be any ramifications if I added: < STATE value = "On-Hold " /> < STATE value = "Obstacle " /> To the states node in the Workflow section to get these states Or would there be a better place to put these I added new states as well, and the primary additional task was having to change the queries and reports to take the appropriate action with the new states. For instance, you may want the "Blocked" ...Show All

• Visual C++ Beta 2005 Visual C++

  I tried writing a win32 console program which would take command line inputs.  When I try to display the command line values of argv I only see the frist letter. The line that I try to display the value is: printf("Program name: %s\n",argv[0]); the output is 't'. I am not sure what is wrong, this is a program that I have tested with 'C' and visual C++ 6.0 and it works fine. Thanks so much for posting this reply ... it solved a problem I've been having with VC++ 2005 Express Edition. -Keith ...Show All

• Visual Basic Get ANSI values for a char?

  Is there a way to return the ANSI value for a char or string   For example, is there a way to return 34 for " or 65 for A Thanks Dave there may be a simpler way, but this works - Dim bChar As Byte = System.Text.ASCIIEncoding.ASCII.GetBytes( "A" )(0) ...Show All

• Smart Device Development Expand Memory of PPC 2003 SE Emulators

  I have followed the instructions from the Device Emulator Manager help file to extend the memory of the image (PPC 2003 SE VGA) I'm trying to use, but to no avail.  Does anyone know if this is a limitation of the 2003 SE image, and if so, is there an alternative image with more memory (64 MB)   By the time you install SQL Mobile and CF 2, there's practically no room left on the emulator for your program (especially if it's a database app).  In the real world, I would install the application into the built-in storage (non-volatile) and I would still have plenty of room left in RAM for running program memory.  ...Show All

• Visual Studio Team System Can I customize the VSTS bug report?

  Hi all, I want to customize the VSTS bug report: Bug Rate, and Bugs by Priority. Currently, these two reports are based on daily data. And I want to create the corresponding reports by weekly data. Any approach to realize it Thanks, Leon Hello Leon, You can customize the reports and create a new methodology so new projects created with that methodology get those customized reports or you can customize a report in a project. This is how you would do it in a project: 1. In your application tier open http://localhost/Reports/Pages/Folder.aspx . 2. Click on the project with the report you want to customize. 3. Cli ...Show All

• Visual Basic Printing A Calendar Control On A WinForm

  Using vb2003 how do i do send a forms contents to the printer in this case a calendar control. The previous samples given appear to be using richtext controls i simply need the calendar sent to the printer (like printscreen basically) Thanks in advance. You can try the code on this site: http://weblogs.asp.net/mschiffer/archive/2004/07/13/181111.aspx ...Show All

• Visual Basic VB 2005 Compiler Optimization Discussion

    There's been something percolating in the back of my mind. I come from a computing environment that preceeded windows and the Intel Architecture and instruction set. n comparison to the instruction set that i'm used to, the Intell instruction set looks like a house wreck which may or may not be important to the discussion at hand. Everyone knows that moderators agree on everything and that in moderator space we just stand in love circles and sway back and forth. So when I was discussing a compiler one day, I said I really admired a language which had a seven pass compiler. "Nonsense", was the response, "two will do it." Wi ...Show All

• .NET Development How to use inherited classes in web method?

  I have two classes as below: public class BaseClass  {    public BaseClass()  {  }    public BaseClass(string name)   {    this._name = name;   }   private string _name = "BaseClass";   public string Name   {    get    {      return _name;    }    set    {      _name = value;    }   }     } public class InheritedClass : BaseClass {   public InheritedClass(string name)    : base(name)   {   ...Show All

• Visual Studio Express Editions Internet Explorer in C#

  Hello, First of all, I am very thankful for these forums and I am glad you guys are here to help! Anyway, I have Visual Studio 2005 Express C# Edition and I am working on a program and let me explain what I need to do. Okay, so I am working on this program. I was talking to the head manager on this and he said here is what we need. We need to have one text box and one button to load a website. Inside the text box the user will type the URL in. When the button is clicked on, it will load the URL from the text box. How can I do this Paul And what if I wanted to supply login credentials using a POST method Is that possible ...Show All