Plz tell me how to fill a dataset with a view which exist in sql server instead of table.

and one more thing is it possble to fetch values from a table if it is locked by oledbtransaction.