private void txttransactionid_TextChanged(object sender, EventArgs e) { //if the transaction was selected to be delivered, display transaction details db = new db_MiletecDataContext(); tblcustomertrans_detail getId = new tblcustomertrans_detail(); getId.transactionid = txttransactionid.Text; if (txttransactionid.Text == getId.transactionid) { dgvProductDetails.DataSource = db.sp_display_customerDetails(txttransactionid.Text); } }