<div>
What I'm trying to do is add a new record to a table. <br />
So that leads me to two more questions -<br />
1. Wouldn't doing this Select * be a extra overhead? <br />
2. Now that I have a reader, how can I add a record to this table? &nbsp;
</div>


What I'm trying to do is add a new record to a table.
So that leads me to two more questions -
1. Wouldn't doing this Select * be a extra overhead?
2. Now that I have a reader, how can I add a record to this table?  

<div>
<div class="content wysiwyg-content">
can someone provide me with a small code example of how to open a table on the sql server, using vb 2005 using ado.net?
</div>
</div>


can someone provide me with a small code example of how to open a table on the sql server, using vb 2005 using ado.net?

Open table with ado.net ?

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,