Join's Q&A profile

• Visual Basic what type of collection to use?

  I have a collection of type System.Collections.Specialized.NameValueCollection, which is great for getting the value of each item using either the Key or Index. However, I also need to be able to get the Name of a Key using it's index, and this doesn't seem possible with this type of collection. The only way I can see to do it is by keeping two collections going, the second with the name of the key in the first collection, that can't be right! ...Show All

• Visual Studio Express Editions Returning Newly Inserted INSTANCE ID

  Thanks in advance for any help I can get with this! I've been trying to retrieve the currently inserted rows Unique ID (Primary Key) with no success. I've tried both INDENTITY_SCOPE() and @IDENTITY. In the following example from the helps files I only ever get SYSTEM.DBNULL returned.  the help file link is for the example is ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/cpref16/html/P_System_Web_UI_WebControls_SqlDataSource_Inse ...Show All

• SQL Server Report Models using Islookup and expandinline

  I am building and deploying models. I have many small description tables, they include two attributes. On attribute is the key (which is a code or type) and the other is a varchar description.  They tables are each optionalone related to the primary table.  I am "denormalizing" the description tables using Islookup.   I change the Role in the primary table to ISLOOKUP, I modify the defaultattr ...Show All

• Windows Forms How to add button to TabControl?

  Hi all! How can I add a button to TabControl to make custom control, with ability to close tabs using button (aka Firefox-like or IE 7-like tabs) 'm waiting for your suggestions. Well, please, I still waiting for you answer. I really need this for my university project... ...Show All

• SQL Server Pkg Execution Works in VS but not in SQL

  I'm able to execute a package in VS Pro on my machine. However when I upload it to the sql server and try to execute the package directly it fails with: Error: The product level is insuficient for component "...." (3129) Error: The product level is insuficient for component "...." (5411) The first component is a DataReader Source which is consuming an ODBC (Noble Systems ATOMIX Driver) connection and the second componen ...Show All

• Visual Basic Color a datagrid cell and enum a datgrid row

  Hi everyone.. I have a datagrid in my form, with 2 columns. One of them Im trying to color it and the other one appear as readonly (gray backcolor, starting from 1 to n rows). Right now Im writing to the first column each row number, changing visible count row will avoid doing this manually The next column is the data im writing, Im trying to color the background of the cell with any color. Im using tablestyles, I declare a datagridt ...Show All

• Visual Studio Team System Setup cannot access Reporting Server

  Hi there, i'm trying to install the Team Foundation Server. When setup asked me to enter a user for the Report Server. I created a user TFSReport and added him to Administrator-group and all the sql-groups. I opened the Report-Server Configuration and configured it so that the TFSReport-User controls the service (works without any errors). Near to the end of the setup, i get the following error, that setup cannot access the SQL Report server. I ...Show All

• Visual Studio Team System Reading test data from dtatabase in methods decorated with TestInitializeAttribute and TestCleanupAttribute

  Hi All, Currently I am working on Unit Testing API released by Micrsoft as part of VSTS. I want to perform a data driven test. For this i need to read data from database in the methods decorated with TestInitializeAttribute and TestCleanupAttribute. My question is "Is it possible to read data from database in those two methods " And "If possible how I can read them " If anyone knows, please inform me. ...Show All

• Visual Studio Team System Publishing button is disabled

  I am not able to publish the test result. I have some web tests and some load tests. The solution and its project are built with no errors. After running the tests, I am able to export the results to a file, but the Publishing button is disabled. I changed the configuration from debug to release and rebuilt and it did not work. How can I publish the result Would it be possible to send the result to any form of database (SQL, Access, a ...Show All

• Visual Studio Express Editions Clarify for me...

  I'm a bit confused.. I've been playing around a little with Visual C++ Express and I've been looking for tutorials on understanding how the .Net framework works etc...but I keeping seeing reference to things that are confusing me... specifically I've seen things listed as Managed C++, Visual C++ .Net, and C++/CLI.  Now I 'think' Manage c++ and Visual C++ .Net are the same thing..but I'm not sure, and C++/CLI seems to be a whole 'new' thi ...Show All

• Windows Forms Wishlist

  Hello,  This is a great application in both commercial as well as educational standpoint.  Here are some of my wishlist: 1.  Ability to change the project on a particular task. 2. Ability to refresh instead of restarting or offline/online 3. Ability  ...Show All

• .NET Development Import from excel file

  Hello, is it possible to read from an excel file and then import the data row by row. I know ado.net what I dont know is to open the excel file, and begin iterating in rows and columns of the excel file. Thanks very much for your help.  Hi Luis,  Look at  this url: http://www.thescarms.com/vbasic/ExcelExport.asp  Will solve all your problems,  Nos vemos, Juan.     ...Show All

• Visual Studio Team System Ensuring unqiue values in a unit test.

  I have a bunch of unit test that I need to write. In each test I will be inserting some data in to a database, say a Users name. I need to make sure the name is unqiue every time I run one of the tests. In the past I used NUnit and in a TestFixtureSetup method I initialized a class variable of type Random and then used this to get the next random number to append on to the end of a users name. This has been working well. What I was wondering is; ...Show All

• Visual C# How do I write to a file on a shared drive on a another server on the same network.

  Hello, I'm having trouble finding a way to write to a file on a shared drive on a different server from where my console application is running.  I would also like to pass the credentials to access the shared drive as I don't want to have to set up the application in some group or have it added to the folders security permissions.  I thought about mapping the drive to the machine manually and then accessing the file that way ...Show All

• Windows Forms ADO - aggregate functions

  Can someone please confirm my understanding of this code snippet dtParent.Columns.Add("P5Sum", GetType(Decimal), "Sum(Child(GroupBy2Summary).P5)") This code snippet should add a column to the parent table named P5Sum, which will contain the result of the sum of all&n ...Show All