Dani50's Q&A profile

• Visual Studio Team System Data Generation issue involving Constraints

  I imported the AdventureWorks schema and trying to generate data for most of the tables. One of the challenge that I ran into involves Production.BillOfMaterials table. It has a constraint that says ProductAssemblyID can not be equal to ComponentID. I have made sure all other fields have proper rules to generate data. After doing all that, the standard data generator fails to insert because of the constraint named CK_BillOfMaterials_ProductAssemblyID. Both ComponentID and ProductAssemblyID is pointing to the same key. Is this by design Do I have to create custom data generator to address this issue I am under the impression that's the only way to correct this issue... Henry, Thanks for following through i ...Show All

• SQL Server Installing SQL Server 2005 on Windows VISTA ULTIMATE

  Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Please help. I have recieved errors when installing sql server 2005 also. When configuring the database services the first error says it cannot find a user and then everything fails after that. For the most part the only people that are loading vista rtm are developers. Will a new insta ...Show All

• Visual Basic Better ways for Reading And Writing to .txt files

  I am trying to create a bunch of records, there will be a limited number of "Codes", about 50. Each "Code" is associated with a name from a textbox, I was trying to have it save each one when you click a button, to a .txt file. So, from the start the record will be blank, the person will go through the form, choose a number from a numerical up and down box, pick a name associated with it (both of these are mandatory and not implied). When they click the button, it will save the contents I talked about into a .txt file, say the number is #2, and the name is "Bob", the next time they try to change that value for #2, it will overwrite "Bob". I am very unexperienced when it comes to file I\O. ...Show All

• Visual Studio Express Editions How to set the icon for a component

  Hi, I would like to know what needs to be done in order to associate an icon to a component to be shown in the toolbox. Also, please, how can you read the icon from a component No, you misunderstood me. I meant the icon that appears in the ToolBox. Now I know it is done with the ToolBoxBitmapAttribute Thanks ...Show All

• .NET Development Connecting to Access Database

  Does anyone know how to connect to a access database using vb.net I created the database in access and added the Odbcdataadapter and was able to preview the contents of the database. I have a text box with a next button and a new button. Each time I click next i want to see the names that i have in the database appear. When i click new i want to be able to enter a new name in the textbox and it gets written to the database i already have with the names. Any thoughts Thanks!! Here is what i have I globally declared Public theDataSet As New DataSet1 Public curPos As Integer = 0 In the next button i have If theDataSet.Tables(0).Rows.Count < curPos Then Me.TextBox1.Text = theDataSet.Tables(0).Rows(cur ...Show All

• .NET Development continuing file search after UnauthorizedAccessException error

  I want to search an perticular .exe file on all the fixed drives (c:, d:, ....) and then replace it with another same named file. I am trying to get it but could not. With try catch method the search is stopped with 'UnauthorizedAccessException'. I have given the following code Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim folder As String = "c:\" Dim pattern As String = "example.exe" Try For Each file As String In My.Computer.FileSystem.GetFiles(folder, FileIO.SearchOption.SearchAllSubDirectories, pattern) MessageBox.Show(file) Next Catch ex As UnauthorizedAccessException MsgBox( ...Show All

• SQL Server Unary operator ignored in parent-child aggregation

  Hi, I have defined an unary operator column for parent - child hierarchy. But it seems that it is considered only in sums on the same level . When rolled-up it is ignored. For example: Child1 has unary operator +. Child2 has -. I get a cube like this: Level 1 Level 2     Amount ----------------------------------------------- Parent  Child1    100            Child2     50 ---------------------------             SUM     50 ---------------------------             SUM     150 Have I missed something, or is it an erro ...Show All

• Visual Studio 2008 (Pre-release) Multiple implementations in one ServiceHost?

  I am trying to figure out if it is possible to have one single ServiceHost implement multiple endpoints (each with different service contracts) where each endpoint uses different singleton classes. I want to have my host provide services by interface like http://localhost/IMyService1 http://localhost/IMyService2 http://localhost/IMyService3 ... There are a lot of services and it is impossible to have one class implement them all. Do I have to create one ServiceHost for each class or can I somehow get the ServiceHost to use different implementations for each endpoint I am looking at IInstanceContextProvider and the InstanceContext class, but am not sure how these are supposed to work, or if they can do what I want. ...Show All

• Visual Studio Team System Work Items attachments maxsize changed, now cannot add attachments

  I changed the maxsize for work items attachments from 4Mb to 25MB. I followed the procedure outlined in the forum using the webservice. I have checked the config db and the value was updated. I even rebooted the TFS server. The problem is now whne I attempt to add any attachment I am unable to save and it tells me I exceed the supported file upload size of (0MB). I tried to change the max back to 4096 and still get the message. Is there anything else to check Is this a known problem ...Show All

• Visual Studio Express Editions How to display a specific part of a RichTextBox content in a textBox?

  I receive some data coming from a buffer and display it in a RichTextBox. The data looks like this: --------------------------------------------------------------------------------------- t1 +22.3 * --------------------------------------------------------------------------------------- i would like to only display '22.3' in my textBox. I have tried many different approaches but i really struggle. It might look easy but its not for me as I am new C#. If anybody have a idea, please feel free to help me. That would be great. Thanks Lio Hi jrboddie, I need to collect the temperature coming from a Neoptix Optical Thermometer communicating via RS232. To achie ...Show All

• Software Development for Windows Vista SetOutputFileName for GraphBuilder

  Hello, SetOutputFileName is used for a CaptureGraphBuilder. What is the equivalent for a simple GraphBuilder Thank you, Christophe, ICaptureGraphBuilder is deprecated in favor of ICaptureGraphBuilder2. ICaptureGraphBuilder2 needs a call to SetFiltergraph() in order to know what GraphBuilder object to work with. SetOutputFileName automates the process of building the graph. However, you can always build the graph manually by using IFilterGraph::AddFilter to add the filters you prefer, and connecting the pins of the filters. ...Show All

• Visual Studio Web Services.

  I am getting the following error: Unable to start debugging on the web server. The web server is not configured correctly. See help for common configuration errors. Running the web page outside of the debugger may provide further information. If I run the service outside the debugger, I get parsing errors. If I comment out (see below) the parts in the config file that are creating the errors, then I get the cannot find the application error. Does anybody know what is going on here ============================================================= < xml version="1.0" > <configuration> <!-- application specific settings --> <appSettings> <add key="DomainName&qu ...Show All

• Smart Device Development data from sql to excel document?

  Hi everyone. Iam currently building a application for a smart pc handheld unit and uses the following techniques. x SQL Server 2005 Mobile Edtion X Microsoft .Net Compaqt Framework X Visual Studio 2005 Ent, C# I have now reached a critical stage in my project were I want to read the data from the database to a excel document, this document should thereafter be easialy transported to another computer using ActiveSync. It should also be possible to edit the excel document and then get it to update the sql mobile database on the handheld device. Or does anyone have another way to solve this problem, or have done anything like this before. Thanks in advacne and have a wonderful day. AFAIK Pocket Excel ha ...Show All

• Visual Studio Team System Webplugin loads first record only

  just implemented this code from Sean Lumley's Blog . but the problem is my table has 3 records but it runs only once for first row.i dont know why can some one tell me how it will run for all rows existing in table. i m using code as it is.do i need to call Getnextrow in post web section.although i tried that 2 but no result. From testrunconfig settings i set the runcount to 5 intially it was one row per data source. 2nd my db has only 3 records so it runs my test for 5 times.which is correct. and it picks the rows in correct way. but i was expecting that when i set the datasource one row pur count and when my query "select * from table" runs it got 3 records so it should runs for 3 times. My 2nd question ...Show All

• .NET Development Junk Values getting displayed when column is NULL

  Hi, I am using Viual studio 2005 I have bound ASP.net Datagrid with a Tatable which has Null value in a particular column. But when i execute it It display some junk value for that Null column How can i set Blank to be diaplyed when the column returns Null from database in ASP.NET ...Show All