kennm's Q&A profile

• SQL Server Reset autoincrement number

  I use Microsoft SQL Server and also I have several tables. One table has ID like PK, and name. ID use autoincrement number mode, and now when I want start form one but not from 156 or like that. I don't know how And also when I delete all data from table an run my apllication and add something in table, it starts form last number, not from one. Maybe can I do it from SQL menagement studio How I can reset table and start from 1 One way to delete the data AND also reset the IDENTITY field is to TRUNCATE the table. (Check in Books Online, topic: Truncate.) However, this may not be available if the table has PK-FK relationships with other tables. ...Show All

• Visual C# The designer could not be shown for this file because none of the classes within it can be designed.

  It is an instance of dealing with the unknown. I have been getting this warning for about three weeks with no ill effect on my development whatsoever. I was wondering what it meant but decided to ignore it for a time being. Then all of a sudden today I could not display the app in the designer at all with an error message (with an error number) which I neglected to save. I simply closed the VS2005 and restarted it. That fatal error disappeared but the warning remained. I am wondering what it means and if I should take care of fixing the problem. This is the full text: Warning 1 The designer could not be shown for this file because none of the classes within it can be designed. The designer inspected the following classes in the file: ...Show All

• SQL Server Looking for suggestions

  I have two stored procedures (l'll call them P1 & P2). P1, after a lot of processing, creates a temporary table that is used by P2 after an "exec P1" is done. I've separated the logic into two stored procedures because, ultimately, other sprocs will need the output of P1. I get an error if I use #tempTable as the output table in P1 because it no longer exists after P1 finishes. ##tempTable works, but I'm concerned about concurrency issues. Any suggestions on what construct(s) I should be using Thanks in advance! Global temporary table (GTT) ( ##tempTable) might not be the one you need here is the downside of using GTT.   1. you cannot use it to cache Data f ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Possible bug? - Textures and Source Areas

  Hi, I've been experimenting and trying to draw a 2D texture (using a sprite batch) to the screen. Now I've specified a source rectangle for the texture - which is at (x, y) and of width & height 1x1. So essentially a single pixel from the source texture, which is RGBA (0, 0, 0, 255) i.e. solid black. When I render this and specify a destination rectangle, what's rendered seems to take into account the pixels either side of the source rectangle - which are RGBA (0, 0, 0, 0) i.e. transparent black. Now this seems to me slightly illogical or at the least counterintuitive - that pixels *outside* the source rectangle should affect what's being drawn! Well, if someone could explain this to me I'd appreciate it very much, or perhaps confir ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectSoundCreate8 wont return

  Goodmorning Gurus! I am able to write MFC and Win32 application DirectSound programs well in visual c++ 6.0. The problem is that I have to wrap a simple DirectSound program into a DLL - and therefore when I make a DLL(Win32 DLL) and call the function below during initialization, the IDirectSound create function doesnt return and my program hangs. Here is the code where it hangs - hr = DirectSoundCreate8( NULL, &m_pDS, NULL ); where, m_pDS is an instance of LPDIRECTSOUND8 the project settings are: win32 debug: Debug single threaded win32 release: Single threaded I have done all the researching I could and didnt find a solution. I request you to please help me. Thanks! mrkodi ...Show All

• Visual Studio Express Editions Avoid the appl being shown in Alt+tab

  Hi  have a monthcalender control on my form transparency is set so that it appers to be a galss form.Only the control is visble.Desktop icons are all clikable I placed the exe in the startup folder so that i can see the current date on my desktop. ShowinTaskbar=false 1..As..i am working with other applications ..when i use Alt+Tab.. i can see my exe icon(which i dont want) 2.when i clik on "show desktop" icon i no longer see  the calender (my exefile)  on the desktop.. someone suggested that i use <vbcode> Protected Overrides ReadOnly Property CreateParams() As CreateParams     Get       Dim cp As CreateParams = MyBase.CreateParams       ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Installing C# Express Edition After VS2003/VS2005

  I waited till the last minute to install C# Express, but I wanted to point out that the download page is potentially confusing. Yes, it says beta versions must be uninstalled, but immediately following it says that any previous versions of SQL Server 2005, VS2005 need to be uninstalled. The good news is that it will install without issue, but I wanted to post this as a recommendation to change the text. Uninstall beta versions Before installing, you must uninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0 (this includes Tech Preview, Beta, or CTP versions). JR Nip wrote: And game Studio Express will only run with C# express. It cannot integrate with vs 2005 pro. The pr ...Show All

• Visual Studio Express Editions vb2005- printing reports that may have more than one page

  I have designed a report that looks fine, sometimes it requires more than one page, but it will terminate at the end of the first page. Is there a Form Feed or Page Break that I can use and how Thanks. Luis In your page printing routine, there is a property . HasMorePages which you can set true (this is through the arguments passed to the Print Page Handler routine). This will cause the print routine to run through again. You will have to keep track of the page you are on. ...Show All

• Visual C# Using StreamReader/StreamWriter or not to use them

    This is outdated version, see Corrections and Questions for current version /* * For learning purpose of functions FromBase64CharArray and ToBase64CharArray, I made following * simple UUEncoder/UUDecoder test case program. There is two implementations of decoder/encoder. * * Overall differencies between implementations are as following: * * Implementation One is taken from Microsotf's sample. * EncoderOne uses FileStream for input and StreamWriter for output phase. * DecoderOne uses StreamReader for input and FileStream for output phase. * * Implementation Two is by mostly developed by me. * EncoderTwo and DecoderTwo uses FileStream for both the input and the output phase. * Besides tha ...Show All

• Visual Studio Express Editions Weird behaviour of the 'is' operator. Is this a bug?

  I've noticed some strange behaviour when using the C#'s 'is' operator. As stated in http://msdn.microsoft.com/library/default.asp url=/library/en-us/csref/html/vclrfispg.asp : An is expression evaluates to true if both of the following conditions are met: expression is not null . expression can be cast to type . That is, a cast expression of the form (type)(expression) will complete without throwing an exception. For more information, see 7.6.6 Cast expressions . The following expression, however, returns 'false': 0 is byte Since 0 is not null, and (byte)0 casts successfully without any kind of exception, shouldn't it return true Just for your consideration. By the way, the expression '(byte)0 is byte' returns ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Whos using TorqueX, Who isn't?

  Just curious: 1. Are you using TorqueX or not - and why or why not 2. If you are using TorqueX are you also using TorqueX Game Builder and why or why not I'm experimenting with both but haven't decided if its the way I'm going to go yet. Primarily, I code it all, but I've been playing with TorqueX for a bit (only 26 days left for me) and it isn't half-bad, with the exception that right now three of the project types cannot be deployed to the 360. ...Show All

• Windows Forms Night Vision

  I am working on a military application that needs to support a "night vision" mode - that is, make the application appear in a green scale color pallet to make it easier on the eyes in reduced lighting. Now, I know I can take an approach that will "skin" or "theme" my application to make it appear green (our GUI COTS product Infragistics NetAdvantage makes this possible), but it still isn't a 100% solution because we would need to re-do all of our images/icons that we use in the app to a green scale version, and then code the functionality to change the images at runtime when needed. Further, because we display maps and map information, there isn't an easy way to change all of the maps into a green scale. Havi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I protect my code when distributing it?

  Having read the FAQ. I noticed that in order to share your game creations (and lets face it, you can't get recognised without sharing your games), you need to send the other person the entire uncompiled game. This includes sourcecode, graphics, music, sound etc. etc. They then compile the code and download it to their xbox360 account and then only if they too are on the games creation program. My key worry here is that you send them everything you have just worked incredibly hard to create. Presumably they can then send this stuff on to whoever they please and god forbid, even sell it on! It strikes me that there isn't much incentive to distribute things this way. How is Microsoft going to prevent the above scenario Is there going to be a ...Show All

• SQL Server Evenly splitting output in SSIS

  I would like to split the data stream so that 1 copy can be sent to a lookup task, and the other can be sent as input to another target. There doesn't seem to be a way to do this in SSIS; but maybe I should be considering other options Can anyone suggest a way to copy data to two different sources ...Show All

• Windows Live Developer Forums No Themes Tab!!!!!!!!!!

  I clicked Customize but there was no "themes"tab, I checked everywhere on my space in edit mode but theres no themes tab ANYWHERE... my friend told me to click "module" when the customize box shows up, but there isnt a 'module' tab.. Can someone please help me with this thanks ...Show All