How Can I Dynamically Build Sql SELECT Using ASP 1.0 Array Concept

The below code is ASP 1.0 to dynamically search a database and I want to use the same concept for a ASP.Net 2.0 solution.  Do I do this in the code behind or on the aspx page and if on the aspx page what controls do I use for the array split?  Basically where do I start.  It took me a long time to get this old code working, I am hoping it is simpler in 2.0.

Thank you

OLD ASP 1.0 code to dynamically build a Sql Select statement for searching a database using one or more search words entered by user.

If Request.Querystring("kwdSearch") <> "" Then
Dim kwdString, ArrKwdString, iCount
iCount = 0 
kwdString = Replace(Request.Querystring("kwdSearch"), "'", "''")
ArrKwdString = Trim(kwdString)
ArrKwdString = Split(kwdString, " ",-1,1)
 
For iCount = 0 to UBound(ArrKwdString)
 If iCount < UBound(ArrKwdString) Then
  Criteria = Criteria & "tblLinkInfo.L_Keywords LIKE '%" & ArrKwdString(iCount) & "%' AND "
  Else
  Criteria = Criteria & "tblLinkInfo.L_Keywords LIKE '%" & ArrKwdString(iCount) & "%' "
 End if
Next
   
 RS.Open "SELECT * FROM tblLinkInfo Where (" & Criteria & ") AND L_Enabled = 1 ORDER BY " & SortBy & "L_Rank", CNN, 3
 If RS.EOF Then
  If Rs.State Then RS.Close
  RS.Open "SELECT * FROM tblLinkInfo WHERE L_Description LIKE '%" & Replace(Request.Querystring("kwdSearch"),"''","'") & "%' AND
  L_Enabled = 1  ORDER BY " & SortBy & "L_Rank", CNN, 3
  End If

  RESULTS --- Display results with Repeater1.DataBind(); etc

  Exit Sub
End If