<div>
Note. I write code directly, I don´t verify.<br />
<br />
by sample : &nbsp;where says &nbsp; &nbsp; &nbsp; &nbsp; row(ccor) &nbsp; &nbsp;-&gt; &nbsp; &nbsp;row(ccor(n)) <br />
<br />

</div>


Note. I write code directly, I don´t verify.

by sample :  where says         row(ccor)    ->    row(ccor(n))



<div>
You put me on the right track...thanks<br />
<br />
Dim dt As New DataTable<br />
dt = ConvertTo(l_lead.Payments)<wbr /><br />
dt.Columns(0).ColumnName = &quot;LeadType&quot;<br />
blah...blah...blah..<br />
<br />
dt.Columns.Remove(&quot;LeadTyp<wbr />e&quot;)<br />
dt.Columns.Remove(&quot;Payment<wbr />StreamID&quot;)<wbr /><br />
blah...blah...blah..<br />
<br />
dt.Columns(&quot;EventType&quot;).Se<wbr />tOrdinal(0<wbr />)<br />
dt.Columns(&quot;StartDate&quot;).Se<wbr />tOrdinal(1<wbr />)<br />
dt.Columns(&quot;PmtAmount&quot;).Se<wbr />tOrdinal(2<wbr />)<br />
blah...blah...blah..&quot;
</div>


You put me on the right track...thanks

Dim dt As New DataTable
dt = ConvertTo(l_lead.Payments)
dt.Columns(0).ColumnName = "LeadType"
blah...blah...blah..

dt.Columns.Remove("LeadType")
dt.Columns.Remove("PaymentStreamID")
blah...blah...blah..

dt.Columns("EventType").SetOrdinal(0)
dt.Columns("StartDate").SetOrdinal(1)
dt.Columns("PmtAmount").SetOrdinal(2)
blah...blah...blah.."

<div>
<div class="content wysiwyg-content">
I have a datatable with the following columns<br />
<br />
[start Date]<br />
[Pmt Amount]<br />
[Compounding]<br />
<br />
How do I copy 2 of those columns into a new datatable to pass to SQL 2008 as a structured data table<br />
<br />
the new datatable would be<br />
startDate<br />
PaymentAmt
</div>
</div>


I have a datatable with the following columns

[start Date]
[Pmt Amount]
[Compounding]

How do I copy 2 of those columns into a new datatable to pass to SQL 2008 as a structured data table

the new datatable would be
startDate
PaymentAmt

Copy datatable into new datatable and rename columns

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.

.NET Programming

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,