Filtering DataSet

Question

Hi, I am developing an windows application, I want to get data from sql server which is in remote server in to dataset initially and then manipulate data on the entire form with dataset with custom filteration how can i make it ?.