ejstembler's Q&A profile

• Visual Studio Express Editions MySQL Database communication

  So simple enough, currently I'm using ODBCCommand and ODBCConnection objects to run pure SQL statements through, I've even wrote a SQL compiler to build insert and update statements for me. But I want something a little more... secure and easy. In VB 6.0 you had the RecordSet object. (DBCon fired the connection object and set the Recordset to the connection object) DBCON("SELECT * FROM TALBE WHERE ID=1;") RS.Field("Fieldname").value = "Hi there I'm in the database" RS.Update REALLY easy stuff! I loved it! I know .NET has DataSets, somewhat similar, but I heard they're slow and bulky. Do we have anything like this for C# I'd really enjoy not having to use my clunky self built SQL builder. Hi, Please ...Show All

• SQL Server Web Sync Snapshots eat up disk space

  Hi Heads up on TEMP files I've been running web Synchronisation for over a month. Just today some subscribers received a message warning of an "OS Error" could not retrieve file "dynsnapshotvalidation.tok". Sometimes they also got an error regarding low or no virtual memory. After much investigation it seems that the Web Server hosting the web sync IIS had literally no space left on the system c: drive. It also turns out that the \\Windows\TEMP folder contained over 9GB of snapshot files. It seems that when the Web server collects snapshot files from Data Server to deliver to the subscriber it creates a Temp copy on it's own local system. Unfortunately this temp data is not cleaned up and over time has jammed up the sy ...Show All

• .NET Development Ultra-fast deserialization/serialization

  Hi, I'm wondering if there is a way to speed this up: I have objects that implement the following methods: public void Serialize(System.IO.BinaryWriter writer) { writer.Write(this.price); writer.Write(this.size); writer.Write(this.dateTime.Ticks); } public MyObject Deserialize(System.IO.BinaryReader reader) { return new MyObject(reader.ReadDouble(), reader.ReadInt32(), new DateTime(reader.ReadInt64())); } That's what I use for serialization & deserialization. Currently I manage to write 10,000,000 objects in 5.5 seconds, however my Raid 0 drives can write up to 140MB/s, so I think there should be some upside left (10mio objects result in 195MB file). I guess the problem is that the .Write ...Show All

• Visual Studio DSL Tools Labs for RTM?

  Are there any labs available for the DSL Tools RTM I'd like to use this to teach a couple of students what the DSL Tools can bring. Thanks, Dennis Hi Dennis, The current release of the DSL Tools also includes a few sample DSL's. You can find them in ..\Program Files\Visual Studio 2005 SDK\2006.09\VisualStudioIntegration\Samples\DSLTools. TOne of them, the "End-End Wizard UIP" sample comes with quite an extensive document that explains this sample in detail. The sample project files, together with the document will certainly provide your students with a great overview of the possibities of the DSL Tools! Edward ...Show All

• Windows Live Developer Forums "..." displayed instead of URL in PushPin Balloon

  I have a map that loads a collection from Windows Live Local. The pushpins in the collection have been edited and the "URL for more info" field has been filled out but in the pop-up balloon on my page, the URL doesn't show up, just three dots like: . . . So, it works, but it's sort of difficult to tell that it is an actual link to click on. Any ideas I'm having the same problem with collection links as you are. I was searching for an answer and found your question. Unfortunately I don't see an answer. Did you find a solution Jeff ...Show All

• Windows Forms Mutex sharing problem

  Hi, I'm creating a named Mutex to allow 2 separate apps to access a database for reading and writing without corrupting it. I do this using: try { m = Mutex::OpenExisting("MyDatabaseSharingMutex"); } catch (WaitHandleCannotBeOpenedException^) { m = gcnew Mutex(true, "MyDatabaseSharingMutex"); } catch (Exception^ ex) { MessageBox::Show(ex->Message); } in the load of each form. I've been testing this just by making one app write whilst the other one tries to read from the database, and have encountered some problems. I'm using m->WaitOne() to get the Mutex, and m->ReleaseMutex() to release it, and even though these are always present in a pair, I still get one program hanging during the read/write process. This is the code used f ...Show All

• Visual C++ string, objects and arrays

  Hello. I need help solveing this problem... -----------------------Player.h------------------------------- 1 - #include <string> // Class Shot, struct Keys, Position and Enum Direction are all here... 35 - class Player 36 - { 38 - private: 39 - Position _p; 40 - Direction _d; 41 - Keys _k; 42 - Shot _s[]; 43 - string _m[]; 44 - 45 - public: 46 - Player(int); 47 - void SetMap(string m[]); 48 - } ----------------------------Player.cpp-------------------------- 12 - Player::Player(int s) 13 - { 14 - _p.X = 10; 15 - _p.Y = 10; 16 - _d = LEFT; 17 - _s = Shot[ s ]; 18 - } 19 - void Player::SetMap(string m[]) { _m(m); } ------------------------------------------------------------- I am getting lots of errors ...Show All

• Windows Forms Do i understand Beginedit()?

  Hi, I am trying to edit a row in my database, but the value doesn't want to stay. When I close the program and reopen it the row just reverts back to it's original value. I'm not sure if I am using begin and end edit correctly. Are they meant to save the new edited row Here's my code: Step.Email.FindByID(0).BeginEdit(); Step.Email.FindByID(0).Text = SuccessString; Step.Email.FindByID(0).EndEdit(); Step.Email.FindByID(1).BeginEdit(); Step.Email.FindByID(1).Text = FailureString; Step.Email.FindByID(1).EndEdit(); Step.Email.AcceptChanges(); (Step is my Dataset) Hi, Thanks for replying! My program just keeps crashing if i remove Beginedit() and endedit() saying 'C ...Show All

• Silverlight (formerly WPF/E) How to connect & retrieve data from DB in WPF/E ?

  Hi, Is there any way to connect to DB in WPF/E and retrieve data from DB If YES, then please let me know how is it possible   Thanks, Santosh Kalkeri AjaxPro http://www.ajaxpro.info/ for the javascript to C# ease Then Subsonic for easy database access http://www.codeplex.com/actionpack . Now bake at 500 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Xbox 360 Headset

  Hello, i want to know if and when how, i can use the Head set for the Xbox 360 game i am developing. Any help would be greatly appriciated. i'm interested in this too. the key is if we get access to the actual headset audio stream if so, then we could wire those to commands in the game. granted, i'm pretty sure SAPI does not run on the 360, so you'd have to write your own custom speech recognition engine. something like this : http://www.brains-N-brawn.com/noReco/ for more advanced speech reco, i'd look into porting CMUs sphinx project. the latest version was written in Java. Thanks, casey ...Show All

• .NET Development Writing a hex value to a stream

  Hello Everyone, I am trying to hex value to a stream. What is the easiest way of doing it I tried the following and a lot more but some reason I can not get it to work BinaryWriter bw = new BinaryWriter(fs); bw.Write("\uc080"); I want the c080 to appear exactly i.e it should be 0xc0 0x80. But the value seems to be getting converted to the dec value. So what would be the best way of doing this Thanks in advance Or this, if you don't want to risk encoding problems: FileStream fs = new FileStream(@"c:\temp\test.bin", FileMode.Create); fs.Write(BitConverter.GetBytes(0xC080), 0, 2); fs.Close(); Beware that output is little-endian so 0x80 appears first in the file... ...Show All

• .NET Development finalize new columns added to a table

  I can't seem to get column changes I make to a datatable to appear in the database. DataColumn col = table.Columns.Add(); // set col parameters adapter.Update(table); But nothing gets updated. How do you update a table when you insert or delete columns Can you explain a bit more about what you are trying to do Are you trying to add a column to the table in your database, or are you trying to update the value for a column that exists in the database table but wasn't in your original table.Columns collection Thanks, Marcelo - MSFT This posting is provided "AS IS" with no warranties and confers no rights. ...Show All

• .NET Development xml validation

  hi, i have to validate xml document in different scenarios. 1) when xml document changes into message 2) when message changes into xml document 3) when xml document loads into database 4) when xml document comes from database i learnt there are two options 1)validating it at the time of loading into the object 2) after loading of xml into object in this link http://msdn2.microsoft.com/en-us/library/ms998559.aspx using xmltextreader to validate xml document is better than using xmlvalidation reader mentioned. how it is possible One link that is very related to your problem: http://msdn2.microsoft.com/en-us/library/system.xml.schema.xmlschemaval ...Show All

• Visual C# Strange behaviour re. the IDE

  We have a winforms application and some of the forms have properties etc. When viewing certain forms, sometimes the 'ErrorForm' we have created pops up like it would at runtime saying a property has not been initialized, it actually pops up as a window like it would show at runtime Also I note after some changes to a separate project, namely adding a static class with a static method that returns a connection string. We can no longer view certain user controls as the IDE shows with the following error One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The ConnectionString pro ...Show All

• Visual Studio Express Editions Getting original settings

  Hello, I have problems trying to get to the original settings of Visual Express 2005. I normally use: tool->Import and Export settings and then use reset or import original settings. I thought this would fix the problem, but not.. I obtain the same settings and not the original ones. Would it be possible that the original settings of visual express 2005 are corrupted by my own settings Where can I find original ones I just want everything new, as it was when I installed visual express the first time... thanks for your help cesar Im not sure which settings your referring to, however if they remain after uninstall and removing those config files, then they must be in the registry. Visual Studio appears ...Show All