HOW TO GET NAME IN TEXT CHANGED

MANEESH AN

13y1.6kVisual Basic .NET

HOW TO GET 'NAME' IN LISTBOX...FROM A FORM, WHERE I HAD INSERTED 'NAME.MAY I GET CODE TO WRITE IN TEXT CHANGED?

5 Replies

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

Iftikar Hussain13y ago
is the autocomplete not working?

Regards,
Iftikar
MANEESH AN13y ago
string strSelectQurry = "if (select count(iAccID)from tblAccountMaster where vAccName like '" + txtCustName.Text.Trim() + " ' %";pls correct this?
Iftikar Hussain13y ago
try like this in form load

private void Form5_Load(object sender, EventArgs e)
{
AutoCompleteStringCollection codesCollection = new AutoCompleteStringCollection();
string strSelectQurry = "Select vAccName from tblAccountMaster s";
using (SqlConnection conn = new SqlConnection(@"Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUser;Password=Mypassword"))
{
if (conn.State == ConnectionState.Closed)
conn.Open();
SqlCommand cmd = new SqlCommand(strSelectQurry, conn);
SqlDataReader dReader = cmd.ExecuteReader();
while (dReader.Read())
{
codesCollection.Add(dReader.GetString(0));
}
dReader.Close();
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
}

textBox1.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox1.AutoCompleteCustomSource = codesCollection;
}

Regards,
Iftikar
MANEESH AN13y ago
IN WINDOWS APPLICATION..I HAVE INSERTED 'CUSTOMER NAME' IN CUSTOMER MASTER FORM.I HAVE TO LIST 'CUSTOMER NAME'IN IN INVOICE ENTRY FORM...WHEN I CURSOR CLICK TO TEXTBOX OF CUSTOMER NAME IN INVOICE ENTRY FORM ...

private void txtCustName_TextChanged(object sender, EventArgs e)
        {
            if (block == 0)
            {
                fnFillAccountNameListbox();
            }
        }
private void fnFillAccountNameListbox()
string strSelectQurry ="Select vAccName from tblAccountMaster where vAccName = vAccName like'"+txtCustName.Text+"' ";
            if (txtCustName.Text.Trim().Length > 0)
            {
                objCfun.fnLoadListbox(lbxCustName, strSelectQurry);

                lbxCustName.BringToFront();

                if (lbxCustName.Items.Count > 0)
                {
                    lbxCustName.Visible = true;

                }
                else
                {
                    lbxCustName.Visible = false;
                }
            }

        }

PLEASE GIVE CORRECT CODE..I DONT GET SELECTED VALUE
Iftikar Hussain13y ago
Hi,
Are you looking for autocomplete textbox? Please provide more details.
Are you looking for in ASP.NET or Windows Application?

Regards,
Iftikar