VB Programaticlly Grab Data From A DB Noob

  Hi, I am very new to the .net framework, but I have a lot of experince in php/mysql applications. So this is this is proboly going to seem like a nwebie question.

I am trying to pull a single item out of the database programaticlly, take the value of that item and set it to a varible so I can work with it in other areas.

Here is basically what I have this is on the vb page in a sub I have the varible MonthlyPrice Defined earlier in the page
Dim connString As String = _ConfigurationManager.ConnectionStrings("ConnectioString").ConnectionString
'Create a SqlConnection instanceUsing myConnection As New SqlConnection(connString)
'Specify the SQL query
Const sql As String = "SELECT Price FROM Plans Where PlainID='" & PlanId & "'"
'Create a SqlCommand instanceDim myCommand As New SqlCommand(sql, myConnection)
'Get back a DataSetDim myDataSet As New DataSet
'Create a SqlDataAdapter instanceDim ReadData As New SqlDataReader(myCommand)
 
'Bind the DataSet to the GridViewMonthlyPrice = ReadData("Price")
'Close the connection
myConnection.Close()
End Using

I just want to get the price of the plan where planID is equal to the value of my varible planID. I want to set that equal to MonthlyPrice which is a decimal so I can add it into some calculations and return a value. I don't really want to bind the data to anything but everytime I search google I can't find anything excpet for binding data to grideview and things like that.

I have tried several diffrent approaches that I have found out there but have gotten errors or and things I am not understanding.

I originally was trying to access a datasource I already have defined that is on the aspx page.<asp:SqlDataSource ID="SQLSelectPlan" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT * FROM [Plans] WHERE ([PlanID] = @PlanID2)">

<SelectParameters>

<asp:FormParameter FormField="grSelectPlan" Name="PlanID2" Type="Int32" />

</SelectParameters>

</asp:SqlDataSource>

 Is there a way for me to grab this datasource which works and is tied to a detailed view, take the value in the price collom and stick it in the MonthlyPrice varible on my vb page? That is the approach that seems the most logical to me.

If someone has better way I would really like to know.

 

Thanks