HOW TO GET NAME IN TEXT CHANGED

Question

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

Iftikar Hussain · Answer

is the autocomplete not working? Regards Iftikar

MANEESH AN · Answer

string strSelectQurry = if (select count(iAccID)from tblAccountMaster where vAccName like ' + txtCustName.Text.Trim() +  ' %;pls correct this?

Iftikar Hussain · Answer

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 AN · Answer

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 Hussain · Answer

Hi Are you looking for autocomplete textbox? Please provide more details. Are you looking for in ASP.NET or Windows Application? Regards Iftikar