how do I populate a datagrid in a smart device with data from a sql database(not SQL CE)

//to populate dataset
SqlDataAdapter da = new SqlDataAdapter ("select * from yourtable",connection);
DataSet ds = new DataSet();
//fill dataset with the returned results by da

//if dataset is not empty to prevent exception when there is no records returned
if(ds.Tables[0].Rows.Count > 0)
//populate the datagridview by dataset
dataGridView1.DataSource = ds.Tables[0]
//do something like
MessageBox.Show("no records");

thank you very much AngelicOne i really neede it.

if this works please mark this thread as solved so others that has the same problems will have an easy time finding the answer.