heelo,

i have a combobox,button in form1. a listbox in form2. the listbox and combobox r populated iwth customernames. now, if itype a string or char in my combobox say 'l' then it
should display all customernames starting with 'l'in the listbox . how do i go about it?

it's the pseudo code :

Select customernames from customer where customernames like Form1.combobox.text

this is the code i wrote in MS Access. SELECT portfolio.Customer_name, portfolio.PAN_number
FROM portfolio
WHERE portfolio.Customer_name Like (Forms!Form1!Combo0 & "*");

But how do i write this query in .net2005. what r the steps to run a query???

Instead of combobox to type char or string cant u use textbox?
if yes then u can list the list box with all the name of customer starting with
that charecter.

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.