RichardSw's Q&A profile

• SQL Server sql_variant in Data Flow Task

  When I add a OLE DB Source that accesses a table that contains a column of data type sql_variant, it generates an error message saying that is an unsupported external data type and will be converted to DT_WSTR.  Since there are large values of the float data type, I am concerned that the float values would be truncated. The only way I have been able to work with sql_variant data types where two databases are involved (source and target of an insert) is using an Execute DTS 2000 Parckage Task.  I tried using an Execute SQL Task and got the same message as above.  Note that when I access the sql_variant column in an Ex ...Show All

• Windows Forms use part of name from one object as name for another object

  Hey I would like to use part of the name of one object as the name of another object Imagine I have an object called myObjectFoo1 I can remove part of that name, to myObjectFoo How do I name a different object with myObjectFoo I of course don't know the name of the object at runtime... Not really, given say an ArraylLst f different  ...Show All

• Windows Live Developer Forums Image search?

  I'm not seeing a source option for performing an MSN image search.  Google and Yahoo both provide this, why not Microsoft Thanks. Seth, Still no image search   Can you tell me if it will be weeks or months before this feature is available Thanks, Ray ...Show All

• Visual Basic Printing Checked only Checked items from Checked List box

  Hi,  I'm a beginner learning at home from Microsoft. I have The visual basic 2005 express. I am attemping a project where my page contains 3 Checked list boxes. What I would like to do is print a list possible what I think you call conatating the 3 lists together and then only printing the items I have checked. I think I need maybe something like an if then statement. And then maybe iteration to go through my List to print only checked boxes. This is what I tried ,Remember I'm a Beginner If checkedListBox1.Item is true Print Item. I'd like to look at full code for this including How I would declare my varibles since my sytem has no ide ...Show All

• Software Development for Windows Vista DelayActivity dynamic update

  Hello, I would like to ask you if it is possible to update DelayActivity.TimeDuration value when DelayActivity is executing I want to achieve scenario like this: workflow is configured to simulate delay specified in the DelayActivity. After DelayActivity starts waiting, user wants to change delay value for the running instance (increase or decrease the delay value). Applying WorkflowChanges to the running workflow instance with different DelayActivity.TimeDuration value set does not work (no errors, old delay value is respected). I was also trying to remove DelayActivity from the running workflow instance and recreate it ...Show All

• Visual Studio Team System Graphs in Team Edition for Software Testers

  Hi I have created a load test and I ran it for 100 Vusers and for a duration of 10 minutes. I have added several counters to the test. Now, in the graph that I see, in the results; I could not identify what does Y axis refer to. Can anybody please explain me what does the Y axis refer to X-axis is of course showing the time in seconds. Does the Y-axis value depend on the counter we select or is it constant for any type of counter For ex: if we select pages/second counter, I assumed that the value for Y axis indicates the number of pages received per second. Similarly when I selected the average response time counter, I assumed that at ...Show All

• Visual Studio Team System No report image in Project Portal, but do see one via IDE..

  I can see a nice chart when I use my IDE and view a report. However, with RC release, when I goto project portal, I have no image under "Remaining Work", but I do when I view report using IDE... Any suggestions You mean if you right click on team explorer to get to the portal page then you do not see the "Remaining Work report" How about if you tried to click on the Quick Launch on the left hand side of the screen where it lists all the reports do those reports work If none of the links to the reports work from the Team Site then what is probably going on is that the TfsRedeirect.aspx page whic ...Show All

• Visual Studio Crystal Reports 9 .Net Server Setup

  Can anyone assist Have been trying to deploy a website that uses crystal reports and am getting the apparently common error that keycodev2.dll is missing... Have tried all the fixes set out in the Business Objects and MS Visual Studio sites but all to no avail. Have just tried running the CR 9 .NET Server Setup on the web server and when prompted for the 19 digit licence code and being told that is not valid or had expired. The code i have starts AAP50 GS00000 and then another 7 digits. Does anyone know if this code is invalid for some reason - have just tried installing a trial version of VS 2003 and have got the same keycode. Many thanks f ...Show All

• Visual C++ (Newbie) - getline - Import/Export file

  OK There I go i'm having a Hell to understand how Import/Export file work in C++ i need to save stuff in a external file and get them later when i re-run the program. To be more specific, i would like to save ''accounts'' without using Databases. only to master Import/Export.  I just don't know how to procede I tried something with getline() but every time I enter the information shown on msdn, I get an error saying it was expecting 2 args while i've put 3 of them. My output file data looks like that  : 0001 abc123 34 2433 64354 Name Blabla 0002 gfdfg 34 6234 84434 Name blabla etc where the first 4 chars are the A ...Show All

• SQL Server SSIS Import and Export Wizard Data Sources

  I'm just beginning to use SSIS (bracing for a steep learning curve due to lack of helpful documentation) and am starting out trying use the Import and Export Wizard.  On the "Choose a Data Source" page there is a dropdown for the Data Source.  I see a list of possible data providers, but not one of "Microsoft OLE DB Provider for ODBC drivers," which is the one I wanted to use because I'm trying to connect to an obscure database.  So I figured that I need to use ".Net Framework Data Provider for Odbc."  Unfortunately, regardless of what I enter for the Connection string or the Dsn or the Driver I invariably get a ...Show All

• Visual Basic searching in datagridview using textbox

  I had a datagridview which contains all the last name of a certain database.the data was displaying properly .I want to accomplished two tasks,first I want it that upon loading on the datagrid, data are sorted alphabetically already even without pressing the column header.Second I want to search the datagrid using a text box. I want like an autocomplete manner, if I type a single letter, say "B", the datagridcolumn will automatically point to the the name say "Bal" and so on...thanks once again. Here is what I would recommend: Bind your DataGridView to a DataView (instead of a Dat ...Show All

• Windows Forms forms

  Hello all..... I'm having a hard time understanding how to read/write to the contents of controls on diffient forms. If I create a Windows Form project with two forms..... add a text box to each...now I add the following code to form1..... Public Class Form1     Inherits System.Windows.Forms.Form     Dim f2 As New Form2     Private Sub Form1_Load(ByVal ...Show All

• Visual Studio Web Form Reset Method

  I'm trying to find the equivilant of the reset method on the Web forms report viewer.  The problem that I run into is that I attempt to change the data and then refresh the local report but the reports contents don't refresh.  On the window forms side I simply call the reset method. You can workaround this issue by instantiating a new instance of the viewer and swapping it for the one already on the webform: ControlCollection coll = oldViewer.Parent.Controls; int oldIndex = coll.IndexOf(oldViewer); ReportViewer newViewer = new ReportViewer(); coll.AddAt(oldIndex, newViewer); coll.Remove(oldViewe ...Show All

• SQL Server Enumerating Role Permissions with SMO

  Hi, I am attempting to enumerate role permissions using SMO. I can enumerate the permissions on a atbel, view, or store procedure no problem. When I try to enumerate the permissions that a role has I get the following error: 'Operation not supported on SQL Server 2000' Can anyone help me in sorting this out. I had the permissions enumerated in DMO but I just can't seem to get it to work in SMO. Thanks, James Hi, I am connecting to SQL2K. I have not problem getting the permissions on a table, view, stored procedure, or function. Its only when I try to get the permissions for a role or user ...Show All

• Visual Studio Express Editions How to fill this array?

  Hello, I've the following sub: Sub fVulCombobox( ByVal objCombobox As ComboBox(), ByVal strKoppel As String , ByVal booCategorie As Boolean ) 'code, etc. End Sub I want to use the the sub. But objCombobox is an array: I want to fill it with 2: fVulCombobox({cmbLocatie1,cmbLocatie2}, "bla", False) {cmbLocatie1,cmbLocatie2} is wrong .... How to do Thanks. Hi, This is just a guess. Don't currently have a visual studio in front of me. fVulCombobox(new ComboBox(){cmbLocatie1,cmbLocatie2}, "bla", False) cheers, Paul June A. Domag ...Show All