gary ggerberdom's Q&A profile

• SQL Server raw file destination and environment variables

  when using a raw file destination it would be nice to be able to use an environment variable for the filename property. like %my_extract%\data.txt instead of c:\my_extract\data.txt You could use the script task to define a SSIS variable, storing the file name, built using the environment variable. Then you can use this variable in Raw adapters by using the File Name from Variable access mode ...Show All

• Visual Studio Express Editions Flat File Database?

  Hey! Is it possible to save data to a flat file and then retrieve it again later just a simple flat file database... or maybe data.dat file what ever a dat file is lol ty all -mark You an save data where-ever you like. If you'd like a flat file, XML is probably the best way to go, for ease of searching, etc. The XML Document class will load and save XML documents for you, as well as exposing ...Show All

• Software Development for Windows Vista WWF or Skelta

  I need to design a workflow application. If we set aside the fact that the WWF is still in beta phase, what would you recommend ; skelta or WWF. I think that WWF misses some features like email etc but has a strong support. Skelta makes the work very tedious like mentioning the workflow variables in different xml's, using its own libraries to access database etc. Please give recommendations with reasons in support Thanks in adv ...Show All

• Visual Basic navigate through records one at a time displaying info from multiple tables vb.net 2005

  Hi, I need to create a Windows Form that displays the fields from multiple linked tables and allows the user to navigate through the records. Basically, I would like to create the functionality of the bindingnavigator programmatically (no drag-and-drop because I must use the Enterprise Library Data Access Block). I have created a dataset with the group of records I would like to display, but am not sure how get the bindingnavigator to work to ...Show All

• Windows Forms Redraw perf problems with custom controls

  When making large controls that can draw quite a lot of data at once (when scrolling up and down) is it best to move over to DirectX because come of my clients are getting out of memory errors when they do large searches (see the link for a screen shot of the control). I can’t see t being a problem with my code as i have gone through the entire thing tweaking it, as far as I can tell its when the users scroll up and down a lot. This causes t ...Show All

• SQL Server Proglem creating index

  I am having a problem creating an index. When I check the table for dupes I don't find any. When I try to create the key I get an error that there are duplicated values. I think that this may be because the key is too long I don't see any other reason. The data looks OK. Each client should only have one record for a date (the 1st of the month) and a paysource. create unique index UniqueArId on AR(CLIENTID, [DATE], PaysourceUUID) Server: Msg 1 ...Show All

• .NET Development block connections

  I was wondering if there is a way to scan all the connections and block certain IP addys. Ive seen one program that does this in C#. Ive tried messing with socket and a tcplistner and i couldnt get it to work. I would love any advice u guys have to share. Are you looking for something like this   using System; using System.Collections.Generic; using System.Text; using System.Net; u ...Show All

• Visual C# How can I solve,Metadata file couldn't b found error?

  We have a solution with 44 projects in it, the solution was developed using .NET2003 and we tried to convert it to VS2005, however when I compile the converted solution I get so much error, I have classified the errors in to 3 categories. 1. Metadata file 'C:\somepath\some.dll' could not be found Error 121 Metadata file 'C:\DM2005\Somenamespacename.DataServices.Generic\bin\Debug\Somenamespacename.DataServices.Gener ...Show All

• Windows Forms Is it possible to specify the window state of an MDI child without impacting the other MDI children?

  Hi, The normal behaviour of the MDI children windows is that when a new child window is opened, it opens with the window state specified in the child code( maximized, minimized or normal ). But, when this window is opened , it also changes the the window state of other open MDI child windows to the new window state despite the current state of the already existing child window. Is there any way by which we can open the new child window without i ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mesh modeling tool

  Hi, I'm looking for a mesh modeling tool. I'm beginner in DX programming so I don't need a tool with thousand of functionnalities for the moment. A free or low cost modeling tool would be great ... Thanks, Steve I can vouch for Milkshape 3D, I've been using it for my personal projects for a couple years now.  It also comes with a couple of .x file exporters.  Theres a trial available and a license will ...Show All

• SQL Server SQL Server Mobile tutorial and getting proper mobile DB installation

  Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem. I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information. I've gotten almost all the way through... successful ...Show All

• Visual FoxPro COPY TO CommandHi Cetin,

  In Visual Foxpro, I am trying to create a CSV file using the COPY TO command with TYPE CSV, but do not want header fields on top of the output file. Furthermore, I am also trying to attach a COMMA after every row. Current Output f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17 "0","49162","0","0","0","0","0","0","0","0", ...Show All

• .NET Development System.Web.Mail Help Please...

  Hello, I've tried searching and searching, but I've had no real luck. I'm working on sending an email via an external SMTP server (I'm trying to use Gmail.com, could this be a problem ) and then send to another email, which also happens to be a Gmail.com address. Now, before posting my code, I'd like to say, what I'm developing this for is basically a plugin for a program based on .NET 1.1, so I don't believe that System.Net.SmtpClient ...Show All

• .NET Development When to call dispose when using SqlConnection and SqlCommand?

     What is the best practice when running code as follows: //### code start #### SqlConnection conn = new SqlConnection("xxxx"); SqlCommand cmd = conn.CreateCommand(); //...do the necessary processing cmd.Dispose(); conn.Close(); conn.Dispose(); //### code end #### calling Dispose on the cmd and the connection seems redundant.  Additionally, if I am disposing hte connection should I first explicitly call Close()   The sh ...Show All

• .NET Development SqlAdapter in VB .net beta

  I am new to vb .net; I am trying to follow the msdn technical article "Building an N-Tier Application in .NET" http://msdn.microsoft.com/library/default.asp url=/library/en-us/dndotnet/html/buildntierapp.asp .. and when trying to .... 7. In the design view, click and drag a SqlDataAdapter control from the Data tab of the toolbox onto the design surface of this component. I am unable to locate any SqlDataAdapter component in the toolbox..... I ...Show All