BReisch's Q&A profile

• SQL Server Return Job Status

  Although this should be painfully obvious, I cannot seem to figure out how to return the status of a job. I want to use something similar to the following to control the execution of a statement based ont he status of a Job. DECLARE @intStatus int EXEC msdb.dbo.sp_help_job @Job_Name = 'jobname' If @intStatus = 4 Begin <execute statement> End What I don't see in the above is how to set the variable @intStatus to the returned value ...Show All

• Visual Basic Help Need Here very Highly Please....

  Hi all , I am a user of visual basic 6.0 and visual basic 2005 express edition i need to get a information about the BindingNavigator ; my Question ; in the BindingNavigator how can i say the navigator to go to a specific number of data for example.... BindingNavigatorPositionItem if i can change this item to 2 or to 3 i can say that is ok for me so i can say that goto the 2 data or third data an that is what i want but when ...Show All

• Windows Forms Cannot assign ImageList in Beta 2

  It appears that the Imagelist property is no longer available on the toolstrip.  Yet, Image Key and Image Index are still available programmatically.  Is there any way to assign Imagelist or has it been removed permanently from toolstrip   If the latter is the case, what is the recommended way to assign images, ie. via local resource or use project resource file and is it possible to reference them directly via an index ...Show All

• Visual Basic How can i use nullable (of t) to handle nulls in DateTime

  Hi, As we all know the Datetime in vb.net 2003 cannot handle nulls. I see that there a system.Nullable (of t) How can I make use of this in order to handle nulls in datatime. An example will be appreciated Thanks a lot.That is exactly the kind of thing i was looking for. I will use it as a base to create generic functions. I wish there were links or books on the matter. Thanks again for taking time to answer my ...Show All

• Visual Studio 2008 (Pre-release) Installing WCF - Certificate_Fail

  Hi! I'm trying to install the Februari CTP but get stuck at the error: [06/05/06,09:47:59] WinFX Language Pack - SVE: dlmgr: Certificate_Fail: CDownloadJob::VerifySignature() : winfxlangpacksv.exe is not signed by Microsoft, and therefore is deleted. Any clues Regards / Michael Sorry for the delay in getting back; since this is an old post, we're marking it complete. Have not seen this issue on t ...Show All

• Visual Basic How to print a paragraph?

  I tried to print a paragraph using .net printing but it exceeds over the margin. How can i make this paragraph to word wrap when i print it Use one of the versions of graphics.drawstring methods that accepts a rectange, or rectanglef. You can use the graphics.measurestring to figure out the size of the box. ...Show All

• SQL Server The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect

  I've read the other posts related to this issue, but I'm just REALLY confused as to whats happening in my case. Like everyone else it was working fine in SQL 2000 but now in SQL 2005 there is an issue. I'm calling a stored procedure with parameters defined like this: @action varchar(10), @GLTransactionID int = NULL OUTPUT , @GLBatchID int = NULL , @GLAccountID int = NULL , @CurrencyID int = NULL , @LocalDebit decimal(28, 13) = NULL , @LocalC ...Show All

• SQL Server connecting using "datasource=localhost"

  hi all, i'm running VS2003.NET with SQL2000 on XP. when i try to use "datasource=localhost" in my connection string- i get "SQL server does not exist or access denide". (local) works and "=myServer" (server name) works. my hosts file is as it should be. i'm trying to connect to the server on my machine. i use to have no problem with it in the past. i think it all went to **** when i changed my machine's nam ...Show All

• .NET Development Problem using select for find a record in dataset

  I am trying to find a record in dataset using select but it isn't work when i run my application show this error message "the especified conversion it isn't valid." my code is: Dim strFilterCriteria As String strFilterCriteria = "Nombre = '" & _ TextBox1.Text.ToString & "'" Dim tablavendedor As DataTable '= New Vendedordataset.VendedorDataTable() Dim filavendedor() As Vendedordataset.VendedorRow tablavendedor = Ve ...Show All

• Visual Studio Team System Build always checks out most of 'Bin' directory? (VS2005 Team Suite RC1)

  I searched a bit for this, but VS2005 Team Suite has been checking out most of my 'Bin' directory each time I open OR build my solution. Has anyone seen this before Is this simply an option that I have forgotten to turn off or is this a bug fixed in RTM Its a very annoying behavior, because often I just want to build the solution and don't have any pending changes, but because its checking out everything all the time it picks up all the Bin and ...Show All

• Visual Studio Team System How to: Add Data Binding to a Web Test

  According to this walkthrough: http://msdn2.microsoft.com/library/ms182546(en-us,vs.80).aspx I should be able take values from a Table Column and use them as values for QueryString Parameters. In my case, I want to use them as Form Post Parameters instead of QueryString but either way, I get the same result: First, When I add the Data Source, the thing says something like 'Invalid Object' when I try to run the test, My data Source is Adve ...Show All

• SQL Server Need help splitting out columns for each row into new table

  Let's say I do a select statement and the results are Acct #     Zip          Phone                 Addr 11223     23232      333-444-5555      6556 Duns Rd. 12345     34343      222-444-3333      1000 Aspire Blvd. I need to create a record using the Acct # and column for each column as well a ...Show All

• Windows Forms Binding Comboboxes to custom lists

  I am running .NET Framework 2.0 B2 I am missing something when it comes to implementing databinding in custom classes. I have a view class that acts as my main data source. The view class basically just loads up the data and returns via properties and BindingLists of NameValuePairs (which is just a replacement for KeyValuePair so that databinding will work) The view class also maintains current properties that tell me what the current selected i ...Show All

• Windows Forms MDI Merging /w ToolStrip and ToolStripContainer

  Hello! Using Whidbey Beta 2 I built a simple MDI App with Menu- and ToolStrip-Controls on the Parent and on the Child. If the Child Form is shown, the MenuItems and the Tool-Items itself  are correctly merged with the main Tool-/MenuStrips placed&nb ...Show All

• SQL Server SSIS & SharePoint Lists

  Hi, is there any example how to extract values from a SharePoint list I searched in Google but I only found something about that someone failed using the web service task for it... If possible I would like to get around any custom .net code (Scripts would be OK), but if I can't get around that, I have to follow that path... Thanks, I would prefer doing something which is supported...On the other hand direct OLEDB would be ...Show All