Stu_R's Q&A profile

• SQL Server user defined functions

  Hi everyone, Today while using user defined functions, I noticed that we must write dbo. before the function name which I did not conceive why it is used like that. Why are there an exception for functions Why do we not have to use the same thing while using SP or not user defined functions Thanks Hi, thakns for your clarification. However something still makes me a little bit confused about this is that is it possible to restrict some user about using UDF or SP Thanks ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA shader parameters from 3d studio

  Hi! I'm currently using 3D Studio Max to create scenes, then export them into .x file format and then import with a standard content pipeline. What I miss is that after the content pipeline processes my scenes I can't find the shader's parameter values I've set up in 3D Studio Max. Is there a way to overcome this problem Any help appreciated, Pawel Jarzebski Well I'm not a user of 3D Studio Max and so I'm not familiar with exactly what is supported by its X file exporter, but once you get a Model imported into an XNA project, and assuming each ModelMeshPart within your Model has a valid Effect (FX file) associated with it, you can access the HLSL global parameters of the effect (which is what I a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Alpha Blending (deferred)?

  Is there a way using the sprite batch object that you can render several rectangles, but when alpha blended, it looks like the entire object was rendered first as a single opaque image, and then that image was alpha blended, such that you would never have known it was several smaller pieces assembling the final object Instead of normally seeing each rectangle blended as it overlays another rectangle. That totally depends on how many such targets you are likely to have, and also how fast your graphics card is. For what it's worth, the composited translucency effects in Windows Vista seem to keep up quite nicely as long as you have a decent graphics card, but generally need to be turned off on older/ ...Show All

• SQL Server Simple flat file import

  Boy, do I need HELP! Have a simple csv file that I need to import. Worked fine in sql2000; I put it into dts to execute on a monthly basis. Makes connection, db connection, table creation fine, but stops at validation of flat file Basically, I want to go out and get a flat file, drop the existing table, and create the table, and import the information from the flat file. Not a complicated table of about 30,000 records. Create table [db].[dbo].[tblPatient] ( [patientID] into not null, [chartID] varChar(15) null, [doctorID] int null, [birthdate] datetime null, [sex] varchar(1) null, [raceID] int null, [city] varchar(100) null, [state] varchar(2) null, [zip9] varchar(9) null, [patientTypeID] int null, [patName] varchar(100) null) Be ...Show All

• Visual Studio Global Objects with Macros?

  Hi, I want to instantiate and initialize a global object upon startup for a Visual Studio session (2005 Standard Edition), and access it with my macros. I’m a novice at VS macros, so I don’t know how to proceed with this. Should I place the class definition within the same public module as the macros, or outside Is there any sort of event handler that is executed on startup (much like Page_Init and Page_Load) Any help with this would be greatly appreciated. THANKS!!! You can use the EnvironmentEvents file and initialize the object in these events: - DTEEvents.OnStartupComplete (the IDE has been loaded) - DTEEvents.OnMacrosRuntimeReset (the Macros runtime had to be reset) ...Show All

• Windows Forms combobox

  hi guys, how do i add a datagrid to a combobox any sample code or links will be helpful . Thanx in advance. rawky Here is the answer: http://www.xmlfox.com/CSsamples.htm -L ...Show All

• SQL Server How does sql server determine order of cascade deletes to many tables

  If have the following scenario Table A Table B fk to Table A Table C fk to Table A fk to Table B - nullable Table A cascades to table b and Table A cascades to Table C. Table B then restricts to Table C to avoid circular reference. However, the way our data is configured, the restriction from B to C will never matter when deleting from A if Table C is always cascaded to first and then B. I have done a few tests and this appears to work. I haven't been able to find any info on this, so is this order something I can always rely on Yes. There is no way to define the delete cascade happens on C before on B. By implementing delete trigger on A, you have full control as to dele ...Show All

• Visual C++ Profiling C++ .Net app in Visual Studio .Net 2003 enterprise version

  Hi, Does anyone know how to profile a C++ .Net application in VS .NET 2003. With VS 6, you can do it by enabling the "profile" in project property link page. But in VS .NET 2003, I couldn't find this setting. Has it moved to some other places I don't believe a profiler was included with VS .Net 2003. There is a free community edition of a profiler from one of our partners which you can use with 2003. VSTS 2005 however does include an excellent profiler. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .xnb files are huge

  Hi! Our 2D game is getting huge because of the non-compressed .xnb files all our graphic are stored as by XNA. A single background image in 1280x720 pixels is using 3,5 MB ! What can you do to get file sizes for graphics down Maybe I need to explain myself better. When the background images are stored as compressed jpg's they are about 75 KB in size for at 1280x720 resolution. When they are published in our XNA game they are about 3.5 MB in size (in xnb format). So the question is how to compress images in XNA when deploying games ...Show All

• Windows Forms Creating Button Controls at runtime and capturing each of their click events

  Hello, I am trying to create multiple buttons at runtime and capture the click event for them (for all of them). However, when I try to capture the click event, I can always only capture the click event for the last button. Anyone know of a way to work around this problem Here is the code I am using: Imports System Imports System.ComponentModel Imports System.Windows.Forms Imports System.Drawing Public Class Form1 Public WithEvents btn As Button Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load For looper As Integer = 1 To 20 'Dim btn As New Button btn = New Button btn.Height = 25 ' Set Size. btn.Width = 150 btn.Left = 20 ' Set Location b ...Show All

• Visual C# Loading Class library dll

  How to load a .net class library dll dynamically from a .net windows application using vs 2005. Hello, Look at Assembly.Load function. Then to create an instance of a class from your library, you can use the CreateInstance function: object theInstance = assembly.CreateInstance( "MyAssemblyNamespace.MyClass", true, BindingFlags.Public | BindingFlags.Instance, null, null, null, null ); Richard ...Show All

• Visual C++ Multi-dimension arrays in VC++ 2005 for n00bs

  Okay, a little background: I'm an aerospace engineer, not a programmer, but I'm experienced in C, and I'm using VS2005 to make some simple-ish tools for our group. I'm trying to declare a multi-dimensional array in VC++ through the 'standard' method... double test[5][5]; ...and then access it in the 'standard' way... test[0] = something I'm putting in there.; ...but it's not working. When I debug, the Watch says that test is a double[][] of length 5. So far, so good, but when I expand it, instead of the 'standard' syntax, it comes up like this.... test[0,1] Length 0 double[] test[0,2] Length 0 double[] ...and so on. I've dug through our copy of MSDN, and online and there ...Show All

• .NET Development How many clients is connecet to server?

  Can i know how many clients is connecet to server Depends on what server and what type of clients. For example, if you were looking at clients for you asp.net application, you will find that information in "sessions total" performance counter. To access it - launch perfmon and go to asp.net applications -> "sessions total" Pranshu Jain ...Show All

• Visual Basic Storing user input in a class or structure

  What I want to do is store the user input in a class or structure to be retrieved from any class within the application. Example: The user inputs properties of a shape to be designed. I am currently passing these properties to each class that uses them to do their computations but this means I have to declare public variables in each class that uses these properties. I want one source of this data that I can retrieve from anywhere in the application. There has to be a cleaner way or doing this, right Thanks in advance You can define these properties as shared members of a class meaning that you can refer to it anywhere the class is visible. You refer to these members using the class name . member name ...Show All

• SQL Server Detailed description on creating a dynamic excel file

  Is it possible that i can create a dynamic excel file (destination) ex, i want to create a Dyanamic Excel destination file with a filename base on the date this will run on jobs. Is this possible 11172006.xls, 11182006.xls You map the columns at design time. You dont need to do that everytime the package runs. As long as the column names and data types remain the same, you dont have to do anything. ...Show All