Vegar Imsland's Q&A profile

• Windows Forms Is setup.exe only for the prerequisites?

  I want to stop my users being able to install my app if certain pre-requisite software is not present, but I don't want the publish.htm page to tell them they can click the install button to have the other sw installed (because users don't have such privileges). How do I do that You could replace the VS-generated publish.htm with a file containing the info you want it to. See the following thread for details: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=928621&SiteID=1 ...Show All

• SQL Server Connection switching to "sa" login

  I have seen some strange behaviour where a connection flips from the login it connected with to use "sa". I have evidence of this captured in a .trc file, where you can see a particular SPID being used (via Management Studio) under a windows login, then for some reason the login name changes to "sa" for a couple of queries, then changes back to the windows login. Has anyone else noticed behaviour like this It's starting to cause me real hassle as it shows up on our Audit reports, when we're only supposed to use "sa" in emergencies only. Could you please file a defect report for this on the Connect site ( http://connect.microsoft.com/sqlserver ) Defects reported by customers on the Connect site g ...Show All

• Visual C# Patch creating

  I build a new version of Setup Project in Visual Studio 2005. Before installing I should uninstall previous version even if single file was changed. Does exist the simple way to create patches for installed .NET Applications A previous discussion is here ...Show All

• Microsoft ISV Community Center Forums end loop at non numeric or empty cell in excel

    I have fixed it! Do not need help on this anymore.   Hi, Why can't the below code not recognize a non numeric value in array y_disp y_disp 1 2 3 4 k j = 0 jj = 0 For j = 0 To i - 1     temp_d = y_disp(1, j)     Do y_disp ar > delta_d         If Not IsNumeric(y_disp(1, jj)) Then GoTo End_         If IsEmpty(y_disp(1, jj)) Then GoTo End_         jj = jj + 1     Loop Until Abs(temp_d - y_disp(1, jj)) > delta_d ' delta_d is given a numeric value earlier in the code Thankful for ideas \Jonas ...Show All

• .NET Development XML Compare

  Assume that there is a XML String such as <Page> <id>1</id> <versionnumber>1</versionnumber> <title><b>This is a test</b> to check</title> </Page> assume the above xml string is version 1 <Page> <id>1</id> <versionnumber>2</versionnumber> <title><b>This is a test</b> to check new version</title> </Page> assume the above xml string is version 2 now is there any way in .net using C# where we can compare OR find the difference between the two versions shown above for the tag "title". Please let me know. Thanks in advance Because you mentioned ...Show All

• Visual Studio Express Editions background worker arguments

  Hello all, I feel as if the answer to this one will be an "oh, why didn't i think of that" . Here goes anyways: I am trying to run a background worker and I need many variables passed to it as opposed to the one that it seems to normally be able to accept. In C i could just use a structure and pass that object, is there an equivalent in VB I tried passing in more than one variable, the methods are not prepared to accept more than one. Thanks, and try not to make me feel too stupid Sorry, in VB: Dim myInt As Integer = 42 Dim myString As String = "text" Me . backgroundWorker . RunWorkerAsync ( New Object () { myInt , myString }) and ...Show All

• .NET Development TableAdapter vs DataAdapter

  Hi peolple, Can someone tell me the big difference between TableAdapter and DataAdapter I have an application in VB.net 2005 express that connects with a ACCESS database. My querys will be mostly SELECT querys (looking for key in a table). Once in a while I will need to use sql command like INSERT INTO, and don't know if the TableAdapters Querys support this (I have tried with no success). Using the TableAdapters may be simple, but I have many problems with this solutions and the way of solving this was to delete the TableAdapters from the forms editor. I could not edit the DataSet in the Dataset Wizard. The problem was that all stored TableAdapter querys were lost, and I have to do all the work again... I want to cho ...Show All

• Visual Basic efficient storing and programming for data (moving from another forum)

  Rebuilding an application from DOS to Visual Basic, I have several questions, mainly concerning storing the (relational) data (SQL). If I want to reuse code, I could use classes. I.e.: there are employees, customers, company's. They all have names, adresses, phone numbers, etc. I could build a class with these fields and create other classes which reference to this one. But how do I save the data stored in the objects created from the classes to an SQL server By programming to populate each and every field of database with the data in the objects This doesn't seem very efficient. And if I add a field, I have to rewrite the code. Could you just store the entire object as a record in the database Databinding is another option, but then I al ...Show All

• Visual Basic DateTimePicker Question.

  Hello. A question, please. How can I clear a datetimepicker in execution time I'd want to show spaces. Thanks... Ok well if you want to make a datetimepicker control display nothing change the Format property to Custom and the CustomFormat property to " " (Blank wont work because it will revert to the default Short Date thingy) ...Show All

• Software Development for Windows Vista Truly Dynamic Runtime Activity Property Nirvana

  I'd like to acheive "Truly Dynamic Runtime Activity Property Nirvana". My most critical custom workflow activity needs to expose a list of items that is not known at custom activity compile time. Each item in the list can be bound to from other activities - this is a pretty powerful concept for our workflow application that makes it very useful for end users that design their own workflows with my custom activity. I've figured out a solution where this dynamic custom activity is possible but it involves dynamically generating / compiling a brand new custom activity class on the fly - not the prettiest solution and I'm trying to create a better solution. Ghenadie has a neat example of how to create dynamic properties here ...Show All

• SQL Server SQL Server 2005 Enterprise Cluster Installation Fail (Error 29503 & 17058)

  When the setup program tries to start the database service (the last step of installation), it indicates an error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (17058) Any help would be appreciated. Solved after several tries. Seems that the problem is the user running the setup program cannot be the cluster service account. ...Show All

• SQL Server trouble with trigger

  having trouble with my trigger, I'm sure it's totally logical behaviour but need help making it do what I want. FOR INSERT AS /* IF UPDATE () ...*/ insert into Account1 (CustomerID,[transaction],[date],total) SELECT i.CustomerID, i.paymenttype, i.paymentdate, i.payment FROM inserted AS i LEFT OUTER JOIN Account1 AS a ON i.CustomerID = a.CustomerID WHERE (i.CustomerID = a.CustomerID) This trigger inserts info into "Account1" table, and is fired on insert into "payments" table. Unfortunately it's doing something I don't understand. For example, Say I have an invoice that equals 4.20. with invoiceid 1 and Customerid 1. If I add payment to invoiceid1 customerid1 in the amount ...Show All

• Visual Studio Express Editions Link Resource Image to PictureBox

  I have several pictures in the Resources File of my application, and have made several forms. What I would like to do is autogenerate a thumbnail on a button for each image, and when someone clicks on the thumbnail I would like it to open Form2 and fill the PictureBox with the appropriate image from the Resources File. I cannot figure out how to do this though, and so would appreciate any help that anyone can give me. 1) I would like my application to create a thumbnail of the appropriate JPG Image. 2) When someone clicks on the button / thumbnail I would like to open Form2 and fill the PictureBox with the appropriate image. I am able to open the form, but I cannot seem to open the image. 3) I would also like to know how to arrange it so t ...Show All

• Visual Studio Urgent:How to control number of records to display in a webpage

  Hi All, I am new to web applications using .Net, I have used crystal report a alot in desktop applications, but I am facing following problem when I am using it in webapplication. Actually Webpage has unlimited height, therefore what I want is all records from the Crystal Report should be displayed in a single webpage, but it is automaticaly breaking the records at 15 and displaying 15 records per page. Is there any way by which I can achieve, displaying all records (say 1000) on the same page irrespective of the page size used in design. Thanks in advance. Chandrakant I think you can set the SeparatePages property of the viewer to true or false. Try changing the default value, and see if th ...Show All

• SQL Server Problems with merging raw files opened as variables

  I have a group of parallel dataflow tasks that produce raw file outputs that I then want to merge together in a subsequent task. I use variable names for the raw file outputs because I want to the path to the files to be easy to configure for different deployment environments. Therefore, I've got a package scoped variable called pkgRawFileFolder and in each of my parallel tasks my raw file destination is derived from another variable scoped at the task level, called tskRawFileOutput which is evaluated as an expression equal to [User::pkgRawFileFolder]+"/RawFile_1" or similar (the name of the rawfile isn't important as long as each parallel task uses a different name). In the container task that performs the merge, I want a Foreac ...Show All