Gridview and SQL search

[takwirira]

Sql Like Command

I am looking for sample code for the SQL LIKE command in VB.Net or ASP.net. I have an access database with user information and I want a piece of code that searches the db for a name the populates a datagrid/listbox/gridview. The command to search is easy enough I just havent found the code to populate a gridview, datalist or grid. Thanks

 

[cjard]

Click the DW2 link in my signature and read the section "Creating a simple data application"

 

[takwirira]

Thanks I will look through

 

[cjard]

After you understand how data access works in .net 2.. you can read the artcile "Creating a form to search data" - that will walk you through the LIKE function, but do each step at a time.. dont try to run before you can walk

 

[takwirira]

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