shimshon's Q&A profile

• SQL Server Drop Stored Procedure causing Dropped Tables

  Hey guys, has anyone ever seen this happen: Try to move stored proc from one DB to another using DTS, errors on create proc. Create proc manually. Three tables referenced by that stored proc have been dropped and re-created with the same table structure. I'm not 100% certain that it happened at exactly the same time, but it seems to be around the same time. Any ideas Anyone seen this happen before I don't know how the DTS task determines dependencies. If it uses say sp_depends SP then you can check by running the SP for your SP to see the dependencies. Note, that this SP only gives immediate dependencies. If this doesn't help find how DTS determines dependencies then ask in the SSIS forum or run your pac ...Show All

• Smart Device Development Deactivating Microsoft Voice Command recognition feature

  Hi, I'm designing the "perfect companion" for Microsoft Voice Command, but for this to work I need to find a way to temporarilly deactivate MVC's voice recognition and reenable it when I quit my program... In other words, I'd like MVC to stop listening to my voice commands when I hit the designated button... I've been looking EVERYWHERE in the registry <:-) ... doing file compares of "before and after state" of the registry with no luck...I just can't find the key that will tell MVC to stop listenning... Can you help me please Thx VoiceCommand is owned by the Windows Mobile team. Posting to one of their forums may get you the answer you looking for. Windows Mobile API : micr ...Show All

• Visual C# Dynamically accessing objects on a form

  I have 12 buttons placed on a form simplye named as button1, button2, ...,button12. I want to change their properties in a loop. Is there any means of possibilities that I might reach their properties in such manner or somewhat alike in a single loop for (i=1;i<=12;i++) { button+tostring(i).visible=false; } hi u can try to create an array of buttons button[] myBunttonArray = new button[]; for(int i = 0;i<myButtonArray.Length;i++) { myButtonArray = new button(); } and then address each button's pperties as u wish I tried it and it works regards ...Show All

• .NET Development facing the same prob

  I'm currently working on a application in VB.NET 2003, with a SQL Server backend. I was asked to make an import function that would allow a user to import an Excel worksheet into SQL Server. I'm aware you can do it from Excel directly to SQL Server, but the clients would like something that wouldn't involve the users of this application touching the SQL Server. I'm using an OLEDB for the Excel connection, and a ODBC connection for the SQL Server connection. Next, I have a button event that would open up a OpenFileDialog window, and a user can choose an Excel sheet. If the Excel sheet is valid, it would go on extracting the data into a dataset: ds = New DataSet ds.Clear() strSQL = "Select HEAT, Practice, C, Mn, P, S, Si, Cu, ...Show All

• Commerce Server Extending Orders System With Nullable Properties?

  I think I remember seeing that this wasn't possible, but just to confirm...are nullable types not supported in the Orders System like for custom strongly typed properties of inherited LineItem and OrderForm classes Can someone let me know or if they found a way around this (ie some way of allowing nulls to be persisted to storage for int values) it would be appreciated.. Thanks, Dave Dave, I wasn't aware of this limitation in CS2007 but I will check. Can you explain a little more about what you're trying to accomplish Jeff Lynch MVP Windows Server System - Commerce Server http://codebetter.com/blogs/jeff.lynch ...Show All

• Windows Forms PropertyGrid and ListBox

  Hi All Can someone show me an example of how to place a "ListBox" property within a PropertyGrid I am working on visual studio 2005.   srinivasa rao   To display any control other than a TextBox or the standard editor for a type, you should implement a UITypeEditor inherited class that performs the editing for you and then, you apply the Editor attribute to the object class that the PropertyGrid is to edit. To demonstrate this, suppose you have a class called Item. You want to edit certain objects of this class using a property grid control. The class Item contains two properties, ValueInt of type int and ValueString of type string. For the string value, you want the property grid to display a File selector so t ...Show All

• Windows Forms drawstring problem

  here is the my class // DataGrid  public public void PrintGrid(Graphics e)    {     Ypos = 150;    for ( int n = 0; n < this .DataGrid.Rows.Count; n++)     {                Rectangle abc = Rectangle.Empty;                Xpos = 40;            for ( int i = 0; i < this .DataGrid.Columns.Count; i++)            {                abc.W ...Show All

• Software Development for Windows Vista Shell Extensions?

  In Vista Beta 1 our shell extensions worked but in beta 2 Build 5384 it no longer works. I found some mention of Like all COM objects, Shell extension handlers must implement an IUnknown interface and a class factory . Most must also implement either an IPersistFile or IShellExtInit interface in Windows XP or earlier. These were replaced by IInitializeWithStream , IInitializeWithItem and IInitializeWithFile in Windows Vista. The Shell uses these interfaces to initialize the handler. In some msdn documentation but I can't find any samples. Anyone have any information Thanks. There seems to be some difference between the 32 bit version and 64 bit version of Vista. My shell extension works on the 32 bit version ...Show All

• SQL Server Errors / warnings after deleting variables & Connection Manager objects

  Hi, As I was developing my SSIS package, I created several variables and tasks ( FTP, WMI Reader Task ). I am now cleaning up, deleting unwanted variables and connections in the design window. I save and build the package and when I load the package, I get warnings that these variables are referenced but can't find them and errors that the WMI connection is not found. When a package calls a sub-package, it stores the absolute path of the child package in its dtsx xml file in a Connection String property. How annoying !!! . When I deploy this to another machine with a different file structure, it becomes a problem. Why can't it store the path relative to the parent package, which would be typically in a sub-directory under the paren ...Show All

• Visual Studio Question about DLL Versioning

  I am currently trying to implement source control (VSS 6.0d) between another user (a UI developer) and me (programmer). The UI developer uses Dreamweaver 8 for his chosen IDE. We do not have other licenses for Microsoft Visual Studio besides mine (VS.NET 2003). We have gotten source control worked out but I am confused as to the best practice concerning the bin folder. I was under the impression that the bin folder is hidden, and each developer had their own when working in Isolation mode. We are working in Isolation here, but because Dreamweaver does not offer a Build option (at least I cannot find it as of now), the UI developer cannot view his changes to .aspx files. As an experiment I added the bin folder to the VSS tree an ...Show All

• .NET Development Dialog Class and debuging

  Hi all, When I am programming, I usualy use Message Boxes or Dialog Windows or Console Outputs to help me debug my application. Now I am developping a Web Application and I do not know how to have the same interaction. Do you know a way to output information in that matter Thanks, JR Debug.WriteLine() needs some configuration to make it work (setting up a TraceListener). If you want a quick fix, try System.Diagnostics.Debugger.Log(0, null, "Hello!"); Debug.WriteLine() will ultimately call Debugger.Log(), so you can just jump to the chase. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Dynamic Tiles

  I'm trying to create a GIS type application using tiles. I've written a little test app which creates 1k*1k tiles. I've chosen D3DPOOL_MANAGED because I was hoping to use the LOD function calls and I also need to be editing some of these textures everytime a new frame comes in. The LOD works, but when I modify the top level the lower levels don't auto generate and I can't find a function call to do it. Also, If this path turns out to be a dead end, I need to find some way to recreate what I am currently doing with DrawDibDraw. It takes a large image and can decimate and push across to the graphics card "very fast". I thought StretchRect would be perfect, but both the src and dest have to be D3DPOOL_DEFAULT. I've only found Upd ...Show All

• Visual C# How to copy Array of objects, by values?

  abstract class AbstractClass { public abstract double this[int i] { set; } } class Point { public double x; public double y; } class ClassA : AbstractClass { private Point[] points; public ClassA(Point[] point_arr) { points = (Point[])point_arr.Clone(); } public override double this[int i] { set { points .y = value; } } } class ClassB : AbstractClass { private Point[] points; public ClassB(Point[] point_arr) { points = (Point[])point_arr.Clone(); } public override double this[int i] { set { points .y = value; } } } public static void Main() { Point[] point_arr = new Point ; int i; for (i = 0; i < 8; i++) point_arr = new ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Setting the Fullscreen Resolution

  Hello all, I have a very simple question that I can't seem to find a direct answer to. My Game's GraphicsComponent's backfuffer is set to 320 x 240. The game window is also 320 x 240. When I swtich to fullscreen by setting the GraphicsComponent's IsFullscreen property to true the fullscreen resolution seems to be 640 x 480. My graphics appear up in the top-left corner. How can I set the fullscreen resolution to 320 x 240 I came up with a working solution. When the device is created, I create an additional Texture2D Render Target that is the dimensions of the viewport. After all of my rendering at 320x240 is done, I use the StretchRectangle() method as described eralier to draw my backbuffer to this altern ...Show All

• SQL Server Asynchronous events to database clients via DAL?

  Greetings, I have a requirement for a SQL Server 2005 database to notify 3rd Party applications of a table change. As is stands now, 3rd Party applications access the database via a Data Access Layer (DAL) dll (C#). I'd like to somehow implement an asychronous event notification scheme via the same DAL to these clients. Can someone offer a clever way to implement such events Broker Services I am under the impression the SSBS is typically deployed when databases are to communicate with one another. Triggers to call some CLR code Other Thanks in advance, Loopsludge In SQL 2005 there is a buil-in solution for 'table change' notifications, namely Query Notifications and the technologies based on it (Sq ...Show All