J Kenyon's Q&A profile
SQL Server Like in query
strSQL = "SELECT Naam FROM tblKlanten WHERE code LIKE '%" & str & "%'" it works in sql but doens't in sql mobile how do i solve this Thanks for replying. Everything is solved now. Cheers, Dave ...Show All
Visual Studio WindowsForms ReportViewer Control - Memory access violation when printing
Hello, When me or my users try to print from the Windows Forms ReportViewer control to a specific printer (a Konica model using PCL), the following error appears in the ReportViewerControl client area: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. It is only happening with the one printer and there are no others of that type to test. The reports seem to work with all other printers, however. Of course, the main one they need to use is the one that is not working. The error appears after choosing the printer to print to and selecting "Print" from the dial ...Show All
SQL Server Cursor versus Temporary Table
Hi All, I am writing a stored procedure in which I need to read some records from a table which satisfy given condition, fetch the last read record and check its value. e.g. SELECT * FROM TestRequestState WHERE StateId = '11' ORDER BY TestReqNo. I want to read the last record of each TestReqNo and check some values from that row. For this I was thiking of reading the above Select using a cursor and then using FETCH LAST to read the last row into some variable. But this seems to be a round about way and also i have been reading that cursor will slow the execution. IS there any other better way. Should I use temp table instead, ...Show All
Smart Device Development How to run visual studio 2005 beta 2 project EXE on a smartphone device
I am developing applications for a smartphone using visual studio 2005 beta 2. I am unable to run my dotnet exe on my smartphone device.Does it needs any framework to be installed If So,how to install and where to install that frame work Thank You, Amar. That's expected should you try to run NETCF V2 application on SP 2003 which has only NETCF V1. Make sure you're using V1 project type unless you have WM 5.0 SP (not likely unless you got hold of some engineering sample). If your device is SP 2002, it's not supported. ...Show All
Visual Studio Team System Rational Integration
We are just beginning a fairly large project and are planning to use VS.Net 2005; however, several people on the project team have had experience with Rational Rose and Rational RequisitePro, we are used to that environment, and we have naturally had no experience with the VSTeam capabilities. We are in a quandary as to whether to use all the features of Team System and/or Rational products which we have experience and confidence in. Here's a few questions - I hope someone out there is in a similar dilemna and is willing to share thoughts and ideas on this. Microsoft seems to have no requirements management tool similar to Rational Req ...Show All
Visual Basic VB6
Hi It's been a while since I've done any VB programming, and I need to get back in to it for work purposes. I've quite a bit of experience at VB 6 programming and have lots of code and examples that I need to use again. Is the latest VB development package backwards compatible with VB6 I'm sure all of these questions have already been answered so appologies for that. Thanks John Hi, Please, help me about use of multi page controls in vb. I was tried to insert multi page control into forms with two page, draw a textbox1 into page1 and second one into listbox now i want to set to property for te ...Show All
Visual Basic Concurrency Problems
I am currently developing an app in Visual Basic 2005. I am using the following code to save changes to the database. Me .Validate() Me .BindingSource.EndEdit() Me .TableAdapter.Update( Me .DataSet.DataTable) However, when the SaveItem_Click event is triggered a concurrency violation is reported: System.Data.DBConcurrencyException: ConcurrencyViolation: The UpdateCommand affected 0 of the expected 1 records The error message only appears when I attempt to apply changes to certain records - in all other cases the update method is successful. If anyone can throw any light on the matter I would be very grat ...Show All
Windows Forms Windows form's Closing Event taking long time
A windows form has 12 tab control’s pages. Mostly pages have a grid control, some .Net control (text box, combo box, label, and buttons) and user controls; on each tab we have a different DS. Popup windows are also open on some tabs. Some time when we visited the all tabs and fill all grids, form closing event takes long time (40 - 50 sec). Actual the MyBase.Dispose method in Form generated code is taking this long time. 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) & ...Show All
Smart Device Development Smart Decive for VS 2005 Express
Is it possible to create a smart device application using any of the VS 2005 Exprees editions ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Preventing memory leaks
Hello, I am trying to make my project clean and so I am looking for memory leaks reported by DirectX debug driver. The problem has two parts: 1) if I set a "Break on AllocId" in DX configuration with Id obtained from previous program run where DX reported memory leak, project is stopped on absolutely unrelated piece of code - is it possible that it takes some time for DX to stop it when it catches a problem how can i find the exact location could this be because of I am running it multithreaded 2) I discovered that even such calls as SetStreamSource, SetIndices, etc. throw a memory leak if they are not "unloaded" by th ...Show All
Smart Device Development SQL CE Licencing - Syncronization
If using syncronizing SQL CE to MS SQL Server what licencing is required. Is it only an extra client licence per device connecting to the SQL Server Thanks. Yes, you'd need SQL Server 2000/2005 CAL for each device (or per CPU license). ...Show All
Visual Studio Team System TF42046: The build service used in the build process is not reachable.
Hi all, Am using the beta 3. I have been struggling with this issue for the past 24 hours. From what I read there can be multiple reasons for this error message. I have experimented and verified the settings mentioned in this link: http://geekswithblogs.net/mskoolaid/archive/2005/12/15/63276.aspx suggestions on resolving or debugging further can help. A couple of other things I am noting: 1. As I see from task manager, the TFSBuildService.exe starts to run, that at least rules out problems with port configuration error. 2. I have enabled tracing in TFSBuildService.exe.config. But I don't see the buildmachine.log getting cre ...Show All
Visual Basic I just want to learn Visual Basic.... Can't find "Windows Application' Template
Hello all, I am trying to re-learn programming after a long hiatus, so I decided to start with the newest version of Visual Basic(VisualBasic 2005). I am trying the 'Create Your First Application' Tutorial, and it tells me to go to File>New Project and choose 'Windows Application'. This isn't an available choice... My choices are: 'Class Library', 'My Movie Collection Starter Kit', 'Screen Saver Starter Kit', and 'Search Templates'. Am I supposed to download the 'Windopws Application' template from somewhere('Search Templates' turned up no results.) Is this my first test to see if I am worthy of using a Microsoft product Or am ...Show All
.NET Development Data drops when reserializing XSD.exe-generated classes using 2.0 framework.
I gen my XSD /classes with no reported errors, then deserialize my sample data using XmlSerializer. The data structure looks exactly as expected in the debugger. Then I reserialize with XmlSerializer and, again, no reported errors. The output is valid by the schema. I can reserialize it if I like using the XmlSerializer objects, for example. The output just happens to be missing a bunch of elements (it's a lax schema, minoccurs of everything is zero, so this is valid). On inspection it seems to be serializing just the string-valued elements--not the longs, dates or enums. I've tried various types of output to no avail. I've been goo ...Show All
Visual Studio Express Editions website expression validator
hi all..... how can i check the website whether it is in valid format / type when user input the webiste url in the textbox.... the code below is used to check email expression Regex.IsMatch(txtEmail.Text, _ "^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\] )$") = False but i can't find out the website expression in visual baisc....... please let me know if anyone got the solution.... thanks hehehe, There's another really good way to do it. Take advantage of a couple of the small black boxes: This is ...Show All
