How To Use A Url Query String Value To Access A Database Record With The Same Value.

Ok, to start I will say I am a novice so detailed solutions are much appreciated.  I believe I am on the right track. Here is what I am trying to accomplish. I have a page that uses an xml driven google map.  When you click on the map marker, the info bubble displays brief information about a community and a link specified from the xml file.  I have specified the links in the xml file to pass a query string variable ex: /community.aspx?name=uniqueCommunityNameHere. I tested this by simply placing a label on the community.aspx page that restated the "name" value - works fine (first commented out line of Page_Load).  Now I need to complete my VB function that pulls the data record from the database - based on the parameter input from the query string - when the page loads.  So if the user clicks the link on the marker for community1, it will populate community.aspx with info about community1 from the database... if they click community7 it will display that community info etc.

Data Table: "Community" Data Fields: ID, Name, Description, Address, City, State, Phone, SalesRep.

ASPX Page Design Elements: lblID, lblName, lblDesc, lblAddress.... etc.

Here is my start... I will need help with the sql statement for sure - how do I create a where clause from the query string parameter passed in?

Thanks so much for your help!

 

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'My initial test to see that the query string is working       lblName.Text = Request("name").ToString()

' Get the community info when loading community.aspx for the user selected community
If Not IsPostBack Then
LoadCommunityInfo(Request("name").ToString())
End If
End SubPrivate Sub LoadCommunityInfo(ByVal community)
' Define data objects
Dim conn As SqlConnection
Dim comm As SqlCommand
Dim reader As SqlDataReader

' Read the connection string from Web.config
Dim connectionString As String = ConfigurationManager.ConnectionStrings("CONHTConnectionString").ConnectionString
' Initialize connection
conn = New SqlConnection(connectionString)
' Create command
comm = New SqlCommand("SELECT * FROM Community WHERE Name = " & community, conn)
' Enclose database code in Try-Catch-Finally
Try
' Open the connection
conn.Open()
' Execute the command
reader = comm.ExecuteReader()
' Populate the list of community information -> Make the labels.text = the database fields --> lblName.text = table-Community field-"Name"
lblName.Text = "Name"
lblDesc.Text = "Description"
....
' Close the reader
reader.Close()
Catch
' Display error message
dbErrorLabel.Text = "Error loading the community information!<br />"
Finally
' Close the connection
conn.Close()
End Try
End Sub