i have two fields(name,mark) in ms access table.now i want to search that through vb.net form using "name" field(not providing full name only a part or letter).In form i have one text box and a search button .the matches will be shown in same form.

On the where clause of the select statement you can write some thing like.

WHERE name LIKE 'F*'

Hope this helps

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.