Welcome to MSDN Blogs Sign in | Join | Help

May 2009 - Posts

Monday, May 11, 2009 2:04 PM

How use Convert in a DataTable select?

How to use Convert() when doing DataTable.Select ? Sometimes you may need or want to select out a number of rows from a DataTable using the LIKE operator, this is no problem on a column with a string type. But what if you wish to do it on a column with,
Posted by maspeng | 1 Comments
Filed under: ,
Friday, May 08, 2009 1:55 PM

Msg 7399 - The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "<linked server>" reported an error. Authentication failed.

I’ve seen this one a few times lately. In SQL Server there is a linked server to Access\Excel etc. Most of the times it works well, however, every now and then we get this: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "<linked server>"
Posted by maspeng | 1 Comments
Filed under:
Thursday, May 07, 2009 4:32 PM

A simple example on how to get Return and Out parameter values using Ado.Net

Another short one. How to capture OUT and RETURN parameter values from a stored procedure in .Net. Well, I’ll let the example speak for itself. First create a stored procedure, this just take an in parameter and an out parameter, it declares a local variable
Posted by maspeng | 1 Comments
Filed under: ,
 
Page view tracker