Listbox

Radiant Software

11y1.3k.NET

hii

i have create one web form.

in that form i had added one textbox n one listbox.

On page load listbox display all client name from database in lixtbox.

Now I want to display--

1- while i type '1' in textbox then listbox only display clientname of '1' clientid.

2-while i typing name starting from 'j' then list box displays all cliename which matches to input that i i typing in textbox.

anybody can help me?

please.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Radiant Software11y ago
Thanku Aman...
I have imlement this code.. this is working.
But i want to search item alphabetically...Means When I type 'P' in textbox then listbox will show all the items which are starting from 'P'..then nxt i'll type 'a' then istbox will show all the items which containing starting from'Pa'...
help me Plz
Sreeni Dony11y ago
By using linq we can filter the search item
eg:from item in items where item.id contains(searchItem)
Aman11y ago
Hi ,
You can do this as well. However I have implemented in a winForm but you can apply same concept on your web form.

just inside the textChange Event of TextBox add the following Line of Code

private void txtBoxInput_TextChanged(object sender, EventArgs e)
{

int employeeID;
string employeeName = txtBoxInput.Text;
if (Int32.TryParse(employeeName, out employeeID))
{
IDSearch(employeeID);
}
else
{
NameSearch(employeeName);
}

}

Now in Both the Method we have used add the following line of code :
public void NameSearch(string name)
{
string connString = ConfigurationManager.ConnectionStrings["EMSYSDbConn"].ToString();
SqlConnection conn = new SqlConnection(connString);
string query = String.Format("SELECT EmployeeName FROM Employee WHERE EmployeeName like '{0}%'",name);
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
DataTable dataTable = new DataTable();
dataAdapter.Fill(dataTable);
listBoxData.DataSource = dataTable;
listBoxData.DisplayMember = "EmployeeName";
}
public void IDSearch(int employeeID)
{
string connString = ConfigurationManager.ConnectionStrings["EMSYSDbConn"].ToString();
SqlConnection conn = new SqlConnection(connString);
try
{
string query = String.Format("SELECT EmployeeName FROM Employee WHERE EmployeeID={0}", employeeID);
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
DataTable dataTable = new DataTable();
dataAdapter.Fill(dataTable);
listBoxData.DataSource = dataTable;
listBoxData.DisplayMember = "EmployeeName";
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}

}
Note :Here I have used different Database for my project

If you have any query feel free to ask, and accept it as answer if it helps
Khan Abrar Ahmed11y ago
Hi try this links

https://joshsmithonwpf.wordpress.com/2007/06/12/searching-for-items-in-a-listbox/
http://www.c-sharpcorner.com/Forums/Thread/71890/-search-a-list-box-while-typing-in-a-text-box-in-winforms.aspx