msFlash's Q&A profile

• SQL Server Question on OUTPUT feature of DML

  I need to audit inserts/updates/deletes on active tables to audit tables on a set of tables that have foreign key constaints with the update cascade and delete cascade defined. I can explicitly code the delete/update on the parent table to perform an OUTPUT to an audit table, but how do I OUTPUT the cascaded delete/update that happens on the child table because of the FK constraint with delete cascade defined without having to resort to triggers. Thanks, -chiraj You might want to check into the use of DML triggers for this kind of issue, but this is not something that I have used much. Dave ...Show All

• .NET Development Download and import a zip file from Internet

  Does anyone know the best way to download (it would be rather peeping since I dont need to save it) a zip file from Internet, and using it to import to my webapp Raulsassaa wrote: The file is zipped in the webserver. I would have to read it inside the zip format. There are 2 classes supported by .Net to Zip/Unzip files in System.IO.Compression namespace! GZipStream DeflateStream Mostly files are compressed using GZipStream So I think you should give it a try to unzip your file. You should know what was the extenstion of the file before Encryption an u need to create the file with the same extension. I hope this will help! Best Regards, ...Show All

• Visual Studio 2008 (Pre-release) Extending DataContext?

  Is it or will it be possible to override the internals of the DataContext I want to alter the object creation implementation in the datacontext to create subclass proxies instead of just instancing the entity types directly. However DataContext seems very black boxish. Im well aware of the claims that non virtuals execute faster than virtual methods etc.. but in this kind of scenario where big chunks of data is fetched from some sort of datasource , those few nano seconds will be impossible to notice.. so that will hardly be a valid argument. Ive seen that there is a "services" collection inside the datacontext , but that also seems impossible to access from the outside. it would be really really lovely if such things were expo ...Show All

• .NET Development calling a stored procedure

  I want to call a stored procedure from my data source with a drop down list box or any control......... Any c# code lying around out there which might point me in the right direction Anything......thanks The forums at http://forums.asp.net are better able to answer ASP.NET UI questions. Thanks. ...Show All

• Windows Live Developer Forums how many pixels per mile/km

  how can i determine how many pixels would equate to a mile for any map/zoomlevel Check out this article first on how the tiles operate in VE: http://viavirtualearth.com/VVE/Articles/WorldWind.ashx That will give you an idea of how to change pixels at zoom to lat/long. Then you need to look into the projection technique used by VE: http://en.wikipedia.org/wiki/Mercator_projection Then you need to find an algorithm to do distance from lat/lon in Mercator. http://www.movable-type.co.uk/scripts/LatLong.html Have fun. John. ...Show All

• Visual Studio 2008 (Pre-release) How to set MaxItemsInObjectGraph on the CLIENT side

  I am receiving the following error on the CLIENT side The formatter threw an exception while trying to deserialize the message: Error while trying to deserialize parameter http://tempuri.org/:RetrieveAllResult. Maximum number of items that can be serialized or deserialized in an object graph is '65536'. Change the object graph or increase the MaxItemsInObjectGraph quota. The data that I am returning is about 3.5 meg in size with an unknown number of objects ( I don't want to count them). I had to on the SERVER side add [ ServiceBehavior ( ReturnUnknownExceptionsAsFaults = true , MaxItemsInObjectGraph = 300000 )] to allow the data to be serialized. I am hosting the service in IIS. On the client side I currently have ...Show All

• Visual C# How to unwire an event handler?

  I have limited understanding of delegates and event handlers.  I know that I can have: button.Click += new EventHandler(mybutton_Click); and also: button.Click -= new EventHandler(mybutton_Click); I believe the second statement will unwire the event handler that has been wired by the first statement.  My questions are: a.  What does the new keyword in the second statement mean, when I am actually trying to remove something b.  How do I unwire an event handler without knowing its name   That is, I want to unwire whatever has been wired to button.Click and start afresh with a new event handler. ( Or better still, how do I unwire the top most handler for that object ) I tried: button.Click ...Show All

• Internet Explorer Development Tuns of bugs in IE7, how to report?

  While attempting, and I do mean only attempting, to develop my application I keep getting "this old feature is now broken in IE7" Well here is a small list of what I can remember off the top of my head.. ----------------- $(id).onclick = 'alert(1);' <-- wont work until you forcefully update the DOM $(id).setAttribute('onclick', 'alert(1)'); <-- wont work until you forcefully update the DOM To update the DOM forcefully... $(id).parentNode.innerHTML += ''; After that innerHTML call, the onclick event assigned via properties will work. ----------------- Another problem, which I, ironically got while trying to post this message is a very big problem that is present when using google maps (or says so by g ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .X importer for XNA

  http://www.myjavaserver.com/~jonathanf/stairs.x This .x file displays correctly in the DXviewer as a staircase. However, when loaded into xna it is merely a cube. What gives The staircase was made using XSI Mod Tool and exported using the default .x exporter. ~Jonathan ok, so i got the importer into my project. however, now it gives a TextureCoordinate0 not found error. I can't figure out how to get a texture onto my simple scaled cube that works though... could someone who has used XSI Mod Tool or XSI help me ...Show All

• Visual Studio Express Editions expecting more than 1 datarow returned from query

  OK here's my question. I want to retrieve from my database employee table all those employees with the name eg. Smith and display them in a list. Can anyone give me any pointers please. I'm using VB 2005 Express Edition. So far this is what I have but it only seems to return 1 row when I know there are more than one entries with the name I am inputting Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim searchString As String searchString = Me .SearchStringBox.Text Try Dim filter As String filter = "LastName LIKE '" & searchString & "'" Dim search() As System.Data.DataRow search = myCDD ...Show All

• Visual C# pointers??

  how can i use pointers in c# as it is managed code development platform You can use pointers with the unsafe keyword http://msdn2.microsoft.com/en-us/library/t2yzs44b(VS.80).aspx ...Show All

• SQL Server 2005 Developers Edition question

  Just getting started with mssql . . . running mssql 2005 developers edition and will be using dreamweaver to develop sites . . . mssql documention states that the developers edition doesn't support remote access - does that mean that I have to have dreamweaver running on the same computer thanks, elvis I could be wrong, but what you pointed out doesn't sound correct, and i couldn't find any documentation that confirms what you said. Developer edition is same as enterprise, i'm not aware of any caveats other than licensing. ...Show All

• Windows Forms minimize, maximize, and close button image...

  hey, In Visual C# 2005 express how would I use some images I made for the minimize, maximize, and close buttons, and change the defaults to the ones I made The images are .PNG if that is somthing you need to know... Thanks :) What about this 2 settings Have you played around with these appearance.BorderSize =  new Padding (3); appearance.TitleBarSize = 32;   The other thing is that the actual images used for the buttons are probably padded already.   ...Show All

• Software Development for Windows Vista Problem with Workflow Monitor Sample

  I'm, having problems running the Workflow Monitor sample. It can query the workflows, but I get a big "X" on the rhs where it's supposed to display the workflow, and returns an error that says: "Microsoft Workflow Designer" "Object Reference not set to an instance of an object". I'm using Beta 2.2. I've got them in the same directory. Locating the Workflow is not the problem. It seems the problem is trying to display the workflow on the panel on the right. Something like hosting the deisgner or something Is that what it does to display the workflow..host the designer I have the same problem with the sample workflow as well as my own workflow. ...Show All

• Visual Studio Tools for Office How to pass parameters to a Word VSTO solution

  Hi there, Newbe question: I have created a word solustion which uses an addiotional assembly to gather data from a Sharepoint environment. (In short it creates a worde version of a posted Agenda and the Minutes afterwards). Since there are multiple meeting workspaces i want to be able to pass the URL as a parameter to the word solution which in its turn invokes the Sharepoint connection assembly. This refers to my specific problem but that will be solved by either passing the url as a parameter. Or a way to invoke the word solution from within the SP meeting site context. Any usefull tips on how the pass parameters to a solution and or start the document from within the SP site context will be greatly appreciated. Kr, Rem ...Show All