<div>
something like this:<br />
<br />
con.ConnectionString = Settings.ConnectionString(<wbr />&quot;myDB&quot;);<br />
con.Open()<br />
cmd.Connection = con<br />
cmd.CommandType = CommandType.StoredProcedur<wbr />e<br />
cmd.CommandText = &quot;HospBillingCodeLoop&quot;<br />
cmd.Parameters.Add(&quot;@HTCod<wbr />e &quot;, SqlDbType.Int).Value = HTCode;<br />
DataReader dr = cmd.ExecuteReader();<br />
DataSet ds = new Dataset();<br />
ds.Load(dr);<br />
...
</div>


something like this:

con.ConnectionString = Settings.ConnectionString("myDB");
con.Open()
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "HospBillingCodeLoop"
cmd.Parameters.Add("@HTCode ", SqlDbType.Int).Value = HTCode;
DataReader dr = cmd.ExecuteReader();
DataSet ds = new Dataset();
ds.Load(dr);
...

<div>
Thank you! &nbsp;It worked perfectly.
</div>


<div>
<div class="content wysiwyg-content">
I have the following stored procedure. &nbsp;I want to pass HTCode from my VB.Net subroutine and then received the values back in a datatable. &nbsp;Is that possible? &nbsp;If so, could someone help me out with the code?<br />

<pre><code id="code-8207092">ALTER PROCEDURE dbo.HospBillingCodeLoop
	(
	@HTCode varchar(50)
	)
AS
	SELECT * FROM [Hospital Billing Data SQL] WHERE HTCode = @HTCode 
	RETURN</code></pre>
</div>
</div>


I have the following stored procedure.  I want to pass HTCode from my VB.Net subroutine and then received the values back in a datatable.  Is that possible?  If so, could someone help me out with the code?

Passing parameter to Stored Procedure

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,