xplosiv_1's Q&A profile
SQL Server Updates too ineffiecient to call from C#
I'm trying to analyze a 2-Table Select Statement and compare to variables. if x > y then do math and run an update command if y > x then do other math and run update command It's very slow.. about 1 record a second. I haven't used store procs yet, but from what I understand, should increase performance. However, I'm having a difficult time tracking down any examples of this simple procedure as a SPROC. I could try using Managed Code in SQL 2005 and writing the sproc in C#.. but that has a learning curve all it's own. Can someone either point me to a SPROC Tutorial online, or outline the basics for the above function above.. it's too late to go to Borders and the Library didn't have any SQL books not chec ...Show All
Silverlight (formerly WPF/E) Image formats?
What image formats are supported Is there a reason GIF is not supported Again I've run into a situation where nothing would render and yet no error handler was called. This time apparently it's because there was an <Image> element with a "Source" attribute referring to a GIF file. It's very frustrating to try to work with WPF/E when it doesn't provide feedback for cases it knows it can't handle. In this case I rather doubt it's an XML validation error. So why isn't the error handler being called I can understand if the WPF/E implementation at this stage doesn't support some image formats. And I can understand that the documentation isn't complete. But I'm surprised that GIF files appear not to be supported, given ...Show All
Visual C# Printed .NET Framework Class Library for 2.0
I was wondering, Microsoft Press put out a multi-volume print version of the .NET 1.1 Class Library Reference in 2003. I've inquired Amazon and Barnes and Noble technical support to see if there was a .NET 2.0 reference available, and I've already looked at Microsoft Press' published books list. I know that all of it essentially is available on MSDN to anyone, but having a professionally printed version from the source would be truely beneficial to have. I find most online versions of books, even those well organized and indexed such as O'Reilly Safari Online library not good enough to reference and learn from unless you somehow can get yourself to concentrate on a screen for hours on end. Books seem to be less impacting on your eyes, crea ...Show All
Visual Basic SQL Procedure - Parameter count
Is there any restriction in the Parameter count for the Stored Procedure I can sense the restriction with the Data type. If any parameter count restriction is avaiable where can i tract such information. I'm searching in the Product Features document... YOu can get the maximum limit of the sql server 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx ...Show All
Windows Live Developer Forums adCenter API Production SSL Certificate Change February 21, 2007
On February 21, 2007 at 7:00 P.M. Pacific time, the Microsoft adCenter API production environment will receive updated Secure Sockets Layer (SSL) certificates. This maintenance will take approximately 1 hour. The maintenance is necessary because the existing production SSL certificates are set to expire on February 23, 2007. We recommend that you do not run your adCenter API applications during the upgrade. After the upgrade, we believe that applications written in languages other than Java will not require any other action, but you should test your applications to make sure they work after the upgrade. There is no effect on the sandbox environment for this upgrade. If you are using Java, you must take the following action AFTER t ...Show All
Smart Device Development library load failed
after build my cab file and when i'm trying to deploy it on pocket pc this message view library load failed Please see this, items 7, 9, 10, 17. http://www.danielmoth.com/Blog/2005/03/please-read-before-posting-to-ng.html ...Show All
SQL Server what is the best way to do this search?
what is the best way to do this search I want a stored procedure which can serach in any of the filled form on my C# windows application. The textBoxes are: txtFileNo txtIDNumber txtContactNumber txtName txtBuilding txtBlock txtBox txtEmail I want SQL Server to search for any fiiled text, so if the user enterred txtName and txtEmail this it will onlt search for txtName and txtEmail. I know how to do this directly from the form but I want to perform this using stored procedure. The error is in here: DECLARE @sql_string varchar(4000), @sql_param varchar(4000) to DECLARE @sql_string nvarchar(4000), @sql_param varchar(4000) And it should work... ...Show All
SQL Server Enable and disable websync.log
Hi, is there a way how to enable / disable logging on web merge synchronization into the file websync.log The file exists in the ISAPI folder, on some machines there are some messages, on others there is nothing. There are Timeout messages on the client during synchronization and we need to find where is the problem, if it is on the server side or if it is a network error or something else. Thanks, Pavel ReplIsapi Settings: Property Value SNAC version (sqlncli.dll) 2005.90.1399.0 Logging Enabled FALSE ...Show All
Smart Device Development Xml validation
I greetings to all, threre is an effective way to validate XML in CF I tried to validate it using XmlReaderSettings but it is not effective. So someone knows how to validate an XML Greetings. Hi thanks for your help. I only copied the file in the same directory of the exe. I tried to launch this example before local to my computer (by double clicking on the .exe). And it doesn't give any error. When I try to deploy it on the device it doesn't found the file but they are in the same folder... Please help :) Grettings ...Show All
Game Technologies: DirectX, XNA, XACT, etc. LoadGraphicsContent for Game and Component - What is the best practice...
Hi, I've followed the spacewar example and put the call to new ContentManager in the LoadGraphicsContent of the Game. Because I need to use the content manager in some of my components I have made it a static property on the top level game. I can call now call upon the content manager from the LoadGraphicsContent method within my components and load textures and stuff as required. However, it seems that the LoadGraphicsContent of the components are being called before the one in the Game. What is the best practice with regards to setting up the ContentManager, and using it within the Game and Component's LoadGraphicsContent. Any ideas Kind Regards, James Hmm, didn't think about tha ...Show All
Visual C++ Using CTS in RS232 Comm
Trying to send data using a COM port to a device that uses CTS to control data flow. Using OpenFile and WriteFile. Setting the dcb.fOutxCtsFlow seems to have no effect on the output stream, the system sends out characters when CTS is not asserted. Thanks for any help, Bob but when i use GetCOMMModemSatus function, it always return 0, and the error code is 995. So could you pls tell me what kinds of cases will cause this function returns error Does it have relationship with BaudRate Thank you! ...Show All
.NET Development System.Net.WebException
I'm using the following function to try to determine how long it takes for a file to download from a webserver. private void btnDownload_Click(object sender, System.EventArgs e) { //**************************************************** Uri uri = new Uri(" http://cslibrary.stanford.edu/107/UnixProgrammingTools.pdf#search=%22unix%20filetype%3Apdf%22 "); System.Net.WebRequest wr = System.Net.HttpWebRequest.Create(uri); System.IO.Stream stream = wr.GetResponse().GetResponseStream(); int b; int counter=0; string strResult = string.Empty; DateTime BeforeDlTime = DateTime.Now; while ((b=stream.ReadByte())!=-1) { strResult += System.Text.UTF7Encoding.UTF7.GetString(new byte[] { (byte)b },0,1); ...Show All
Visual C++ Compile C++ code To .Bin File
Hi. can I compile C++ code with VC++ or VC.Net to a BIN file How thanks. Hi again and I'm sorry I'm late! I have a Microcontroller that must be program. my programer needs a binary file. ( *.bin) the *.bin file has no Header .( I checked it ) and this is difference within "BIN" files and other type. cause this code run on processor . ( there is no Operating System!!! ) and if my file has Header ( like exe,... ) it won't work. ( if I rename exe to bin. ) but I can't compile my C++ code to a binary file (*.bin) what should I do ...Show All
Windows Forms Web Browser Control Stealing Focus
I'm afraid I've had a small problem with Visual Basic.NET (2005) and its Web Browser control. I have a small chat program I'm developing. The browser displays the text of the chat (specifically tag-board), while a textbox is used to input the text and send it to the server. The problem occurs after interacting with the browser control in any way: Right-clicking, clicking, highlighting, tabbing to, etc. After any interaction with said control, everytime the browser is forced to refresh (I have a 3-second timer that checks for changes in cookie data, forcing a refresh if there is), it steals focus from whatever other control I happen to be using. Any combo boxes, or textboxes, or buttons automatically give up their focus to the browser's upd ...Show All
Visual Studio 2008 (Pre-release) Model generation wizard working backwards or is the programmer backwards? :)
I have a table (again, using the video game stuff as my sample to play with): ID Title Description Rating (int, refers to the ID column in GameRatings) Type (int, refers to the ID column in GameTypes) Rating and Type both have foreign keys that point to the source tables GameRatings and GameTypes respectively. I have Associations in my Entity model that have produced classes called FK_VideoGames_TitleRatings and FK_VideoGames_VideoGameTypes. That all appears fine. However, I don't appear to have any navigation ability to allow me to do things like: game.Type.Name or game.Rating.Name Is there something I missed in the DB to allow for this automatic member generation, or, if the wizard doesn't do it, what do I have to do to my pre-generated ...Show All
