bslim's Q&A profile

• SQL Server group by

  Can you please tell me the difference between saying Select min(x),y from table group by y _____________________________________ Select x,y from table group by x,y having x = min(x) Bob: Examine this: set nocount on declare @table table (x integer, y integer) insert into @table values (1,1) insert into @table values (2,1) insert into @table values (2,1) insert into @table values (2,3) insert into @table values (3,4) -- Can you please tell me the difference between saying Select min(x),y from @table group by y -- _____________________________________ Select x,y from @table group by x,y having x = min(x) -- -------------------------------- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Art/Sound assets

  First off, I'm really excited about XNA/etc. If I ever meet the guy/gal who came up with this idea I would love to buy them a beer. I'm a programmer with professional experience. I feel like I'll be comfortable with XNA development once I've got my hands on it. My main concern is game assets. I'm no artist, nor am I a sound engineer. Here are my questions: How much art/sound content is expected to be available for programmers like me Will there be a variety of content For example, I want to make a fantasy RPG and some other guy wants to make a space themed FPS. Will we both have access to the assets we need Will art and sound types be able to upload their own content for other developers to use ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. directdraw not available?

  well, i tried to play haloCE but the problems with directX. on the display tab, all of those things are "not available" any help would be appreciated. heres the information from directX and a screenshot. i hope this is the right spot to post this in! by the way, im on a toshiba 1005-S157 laptop. http://forum.ccleaner.com/index.php act=Attach&type=post&id=877 You will need a better graphics card if your laptop is upgradeable. Otherwise you will need to get a better laptop/pc. This isn't a Windows/DirectX problem, it's a hardware problem. ...Show All

• SQL Server using views to access tables in another database

  We have a database where the application configuration tables are in the same database as the user database. We want to move the user data to another database (to ease deployement of changes). We are thinking of moving the tables to another database and creating views in the old database to eliminate having to recode our application. We have tested that the CRUD statements will all work with the views, but are wondering what performance impact this will have. So, what impact will using the views to mask the tables from another database have Thanks, Ernie There should not be any performance difference as long as the queries in your views are simple SELECTs against the original tables. ...Show All

• Visual C# C# pointer

  I need to create a C# pointer for a DLL function. I wrote byte* Read_Data_ptr, but I get the error: Pointers and fixed size buffers may only be used in an unsafe context Any help with this would be geatly appreciated. Thank you, Mike Hi, you need to declare an unsafe block where you can use unmanaged code: unsafe { byte* Read_Data_ptr; } Consider "marshalling" (i.e. converting your unmanaged type to managed type) when calling functions from DLL's. ...Show All

• .NET Development Needed: Socket

  Hello everybody :) I'm searching for a good socket(Server/client). I know, in C# I can use System.Net.Socket, but I'm looking for something more easy. A socket that's free, multi-threaded(so that it can handle multiple connections if it's listening to connections) and it would be nice if it was open-source. Thank you, Nils A socket server generally supports more than one concurrent connection; but that's done through more than one socket. Often well-known ports are used simply to initiate a connection, thereafter a ephemeral port is used. If the "connected" protocol is such that it follows a connect-communicate-close model then ports can be reused. A socket library won't abstract the basic nature of sockets away; you'll sti ...Show All

• Visual Studio 2008 (Pre-release) Asynchronous Services - Duplex Contract

  Hello, I'm very new to WCF and SOA. I'd like to prototype a proper SOA demo, where services are running autonomusly, with thier own respective QoS. So I'd like to make the services asynchronous. It seems that the best approach for me is to use Duplex communication and callbacks. 1. Does wcf's implementation of duplex communication work through firewalls (through HTTPS) 2. Is the Duplex communication model scalable Because I'm guessing that the server needs to somehow track each client call and keep track of thier respective callbacks How does this work for looong running work 3. Can I find information on the internals of the wcf's callback architecture Thanks in advance, Houman > ...Show All

• Windows Forms Sorted DataGridView when OleDbDataReader is used in C#

  I'm using this code to populate a grid, but once filled if I click on the columns heading it doesn't sort even if I enabled the reordering column feature. Why is that and how can I sort my columns please. thanks OleDbDataReader OleDbDr = null ; dbRecordsHolder = new ArrayList (); using ( OleDbConnection Connection = new OleDbConnection (connectionString)) { OleDbCommand Command = Connection.CreateCommand(); Connection.Open(); Command.CommandText = "SELECT * FROM CLIENTS " ; try { OleDbDr = Command.ExecuteReader(); if (OleDbDr.HasRows) { foreach ( DbDataRecord rec in OleDbDr) { dbRecordsHolder.Add(rec); } } } finally { OleDbDr.Close(); Con ...Show All

• SQL Server connection to AS cube error

  Hey all, wondering if any of you can help me.. I have built an AS cube and deployed it. I am now trying to set up a model in report manager so that i can build reports off the cube.. I have setup the datasource as follows : Name: GAPLSales_DS Connection Type: MS SQL AS Connection String: Data Source=MANT4003;initial catalog= GAPLSALES GAPLSALES is the name of the database on AS Intergrated Security.. I then try to create a model, and i get the following error: Cannot create a connection to data source '' . (rsErrorOpeningConnection) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote erro ...Show All

• Visual Basic Leave Event

  i cant seem to work out how to do this I am in textbox5 and on the leave event i want to have textbox1 to 4 leave events to be proformed and still be able to click into one of those textboxs in textbox5 click on textbox1 TextBox5_leaves(-------)handles textbox5.leave code leave textbox 1-4 end sub Textbox1_leaves(------) handles textbox1.leave, textbox2.leave, textbox3.leave, textbox4.leave code to preformed on the textbox five leave for each textbox end sub textbox1 has focus this works but i am getting this error the sender is set to nothing in the texbox1_leave any troughts System.NullReferenceException was unhandled Message="Object reference not set to an instanc ...Show All

• Windows Forms Publishing VB projects

  I managed to build some projects and successfully publish them though the project needs some improvement. I successfully installed the programme in my notebook where I build it in the first place. But when I try to do the same in my office computer, I get an error message. Same on one of my colleague's computer at office. All the computers have Windows XP Pro as the OS but the office computers don't have the VB Express Edition installed. What may be the problem with the publishing It might be helpful if you copied the error message and posted it here. They are quite useful sometimes. The most obvious thing is... do the other computers have the .NET Frameworks 2.0 installed This is a pre ...Show All

• Visual C++ How can I prevent my application from being launched multiple times simultaneously?

  Basically, I want my application to detect whether it's already running and shut down if it would be the 2nd copy. I think the solution might use COM objects, but I can't make any sense out of the COM documentation in VC++ 6.0. Hi, One way is to use (named) kernel objects. Suppose if you have dialog based application, During the Initialization, you may have to create a mutex for synchronization. But before creating that you should try to open the mutex you are supposed to create. if open call is success. simply return from the function and end the dialog. pseudo: if(OpenMutex(....."MyMutex")) return FALSE; // else CreateMutex(...."MyMutex"..); .... // do further. Note: Using Ker ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Just clicked connect to pc and it froze up, help.

  Its been saying "Connecting to pc" for a half an hour now, my pc is connected to my 360 via wireless connection and its not going through, is it suppose to take awhile or am I suppose to do something Thanks in advance, I really want to use this. (Moved to XNA Game Studio Express forums) Wireless shouldn't be an issue at all. However, there are a few things that can affect connectivity, with an incorrect key being the most-likely culprit. The first step is to use the MEdia Center Extensions to verify that your PC and Xbox can communicate with each other. Once you've verified that, generate a new key and try to connect again. ...Show All

• Visual Basic Regression Equation / Statistics in VS 2005

  Is there an easy way to create a regression equation based on certain data located in variables Or do I have to get out the 'ole stats book and write the code manually I couldn't find anything in the help file about this, so I may be out of luck! Thank you! -Corey "This involves comparing all the X values and the Y's, not easy." This is what I was responding too. The OP wanted to know how to do linear regression. As you can see, it's not a difficult problem. ...Show All

• Visual Basic VB 6.0 - API Signature

  Can anyone explain the significance of the Ex with the name of the Function or Procedure. Eg: InitCommonControlsEx What i understand is that the Extension HI Srinivasan, There are basically 2 different functions - one that is named InitCommonControls and another one with name InitCommonControlsEx. They have different signatures (i.e. take different number of arguments). The second function was introduced as an extended version of the first function (as you mentioned already) and it takes additional data in parameters which allows for more customizations by the client code. Best Regards, ...Show All