OracleDataReader 和 OracleDataAdapter 用例

最新推荐文章于 2023-04-21 13:59:08 发布

原创最新推荐文章于 2023-04-21 13:59:08 发布 · 4.7k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#dataset

Oracle Spatial 专栏收录该内容

6 篇文章

订阅专栏

1.OracleDataReader

cmd.commandtext = "select name,shape from spatial.cola_markets";

                using (oracledatareader readergeoinfo = cmd.executereader())
                {
                    while (readergeoinfo.read())
                    {
                        geoinfo geoinfo = new geoinfo();
                        if (!readergeoinfo.isdbnull(0))
                        {
                            geoinfo.id = readergeoinfo.getstring(0);
                        }
                        if (!readergeoinfo.isdbnull(1))
                        {
                            geoinfo.geo = (sdogeometry)readergeoinfo.getvalue(1);
                        }
                        geoinfolist.add(geoinfo);
                        console.writeline(geoinfo.id.tostring());
                    }
                    readergeoinfo.close();

}

2.OracleDataAdapter

                    using (OracleDataAdapter ad = new OracleDataAdapter("select * from SPATIAL.COLA_MARKETS", con))
                    {
                        System.Data.DataSet ds = new DataSet();
                        ad.Fill(ds);
                        DataTable tt = ds.Tables[0];
                        SdoGeometry d = (SdoGeometry)tt.Rows[4][2];

}