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 id,Name,Surname,balance 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.

Search from Ms Access and desplay record in labels

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)