CharlieRussell's Q&A profile

• SQL Server Join tables

  hi I got a confusing problem.I have 2 tables (Table_1 , Table_2) whit relation On table_1.key and table_2.fkey.I need to get a table contains information from 2 table : title , key , fkey for mindate,mindate , describtion of mindate. so I tried to write a function for returning (select top(1) * from table_2 order by date) so only I need to connect this function to table_1. Here for running function I need to send Key to function and I dont know how I can do that because wnehe I try to join them I get Error message.in seccond try I made a procedure like this : SELECT Table_1.title, Table_1.[Key], Table_2.fkey, Table_2.date, Table_2.describtion FROM Table_1 INNER JOIN Table_2 ON Table_1.[Key] = Table_2.fkey where Table_2.[ke ...Show All

• Visual C# Windows enumeration (in C#)

  How can I enumerate windows How can I get handle of window Is it possible Thanks for any answer or links on net. S I'm assuming you mean enumerating windows running on the desktop/Windows level and not just those within your own application... if that is the case, take a look at this Code Project article which has some code to do just that, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3d mesh animations.... soon?

  Anyone got any news on when we can see some 3d animated meshes 2d's great but I am gagging for some 3d action. BTW, nice work to those who allowed us the power of swm files in XNA I suspect people are waiting until there is a release with the content pipeline, otherwise its a lot of work to write the convertors which will be of no use. There is no date announced when a content pipeline ready version will be availalbe. ...Show All

• Microsoft ISV Community Center Forums Buddy program?

  Hi, I signed up for the buddy program about 2 months ago, and have yet to be connected with someone. I emailed budsup@microsoft.com initally, someone contacted me and I was working with her. I thought it was resolved by her email stating: " As a matter of fact, Ibrahim, I matched you up a moment ago with a Microsoft Buddy…the trouble seems to be that there was a different name in the system than the one you’ve given me here…" But I never heard back from her, or my buddy after that. I followed up with her but received no response, and then sent an additional email to budsup@microsoft.com, and heard nothing back. How can I go about being matched up I guess there was some confusion over what name/email I signed up with but I didn' ...Show All

• Windows Forms my Form1 consists of button1,button2,checkbox1. if i click on the button1...messagebox has to display "button1 clicked"

  Hai friends, my Form1 consists of button1,button2,checkbox1 and so on. if i click on the button1...messagebox has to display " button1 is clicked " or if i click on the checkbox1...messagebox has to display " checkbox1 is clicked ". if i get this i can move any control to wherever I want. so plz help to identify what control i selected using MOUSEDOWN event(); following code i used but i am not getting..... private void Control_MouseDown(Object sender,MouseEventArgs e) { Control control = (Control) sender; if (control.Capture) { label1.Text = control.Name+" has captured the mouse"; } } regards, prem kumar. try follow way can ide ...Show All

• .NET Development Calling Remote Stored Procedure in C#

  I am trying to call a remote stored procdure in c# but am receiving the following error message in my ASP.NET application when trying to call the appropriate method: System.InvalidOperationException: Internal connection fatal error. Calls to local stored procedures on the SQL server the ASP.NET application is connected to are run fine. I have logged into the SQL server using the same user as the ASP.NET application and called the remote proc manually (using EXEC [SQL Server Ip Address].databasename.dbo.storedprocedurename) and it works fine I am using the followinng code to call the remote proc: SqlConnection cnDefault = new SqlConnection ( this .DbConnectString); SqlCommand cmdCommand = new SqlCommand ( " ...Show All

• SQL Server SQL Injection attacks

  I am taking a class where the professor really dislikes using parameterized queries because he considers them to be pointless. Despite the many points that I and a classmate bring up, the only thing he considers valid is using them to prevent SQL injection attacks. To prevent this, he replaces all single quotes with a pair of single quotes. I know this works for SQL server, but will fail in some others (for instance MySQL also allows \'). Is there other possibilies such as the \' that need to be protected against Your professor is looking at parameterized queries backward. They should be the standard approach only abandoned with a good reason. First, by using parameterized queries you remove the need t ...Show All

• Visual Studio Equivalent for <see langword="null"/>

  Hi, NDoc used to have an extremely cool feature that allows you to include phrases like 'null reference ( Nothing in Visual Basic)' in your code without typing it all the time. It's documented in http://ndoc.sourceforge.net/content/tag_see.htm. I have noticed that these special tags don't seem to work in sandcastle. Is there an equivalent feature for this somewhere If not, could this feature be added because it is extremely useful and not just for null. Regards, Michael Looks like in the September 2006 CTP the langwords are at least made bold. Any thoughts to expanding them as mentioned in a previous post ...Show All

• Visual Basic KeyDown Repeat Delay

  Just what it says...when using the KeyDown event it delays just as if a key was held down in a text application. Of course I can change this rate in Windows itself, but I'd like to change it on run-time with my program (then of course have it revert back when the program closes). Is there a simple code which will change the delay/repeat rate to a set value Thanks! Hi, Not that i know of but you could use a timer as a delay and set the number of milliseconds or seconds delay in your code perhaps Example taken from Microsoft files. This example tracks the time of day in one-second increments. It uses a Button , a Label , and a Timer component on a form. The Interval property is set to 1000 (equ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. aaaaaaaarrrrrrrrrrrrrrrrrgggggg!!!!!!

  I do not sleep the two days because of XNA framework… because it delays in such a way ... I am starting to hear voices ...I have fear… fear to sleep and the SDK not to leave. MClever wrote: Well just so you're well aware, there are ninjas trying to kill you.... Well, as long as there's not also pirates and robots. ...Show All

• Visual Studio Team System Can I use the XML/XSD schema as a source for data genaration?

  I have some XML/XSD schema which has table definition. Can I use this schema in place of the RDBMS table for generating the data And is it possible to have this data generated in the XML file Right now we either reverse engineering the schema from database or import it from Sql Script. And there is no direct way to import the schema from XML/XSD. A workaround is that you can write your code to create sql script so that it can be imported. For data generation, there is no direct way to generate data into xml file. You can generate data into the database first and then export them into xml file. Thanks, ...Show All

• SQL Server DAY() not working with 'Left Join'???

  I have two tables. Days (1-31) and dates (random dates) If I have a query that is Select Day, Date From days LEFT JOIN dates ON days.Day = DAY(dates.date) Order By Day, Date The left join will not return all the days in days just the ones that join with dates. It returns as if I am doing and 'Inner join'. What do I need to do different Thanks. So I get to playing around with your example and descovered some stuff I didn't know about left joins. My query has touble when I add a Where clause on it to filter dates to a certain range. The differents querys are below in case someone else needs help. Thanks. NOT WORKING Select a . Day , b . date From days a LEFT ...Show All

• Visual Studio Express Editions Hide message in an .exe file

  Hi, I need your help. How to add 16 byte or 32 byte string in .exe (.NET Assembly) file Even if i add message in an .exe file, the .exe file should work properly. Is there any way to add and extract message from/in .exe file Please send your suggestion or links. Thanx. M. GANESAN You can add string resources into .NET Assemblies. In Visual C# Express, right click the project name in Solution Explorer, select Properties, and go to Resources tab. Or in Solution Explorer, double click the auto-generated Resources.resx file (or similar). A resource editor should open. Then you can add resources; images, strings, files etc... In runtime, you can get the resources from Resources-class. (It is something like global::<Yo ...Show All

• Windows Forms Designer forces DataGridView.AutoGererateColumns = false??

  I have setup a DataGridView with a data source of DataTable. In the designer's properties it says AutoGererateColumns= true, but in the designer.cs code it is clearly set to false If I don't change the code it will not display my table properly when the Table is filled with data. Is designer forcingforceing this attribute to false because the datasource is empty at first or what As soon as I do make a change to the design, and save, the designer code flips it to false again. The only way around this is to change it in my init code, or changing the designer code each time I make an edit is this a VS bug thanks, matt I realize that by default it is set to true, but the designer is automatically setting it ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Debugging shaders with Visual Studio C++ Express

  I have installed August 2005 SDK. It installed also DirectX extension for "Visual Studio .NET 2003", but not for "Visual Studio 2005 Express", so inside this IDE there is'nt the menu item Debug -> Direct3D -> .... I must install this extension manually for VS Express And if yes, how Thank you for your help. Bye Toni Visual Studio 2003 was the last version of Visual Studio to support shader debugging. Instead, you have to use PIX (from August 2006 SDK), and capture at least one frame's worth of rendering. Then go into the stream, move to a rendering command, and debug your vertex or pixel shader. For a vertex shader, click the "mesh" tab beside the "render" tab, right-click a vertex (pre- ...Show All