Chuck S.'s Q&A profile

• SQL Server Flat File with Nested Data

  I am looking to import data into SQL Server 2005 using SSIS. I want to take data that is contained in a flat file and place it into the various appropriate tables in my system. The flat file contains nested data. For example... Bob,Smith,555-5555,123~3.33|245~1.99,Active So I want to build a package that brings in the records as follows Client Table: First Name, Last Name, Phone, and Status (Bob, Smith, 555-5555, Active) Order Table: OrderID, Amount (ID 123 @ $3.33 and another row ID 245 @ $1.99). If possible I would also like to tie the orders to the client record that was inserted. My first question is if SSIS supports nested fields as in my example. Can it break a file by commas, then within a field by other delimiters I ...Show All

• Internet Explorer Development IE generating a lot of data traffic

  I am web-developer and wondering how to solve this problem. If I look for data-traffic on my site it was a lot more than expected. My webpages have some javascript and r.a.d. controls, I run in debug=false. I noticed that whenever someone uses the "open in new window" functionality, a *lot* of data is passing the line. As if the cache is not working at all. Doing some researh I found that most sites on the internet are suffering from this behaviour. To give you an example. Go to www.asp.net doing some search in some forum. See the big difference in clicking on a link and right-click on the link and choose "open in new window". As if all pictures/scripts/resource files are loaded AGAIN. Doing the same with FireF ...Show All

• Visual Studio Add Resources using EnvDTE in VS 2005

  Hi, I am using EnvDTE to generate a project from templates. What I would like to do is, in my Wizard, I give the user the option of selecting an Icon file. I can programmatically add this icon file to my Project. But I cannot add it to the Resx file as a resource. If I add a token "placeholder" for it in my csproj file, it does not find the file since my token replacements occur on RunStarted() whereas I add the file programmatically only on RunFinished(). Any assistance would be greatly appreciated! Regards I am strugling to find the appropriate interfaces to access the resouces of a project. I can access the project properties : Project project = document.ProjectItem.Containing ...Show All

• Visual C# using array lists

  I need an array like variable type that will automatically resize based on how many numbers are in it. After consulting my c# book, it seemed like an arraylist would be my best bet. After creating my array list, and adding some numbers to it, I realized that I had no idea how to read numbers from it. I thought it would be like reading numbers from a normal array, but this gave an error saying that I was trying to convert an object into an integer. heres what I tried (sorry the code is pretty crazy) for (int counter = 0; counter < gcGalaxSetup.gInSystem.Count ; counter++) { Matrix kartMatrix = Matrix.Translation(gcGalaxSetup.gShip[gcGalaxSetup.gInSystem[counter]].Position); ... gInSystem is my arraylist (or rather it re ...Show All

• Visual C++ I want to use ping to detect if the internet connection is connected or not , need a good sample program

  I want to use ping to detect if the internet connection is connected or not , I need a good sample program .please give me a good sample program to do this. I appreciate your help. Hello Re: I want to use ping to detect if the internet connection is connected or not , need a good sample program Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• Windows Forms User control with Events

  I have to develop an user control that should generate specific events (with data). Does somebody know where to find an example or guideline for this Thanks in advance. The following assumes you're using C# and .NET 2.0 (Visual Studio 2005) If you want to include data and the EventArgs class doesn't suit you needs, you'll have to create a new EventArgs-derived class. E.G: public class MyEventArgs : EventArgs { private object data; public MyEventArgs(object data) { this.data = data; } public Object Data { get { return this.data; } } } You can now use the event keyword in C# to create an event in the class that can raise the event. e.g.: public event EventHandler<MyEventArgs> MyE ...Show All

• Visual C# Edit a string?

  I would like to edit a string but I am having a little bit of trouble doing it. For example: string Mystring = "test\r\n"; I would like the string just to read "test". how can i cut the last 4 chars off Wes Payne wrote: Then Brendan Grant's suggestion is probably the best one. That way, trailing (and leading) whitespace characters, which can lead to unsightly boxes, will always get removed no matter how long the string you want to keep is. Hopefully, that's the worst you have to deal with. If there are other, special characters creeping in and leaving unsightly boxes, then sterner measures would be required. No I am only gathering the data from a stream and then posting it in a listbox control. So th ...Show All

• Community Chat taskbar color

  alright i've been searching around for a while and still havent found much. does anyone know a way to change the color of the taskbar to some color that isn't XP set, like black iv read up on this and there were 2 solutions, 1,third party software;2,"hack". Well considering that there is 3rd party software, there should be a way to change it programmaticly. so does anyone know how or at least what programming language this can be done in well im guessing your talking to me, clinto. and well i assume that there's a file that holds the windows blue,silver, and olive themes. If it were possible to find it and "hack" it, i think it can work. the problem is finding it, and even if its possib ...Show All

• SQL Server Is there a way to have numbers listed against each rows

  I want to return numbers 1,2,3... for each row  in my reports when its returned e.g I want my report to have numbers listed against each row 1. boy 2. cat I looked at the Globals but i can't see anything to use.. Any ideas Sure it must be easy.. Thanks in Advance Lets say your query looks like this: "select grp.Name, det.value from groups grp left join details det on ..." you get result: Cat, 1 Cat, 2 Cat, 3 Bump, 1 Dog, 1 Dog, 2 Dog, 3 Egg, 1 Egg, 2   Your report definition is:   (grpName) Lp, Name (details) Value   in "Lp" definition you should have: =RunningValue(Fields!Name.Value, countdistinct , no ...Show All

• Visual Studio Building a simple EXE that can run on any 2000 or XP machine

  Can someone point me in the right direction. Basically all I want is an exe of a form that displays the username. I need to be able to execute this exe from a logon script on any of our 2000 or XP machines. I've pretty much figured out how to create the form in C#, but when I try to run the exe on other machines I get errors. I'm guessing it's because maybe they don't have the latest .NET framework installed. My question is, should I be doing this some other way like using C++, or some other feature in VS2005 I can't imagine needing the .NET framework for such a simple thing. Any suggestions are welcomed even if it's something like "Go out and by this particular book newbie" :) This is not an ans ...Show All

• Visual Studio Express Editions write to excel using C#

  hello, i'am doing a tutorial i found on the microsoft website where i'm simply suppose to write a couple of values into a table in excel. well my program builds fine but i have run through a couple of exceptions that i'am having a hard time fixing. here is the script: using System.Data.Common; using System.Text; using System.Reflection; namespace myApp { /// <summary> /// Summary description for Class1. /// </summary> class Class1 { static void Main( string [] args) { object path = "C:\\Documents and Settings\\LKaba\\Desktop\\"; System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection( "Provider=Microsoft.Jet.OLED ...Show All

• SQL Server Generate Multiple Tables from Column data

  I have a large table with 30000+ rows.  Most of the rows can be group by Column 1. Say you had 10000 people and numbers 1 through 3.  Every person would be linked to 1, 2 & 3.  hence 30000 rows. What i need to do is create a table for each number.  i.e.  Table 1 where column 1 is 1 (then it lists 10000 rows)  Table 2 where column 1 is 2 (another 10000 rows)  and so on.  I need to create just under 300 tables. Is there a quicker way of doing that than this 300 times I'll try and put it into an example of what i'm looking for Original table Column 1              Column 2     &nbs ...Show All

• Visual C# Closing files (without saving) is slow

  I've seen other posts about the VS 2005 C# IDE being slow for typing or when saving files, but for me both of these cases are ok. But *everytime* I close a file (whether or not it needs saving), it takes several seconds. If I open up the "Windows" dialog to close several windows, it can take minutes. I've tried the obvious like defragmenting the HD, not having too many files open at once -- doesn't matter. Any suggestions Thanks! The .suo file was up to 850 KB. I deleted it, and when it was re-created it was about 380KB. Deleting it does seem to have resolved the problem. I don't know if it will grow back to 850 kb over time and cause the same kind of issues again, but only time will tell.... ...Show All

• Visual Studio Team System Just to clarify TeamSystem license - TFS

  I have been reading a lot of different information about TFS x TeamSystem license model, concerning Cals etc One thing I am almost sure is when we sign for MSDN Premium TeamSystem (whether Suite, Dev, Tester or Arch), we do have rights for 5 CALs to access TFS. Another issue has to do with using this package after expiration. I have posted previously about the possibility of signing for MSDN Premium TeamSystetm Suite, and when renewing, choosing a lower package (tester for instance). In this case, I would not receive any other new features on the other versions (in this case Dev and Arch), but I would be fully license covered to continue using the whole package I had up to that moment. Could anyone from Microsoft confirm this 2 in ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Many Questions that I would like to know about XNA

  Hello, I plan on downloading XNA Gamestudio (not the proffesional one) to my computer but before I do I have a couple questions. 1- I am completely 100% new at game making, is XNA right for newbies at game-making 2- Am I able to create any genre of game on XNA I want to create a FP or TP shooter and perhaps racing game... 3- With XNA are you able to create your own animations and graphics with the program or do you have to use a seperate program for that 4- Is there any possibility of making cutscenes during the game This may sound crazy I don't really know. 5- Is it difficult for a game maker who is expirienced to make a game with up to date graphics. How long (I'm sure it varies) does it take to ma ...Show All