Hi,
How could I retrieve datarow as sql below from datatable which its data still in datatable but not yet saved in database?

You can use the MyBO.CurrentDataTable.Select() method.  It returns an array of DataRow objects that match whatever criteria you specify.  However, if you just want one field, you'll have to just iterate through the rows of the DataTable and get the values.