<div>
<div class="content wysiwyg-content">
I have 2 columns in a dataset with dates:<br />
<br />
&nbsp; &nbsp; &nbsp; A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B<br />
1/1/2008 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/3/2008<br />
2/5/2008 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3l2l2008<br />
<br />
I want to add a third column 'C' that would be the working days between the two dates (in excel it would be networkdays) &nbsp;I've been trying something like this:<br />
<br />
Me.DataSet1.Tables(0).Colu<wbr />mns.Add(&quot;d<wbr />iff&quot;).Expr<wbr />ession = &quot;PU_Date&quot; - &quot;Del_Date&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Debug.WriteLine(Me.DataSet<wbr />1.Tables(0<wbr />).Rows(0).<wbr />Item(&quot;diff<wbr />&quot;))<br />
<br />
Thanks
</div>
</div>


I have 2 columns in a dataset with dates:

      A                     B
1/1/2008              1/3/2008
2/5/2008               3l2l2008

I want to add a third column 'C' that would be the working days between the two dates (in excel it would be networkdays)  I've been trying something like this:

Me.DataSet1.Tables(0).Columns.Add("diff").Expression = "PU_Date" - "Del_Date"
                      Debug.WriteLine(Me.DataSet1.Tables(0).Rows(0).Item("diff"))

Thanks

Add column to dataset

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.