public static DataSet LoadData()
{
	string sqlstring = "";

	//  Make the connection to the SQL Server CE data source
	SqlCeConnection conn = new SqlCeConnection("Data Source=<completePath of SDF file>");

	//  Create the SqlCeDataAdapter object
	sqlCeDataAdapter da = new SqlCeDataAdapter();

	//  Create the DataSet object
	DataSet ds = new DataSet();

	try
	{
		sqlstring = "select name from mytable where name = ?";

		// Create the SelectCommand instance to run a select query
		da.SelectCommand = new SqlCeCommand();

		// Set SelectCommand object properties
		da.SelectCommand.Connection = conn;
        	da.SelectCommand.CommandText = sqlstring;
		da.SelectCommand.Parameters.Add(new  SqlCeParameter("name", System.Data.SqlDbType.NVarChar, 30));
		da.SelectCommand.Parameters["name"].Value = name;


		//  Populate the DataSet object
		da.Fill(ds,"name");
	}

	catch (SqlCeException sqlx)
	{
         	ShowErrors(sqlx);
	}

	catch (Exception x)
        {
		MessageBox.Show(x.Message.ToString());
	}

	finally
	{
		//  Explicitly dispose the SelectCommand instance
		da.SelectCommand.Dispose();

		da.Dispose();
	}

	return ds;
}

public System.Data.IDbDataAdapter DisposeAdapter (System.Data.IDbDataAdapter dbAdapter)
{
	if (dbAdapter is SqlCeDataAdapter)	
	{
		// Create the SqlCeCommand object and assign the SelectCommand object
		SqlCeCommand cmd = dbAdapter.SelectCommand;


		// Dispose the SqlCeCommand object
                if (cmd != null) 
                {
                    cmd.Dispose();
                }

                cmd = dbAdapter.InsertCommand;
                if (cmd != null) 
                {
                    cmd.Dispose();
                }

                cmd = dbAdapter.UpdateCommand;
                if (cmd != null) 
                {
                    cmd.Dispose();
                }

                cmd = dbAdapter.DeleteCommand; 
                if (cmd != null) 
                {
                    cmd.Dispose();
                }
	}

	return null;
}