Mark Benningfield's Q&A profile

• SQL Server is SSIS wonderful?

  Hi guys, I'm using sql 2000 now but eventually will upgrade existing server to sql 2005. currently we only have OLTP dbs. I would like to set up data warehouse & OLAP functionality to drive reporting from the system, is SSIS the product I need can you please give me the suggestions regards I like being disagreed with on technical stuff - by defending my ideas on importing others we all improve. OLE DB Command - row by row is way too slow - in a perfect world you would have something like UPDATE mytable FROM ... translated to SSIS. Also - i forgot in me previous post - I found a nugget today in Microsoft SQL language - DELETE FROM x FROM x x ... ...Show All

• Visual C++ How to open TreeCtrl item via Enter key?

  Hi, I need to open a CTreeCtrl Item via Enter key. When searched MSDN i have seen TVN_KEYDOWN notificatoin available to achieve this! But does this tells about Enter key to the parent window And also i need to track the treeview items via typing their name..could anyone direct me how to achive this with CTreeCtrl & CTreeView Thanks in Advance, Rjn Try to intercept control`s window (GetWindowLong(GWL_WNDPROC)/SetwindowLong(GWL_WNDPROC)) procedure and process WM_CHAR and WM_KEYDOWN messages. ___________________________________________________ Best regards, Alexander Stoyan    E-mail: alexander.stoyan@gmail.com    MSN: alexander.stoyan@gmail.com    ICQ: 295663150 ...Show All

• Visual Studio 2008 (Pre-release) HierarchicalDataTemplate and pack://application => Doesn't work ?

  Hi everybody, Using the June CTP of WinFX, I'm trying to customize a Treeview so I decided, for the ItemTemplate, to use a HierarchicalDataTemplate. I'm an image Folder.ico (build as a Resources) in my project, located in a folder called Resources. Here is my code: < HierarchicalDataTemplate x:Key = " TreeviewListLibrariesItemsTemplate " > < StackPanel Orientation = " Horizontal " > < Image Source = " pack://application:,,,/Resources/Folder.ico " VerticalAlignment = " Center " /> < TextBlock Text = " {Binding} " VerticalAlignment = " Center " /> </ StackPanel > </ HierarchicalDataTemplate >   It works fine for the text but I get an exception for the ima ...Show All

• Visual Studio Tools for Office Command bar in Outlook

  Hi, I am trying to create a command bar in Outlook 2003 (VSTO, C#) that would look similar to task pane. Command bar should be docked to the right, with a specified width and when placed there the buttons shouldn't be rotated (if I create a simple command bar with a button and dock it to the right side, the button is rotated). Is there a way to accomplish this Thanks in advance. Hello Peter I think your question is more specific to the Office OM/API. Please take a look at this post for information on other MSDN forums & newsgroups that might be better suited for this question. Mike ...Show All

• Visual C# Problem with File.Copy() - Skipping files?

  I have an application that I want to use for copying files. My goal is to copy a files, if a file is in use or not accessible because of security reasons I want to make note of that file then continue with the file copy process. For some reason when my app is copying the C:\Windows\System32\Config folder it will fail on the first non-accessible file then ends the copy process. It only seems to happen on this folder (folder contains registry and eventvwr files, thus they are in use). Can someone give me some help here, I am at a lost. This chuck of code runs in a BackgroundWorker thread. [code] private void FileCopy( string srcdir, string destdir, bool recursive, ref DoWorkEventArgs e) { Directo ...Show All

• SQL Server Implementing "preconditions"

  I have about a half-dozen insertion tasks that depend on a condition: SQLServerProcessDate == OLEDBprocessDate. If the task executes early, old data gets inserted and needs to be backed out later on. (This happens about two-three times a month.) The jobs start at 8:00 PM, but on occasion processing runs late. In order to make the task intelligent enough to not insert old data, I've thought of a couple options: 1.) Separate scheduled job runs continuously, comparing process dates. When the dates match, it sends a message to the other jobs. Pro: less repetitive. Con: another scheduled job ! I'll have to learn the message queue task; a little bit complex; flood of database activity on message reception may slow system down 2.) Compare the dat ...Show All

• Smart Device Development Open a file with it's default program ? like jpg ?

  Hello .. Please i want to know how to open a file with it's default program like opening a jpg file or mpg file or any thing .. because "process.start" is for exe files only .. and the default program for mpg ( for examble ) is different from device to device .. So , how can i do it regards,, That would only work if you use ShellExecute option (System.Diagnostics.ProcessStartInfo.UseShellExecute is set to true). In that case shell would launch application associated with extension. ...Show All

• .NET Development Add new record

  I learned how to edit a record, but now how do you add a new record Dim workRow As DataRow = workTable.NewRow() what is a datatable this is my hang up for now Davids Learning OK, I'll answer one question with a code example and then add some additional comments. A datatable is a type used in .NET to allow tabular data to be stored. If you familar with a database, then a datatable is a type that can be used to represent a table from a relational database. As its not a table in a database but a datatype that can be used to represent this data - it can also be created and used independently of any database to allow collections of tabular data to be used in you application. An example of cre ...Show All

• Smart Device Development Strange Serial Port Exception

  Hi, I am developing an RFID reader project, using VS2005 C#.NET on pocket pc emulator. My RFID reader device is connected on serial port of my computer. I can not send or receive data to the serial port. there is an IOException or WriteTimeOutException. Here is my code. //I created an object serialPort1 of the class System.IO.Ports.SerialPort with the SerialPort control using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace DeviceApplicationTest { public partial class Form1 : Form { public Form1() { InitializeComponent(); try { ser ...Show All

• Microsoft ISV Community Center Forums Insert Macro

  Hello, I want to write a macro where on inserting a new row in the active worksheet, the newly inserted row will become yellow in color. But I dont know how to do this. kindly help Thanks Hi In order to run your macro it needs to be triggered by an event. I don't think that there is an event generated by inserting a row. ...Show All

• Smart Device Development "Error: Cannot establish a connection. Be sure the device is physically connected to the development computer."

  Hi ..I was building a .net project by using vs2003 smoothly..I could deploy the solution on my Datalogic smart-device ; everything (including active-sync ) was perfect.. But 2 days ago, took the smart device away from the craddle while the project was still deploying. Since that time, I can't deploy my project on the smart device..I have tried installing windowsCeAddOnv1.1, installing ports.reg, deleting desktop crypt; uninstalling activeSync, and also reinstalled the vs2003. I still cannot deploy the solution on the smart device ; although I can connect to the device by active-Sync.. Please help immediately..I'm 2 days behind my schedule already... ************ I discovered that the problem must be about the smart device.. Because tri ...Show All

• Visual Studio msdn library won't install

  I have Visual C++ .NET 2003 Standard Edition. When I install the library in hangs on disc 2 every time(I let in run for 2 hours). I tried transfer the files from the cd on to the local drive and the computer crashes. The softare came with a box set I purchased some time ago. Can anybody help me solve the problem, who to email, or where to download I would greatly be apprecited. Thanks. Edit: The CD is 2003JAN. With a folder 1033 inside. I understand there are different ones. Also the crash is actually a blue screen.    I can drag both CD1 and CD3 to the hard drive with no problem. Its only the CD2 that causes the issues. If I drag it.. there is a blue screen. If I try to install its stops m ...Show All

• Visual Studio Express Editions How to get another websites IP address in Visual Basic

  Hi there, I am currently working on a HOST File editor project in Visual Basic, where the user has to enter the word they want mapped to a certain IP address of a website. However, as many users won't know what an IP address is, nor how to get it, I was wondering if there is any way to retrieve the IP address of a website. I'm guessing it will involve using Domain Name servers right Any help will be much appreciated, RichardHarley I would think something like: Dim hostInfo As IPHostEntry = Dns.GetHostByName(hostString) Console.WriteLine(( "Host name : " + hostInfo.HostName)) Console.WriteLine( "IP address List : " ) Dim index As Integer F ...Show All

• .NET Development Sql Connection String Error

  hi all , i have a problem when i am trying to connect to the data base via Network or via Web. this is my connection string : static private string GetConnectionString() { return "Data Source=10.0.0.25\\SQLEXPRESS\\Databases\\FWR.MDF;Integrated Security=True;User Instance=True"; } and i recive this error exption : (An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). i want to know how to solve this error. Best Regards Ahmed EL Gendy ...Show All

• Architecture Active Directory , Exporting xml as users

  We have an application that churns out xml a collection of user details and credentials.We have decided to have a central repositry as Active directory.I want to test it using windows xp without a windows 2000 or 2003 server.Is it possible , if so, How Hi, Sorry for not responding as i away from work.Ok right now we are on to the stage of deciding the schema.Schema would contain custom information like data related to healthcare information.Im really confused as of now.Could you please help me in understanding how i can treat ADAM as a repository for storing custom/personal data related to an user. The Adam schema is sooo confusing.One thing i can understand is about creating Containers and objects ...Show All