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

HOW TO GET NAME IN TEXT CHANGED

Answers (5)