search textbox related

Question

i hsve s written a code where in a textbox when i enter any alphabet particular emplyee list shows down with its user id also with it for eg if i type "su" in textbox it shows up name starting with su if i select my name from the list it will take my name as well as my user id also on a search button i want to show the projects related to the employee "subin" the project will be called using userid but the name of the employee is in different table andi want to search project by the name how wil i do ? thanks

Salman Beg · Answer

Hi. When you select the name and click on search at that time get the userid and make a join with the other table and retrieve the project related Information. Thanks.

Jignesh Kumar · Answer

Hi Subin, Please try below link, it may help you to achieve your task. https://www.aspsnippets.com/Articles/Implement-jQuery-AutoComplete-TextBox-in-ASPNet-MVC.aspx

Amit Gupta · Answer

You need to use join to fetch between tables and then use where clause to search with your criteria. You can use query builder to create query based on two tables.

Subin Thomas · Answer

yea but i am a beginner can you help me with coding part thanks

Siddhartha Sharma · Answer

use this rivate void Form1_Load(object sender, EventArgs e) { // declare custom source. var source = new AutoCompleteStringCollection(); // fetch record from database datatable dt = getdatafromsql("select name from tbl"); // fill database records to custome sorurce for (i=0;i { source.Add(dt.rows[i][0].tostring();); } // Create and initialize the text box. var textBox = new TextBox { AutoCompleteCustomSource = source, AutoCompleteMode = AutoCompleteMode.SuggestAppend, AutoCompleteSource = AutoCompleteSource.CustomSource, Location = new Point(20, 20), Width = ClientRectangle.Width - 40, Visible = true }; // Add the text box to the form. Controls.Add(textBox); }