C# Access How to return multiple results from database??

Change your btnSelect_Click function into this:

private void btnSelect_Click(object sender, EventArgs e)
{

    string connStr, selectName, selectCmd;
    selectName = txtName.Text;
    selectCmd ="SELECT * FROM product WHERE skid = '" + selectName.Replace("'", "''") + "'";
    connStr ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=product.mdb";
    OleDbConnection conn;
    OleDbCommand cmd;
    conn = new OleDbConnection(connStr);
    conn.Open();
    cmd = new OleDbCommand(selectCmd, conn);

    using (OleDbDataReader myReader = cmd.ExecuteReader())
    {

        StringBuilder sb = new StringBuilder();
       
        while(myReader.Read())
        {
            sb.AppendFormat("Skid\t{0}\n", myReader["skid"]);
            sb.AppendFormat("Weight\t{0}\n", myReader["weight"]);
            sb.AppendFormat("Quantity\t{0}\n", myReader["quantity"]);
            sb.AppendFormat("Description\t{0}\n", myReader["description"]);
        }

        if (sb.Length == 0)
            sb.Append("Cannot find record!");
       
        rtbShow.Text = sb.ToString();

    }

    conn.Close();

}

That will iterate through all records returned by the query and append them to control's text

Zoran