Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Windows Forms >> Windows Forms Sample Applications

ParamArray - SqlHelper

In the Microsoft.ApplicationBlocks.Data SqlHelper Class that comes with TaskVision, there are quite a few ParamArrays. I never knew about this and I think it's totally awesome for a Data Layer. Is there a way to do the same thing in C#? Or is this a VB only thing?
[265 byte] By [codefund.com] at [2008-2-20]
«« ParamArray
»» Anyone have components to sell?
# 1
I know we were just talking about this, but I thought I would post anyways.

I rewrote the DataLayer from Taskvision in C# and in the place of the paramarray I just passed an object array.

Instead of:

DAL.ExecuteNonQuery(MyConnection, "MyTable_Insert", Param1, Param2)

it looks like:

DAL.ExecuteNonQuery(MyConnection, "MyTable_Insert", new object[]{Param1, Param2})

codefund.com at 2007-9-8 > top of Msdn Tech,Windows Forms,Windows Forms Sample Applications...
# 2
SqlHelper is downloadable from Microsoft in both VB.Net and C# versions. It's part of Microsoft Application Blocks for .NET, of which there are 2 Application Blocks.

1. Data Access Application Block Overview
Chris Brooks, Graeme Malcolm, Alex Mackman, Edward Jezierski
Microsoft Corporation

April 2002

2. Exception Management Application Block Overview
Kenny Jones, Graeme Malcolm, Alex Mackman, Edward Jezierski
Microsoft Corporation

April 2002

codefund.com at 2007-9-8 > top of Msdn Tech,Windows Forms,Windows Forms Sample Applications...
Windows Forms
Windows Forms Sample Applications

Windows Forms Hot Topic

Windows Forms New Topic

Windows Forms

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified