Search from Ms Access and desplay record in labels

Question

Suppose I have lblName lblSurname lblBalance. now my primary key is Name how do i search for a record using a text box (txtSearch) to search for a record and then display the record in the above labels lets say m using btnSearch button.

Akshay Phadke · Answer

Just you need to write a query on Search on search suppose user search xyz name all xyz details are there in database will show of xyz you just need to write a select query . would recommend you instead of showing records in label show in a gridview that would be great .

Lukas Kuutondokwa · Answer

//Account number not account name. int n = Convert .ToInt32( Interaction .InputBox( Enter Account Number:  Search  20 { AccountNumber= ds.Tables[0].Rows.IndexOf(record);

Lukas Kuutondokwa · Answer

//Using inputbox to search.....i removed the text box private void btnSearch_Click( object sender EventArgs e) { int n = Convert .ToInt32( Interaction .InputBox( Enter Account Name:  Search  20  200 200)); DataRow record = ds.Tables[0].Rows.Find(n); if (record != null ) { AccountName= ds.Tables[0].Rows.IndexOf(record); lblName .Text = record[0].ToString(); lblAccount.Text = record[1].ToString(); lblBalance.Text = record[2].ToString(); } else MessageBox .Show( Record not found ); }

Akshay Phadke · Answer

select idNameSurnamebalance from tablename where Name='+txtName.text+'; this will be your query

Lukas Kuutondokwa · Answer

Yeah I m just still on the basics didn't yet get to the part of creating queries in C#. I tried google its a nightmare. My lecturer is even worse. But yeah will try.

Akshay Phadke · Answer

o just write a query on search and display its repective fields on labels

Lukas Kuutondokwa · Answer

@Akshay no I dont want gridview I want to display it in labels i have designed a form that looks like a statement and I after searching for a record then it just sends the information from the different fields to the coresponding labels thereafter i simply print the form.