retkow's Q&A profile

• Visual Studio 2008 (Pre-release) Security Question re Stored Procedures

  Hi, I have only just started looking at this stuff, but I can't find any relevant discussions on this subject so I apologise if it has been done to death already! Basically, this is about the fact that most corporates I have worked with have mandated the use of stored procedures over the use of raw or dynamic sql from a security perspective (i.e. for the well-known reason that in order to run the sql, the user needs rights on the base tables). I do not know if this is still the case with SQL 2005 (I haven't had a chance to investigate if there are now better ways!) and I also know that support for stored procedures is intended in the entity framework in future CTPs, but so far everything I have seen has been around the framework g ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do you implement Fog into a scene?

  Hi All, I have finally got some 3D up and running so things are whizzing about (which is always fun to watch... for a while, yeah I know, small things...) and I was wondering if anyone had any examples of putting fog into a scene. I tried last night and succeeded in turning all my meshes to white, not matter how far away they were from the camera. No matter what I did to the values, nothing changed. As always, any help is greatly appreciated. Cheers   LeeC22 wrote: More than 8 bits per colour component in an image format used in games, which format is that One of the biggest developments in the latest generation of games is the use of high dynamic range lighting, which involves using colors brighter ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using textures with a custom pixelshader SpriteBatch

  Hello World, Running SpriteBatches with a custom pixel shader is no problem. Works perfectly. (For those that wonder how, just write an effect with a sampler state and a pixel shader and no vertex shader and run it around your spritebatch that uses Immediate). Now If I want the pixelshader to use an additional texture to the one sent to the draw call it simply doesn't work. Every sample state contains the texture in from the drawing call. Can't get access to my custom set texture. Anyone got a clue to get this working Or should I just give up and draw my own quad and set the textures myself hello :)   Malmer wrote: Hello World, Running SpriteBatches with a custom pixel shader is no problem. Wor ...Show All

• Visual Studio Setting report parameters question

  Hello. I'm writing some Windows application and I use ReportViewer control to display my reports. I use Local processing mode. Also I want to have one ReportViewer control that will display different reports depending on user's choice. I use the following code: string rdlName = SelectedReportRDLC ; LocalReport localReport = reportViewer.LocalReport; //loading new RDL here localReport.LoadReportDefinition( GetReportStreamReader( rdlName ) ); ReportParameter[] paramArray = new ReportParameter[] { SelectedReportParam }; reportViewer.LocalReport.SetParameters( paramArray );  // <= ReportProcessingException localReport.DataSources.Clear(); LoadDataset(); localReport.DataSources.Add( SelectedReportDataSource ); r ...Show All

• Windows Forms Window Vista

  Hello, Mother Board Intel 865 GBF Series, Windows Vista Install On board Audio Driver Not Spported., pls....solution ...Show All

• Visual Studio Team System How to deploy one project to multiple servers...

  I am using the database professional to create a generic DB that I have a copy of on two different servers with the exact same database code (procedures, functions, tables, etc.) and I was wondering how I can use one project to make all my changes and then deploy those changes to each of the two servers using the deploy functionality rather then do a schema comparison for each of the different servers and then running a seperate script on each server. Is there a way to package the comparison engine in an executable Our database schema is part of a COTS product we supply and support. We do not have direct access to our customers databases. Additionally, not every change to the db is implemented at every lo ...Show All

• .NET Development .Net Framework 1.1 vs. 2.0 adoption

  We are considering migrating our product from .Net 1.1 to 2.0. However, we are concerned about adding the extra 25mb download requirement for the .NET 2.0 framework. Our product is designed for personal users and is exclusively available as a download from the web. 1) What is the difference in the personal computer install base between .NET 1.1 and 2.0 2) What computer manufacturers are shipping with .NET 2.0 already installed as for shipping, its all down to Windows Update and if the supplier selected to install all updates including custom updates. .NET 2.0 is of course needed for newer classes and so on - if the end user doesnt have .NET 2.0 and your app is built on .NET 2.0, it will not work ...Show All

• SQL Server Package Configuration using xml-file fails

  Hallo, I use SSIS Version 9.00.1399.00 and keep getting problems trying to use package configuration. I choose xml configuration file as type and browse a path on our LAN to create te configuration file . Then I select the properties of a OLEDB communication manager as Properties to Export Doing so I obtain this configuration: Name: JACBE_IF_CONFIG Type: Configuration File New configuration file will be created. File name: L:\Projects\Vinci\SSIS\DVL\FMC loader Import\FMC Loader Import\FMC Loader Import\JACBE_IF_CONFIG.xml Properties: \Package.Connections[JACBE_IF].Properties[UserName] \Package.Connections[JACBE_IF].Properties[ServerName] \Package.Connections[JACBE_IF].Properties[RetainSameConnection] \Package.Co ...Show All

• Visual Studio Express Editions Reading a web page...

  I have been trying to read from a Web page inside of a WebBrowser control. I can read the entire page code, but can not specify certain areas of the page to read, like a text box. I would like to be able to read just the text box in my web page and have it write the context of the web page text box over to my application textBox... This is the closest I've been, but I can not get it to work at all. It will do the "if ()" event, which is just a message box, but it will not copy the web pages text box contents to my application textBox. <input name="txtName" type="text" id="txtName"> in order to get that element, I would do this: HtmlElement theTextBox = this.theWebBrowserCont ...Show All

• Software Development for Windows Vista What cool UI stuff should every app take advantage of in Vista?

  What cool stuff should every unmanaged desktop app take advantage of in Vista And still work well downlevel In XP it was themes, new common dialogs, for example. There does not seem to be the push by Microsoft for apps to exploit or take advantage of Vista UI features as there was around the Windows 2000/XP timeframe. People were making sure their apps looked and felt like XP long before it was released. Now with Vista just around the corner, we have huge COM based shell stuff that nobody is even looking at or caring about. Devreadiness doesn't have this type of info. What are the cool things to do in every app and also have a good downlevel fallback Some stuff I've found are: - IFileOpenDialog/IFileSaveDialog - very lar ...Show All

• SQL Server Parameterized MDX Query Performance Issue in SSRS

  Hi, I'm having issues with a reasonably complex MDX query used in a Reporting Services report. I have executed the query and traced activity on the SSAS box and have discovered that there is a major difference in performance between the parameterized query and the exact same one but with 'hard coded' values. The difference we are talking about is from a couple of seconds (hard coded) to minutes when parameterized!! The key difference is that the parameterized query is causing litterally hundreds of thousands of Query Dimension events (EventSubClass : 1 - Cache Data) to occur against one of the dimensions (the Date dimension to be exact). This dimension is not even large with only a few hundred leaf level members and about five levels ...Show All

• Visual C# Events

  I know how events/delegates works. its when implementing them that seems to be the problem with me. now... I have: a Form several classes the form knows nothing, it only knows about 1 class, which it instantiates. this class instantiates other classes. The form, nor do the other classes, need to know about each other. now, I have successfully created events which when raised from the main form, one of the classes acts upon it - thats all good. what I want now, is the complete opposite. I want to make an event where, in one of these classes (not the class the main form creates) I can raise so that the main form picks it up and acts upon it. Since I am mostly confused at times when events are involv ...Show All

• Visual Basic how to find internet connection

  hi, can anybody say how to find wheather we have internet connection in our system and what type of connection Some additional information on the context and usage of such a query would be helpful for providing better suggestions. For a greater, higher level solution with the caveat of requiring .NET 2.0 or above, you may wish to look into the System.Net.NetworkInformation namespace for methods of querying network interfaces, gateways and the like. Hope this helps! ...Show All

• SQL Server Who cand add users to the db_securityadmin role ?

  I have user which is a member of the db_securityadmin database role. It has no other permissions applied to it. When I login with this user, and try to add some other database users to the db_securityadmin role, I receive an error stating that I don't have the permissions to do this: User does not have permission to perform this action. (Microsoft SQL Server, Error: 15247) Is this the normal behaviour, or is there something wrong I am using SQL Server 2005. From what I know, this works fine with SQL Server 2000, but it doesn't work as I expected with SQL Server 2005. This is by design. According to the SQL Server 2000 documentation for sp_addrolemember ( http://msdn.microsoft.com/library/defa ...Show All

• SQL Server How to enable the option of " Create New SQL Server database " from Database Explorer

  Hi there I am working on Visual Web Developer Express Edition 2005. When I right click on database explorer to create an SQL server database then I always find the option " Create New SQL Server database " Disabled. Can any one tell me how to enable that option please You are probably in the wrong forum for this question, but do you have SQL Server Express installed http://msdn.microsoft.com/vstudio/express/sql/ ...Show All