Ron Luebke's Q&A profile

• Visual Studio Team System Variable foreign key generation ratios

  Is there a way to generate foreign key values in a non-uniform way If I have a sales order table and a child sales order detail table and I set the generation ratio to be 10:1, every sales order is going to have 10 detail lines. I would like to have some variance where sales orders have anywhere from 3-12 lines, for example. Thanks Henry for taking the suggestion. I only wish there was direct support now. :-) Alle, thanks, I will try your suggestion and see how it works. I would like to avoid messing with my foreign keys just to get this to work though. Another thought just came to mind as well. It might be possible to employ multiple data generation plans (without clearing the data in between) w ...Show All

• Visual Basic Unable to add winsock library to project

  I'm migrating a project from VB6 to VB.net. This project uses winsock. I want to initialize a socket. But after migration, I'm unable to start socket thru WSAStartup. I'm neither able to add ws2_32.dll / wsock32.dll to my project nor reference them in any other way. WSAStartup(257, sWSAData) results in 10014. sWSAData is empty and I dont know how to initialize WSAData structure Microsoft.Net.Sockets.Socket is strictly speaking more like the Winsock control that you have in VB6. It is lower level then say TcpListener and TcpClient . Depending on what you are trying to do, either choice may be better. If you want something that mimics the raw Winsock stuff, then use Sockets. If you are ...Show All

• Internet Explorer Development cookies question

  hi guys, for example, when an user access and log on our website site1.br.com , user will fill out a form and it would store the user information (such as user email address) to cookies in local machine. If the same user tries to access site1.br.com again then it will use cookies to remember the website setting. Now let's say that we want to bring a mirror web site site2.br.com (identitcal to site1.br.com) online. if the same user tries to access site2.br.com, cookie will be unavailable because the first time cookie were stored in site1.br.com, thus user will need to fill out information again for cookie to be saved for accessing site2.br.com the next time. Is there a way to store cookies for both site1.br.com and site2. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. how do you assign an integer for a sprites position?

  Yeah... my question is basicaly the title. Don't really understand what you mean here. But a sprite has a x,y position so just assign it. pos.x = 64; pos.y = 32;   ...Show All

• SQL Server basic SQL question

  I'm not sure if this is the correct forum or not, but I have a basic question. Currently we have are doing calculations via stored procedures and then returning the results back to the client in either a web page or a winForm style application. There are times that the stored procedure takes 20 minutes or 3 hours to run. Now, our database person says that all the calculations needs to be removed from SQL and put in either the web applications code or the winForms code (based on what is calling it) the db person also states that SQL is not intended to do any kind of math (calculations) and they should all be done in the application. I think the calcs should be done on the db and its going to take 20 mins to 3 hours for these things to run n ...Show All

• Visual Studio Hiding row containing subreport

  Hi, I'm having a subreport in a row. Initially I'm setting the Visibility-Hidden value of the row to false and Visibility-ToggleItem to a field in a different row. I would like to hide the row when there is no data in the subreport and also avoid the toggle icon. Is this possible If so can someone explain how. Any help is appreciated. Thank you. Ajay ...Show All

• Visual Basic Problem returning from dialog box subroutine

  I must be missing something very basic here. I have a text box in a dialog box and want to warn the user when he clicks OK and the text box is still empty. The code below takes the path that I want when there is no text in the text box, but for some reason, the dialog box exits anyway even though the Me.Close() function is not executed. There must be some way to validate the entries on the dialog box after OK is clicked but before the subroutine exits. What am I doing wrong Private Sub OK_Button_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK_Button.Click If NameTextBox.Text = "" Then MsgBox( "You must enter a name" , MsgBoxStyle.Critical, "Status" ) ...Show All

• Visual Studio Team System How to add new folder to Team Query Hierarchy?

  Hello, I want to create (hierarchy) some folders inside Team Queries to orange the view in team explorer. How can I do this Thank you Edit did not work for me - it complained about file extension association. Anyway, I normall just do drag and drop on another WI form or query window, it works just fine for me. -Mohammad ...Show All

• Visual Studio 2008 (Pre-release) When I throw exception from a server, the server crashes!

  For example when the login fails, I throw the exception, but it seems that the server itself crashes! Do I need to do Duplex Hello, For example when the user tries to login, for instance call SetLogin(login), if it cannot the SQL Server creates an exception when calling Open on ADO.NET. This exception thrown or other exceptions, for example if a sql server throws an exception, must be caught in the client and shown appropriate messages. But it seems that the client receives Service.ServiceModel.FaultException and nothing else. For example I enter a wrong password for login anf the server sends this error to the client:System.ServiceModel.FaultException: The server was unable to process the request due to an internal error. For ...Show All

• Visual Studio Express Editions How to put a hyperlink in Visual Basic .NET 2005

  I am trying to do something that seems so simple, but I cannot get it. It is annoying me to my limits. I am in need to add a Link Label to my form and hyperlink it to my site. I have been programming for quite a while in Visual Basic 5.0 where link labels were non-existant. Now, I need to figure this out. The program is finsihed, so I added the Link Label etc, but now how do I hyperlink it to my site so when the person using the program clicks the link, my site will open in IE (or their default browser) Thanks P.S. - I know the link from the help files to the Microsoft MSDN library. It is too confusing for me to understand, and I don't really believe I need 2 pages of code for simple little tiny link. Please help, it is greatly a ...Show All

• Visual C# having trouble calling System.Management

  Hi, I use the Viusal C# Express edition. As far as I know the 2005 version that I am using is based on .Net 2.0, so it should have the System.Management namespace. However, I can't use that namespace... There is no intellisense or anything that popos up after I type it out... Do I need to have a server version of the OS to have System.Management Thanks, Ke Hmm... I added in the dll manually... but still won't work. If I try to compile it would say: Error 1 The type or namespace name 'Management' does not exist in the namespace 'System' (are you missing an assembly reference ) C:\Users\Ke\AppData\Local\Temporary Projects\WindowsApplication1\Form1.cs 8 14 WindowsApplication1 With the code like thi ...Show All

• Software Development for Windows Vista Assign a different Item for each task in a task replicator

  Hi, i made a task replicator in my workflow and i'd like to know if it's possible to assign different item (document) to each task. In the object SPWorkflowActivationProperties i saw the Property item, itemId and itemUrl. So it's easy to change the item of the workflow. But in the object SPWorkflowTaskProperties there is only the Property TaskItemId. During the execution TaskItemId Property is set by default to -1 and when i change it, it doesn't change anything. The task item is still the Workflow Item. asked me if you need more explanations. Thanks Sam I don't manage to find the answer. Do you think I have to do a workflow for each item(document) Is it possible to start a wo ...Show All

• Visual Basic Label - Multiline. [Amended].

  Hello. A question please. I'd want to fill a label with different texts. Theses texts can have 2 lines. Can I set the number of characters in each line of the label Thanks... Hi, Do the following instead.>> Drag a textbox to your form. Set the following properties to TRUE. ReadOnly=True MultiLine=True Then drag the vertical height of your textbox and adjust the width to suit the font and text you are using. Adjust the textposition property to Center if you want too. In code textbox1.text=" This is line 1 " & VbCrLf textbox1.AppendText(" This is line 2 ")     Hope that helps   Regards, S_DS   ...Show All

• Commerce Server Item-Level Discount Problem

  I'm pretty new to Marketing Manager and I would like to know if it is possible to setup the following discount Buy 2 items on any product and get $5 off the price of this product. I tried different discount types and always had the same problem. The total discount value is correct but the discount distribution is not. For example, if I add two items of Product A and two items of Product B, I get $10 discount for one of them and $0 discount for the other rather than having $5 discount for each. The Properties Window of the OrderDiscount component allows you to select between applying the discount to the most expensive items first or to the least expensive items first and there is a custom option as well but none of the ...Show All

• SQL Server Export import dataset/ stored procedureS?

  Hello. I am making an application that works towards SQL Express database. These Stored procedures are saved in database. I need to use these SP in another database that I have. Is it possible of exporting these and importing to my new database well you can either copy and paste the stored procedure into your new database, as you created in your original database, or copy and paste the stored procedure into the query editor (if there is one in SQL Express) and execute the query, which will create a stored procedure in the selected database. You may need the management tool, im unsure but here is a link to it: http://msdn.microsoft.com/vstudio/express/sql/ http://www.microsoft.com/downloads/de ...Show All