How to autopopulate a textbx with data keyed in other txtbox

kumartyr

i have two textbox in a form and will be typing firstname and lastname in that two textbox

what i want is if i type a name in first textbox and do tab or mouseclick to next textbox i want the matching lastname of the firstname
to be automatically populated

how to do this... i have written the below coding but am not able to find which textbox event will be appropriate to do this..
please someone clarify my doubt

if (LastNameTextBox.Text == "")
{
ACSCLN = new AutoCompleteStringCollection();
ORCMND13 = new OracleCommand("Select LASTNAME from VMS_VISITOR where FIRSTNAME='" + FirstNameTextBox.Text + "'", CON);
DR22 = ORCMND13.ExecuteReader();

if (DR22.HasRows == true)
{
while (DR22.Read())
{
ACSCLN.Add(DR22["LASTNAME"].ToString());
}

LastNameTextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
LastNameTextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
LastNameTextBox.AutoCompleteCustomSource = ACSCLN;

}
LastNameTextBox.Focus();

2 Replies

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

Iftikar Hussain13y ago
Hi,
You can do this on Mouse Enter event of LastName textbox

this.TxtBxLastName.MouseEnter += new System.EventHandler(this.TxtBxLastNameMouseEnter);

private void TxtBxLastNameMouseEnter(object sender, EventArgs e)
{
if (LastNameTextBox.Text == "")
{
ACSCLN = new AutoCompleteStringCollection();
ORCMND13 = new OracleCommand("Select LASTNAME from VMS_VISITOR where FIRSTNAME='" + FirstNameTextBox.Text + "'", CON);
DR22 = ORCMND13.ExecuteReader();

if (DR22.HasRows == true)
{
while (DR22.Read())
{
ACSCLN.Add(DR22["LASTNAME"].ToString());
}

LastNameTextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
LastNameTextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
LastNameTextBox.AutoCompleteCustomSource = ACSCLN;

}
LastNameTextBox.Focus();
}

Regards,
Iftikar
0
Sanjeeb Lenka13y ago
if you are using windows form you can go for keypress event
0