<div>
<div class="content wysiwyg-content">
Is it possible to remove one column from dataset returned? alos hoe do you add rows to a datatable based on column name instead of column count. <br />
I used this in my code <br />
&nbsp;''Dim dr As DataRow<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'For Each row As DataRow In lobj_Dataset.Tables(0).Row<wbr />s<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' &nbsp; &nbsp;dr = dt.NewRow<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' &nbsp; &nbsp;For i As Integer = 0 To lobj_Dataset.Tables(0).Col<wbr />umns.Count<wbr /> - 1<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' &nbsp; &nbsp; &nbsp; &nbsp;dr(i) = row(i)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' &nbsp; &nbsp;Next<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' &nbsp; &nbsp;dt.Rows.Add(dr)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Next<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lobj_Dataset.Tables.Add(dt<wbr />.Copy)
</div>
</div>


Is it possible to remove one column from dataset returned? alos hoe do you add rows to a datatable based on column name instead of column count. 
I used this in my code 
 ''Dim dr As DataRow
                    'For Each row As DataRow In lobj_Dataset.Tables(0).Rows
                    '    dr = dt.NewRow
                    '    For i As Integer = 0 To lobj_Dataset.Tables(0).Columns.Count - 1
                    '        dr(i) = row(i)
                    '    Next
                    '    dt.Rows.Add(dr)
                    'Next
                    lobj_Dataset.Tables.Add(dt.Copy)

Removing column from dataset

Is it possible to remove one column from dataset returned? alos hoe do you add rows to a datatable based on column name instead of column count. 
I used this in my code 
 &#39;&#39;Dim dr As DataRow
                    &#39;For Each row As DataRow In lobj_Dataset.Tables(0).Rows
                    &#39;    dr = dt.NewRow
                    &#39;    For i As Integer = 0 To lobj_Dataset.Tables(0).Columns.Count - 1
                    &#39;        dr(i) = row(i)
                    &#39;    Next
                    &#39;    dt.Rows.Add(dr)
                    &#39;Next
                    lobj_Dataset.Tables.Add(dt.Copy)

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications