Auto complete in datagridview

Question

how to use auto complete in textbox to display in datagridview using c#.net.

i will post a link here

https://onedrive.live.com/redir?resid=53870F6D1012733F!267&authkey=!AP_o_XnR6tdrHKw&v=3&ithint=photo%2cpng

plz help

Answer 1

Hi,

Which is which?
TextBox is a source for user to input, and DataGridView is a target to that will be shown?
Or when TextBox.Text is changed, it will be replaced customer's name in DataGridView?

Please inform the further detail.

Regards.

Answer 2

yes...

when textbox click event is fired datagridview is displayed with list of customers name and details. if a user type a letter in textbox , the related datas or customer name should be shown in datagridview..means auto complete.

help me sir plzz...

so many issues are there in my project..and i have only limited period of time. :(

Answer 3

Hi,

I suppose...

handled event is TextBox_TextChanged

In the event:
 1) know the length of TextBox, i.e. the number of characters which user input.
     suppose it's 3 characters
 2) loop all rows of DataGridView, i.e. from 0 to DataGridView.RowCount -1
     if the first 3 characters in DataGridView(Customer column) = TextBox.Text
         the row of DataGridView is visible
     else         the row of DataGridView is invisible  

Regards.

Answer 4

Hi,

How about this?
(This is only in my mind, not checked with Visual Studio)

private void textBox1_TextChanged(object sender, EventArgs e)
    {
        //int chrLen = this.textBox1.TextLength;
        this.dataGridView1.SuspendLayout();
        for (int myRow = 0; myRow <= this.dataGridView1.RowCount - 1; myRow++)
        {
            string dgvText = this.dataGridView1[0, myRow].Value.ToString();
            if (dgvText.IndexOf(this.textBox1.Text) == 0) 
                {
                    this.dataGridView1.Rows[myRow].Visible = false;
                }
                else {
                    this.dataGridView1.Rows[myRow].Visible = true;
                }
        }
            this.dataGridView1.ResumeLayout();
    }

Regards.

Answer 5

not working sir...control is not entering to the textchanged method...

Answer 6

I hope this will be the final trial.

// --- Text Changed: Incrementary Search
private void TextBox_TextChanged(object sender, EventArgs e)
{
	int txtLen = this.TextBox.Text.Length;
    // --- DataGridView Loop
	for (int myRow = 0; myRow <= DataGridView.RowCount - 1; myRow++) {
		DataGridView.Rows(myRow).Visible = false;
		if ((DataGridView(0, myRow).Value.ToString.Length < txtLen)) {
			continue;
		} else {
			if ((DataGridView(0, myRow).Value.ToString.Substring(0, txtLen) == TextBox1.Text)) {
				DataGridView.Rows(myRow).Visible = true;
			}
		}
	}
}

Regards.

Answer 7

 private void txtCustmrName_TextChanged(object sender, EventArgs e)
        {
            int txtLen = this.txtCustmrName.Text.Length;
            // --- DataGridView Loop
            string unme;
            for (int myRow = 0; myRow <= dguser.Rows.Count - 1; myRow++)
            {
                unme=dguser.Rows[myRow].Cells[1].Value.ToString();
               dguser.Rows[myRow].Visible = false;
                if (unme.Length < txtLen)
                {
                    continue;
                }
                //if ((DataGridView(0, myRow).Value.ToString.Length < txtLen))
                //{
                //    continue;
                //}
                else
                {
                    if (unme.Substring(0, txtLen) == txtCustmrName.Text)
                    {
                        dguser.Rows[myRow].Visible = true;
                    }
                }
            }

i wrote above code..it shows the following error..

"Row associated with the currency manager's position cannot be made invisible."

in below code..

help me sirr

unme=dguser.Rows[myRow].Cells[1].Value.ToString();

Answer 8

As far as your first image, "Customer" name is the first column, the second is "Description".
So, I suppose Cells[0] is correct.

https://onedrive.live.com/redir?resid=53870F6D1012733F!267&authkey=!AP_o_XnR6tdrHKw&v=3&ithint=photo%2cpng

I'd like to clarify your needs again.
Please provide some pictures: name(input none, one character, two characters) and each result of DataGridView.

Answer 9

below is my form..

https://onedrive.live.com/redir?resid=53870F6D1012733F!268&authkey=!AJKEOxT500doXsk&v=3&ithint=photo%2cpng

below is the error

https://onedrive.live.com/redir?resid=53870F6D1012733F!269&authkey=!AGBdkBQ7kQjrHdo&v=3&ithint=photo%2cpng

help me sir .. :(

Answer 10

Please explain your needs with using Excel.
If your needs would be satisfied, how the results would be.
Please provide some pictures: name(input none, one character, two characters) and each result of DataGridView, with using Excel. 

Answer 11

i got a sample for my project. its an executable file.. that is .exe file. my duty is to make a new project from the given sample. 

i will explain what all things i need.

i have a datagrid contain three columns..namely "UserID, UserName, Role". UserID will be hidden for the end users. when a forms is loaded this grid is invisible. grid is visible when the textbox named txtcustmr is clicked. grid will display all the records. when the user types any letter in the textbox, the matching UserName should be displayed in the grid. 

https://onedrive.live.com/redir?resid=53870F6D1012733F!270&authkey=!AHqVsz2TWxn_pFI&v=3&ithint=photo%2cpng

above is the image of grid appears when user click on textbox.

https://onedrive.live.com/redir?resid=53870F6D1012733F!271&authkey=!AMIzp71K0TPa7RE&v=3&ithint=photo%2cpng

above is the image of grid appears when user type text in texbox.

help me sir..

Answer 12

How many characters(letter) can be input in the TextBox?
Only one character? or more than one?

Answer 13

any..if user types letters..matching words should be displayed in grid..that is auto complete..

Answer 14

Sorry. I cannot/won't follow you further.  Would someone give him/her a help?

Answer 15

so sad :(

Answer 16

Hi Mousimi Nishad,

Maybe you could read to your old thread:

https://social.msdn.microsoft.com/Forums/windows/en-US/20d26c09-aa85-448b-b2cd-66c5db5f967c/user-control-to-create-a-datagridview-in-textbox-click-event?forum=winforms

Regards,

Moonlight

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.