<div>
We're going to need a little more information than this.
</div>


We're going to need a little more information than this.

<div>
Your question will best be explained with an example
</div>


Your question will best be explained with an example

<div>
<div class="content wysiwyg-content">
I am trying to obtain values from a database and ive tried using SQL and a datagrid but nothing seems to be happening except run time error 6153.<br />
<br />
What i am trying to do is obtain the value from a column 3 and match it to the text in column 1.<br />
<br />
e.g &nbsp;I have 4 records<br />
<br />
dave &nbsp; &nbsp; Cost = £40<br />
phil &nbsp; &nbsp; &nbsp; Cost = £20<br />
george &nbsp;Cost = £30<br />
jamie &nbsp; &nbsp;Cost = £10<br />
<br />
i also need the values to be obtained during each load as the database field will be updated<br />
<br />
thx in advance<br />
<br />
neutrinohunter<br />
<br />

</div>
</div>


I am trying to obtain values from a database and ive tried using SQL and a datagrid but nothing seems to be happening except run time error 6153.

What i am trying to do is obtain the value from a column 3 and match it to the text in column 1.

e.g  I have 4 records

dave     Cost = £40
phil       Cost = £20
george  Cost = £30
jamie    Cost = £10

i also need the values to be obtained during each load as the database field will be updated

thx in advance

neutrinohunter



Obtaining Value from a database or datagrid

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.