John Oliver (UK)MSP, VSIP's Q&A profile

• .NET Development DateTime select problem

  hi ppl, im using a datatable.select method to filter a datatable, i have a datetime column and i have 2 dateTimePickers. Im doing the next: string date; date = String.Format("Fecha >= #{0}# AND Fecha < #{1}#", dtPickerDesde.Value.ToShortDateString(), dtPickerHasta.Value.AddDays(1).ToShortDateString()); rows = dtFacturas.Select(date); //rows is my DataRows array i dont know why it throw me exception with some dates and with some others it dont for example, when the string is like this: Fecha >= #31/07/2006# AND Fecha < #01/08/2006# thres no problem but when its like this: Fecha >= #31/01/2006# AND Fecha < #01/08/2006# or this: Fecha >= #28/02/2006# AND Fecha < #01/08/2006# it throws an exception, and much m ...Show All

• Visual Basic what do the pros use to validate input?

  hi i now try to validate my input using if else, but i end up with alot of andalso, how do the pros do it i am tring to validate an ip address, so ... i did like : ' to ensure 1st oct of IP is between 1 & 254 & the rest between 1 & 256... if firstOct > 0 andalso firstOct < 255 andalso secOct > 0 andaslo secOct < 256 ..... it seems ineffective as it contains alot of andalso stuff, is this correct well you could make a function which handles the inputs you give it, and give it say between the ranges to check. Example private function IsValidRange(byval valueToCheck as Integer, byval rangeFrom as Integer, byval rangeTo as Integer) as boolean if valueToCheck > rangeF ...Show All

• Visual Studio 2008 (Pre-release) Automation & ToggleButton

  I have an custom ToogleButton and I want to have an Invoke interface " IInvokeProvider" How I can implement this interface into my control. I use System.Windows.Controls. Thanks If I understand your question correctly, I believe it would look something like: public class CustomButton : ToggleButton, IInvokeProvider { void IInvokeProvider.Invoke() { OnClick(); } } Hope that helps, Kent ...Show All

• Smart Device Development Device ID Data Type

  Hi All, I want to be able to uniquely identify a mobile device. I've discovered that devices have a Device ID but is only accessible via the Win API through PInvoke() calls. The article I found is here: http://msdn2.microsoft.com/en-us/library/ms172516.aspx PInvoking is not a problem for me. I actually found this article through a message board where someone actually had problems using it. 1) Is this article up to date and compatible with WM 5.0 devices Most Importantly 2) Is the device ID a GUID Or is it something else The article indicates it converts the final result into a string not a native GUID. This doesn't actually mean that the string doesn't contain a GUID though. I haven't run it through yet to see, but I do ...Show All

• SQL Server Having problems finding Sql server with VS 2005

  I have upgraded to VS 2005 and using SQL server 2005 express. I have the SQL server up and running using the managment tools and have created a small simple database. I want to connect to it using the Server Explorer window in visual studio but it does not appear I have had it sometimes but when i do I am unable to attach or select any databases that are there Can anyone tell me were i am going wrong Is it because i have upgraded from an older version The server create and lets me add record to the tables i make, visual studio loads and i can create pages but making them talk is proving hard when it shouldnt. any help appreciated. Nick PS the error i get is: Could not find row in sysindexes for database ID 5, object ID 1, index ID 1. Run ...Show All

• Visual Studio Express Editions Tutorials!

  can anyone help me find a tutorial that teaches you how to make an FTP Client, all the ones i have so far found are for older versions and the code doesn't work (by older versions i mean like vb5-6) nor will vb.net convert it form me.... anyone who can find me one....ummm....gets a cookie...or....sumthing like that.... - Josef Stalin http://www.freevbcode.com/ShowCode.asp ID=4655 - example FTP client ( VB.NET) http://www.developer.com/net/vb/article.php/3424121 - article about writin a FTP client in VB.NET more : http://www.google.com/search hl=en&q=FTP+client+vb.net&btnG=Google+Search And remember - G o o g l e is your friend ;] ...Show All

• Visual Studio Team System n mi Upgrade database to specified version in automated build task

  We are using team build to run a nightly build and deployment to our test environment. We are thinking about to create a DBScripter.exe app to upgrade our Oracle DB to the specified version. It will look for change scripts and handle the upgrade of the database to a specified version. What can be a good approach to integrate this in the build process I was thinking about calling this at the BeforeCompile Event and the Exec command. But if the return code is less than zero from DBScripter.exe I want to cancel the build. How can I check for the return code and cancel the build if there is any error I would also thinking about using the assembly info task to apply a custom build number to the assembly files. How can I access the buil ...Show All

• SQL Server populate catalog Full Text Search SQL 2005

  Hi To All I'm trying to populate catalog in SQL 2005, but it doesn't work because in tables there are ntext fields. In SQL 2000 it works normally. I've made some test in both sql server. Why Is there something to set in sql 2005 Thanks Bye I had a similar problem when I was creating my first catalogs.. I found that you can index a table and tell it to start a population but unless you enable the fulltext the catalog does not populate. Can you verify that fulltext is enabled for the database and the table Right click and select properties for the database... I don't remember exactly where it is but is should be selected. For the table, right click the table... choose full ...Show All

• Visual C# Attractive UI design

  I'm developing a desktop application with C#. I want to make the user interface attractive and different from usual. Is there any site where I can see some samples of attractive UIs. Thanks. Hi, I have been using this component and its realy greate. Professional UI ...Show All

• Visual Studio Team System TFS and .net websites don't work together?

  Hi Guys, While creating Team project, it's reading config values from c:\InetPub\WWWRoot\Web.config file. If I remove that file, it will give me TF30177 ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=923532&SiteID=1&mode=1 ) error. But if i keep that file there(c:\InetPub\WWWRoot\), than my .net web-sites stop working. (It gives error for config values as it seems like it reads from c:\InetPub\WWWRoot\web.config location.) Questions: 1. Why TFS read from only c:\InetPub\WWWRoot\ location 2. How can i change web.config file's (for tfs) location 3. Is there any another way to resolve this Thanks in advance. Thx Luis, Server Application Pool ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Hows It Going?

  Hey Guys, I'm not really much of a Game Maker myself, but I like to look at other people's progress. Hows it going Are you guys working on any games Got any screen shots Share them, please. :) Speaking for myself, XNA has really sparked my interest in writing games -- because now the task seems manageable. I've always had trouble with C++ (all those nasty pointers), but XNA uses C#, which I find much easier to use. XNA also makes it easier to use DirectX. I've already made a pong/hockey game in XNA; it took me about a week. Before XNA, I never would've finished it. :) So, personally, I think this is a great development, and I applaud Microsoft for giving us hobbyists a chance to produce something people might actually like to pla ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. TextureEnabled error

  Hello! I have a strange problem: Here is the simple code: foreach ( ModelMesh mesh in this ._islandModel.Meshes) { foreach ( BasicEffect e in mesh.Effects) { e.TextureEnabled = false ; e.LightingEnabled = true ; e.EnableDefaultLighting(); e.World = Matrix .Identity; e.View = this ._camera.View; e.Projection = this ._camera.Projection; } mesh.Draw(); } if property TextureEnabled equal to false all is rendering fine(without texture), but if i switch its value to TRUE i have an error: An unknown error has occurred. The result code was -2147467259. The same problem with VertexColorEnabled property May be someone can help Video-ATI 9250. ...Show All

• SQL Server Link to Data

  I have a superbase database i like to link to sql server 2005. MS access is not working. How do i link a ODBC data connection into SQL Server. You can either use the create a linked server for the datasource and then acces it via the four part name with the following syntax SELECT * FROM LinkedServername.Database.Schema.ObjectName (Those parts that don’t exists on the target server can be left out like LinkedServerName...ObjectName if applicable) ...or you can use the OPENROWSET function which can take a connection string for adhoc querying ...or you can use the OPENQUERY function to use a linked server to query for (if you want to do more than just querying some data from tables like executing ...Show All

• SQL Server Skipping Rows with OPENROWSET

  I was wondering if anyone happen to know how to skip the first and last row within a fixed length file i saw the firstrow and last options but they dont seem to work. SELECT top 10 * FROM OPENROWSET ( BULK '\\servername\e$\text.txt' , FORMATFILE = '\\dbservername06\e$\test_format.fmt' )   Any Thoughts Thanks DM So you tried the FIRSTROW, LASTROW options like: SELECT top 10 * FROM OPENROWSET ( BULK '\\servername\e$\text.txt' , FORMATFILE = '\\dbservername06\e$\test_format.fmt', FIRSTROW = 100, LASTROW = 200 ) And why didn't it work What was the results you got Did you get any errors ...Show All

• Visual Studio Team System Prohibiting a user from reviewing their own work item

  I have a a field on a work item called "Reviewed By" to manage code peer reviews. To this field I have put entries into the ALLOWEDVALUES list that correspond to people who are allowed to do code peer reviews. However, I want to exclude the current user from that list if they are one of my peer reviewers; i.e. they can't peer review their own code. I've tried putting the value "currentuser" in the PROHIBITEDVALUES list, but the user wasn't exlcuded from the Reviewed By drop down. I've also tried creating a dummy field in the work item that has the value "currentuser" copied into it. When this is displayed on the work item form it has the correct user name. However, the entry isn't excluded from the Reviewed By ...Show All