asp sql query to asp.net sql query
Posted on 2011-02-16
I have a asp webpage working using the following sql query :
SELECT * FROM tblFixtures WHERE FixtureTeam LIKE '%" + Replace(rsFirstTeam__MMColParam, "'", "''") + "%' AND FixtureDate >= Now -1 ORDER BY FixtureDate ASC
using the following also :
rsFirstTeam__MMColParam = "1st Team"
If (Request("MM_EmptyValue") <> "") Then
rsFirstTeam__MMColParam = Request("MM_EmptyValue")
Following years of using Dreamweaver and asp, I now need to convert existing pages to asp.net - How should my asp.net datasource SelectCommand query look?
As you can tell from my question, I am not very experienced. Dreamweaver query created using gui