Interview Question in Visual Studio 2005


 

Interview Question :: VIsual Studio 2005 Data access

Looking at my post you will see I am a newbie to Visual Studio 2005, I was just playing around with data access and a little project came to mind

I have on my website

GridView1, txtName and btnSearch on the web page

I have a Microsoft Access Database called runnersdb it has a table called Runners

In the table called Runners I have a list of names of people

On the website I want to enter for example Jam and click search

As a result the gridview should show results such as James, Jamie, Jamali etc i.e. I want to make use of the LIKE command in SQL

Can you please help with the code I would need

Thanks
by ksk