Battlekiller's Q&A profile

• .NET Development arrays to sql server table

  Using vb8, I would like to be able to programmatically save data in arrays to an existing sql server 2005 table. I've found tons of info on how to load db data into arrays but not the reverse. Can anybody offer some clues That's the point. The DataTable doesn't cause changes to occur in the database table. As I noted above, I am trying find out what needs to be used (DataAdapter, DataSet and/or DataTable ) and when. Obviously, what I'm doing is not working which is why I've asked for help.   Thanks for the info about using AcceptChanges after the for/next loop. Regarding DMan1's reply, as far as I can tell, I'm not using a TableAdapter; should I be This ...Show All

• SQL Server 'downgrade' to server 2000 from 2005

  Hi, I'm looking into how i can revert back to running my db on sql server 2000, it's currently running on 2005 and having problems. Any help/pointers would be much appreciated Refer : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=186526&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1273824&SiteID=1 Madhu ...Show All

• Visual Studio Team System ALTER TABLE: Deploying changes new column's position

  Created new database with one table. Created new project and solution. Using Schema Compare, brought in the new database schema. Added to new source control database Checked out table definition In the project, added a column to the table.  Added it in the second positition, right after the first column. Checked in table. Schema Compare project to target database and wrote updates. Now, when looking at the target database, the column I added while in the project is there, but its in a different position within the table than where I added it. Is this correct I try to have an "order" to the columns in my tables for the sake of readability.  If the system is just going to place them at the end of th ...Show All

• Windows Forms Record Begin Edit Event

  I want to enable a "Cancel Update/Add" button and Save button when a user makes any change to a record. Is there anyway to know when a user begins editing a record besides TextChanged and similiar events I have tried the RowChanged/ing of the Datatable and other events with no luck. Thanks Simmy http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=324160&SiteID=1 ...Show All

• Visual Studio How to do the Summary on the sub-reports (Cross Tab format) on the 2nd column?

  Hai..., I have designed one of my report that makes use of sub-report. The sub-report i needed is coz i want to display the data horizontally. For example, Tax1 Tax2 Tax3 20 30 40 Ok, I have added this sub-report to my actual report. Now in the main report how do i show the sum of Tax2 information. Hope my question is clear. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Components, Game.GameServices and GraphicsDevice

  I've been working on some Game Components and was following an article by Mitch Walker about exposing GraphicsDevices between Game Components through Game.GameServices . I thought I'd try it out as it would make things so much easier.So, I went through the article and implemented what was needed, but I still can't get at the GraphicsDevice for some reason. Inside my Game Component, I have: private IGraphicsDeviceService GraphicsDeviceService; public override void Start() { // TODO: Add your start up code here GraphicsDeviceService = this.Game.GameServices.GetService<IGraphicsDeviceService>(); GraphicsDeviceService.DeviceCreated += new EventHandler(GraphicsDeviceService_DeviceCreated); GraphicsDeviceService.DeviceReset + ...Show All

• Visual Studio Visual SourceSafe 2005 upload file size problem

  I'm having problems with checking in new files to sourceSafe over a certain size. Steps to reproduce the error: 1.. Created a new project and added to SS over http to my server. 2. Created a word document with a series of images until it reach 1 MB in file size. 3. Added that file to the project and checked into SS, that uploads fine. 4. Changed the word document and increased the file size to 2 MB, added that file to SS, as a new file and it fails to upload. I can see the file in the Upload folder on the server with a GUID, I renamed the file so that it will open in word and it's OK.........It just won't load into SS............without getting the "There was a failure uploading the URL...." I've changed the ...Show All

• .NET Development ReflectionOnlyLoadFrom in another AppDomain

  Is there a technique for loading an Assembly into a new AppDomain as a ReflectionOnlyLoadFrom I'm writing a utility to compare the types in assemblies. If the two nominated assemblies are in different paths but share the same identity information (i.e. Name, Version, Culture etc) I get an Exception on the second Assembly.ReflectionOnlyLoadFrom() call, stating an API Restriction on loading the same assembly identities from different paths (and fair enough!). This led me to investigate loading the second assembly into a new AppDomain, to avoid the API restriction. But, the new AppDomain only has the .Load() method, no LoadFrom() or ReflectionOnlyLoadFrom(). Is there a technique for this Cheers. Ed ...Show All

• Visual C# How to name single class instances

  Say i have a static class DX9, that holds the DirectX Device as a public variable, how would i name it Should i name it the same as the class Another example: I have a static class Player, that holds an instance of the Character class as a public varaiable. How do I name it Well its really up to you. If the class name is descriptive enough, you sure can use the class name as the variable name. If i remember, DirectX has multiple classes named as "Device", so you could name them as GraphicsDevice, Keyboard ect... But i would suggest you not to use public variables, if it is not really necessary (performance issues). Properties makes it more easy to alter the code later if needed. ...Show All

• SQL Server how to create "unsafe assembly"?

  Greetings... I'm trying to create an "unsafe assembly": USE master GO CREATE ASYMMETRIC KEY StoredProcedures_dll_Key FROM EXECUTABLE FILE = 'C:\Documents and Settings\All Users\Documents\hunter\StoredProcedures.dll'; CREATE LOGIN StoredProcedures_dll_Login FROM ASYMMETRIC KEY StoredProcedures_dll_Key; GRANT EXTERNAL ACCESS ASSEMBLY TO StoredProcedures_dll_Login; GO USE gfx_sa GO CREATE ASSEMBLY hunter_storedProcedures FROM 'C:\Documents and Settings\All Users\Documents\hunter\StoredProcedures.dll' WITH PERMISSION_SET = UNSAFE; GO CREATE PROCEDURE [dbo].[hunter_storedProcedure1] ( @symbol_id as int ) AS EXTERNAL NAME hunter_storedProcedures.StoredProcedures.StoredProcedure1 GO But on 'CREATE ASSEMBLY" claus ...Show All

• Visual C++ DLL calling static function in main app

  Hi, I'm trying to develop a pluginsystem for a project I'm working on. During inititalization of the global section in the DLL a call is made to a static function in a class named "Instantiator" which registers the plugin class with it's name in a map. However both the application and the DLL share a instance of the "Instantiator" class. I thought that because the member function are declared static that both the application and the DLL would use the same instance of the "Instantiator" class Is there a way to get the required behavior Regards, Christian Sorry about my confusing explanation. I'll try to explain a little bit more. There is a class named "Instantiator" ...Show All

• Visual Studio Team System TFS RC - Data Tier Analisys Service - Goes Down Unexpectly

  Hi! I cannot find how to troubleshoot this issue. I have a TFS RC Dual Server installation in production for about half a year by now. Since last month we are experiencing some Analisys Services problems almost everytime the TSF Warehouse y regenerated (manually or automatically). The Analisys Services service simply goes down logging: Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7034 Date: 26/06/2006 Time: 02:16:46 p.m. User: N/A Computer: TIMFUDT Description: The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s). For more information, see Help and Support Center at http://go.microso ...Show All

• SQL Server SQL Statement problem with table where there is an ID Plus Version field.

  I'm having trouble finding an SQL Statement manner of producing the result set I want from some data that is structured in an unusual manner. I have a data table with a format similar to the following (This is a test table and data)... ID - Version - TextData - etc... 1 - 1 - "Data1" 1 - 3 - "Data1.2" 1 - 9 - "Data1.2" 2 - 5 - "Data2" 2 - 9 - "Data2.1" 2 - 18 - "Data2.2" The ID column and version column is the Primary Key (both columns together), previous Version items for the same ID are like History records, and for my purpose I need to be able to only look at the most recent Version for any given ID. Neither are unique by themselves. Version has no descernable ...Show All

• Windows Forms Update Application

  Hi How dose the update system works in .NET enviroment I meen not a installing program, only a intall that will update a part of a installed program. And how do i control the version in updated program Hi well... I tryed that but it was to difficult add files (not included directly in application for ex. Mapfiles-, pdf-, dwg files etc. etc.) by the way my server and Clickonce dosen't work toghether very well, VS 2005 needs a frontpage service to work. And the service that VS needs can't be found (server Windows 2003 and frontpage 2003). ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Lock texture level and write data to stream

  Hi, Is it possible to lock a texture at a certain level and then write its data out to a BinaryWriter Thanks for any help, -Dave Excellent i see what you mean now. I have been working on it and when i try and write the data from one stream to the other i run into an access violation error. The streams length is huge, just for a simple 256x256 dxt1 texture with no mipmaps. Its length is coming in as 2147483647. Heres the code im using... BinaryWriter bw = new BinaryWriter ( File .Create(file)); gs = textures .TextureImage.LockRectangle(0, LockFlags .None); byte [] chunk = new byte [gs.Length]; gs.Read(chunk, 0, gs.Length); bw.Write(chunk); Is there a better ...Show All