leo1's Q&A profile

• SQL Server Union Support

  Hi there, I am facing a very strange problem. When I try to read data from my Xml based DB using XQuery (or XPATH), it shows me an error message that xQuery union is not supported. I really want to use union (|) in my XQuery and currently I am using query() method. So, is there a way by which I can execute my query Regards Salman Unfortunately we don't support the XQuery union operator in SQL Server 2005. As a workaround you can use the sequence constructor as follows: /a | /b can be rewritten as (/a, /b) The main difference between the union operator and the sequence constructor is that the union eliminates duplicate nodes. You can achieve this by adding /. after the sequence constructor because / operator elimin ...Show All

• Visual Basic Interop Forms Toolkit 1.0 | Wrapper

  Hello Everybody here, Interop Forms Toolkit 1.0 seems to be very nice. Unfortunately the VB Express Edition has no Addin in the Tools menu for generating InteropForm Wrapper Classes. To do it manual seems not to be so easy... Any other possibilities With greetings from Germany Josef Hi Josef, I'm surprised that VB6 is shutting down on you...if you see an error message please let us know. The fact that you're seeing mscoree.dll is expected behavior: this is the file the .NET Framework uses to load the CLR into memory when called by COM. Basically it's the file that handles creating your .NET object for VB6. Hope that helps, Jonathan ...Show All

• Windows Forms DataGrid

  I would like to populate a datagrid during a forms load procedure... It is a static grid i.e it will always be the same. How do I insert the headers and the data in the columns and rows Thanks Mitch hmm. not sure I follow. you create your columns first.... Datagrid1.Columns.Add("Column1", "Column1") Datagrid1.Columns.Add("Column2", "Column2") you add columns and give them a column name as I have done above, column 1 and column 2. Next you create the records. The rows of data. To do this, the Rows.Add() method has an overload where you can give it an array of columns to add for that record. Dim theRecord() as Object = {&quo ...Show All

• SQL Server Printing table design?

  I am trying to print out table design information (example: PK, data type, etc.) for multiple tables within my database for documentation purposes. Is this possible and if so, how can I achieve this I use Visio for that, if you just need the plain data to do eomthing with it, you might query the Information_schema views. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms Automatic update works when turned off

  Hi, I'd like to check for and download updates programmatically. I've turned automatic updates off, and everything works as expected besides one scenario. If I check for updates manually (call CheckForUpdateAsync), find that there is new version available, but do nothing, next time user starts the application, automatic update occurs. This is the only case when disabled automatic update kicks in. Will greatly appreciate any hint. Thanks, Dmitry You are not specifying minium required versions under update CheckForUpdate maybe a better method CheckForUpdateAsync looks to download the update anyway in a background thread. HTHs, James From MSDN CheckForUpdateAsync returns immediately and ...Show All

• Commerce Server Ranking Categories under the catalog root

  I'm having trouble getting Commerce Server to accept the ranks I assign to Categories that are children of the catalog root, ie the first category level..I have a hashtable that is keyed by Category Name and contains a rank as the value, and I want to update all categories in that hashtable to be the assigned rank. The code works fine for all Categories that are not the root, but the same code is failing if I try to rank the main catalog categories (specifically it's telling me it succeeded and all category ranks reset to 0). Here is a sample of the code I'm using to accomplish the rank updates. StaticCategory parentCategory; CatalogItemsDataSet . CatalogItemsDataTable categoriesTable = null ; parentCategory = ( StaticCate ...Show All

• Visual Studio Express Editions Adding and Removing from a variable Array?

  Sorry for the beginner question but I can't seem to figure out how to add or remove values from an array of variable size. For example, this works without problem: Public Class Form1 Public config(2) As String Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load config(0) = "test" end sub End Class This however doesn't... I've tried various variations on this and I can't seem to figure it out. Public Class Form1 Public config() As String Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load config(0) = "test" end sub End Class How do I ...Show All

• Visual Studio Express Editions a question

  didnt rly know how to name the thread subject, anyway how do i make it impossible to have a certain number in a label i have my numbers generated by a Random () and if MyInt = 1 i want that 5 doesnt appear even if it says it has to appear (from my random list) i hope u know what i mean thx in advance RubenPieters wrote: MyInt is just some integer that is 1 after i click a button but i only want 5 not to appear if it is 1, and my random() goes from 1 to 15 and it puts it numbers in the label, but after i clicked the button(MyInt is now 1) once the random() goes 5, i want to not have it come on the label(everytime the random() has 5) i dont rly understand what youre saying, but ...Show All

• Windows Forms Multi language help please

  how can i add a combo box were people select the language they want and it will transform it al into that selected language any help is appreciated thank you hi It seems that there is a bug related to the resource manager: http://dotgnu.org/pipermail/pnet-developers/2003-December/000844.html The reasons are: 1) ResourceManager uses CultureInfo.CurrentCulture, but it should use CultureInfo.CurrentUICulture instead. 2) The CultureInfo.CurrentCulture and CultureInfo.CurrentUICulture getters should make an indirection to the Thread. So, the problem is that while the Thread now has the correct culture, the Resource manager does not update the values on the screen what you could do is the follow ...Show All

• SQL Server Tools for database design....

  We have several developers that design DBs using the SQL 200\2005 Database designer. What tools, of reasonable price (< $!000 ) are availabe today for database designers. IA, Barkingdog if by database design you mean data modeling - we recently selected Toad data modeler from Qwest software. Reasonably priced compared to competitors and fairly full-featured. Also works against most relational DB types, not limited to SS. ...Show All

• Smart Device Development Unable to connect to device using specific IP address

  I have a Smart Device application orignally written in VS.NET 2003 and recently converted to VS.NET 2005. When I try to deploy to my device using a specific IP address I get the "Connect to device failed" error. I can deploy using ActiveSync to provide the IP address, but this does not work for me since I need to be able to debug with a DEX cable connected to my device, I can't have it connected to the cradle. Other than the usual advice to disable firewalIs and use ActiveSync to provide the IP address, are there any useful device connection troubleshooting guidelines I was able to get VS.NET 2003 to deploy to specific IP address but it was flaky at best. I had to first deploy using ActiveSync and then change my device conn ...Show All

• Windows Live Developer Forums Client error (Invalid value for AppID in request)

  I've got two applications (separate keys) that use Msn search api and have worked for months with no problems. Now for the past couple of days calls to Msn search api started failing with: <soapenv:Fault><faultcode>soapenv:Client</faultcode><faultstring>Client Error</faultstring><detail>Invalid value for AppID in request</detail> The applications issue at most a few hundred calls per day, so I should be nowhere near the daily limit. I see other people have reported similar problems in the past. Any chance in getting this fixed Thanks, Sami ...Show All

• Visual Studio Installing VS2003 add-in programmatically or using registry file.

  Hi, In my product installation I have to also install VS2003 addin. One way to achieve this is to launch the default set up that is created by Visual Studio 2003. However I want to install the add-in dll not using the default setup. How can I achieve the same Thanks and Best Regards, Vishal Hi Vishal, Could you please specify what exactly you meant It's not clear from your question - what do you need What do you mean by 'default setup' Thanks! ...Show All

• Visual C++ color Slider Control

  Hi to All, My Requirement: i want to show a slider with color containing a range of numbers. for example from 1-100 user can pick any number. i want show the user already used number by red color, unused by blue and picked by someother guy but never used it in green color. the control is some wat like slider, so the user easily slider over the numbers and pick any number which is unused. plz guide me wat control to be used and how can i do this in vc++6.0 Thanks and Regards Amjath You may have to do some custom draw to accomplish your requirement. This article could help you to learn something related to it. ...Show All

• Visual C++ Runtime Error

  When i try to play this game called SilkRoad i always get a runtime error message is there any way to fix this problem Sounds like a bug in the game SilkRoad. Ask the game developers if fixes are available. Chances are pritty low that this forum might be of any help for you. It is a developer forum. You might be lucky that a dev of SilkRoad reads this... -- SvenC ...Show All