DataTable使用示例

private DataSet GetDataSet(OdbcConnection conn)
{
    try
    {
        string sql = "select * from mytable";
        OdbcDataAdapter adapter = new OdbcDataAdapter(sql, conn);
        DataSet dataSet = new DataSet();
        adapter.Fill(dataSet, "mytable");
        return dataSet;
    }
    catch 
    {
        return null;
    }
}