MapXtreme2005 Table在GridView中显示

ForXtremeMap

于 2008-09-23 11:30:00 发布

阅读量680

点赞数

分类专栏： MapXtreme2005 文章标签： table

本文链接：https://blog.csdn.net/ForXtremeMap/article/details/2966554

版权

MapXtreme2005 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

MIConnection connection = new MIConnection();
        connection.Open();
        MICommand miCommand = connection.CreateCommand();
        miCommand.CommandText = "Select Country,Capital,Continent from world";
        miCommand.Prepare();
        MapInfo.Data.MIDataReader miReader = miCommand.ExecuteReader();
        DataTable dt = new DataTable("Data");
        for (int i = 0; i < miReader.FieldCount; i++)
        { DataColumn dc = dt.Columns.Add(miReader.GetName(i)); }
        while (miReader.Read())
        {
            DataRow dr = dt.NewRow();
            for (int i = 0; i < miReader.FieldCount; i++)
            { dr[i] = miReader.GetValue(i); }
            dt.Rows.Add(dr);
        }
        dt.Columns[0].ColumnMapping = MappingType.Hidden;
        dt.Columns[1].ColumnMapping = MappingType.Hidden;
        dt.Columns[2].ColumnMapping = MappingType.Hidden;
        GridView1.DataSource = dt;
        GridView1.DataBind();
        miReader.Close();