ContributionsMost RecentMost LikesSolutionspass parameter in ado createrecordset Hi there, How do I pass a parameter in the ADO CreateRecordSet? Ie: var userId = 1337; qry.Open("SELECT COUNT(*) from [dbo].[Users] f WHERE f.UserId= userId", connectionString, -1, -1, adCmdText); ^^ UserId is being passed here.