<div>
You aren't using a stored procedure, so there isn't a &quot;return value&quot;. &nbsp;There is a result of your query, and so to get that, you need to do:<br />
<br />

<pre><code id="code-20-42391737-1">Dim getRow = Convert.ToInt32(cmd.ExecuteScalar());</code></pre>
<br />
<a href="https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar(v=vs.110).aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar(v=vs.110).aspx</a>
</div>


You aren't using a stored procedure, so there isn't a "return value".  There is a result of your query, and so to get that, you need to do:



Dim getRow = Convert.ToInt32(cmd.ExecuteScalar());


https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar(v=vs.110).aspx [https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar(v=vs.110).aspx]

<div>
Thank you for your answer.<br />
can you just tell me how to pass the let's say column 0 only?<br />
<br />
can I do <br />
Dim getRow = Convert.ToInt32(cmd.Execut<wbr />eScalar(0)<wbr />)
</div>


Thank you for your answer.
can you just tell me how to pass the let's say column 0 only?

can I do
Dim getRow = Convert.ToInt32(cmd.ExecuteScalar(0))

<div>
Basically U gave me a good solution but still it doesn't return a value just a boolean it there is data or not and this is good enough foe me.
</div>


Basically U gave me a good solution but still it doesn't return a value just a boolean it there is data or not and this is good enough foe me.

<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I'm doing some query to get a parameter from SQL.<br />
<br />

<pre><code id="code-10-29071858-1"> Using cmd As New SqlCommand(&quot;select * from&quot; + &quot; &quot; + tablen + &quot; &quot; + &quot;where id=@rowid&quot;, Basewebpage.Passport.Connection)
            cmd.Parameters.AddWithValue(&quot;@rowid&quot;, rowid)
            Dim getRow = Convert.ToInt32(cmd.Parameters(0).Value)

        End Using</code></pre>
<br />
I have one issue here:<br />
I can't get the value- Dim getRow = Convert.ToInt32(cmd.Parame<wbr />ters(0).Va<wbr />lue)
</div>
</div>


Hi guys,

I'm doing some query to get a parameter from SQL.

(CODE)

I have one issue here:
I can't get the value- Dim getRow = Convert.ToInt32(cmd.Parameters(0).Value)

Visual basic

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

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,

Visual Basic.NET

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.