<div>
reader_recode.getvalue(0) replace the 0 with the number of the field u are trying to get. This is really the proper way of using the reader. <br />
<br />
0 example <br />
<br />
say u have a table with the following fields<br />
field1 field2 field3<br />
<br />
and u want field 2 u would replace 0 to 1<br />
<br />

</div>


reader_recode.getvalue(0) replace the 0 with the number of the field u are trying to get. This is really the proper way of using the reader.

0 example

say u have a table with the following fields
field1 field2 field3

and u want field 2 u would replace 0 to 1



<div>
<div class="content wysiwyg-content">
Here is the code that I am using,<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim sqlcom1 As SqlCommand = New SqlCommand(&quot;SELECT * &quot;&nbsp;&amp; _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;FROM TABEL1 &quot;&nbsp;&amp; _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;WHERE VAR1 = '&quot; &amp;&nbsp;cmb_VAR1.Text &amp;&nbsp;&quot;'&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim reader_recode As SqlDataReader<br />
&nbsp; &nbsp; &nbsp; &nbsp; reader_recode = sqlcom1.ExecuteReader<br />
&nbsp; &nbsp; &nbsp; &nbsp; While reader_recode.Read<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rtb_DATA1.Text = reader_recode(&quot;DATA1&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; End While<br />
&nbsp; &nbsp; &nbsp; &nbsp; reader_recode.Close()<br />
<br />
I get an error when using Option Strict On. &nbsp;If I turn that off, things are fine, but I would like to code this correctly.<br />
<br />
Here is the error:<br />
<br />
Option Strict On disallows implicit conversions from 'System.Object' to 'String'.<br />
<br />
Any ideas?
</div>
</div>


Here is the code that I am using,

        Dim sqlcom1 As SqlCommand = New SqlCommand("SELECT * " & _
                                        "FROM TABEL1 " & _
                                        "WHERE VAR1 = '" & cmb_VAR1.Text & "'")
        Dim reader_recode As SqlDataReader
        reader_recode = sqlcom1.ExecuteReader
        While reader_recode.Read
            rtb_DATA1.Text = reader_recode("DATA1")
        End While
        reader_recode.Close()

I get an error when using Option Strict On.  If I turn that off, things are fine, but I would like to code this correctly.

Here is the error:

Option Strict On disallows implicit conversions from 'System.Object' to 'String'.

Any ideas?

Easy One:  How do I populate a RichTextBox with a cell from SQL Server?

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,