<div>
Dim DsPathway1 as string...<br />
<br />
Did you mean to dim this as a dataset?
</div>


Dim DsPathway1 as string...

Did you mean to dim this as a dataset?

<div>
DsPathway1 is a dataset already created from a DataAdapter 
</div>


DsPathway1 is a dataset already created from a DataAdapter

<div>
<div class="content wysiwyg-content">
 Public Sub GetPathway(ByVal vABR_ID$)<br />
&nbsp; &nbsp; &nbsp; &nbsp; If SqlConnection1.State = ConnectionState.Closed Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlConnection1.Open()<br />
&nbsp; &nbsp; &nbsp; &nbsp; End If<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim DsPathway1 As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; SqlDiplomateAdapter.Select<wbr />Command.Pa<wbr />rameters(&quot;<wbr />@abr_id&quot;).<wbr />Value = vABR_ID<br />
&nbsp; &nbsp; &nbsp; &nbsp; SqlDiplomateAdapter.Fill(D<wbr />sPathway1)<wbr /><br />
<br />
The above code is an attempt to populate th a dataset.<br />
<br />
However, the dataset includes to fields one is nvarchar and the other is a bit. &nbsp;I'm getting an error say that &nbsp;&quot;As Interger &nbsp;Value of type &quot;string cannot be converted to System.Data.DataSet&quot;<br />
and<br />
&quot;As Interger &nbsp;Value of type &quot;string cannot be converted to System.Data.Datatable&quot;<br />
<br />
can I assume that that's because of the BIT? &nbsp;What options do I have?<br />
<br />
Regards<br />

</div>
</div>


 Public Sub GetPathway(ByVal vABR_ID$)
        If SqlConnection1.State = ConnectionState.Closed Then
            SqlConnection1.Open()
        End If
        Dim DsPathway1 As String
        SqlDiplomateAdapter.SelectCommand.Parameters("@abr_id").Value = vABR_ID
        SqlDiplomateAdapter.Fill(DsPathway1)

The above code is an attempt to populate th a dataset.

However, the dataset includes to fields one is nvarchar and the other is a bit.  I'm getting an error say that  "As Interger  Value of type "string cannot be converted to System.Data.DataSet"
and
"As Interger  Value of type "string cannot be converted to System.Data.Datatable"

can I assume that that's because of the BIT?  What options do I have?

Regards


Conversion problem

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,