把选择的结果填充到datagrid中
2015-06-11 12:00:14 访问(1362) 赞(0) 踩(0)
MapInfo.Data.MICommand cmd = Connection.CreateCommand();
cmd.CommandText = "select " + " Round(MI_Area(Obj,'sq mi','Spherical'),1) " + ",state from usa";
MapInfo.Data.MIDataReader tmpReader = cmd.ExecuteReader();
DataTable dt = new DataTable("Data");
for (int i = 0; i < tmpReader.FieldCount; i++)
{
DataColumn dc = dt.Columns.Add(tmpReader.GetName(i));
}
while (tmpReader.Read())
{
DataRow dr = dt.NewRow();
for (int i = 0; i < tmpReader.FieldCount; i++)
{
dr[i] = tmpReader.GetValue(i);
}
dt.Rows.Add(dr);
}
dataGrid1.DataSource = dt;
tmpReader.Close(); //otherwise it will cause an exception.
标签：
把选择的结果填充到datagrid中 
上一条：
下一条：
相关评论
发表评论