Isabel_ve's Q&A profile

• Visual Studio Team System How customizable is TFS?

  Hi, Just wondering how customizable is TFS... For example, what if I wanted to add new state values in the Status section on the Work Item Detail tab Is there a table I can INSERT new values The same goes for Discipline values... Thanks, - gshaf What you need to do there is to modify the workitem in question and add the values that you would like to use. There are many posts out there on the topic. I would also look to MSDN for Process Template Customizations. You do not actually modify the sql tables. This will get handled when you import the new workitem. You will want to get familiar with the WITexport and WITImport commands.These command line utilities allow you to export and import the workitem t ...Show All

• SQL Server Storing query results in SQL table

  Hey guys/girls, I was wondering if there is a way to store the report query results into a SQL database for use within an application. I would like to have the query information used in the report updated to a SQL table for later use. The other catch would be to deploy the information to a separate datasource location than the report is using (because the information will be stored in a different location than where the report is gathering information. Thanks! BJ Hi, sure. the easiest thing would be to use a stored procedure which would insert the results first in a table and then afterwards within the same procedure insert the data in a persisted table. HTH, Jens K. Suessmeyer. --- http://www.sq ...Show All

• Visual Studio sgen.exe exit with code 1

  hi folks, can you plerase help me with the above error! I've reviewed the comments in a similar thread and carried out all the actions to no avail. My solution is made up of a Winform project which accesses a Web service in the solution. I've removed/added the web service and the problem project, to no avail. Please help.   Thanks Hello everybody. I'm also experiencing the same problem, but I's only when I've signed the assembly. Or when I've checked the "Sign the Assembly"-box and added a snk-file. If it's not checked, then it compiles without a hitch. I'm no expert in these things, but I thought maybe someone would find that interesting. Have a nice day. Rune G. ...Show All

• SQL Server System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host.

  Hi all, I use Assembly .LoadFrom("test.dll"); to dynamically load a dll in a SQL CLR pocedure method, but I get this error: System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host. Any idea Thanks in advance. As the error says, you can not do it. You are not allowed to load a user assembly from anywhere but the database. Catalog your assembly in the database and call Assembly.Load("asm_name"), and it should work. Niels ...Show All

• .NET Development HELP! Change the database at runtime?

  I am building a winform app that needs to be used to create/edit numerous Access databases. I have created all of the datasets using the tools in VS2005 to create my objects to bind to my forms. I found the connectionstring in my appconfig and it points to my dummy/prototype MDB just fine. I have created a Open function that allows me to select the Access MDB that I currently want to work with. How do I change the connectionstring to talk to talk to this MDB instead of the one set in my app.config. I tried creating a new string and telling the XSD file to use this file, but the XSD keeps reverting back to it's default value for the this._connection = string. Suggestions or Ideas Thanks all! David Hi, "You are ...Show All

• Visual Basic in my vb.net windows application i have a requirement of automatically pressing the prtscr button

  in my vb.net windows application i have a requirement of automatically pressing the prtscr button in the key bord form every 5 minutes i am using the timer control but i dont know how to do automatically pressing the prtscr button event my requirement is to taking screen shots for every five minutus for every five minutus i am using the timer control and i dont know how to execute the button press of prtscr button for every 5min You don't need to push the button. Use the code from these threads: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=874972&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=644666&SiteID=1 ...Show All

• Visual Studio Express Editions Copy image/graphic from panel/drawing surface to richtextbox

  I have the following code which allows freehand drawing using a mouse. It uses a panel as drawing surface. I will add the ability to load background images on the panel so can draw on that bmp. Now after all the drawing, I want to ensure its one image, a bmp, copy to clipboard then paste it into a richtextbox on another form in the program. Now attempting this I have tried several approaches. None have worked at all. The online tutorials or samples to study I can find are many years old and many version of basic ago. None work of course. Here is my base code for drawing. Any advice, or directing me to a tutorial, sample, or a reference book would be greatly appreciated. From what I read, this should work. There wa ...Show All

• Visual Basic Formula construction

  I have a big problem here, I am writing an application that requires that the user have the ability to construct their own pricing formula for different items and have managed to store that formula in the database, the problem is... How can I read a resulting formula string as a formula I.e: (BuyingPrice * (100 + VATpercent) + 10) BuyingPrice = 40 VATpercent = 17.5 I can return the string "40/100*(100+17.5)+10" but can't find a way to process it and return the result (57). Any ideas will be greatly appreciated guys. The following is the VB implementation of this code, you'll need to add the reference to Microsoft.jscript.dll and there is a obselete warning which is generated fo ...Show All

• SQL Server Minimum config to upgrade 2000 to 2005?

  I am trying to upgrade from SQL Server 2000 Developer Edition (SP4) to SQL Server 2005 Developer Edition. I want to be able to use Reporting Services in the 2005 version. But the 2005 Upgrade Advisor says: Reporting Services is either not installed or is installed incorrectly. - Virtual directory settings do not match the default configuration - Custom virtual directory settings block edition upgrades - Custom extensions are deployed on the report server - ASP.NET account information is encrypted What do I need to install from the 2000 product in order to be able to upgrade to the 2005 version Daniel, thanks for your help. I'm on the (very) low end of experience with all this. >1) Have you modified the IIS settings for either ...Show All

• Visual Studio Can a build ever end without a OnBuildDone event?

  I currently have some code in my Addin that relies on a build ending with a OnBuildDone event.  Does anyone know of any situation that may cause a build to end without a OnBuildDone event   It seems like most of the typical exceptional situations (user cancels build, build fails, I kill build process) throw a OnbuildDone event.  However I am starting to suspect there are situations where this isn't the case... Any info or pointers on where to find the documentation on this sort of stuff thanks! ...Show All

• Visual Studio Tools for Office Question regarding creating, saving and emailing EXCEL document

  Hi, I am using C# and VSTO to populate an EXCEL document from a database. I then want to email this EXCEL document as an attachment to a specified number of users. Everything works except when I try to open the attachement. I receive the following error "The file could not be accessed. Try one of the following: Make sure the specified folder exists, Make sure the folder that contains the file is not read-only, Make sure the file name does not contain any of the following characters.......". I tried sending a file, .xls and .txt, that already exists and the attachment opens up correctly. I think VSTO is not properly closing excel before emailing it. Does anyone have any ideas on how to fix this Below is the code: ...Show All

• Visual Studio VS2005 not recognized during Extensions for Framework 3.0 install

  I am attempting to install "Visual Studio 2005 extensions for .NET Framework 3.0 (WCF & WPF) November 2006 CTP" (vsextwfx.msi) but keep getting an error: "Setup has detected that a prerequisite is missing..." and lists several products including VS 2005 Standard, Professional, Team System as options for the prereq. I have VS2005 Team Edition w/sp1, framework 3.0 RTM, and have the workflow foundation (WWF) installed, but it seems my install of VS is not being recognized. I had this one installed once a couple of months ago, but then removed it later. Now when trying to install it again, because I have just realized that the .net 3.0 prerequisites gone missing from my setup project, the same error message ...Show All

• Visual Basic VB2k5: Error - Must declare the scalar variable @name

  Hi, whenever the da.fill(mydataset, "tb1") is executed, the error "must declare the scalar variable @name". what caused the error Dim cn As New Odbc.OdbcConnection("DSN=db1") Dim da As New Odbc.OdbcDataAdapter Dim bs As New BindingSource Dim mydataset As New DataSet 'Dim n1, a1, ad1 As New TextBox Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click cn.Open() da = New Odbc.OdbcDataAdapter da.SelectCommand = New Odbc.OdbcCommand("select * from tb1", cn) da.InsertCommand = New Odbc.OdbcCommand("insert into tb1 (name, age, address) values (@name, @age, @address", cn) 'da.UpdateCommand = New ...Show All

• Visual Studio 2008 (Pre-release) Inherited List class as DataMember

  Hi Im trying out WCF for the first time and have hit a small snag. In my project I have a class called Passenger which simplified look like this <DataContract> _ Public Class Passenger <DebuggerBrowsable(DebuggerBrowsableState.Never)> _ Protected mAge As Integer = 0 <DataMember()> _ Public Property Age() As Integer <DebuggerStepThrough()> _ Get Return Me.mAge End Get <DebuggerStepThrough()> _ Set(ByVal value As Integer) Me.mAge = value End Set End Property End Class I then have a strong type collection of Passengers with an additional method <DataContract()> _ Public Class PassengerList Inherits List(Of Passenger) Public Function FooBar() As Boolean ...Show All

• .NET Development Accented Characters

  Hi, I have a question for accented characters. For example, when I am doing regular expression match, how can I match "A" against all accented characters "AAAAaaaaaaa" I have tried all possible options in RegexOption enum, but nothing works so far. I know in SQL Server full-text search you can setup accent insensitive, so I guess I can do the same thing .NET. Could someone please tell me how. Thanks, Ning You will need to break out all the characters you are interested in and place them into a set such as [A AAAA] to fulfill what you want to do. ...Show All