Search from Ms Access and desplay record in labels

Lukas Kuutondokwa

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.

7 Replies

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

Lukas Kuutondokwa10y ago
//Account number, not account name.
int n = Convert.ToInt32(Interaction.InputBox("Enter Account Number:", "Search", "20"
{
AccountNumber= ds.Tables[0].Rows.IndexOf(record);
Lukas Kuutondokwa10y ago
//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 Phadke10y ago
select id,Name,Surname,balance from tablename where Name='"+txtName.text+"';
this will be your query
Lukas Kuutondokwa10y ago
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 Phadke10y ago
o just write a query on search and display its repective fields on labels
Lukas Kuutondokwa10y ago
@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.
Akshay Phadke10y ago
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 .