int rowIndex = dataGridView1.SelectedCells[0].RowIndex;
string itemName = dataGridView1.Rows[rowIndex].Cells[1].Value.ToString();
decimal price = 0;
MyDataSetTableAdapters.StoreTableAdapter adapter = new MyDataSetTableAdapters.StoreTableAdapter();
DataTable table = adapter.GetData();
DataRow[] rows = table.Select("StaffID='" + itemName + "'");
if (rows.Length > 0)
{
price = (decimal)rows[0]["SalePrice"];
}
dataGridView2.Rows.Add(dataGridView2.Rows.Count, itemName, price.ToString("N0"));