dvboom's Q&A profile

• Visual Basic Passing Parameters ? and LIKE with Table Adapter

  The following examples DO work in Query Builder (dataset designer) but DO NOT work in Preview Data for the tableadapter or at runtime using "FillBy". There seems to be an issue when using , wildcards and LIKE together: SELECT     ID, ClientName, AR_ID, ContactList, AssignedSalesRep, LastTicketDate, AddressList, PhoneList, State, City FROM         ConXitClients WHERE     (ClientName LIKE N'%' + + N'%') SELECT     ID, ClientName, AR_ID, ContactList, AssignedSalesRep, LastTicketDate, AddressList, PhoneList, State, City FROM  &nbs ...Show All

• Visual Studio Team System TFS not seeing all accounts properly

  I'm having multiple issues that all seem to point to TFS not seeing all the accounts it should.  First up, when I run reports, I get the following errors: An error has occurred during report processing. (rsProcessingAborted) Cannot impersonate user for data source 'CurrituckDS'. (rsErrorImpersonatingUser) Logon failed. (rsLogonFailed) For more information about this error navigate to the report server on the local server machine, or enable remote errors Secondly, the list for the "Assigned To" dropdown doesn't include a large majority of the accounts that should be in the Team Foundation Valid Users group.  For at least on ...Show All

• Visual Studio Express Editions why is vb.net printing so difficult?

  Hi, I have loads of VB6 apps I am trying to migrate to VB.net and the biggest problem I have is that printer.print has no equivalent in vb.net Can anyone tell me a simple way to print in dot net Thanks That ok with fixed strings "yada..yada.." but what to do when we have a neatly formated datagridview of say a balance statement and I need a print out of that....I am having a real hell now ...Show All

• Windows Forms IExtenderProvider and Design Time Attributes

  How do I apply design time attributes to my IExtenderProvider class's properties that it's providing   Do I put the attributes on the Get or Set method, or is there another way   I have an IExtenderProvider that provides a property thats a collection.  I want to apply the DesignerSerializationVisibility.Content attribute to the property, but there is no pro ...Show All

• Visual Basic Retrieving data from an excel file?

  Hi, I am trying to retrieve some data from an excel file. The only problem is that the excel file is not a normal one. I'll explain how the excel file is: Details of RSL Details of Agent RSL name Agent name RSL Address Agent ...Show All

• Visual Basic Mathcad DLL

  Can I write a Mathcad DLL using Visual Basic 2005 Maybe making one from a class The last VB program I wrote was in VB6 and I've never written a C program, so I am very new to this. I have to make a function available to Mathcad and I only have very old C examples. Hi Bill, Welcome! Yes...... Here's an example with instructions on how to put a DLL together. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=214754&SiteID=1 ...Show All

• Visual Basic Getting the last number of a column

  How can I get the last number of a column in a certain table of my database.I had a form that was bounded to this table that has an autonumber field.To be able to add another record and automatically add the autonumber, I want to get the last value in the table to be able to increment it by one when i click the add new button.thanks.... An identity column adds itself, by definition. You can do a select TOP(id) to get the highest number there, or if you were to write your insert as a stored proc, you could have it return @@IDENTITY, which would be the value you inserted into the identity column. ...Show All

• Windows Forms Viable click-once scenario?

  I am an experienced win-forms developer (but not it asp.net). I have an application scenario where I am wondering if click-once deployment would provide benefit. Basically, it is an internet web/html based training program that needs to launch a local 3D simulation environment (based on the Gamebryo gaming engine). In a perfect world, this is how I would like it to work: 1) User runs through the training web pages, and gets to the simulation portion of the training 2) The user is presented with a web page containing a button to launch the simulation executable 3) The system determines if the app exists on the local machine, and if not d ...Show All

• Visual Studio How to use the crystal report viewer 11 to insert in VS.net 2005 beta 2????????

  Hello All, I installed VS.net 2005 B2 and than installed Crystal Report Development Edition 11 now I should use the reportviewer tool of Crystal Report 11 I don't see it on toolbox of VS.net. Crystal report 11 have Reportviewer11 sperate or use Reportviewer of VS.net 2005 Thanks, Starfo Hi, I've searched the Business Objects website to no avail. There's no mentioning of a new VS.net component or something. But there's a Release 2 on the Crystal Reports XI. I'm not quite sure if it already supports the VS2005. But lets just wait for the release and see... cheers, Paul June A. Domag ...Show All

• Windows Forms Directory.GetFiles

  Hi, How can I GetFiles in directories that are in the directory I chose as the path  For example: Directory.GetFiles("C:\", ...); when I do this, it will only search in c:\, how can I make it to also search in the directories inside  (Program Files, Windows, etc...) Thanks Fun with recursion.  Here is a little sample of how to traverse&nbs ...Show All

• SQL Server Report grouping question

  Hi all, I am brand new to using reporting services. I am having a problem creating this simple report. Here is what I am trying to do: 1. At the top of each page on the lefthand side, I went to print the customer name. 2. Under the customer name, I want to print all the product this customer purchased. 3. I also want to be able to change the column widths for the product fields. Presently, if I click and drag the the column lines. the customer name field is also being made smaller which I don't want. 4. I want group totals for each customer. Some of the above things I sort of got working. But the biggest problem ...Show All

• SQL Server How to 'attach' an existing .MDF file to the local SQL Server

  I have a data file, call it Data.mdf, that I am accessing through Visual Studio. It does not show up in SQL Server 2000 Enterprise Manager. How can I get it assigned to, or imported into, the local server so I can manage it Thanks Glen   hi, Just put your database file (Data.mdf and Data.ldf) to "C:\Program Files\Microsoft SQL Server\MSSQL\Data" folder. Open your SqlServer 2000 and  then right click on the "database" select "All Tasks" then select "Attach Database'". Locate your file from the specified folder above. Then that's it. hth, Michael Castillones ...Show All

• Visual Basic Visual Basic 2.0

  Greetings. I use Visual Basic 2.0 to teach my kids a bit of programming. I do have Visual Studio Express - but it won't run on all my school PC's - while VisBas2 is small and quick!! BUT it doesn't have any help files . . . . I want to keep showing these kids good coding but I haven't found anything as small and quick as VisBas2 . . . . with helpfiles! Any and all suggestions gratefully accepted! Cheers, David If VB Express is too big for ya (1.3Gb w/ help files) there is a non-microsoft product out there called KPL (kid's programming language): best off all - IT's FREE! http://www.kid ...Show All

• Visual Basic Listbox update problem - easy one, i guess

  This should be an easy problem, i bet there is someone who can help me. I'm a begginer, so thanks in advance! I'm working in VB 2005 Express. The problem is: in one form there is a listbox with a MS Access database source, and in the other form si a datagridview throug which users change that particular data. Datagridview control works and updates perfectly, but how can I update (or refresh ) listbox in the first form after the changes have been made What is the method and syntax for this (When I close the program and start it again, listbox is fresh and updated, but I would like to do ti without restarting.) Thaks, Tomislav ...Show All

• Windows Forms Adding a DataSource property to my Control

  I want to add a DataSource property to my control that, at design time, will allow the designer to drop down a list of valid datasource components just like the DataGrid control.  The type on the DataSource property is just 'object', so I know it isn't that.  Is there a special designer attribute I have to use on my property ...Show All