DataSet HasTables Method

-
DataSet Extentions.
Add Methods to Objects.

So, it's getting me tired to always right:
     if (ds != null && ds.Tables.Count > 0)
to make sure that a certain dataset really has tables inside.

So here is an extension I added to the DataSet object:
        public static bool HasTables(this DataSet ds)
        {
            if (ds != null && ds.Tables.Count > 0)
                return true;
 
            return false;
        }

Simple, yet efficient :)

Elad Shalom,
CTO at ITweetLive.com

Comments

Post a Comment

Popular posts from this blog

Linked Files in Visual Studio 2010

-
Image
File Linking, File Sharing and Shared Projects. You know how it feels to have shared files on VSS? Gooood . Actually it felt so good that my beloved CTO (who said something about promotion?) switched to TFS just 4-5 months ago.  And ever since - I cry myself to sleep every night. Instead of one file, shared between 5,6,7 or 10 projects, we now have a copied file for each project.  This is due to Microsoft "Best Practice" which says - No Shared Files . Meaning...? If I have a JavaScript file called Arrays.js.  It's all purpose is to handle arrays in JavaScript.  This file exists in 6 different projects, which mean, that if I have another addition to this small JavaScript library, I have to copy it to 6 different files in 6 different projects... JUST SHOOT ME!!! Finally, I have the fix we've all been waiting for, courtesy of VS 2010: "Add File As Link" How to Link Files to Different Projects: Let’s say we have 2 completely dif
Read more

Advantages and Disadvantages of Decriminalising Privacy

-
The only way to avoid the unfairness of a copyright tax that funds benefits for criminals is to decriminalize the benefit and make "piracy" legal for everyone. The public good provided by the tax then corresponds to the provision of free content for everyone. What are the advantages and disadvantages of decriminalizing piracy? Please see the following for a description of copyright tax: http://www.1729.com/ip/CopyrightLevies.html 8 Advantages and Disadvantages of Decriminalizing Privacy The intentional violation of the Copyrights Act, in relation to commercial products like music, software, and so on, is known as ‘privacy’. For instance, if you use a music recording or software without a license or make a copy of it to distribute without permission from the creator, you are violating the Copyright Act (Dorrel 2005). The main objective of copyrighting is for the creator to be able to recover all the costs he/she invested in producing the work. Thus copyrighting becomes
Read more

Split String in SQL Server

-
Split String in SQL Server. NVARCHAR and VARCHAR Split in MS SQL. For all of you there who wishes to preform a simple "split" on a varchar on nvarchar input in ms sql (sql server) this is for you: Basically, this post's gonna contain a Create Function Script which you will to execute in your server.  It will also contain the simplest way to use it. There will be more examples in a different post I'll upload soon... CREATE FUNCTION dbo.Split (     @RowData nvarchar(2000),     @SplitOn nvarchar(5) )  RETURNS @RtnValue table (     Id int identity(1,1),     Data nvarchar(100) ) AS  BEGIN     Declare @Cnt int     Set @Cnt = 1     While (Charindex(@SplitOn,@RowData)>0)     Begin         Insert Into @RtnValue (data)         Select             Data = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1)))         Set @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))         Set @Cnt = @Cnt + 1     End  
Read more