<div>
you need to bind the textboxes to the datagridview if i am understanding your question correctly
</div>


you need to bind the textboxes to the datagridview if i am understanding your question correctly

<div>
Infact I don't need datagridview at all. You can replace the code. I just want to retreive a record and fill textboxes - &nbsp;txtTransactionnumber.txt, txtAddress.txt , txtCity.txt, txtState,txt ,txtZip.txt &nbsp;and txtRepcomment.txt.
</div>


Infact I don't need datagridview at all. You can replace the code. I just want to retreive a record and fill textboxes -  txtTransactionnumber.txt, txtAddress.txt , txtCity.txt, txtState,txt ,txtZip.txt  and txtRepcomment.txt.

<div>
<div class="content wysiwyg-content">
How can I retreive a record from txtMytransno.txt and load it into these textboxes? &nbsp;- Transactionnumber, Address, City, State, Zip and Repcomment. Below just fill Datagridview. <br />
<br />
<br />
<br />
Dim StrConnection As String = &quot;provider=microsoft.jet.ol<wbr />edb.4.0;&quot; + &quot;data source = C:\Documents and Settings\CLIENT.SST_DOM\De<wbr />sktop\XMAN<wbr />\bad.mdb&quot;<br />
<br />
Dim Connection As New OleDbConnection(StrConnect<wbr />ion)<br />
<br />
Dim myCommand As New OleDbCommand(&quot;SELECT * FROM badtable where Transactionnumber = ' &quot;&nbsp;&amp; me.txtMytransno.txt &amp;&nbsp;&quot; ' &quot;, Connection)<br />
<br />
da.SelectCommand = myCommand<br />
<br />
da.TableMappings.Add(&quot;Tabl<wbr />e&quot;, &quot;badtable&quot;)<br />
<br />
Try<br />
<br />
da.Fill(ds)<br />
<br />
DataGridView1.DataSource = ds.Tables(&quot;badtable&quot;) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;------ &nbsp; This is load on datagridview only<br />
<br />
Catch ex As OperationAbortedException<br />
<br />
MsgBox(ex.ToString)<br />
<br />
End Try<br />

</div>
</div>


How can I retreive a record from txtMytransno.txt and load it into these textboxes?  - Transactionnumber, Address, City, State, Zip and Repcomment. Below just fill Datagridview. 



Dim StrConnection As String = "provider=microsoft.jet.oledb.4.0;" + "data source = C:\Documents and Settings\CLIENT.SST_DOM\Desktop\XMAN\bad.mdb"

Dim Connection As New OleDbConnection(StrConnection)

Dim myCommand As New OleDbCommand("SELECT * FROM badtable where Transactionnumber = ' " & me.txtMytransno.txt & " ' ", Connection)

da.SelectCommand = myCommand

da.TableMappings.Add("Table", "badtable")

Try

da.Fill(ds)

DataGridView1.DataSource = ds.Tables("badtable")            ------   This is load on datagridview only

Catch ex As OperationAbortedException

MsgBox(ex.ToString)

End Try


retreived record

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,