在DataGridView中浏览shp图层的属性表[.dbf文件]

        每次浏览shp图层的属性表时,总是使用ArcMap打开,比较麻烦。虽然网络中有小巧的DBF数据库浏览工具,也还是觉得有点大材小用。

        下面的C#代码用来读取shp图层的属性表,并在DataGridView中显示,在VS 2005中调试通过,代码很简单。

OpenFileDialog ofdDBF  =   new  OpenFileDialog();
ofdDBF.Filter 
=   " 属性表文件(*.dbf)|*.dbf " ;
if  (ofdDBF.ShowDialog()  ==  DialogResult.OK)
{
    
string  OpenFileName  =  ofdDBF.FileName.Trim();
    
string  dbfFilePath  =  Path.GetDirectoryName(OpenFileName);
    
string  dbfFileName  =  Path.GetFileName(OpenFileName);

    IWorkspaceFactory pWorkspaceFactory 
=   new  ShapefileWorkspaceFactoryClass();
    IWorkspace pWorkspace 
=  pWorkspaceFactory.OpenFromFile(dbfFilePath,  0 );
    IFeatureWorkspace pFeatureWorkspace 
=  pWorkspace  as  IFeatureWorkspace;
    
if  (pFeatureWorkspace  !=   null )
    {
        IFeatureClass pFeatureClass 
=  pFeatureWorkspace.OpenFeatureClass(dbfFileName);
        
if  (pFeatureClass  !=   null )
        {
            DataTable dt 
=   new  DataTable();
            DataColumn dc 
=   null ;

            
for  ( int  i  =   0 ; i  <  pFeatureClass.Fields.FieldCount; i ++ )
            {
                dc 
=   new  DataColumn(pFeatureClass.Fields.get_Field(i).Name);
                dt.Columns.Add(dc);
            }

            IFeatureCursor pFeatureCursor 
=  pFeatureClass.Search( null false );
            IFeature pFeature 
=  pFeatureCursor.NextFeature();
            DataRow dr 
=   null ;
            
while  (pFeature  !=   null )
            {
                dr 
=  dt.NewRow();
                
for  ( int  j  =   0 ; j  <  pFeatureClass.Fields.FieldCount; j ++ )
                {
                    
if  (pFeatureClass.FindField(pFeatureClass.ShapeFieldName)  ==  j)
                    {
                        dr[j] 
=  pFeatureClass.ShapeType.ToString();
                    }
                    
else
                    {
                        dr[j] 
=  pFeature.get_Value(j).ToString();
                    }
                }
                dt.Rows.Add(dr);
                pFeature 
=  pFeatureCursor.NextFeature();
            }
            dataGridView1.DataSource 
=  dt;
        }
    }
}

这样就再也不用每次都费力的打开ArcMap了,用这个小工具即可。

转载于:https://www.cnblogs.com/GISCafe/archive/2008/05/22/1206395.html

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
c# DBF数据库导入导出实例 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.Odbc; using System.Data.SqlClient; namespace DbfExample { public partial class Form1 : Form { System.Data.Odbc.OdbcConnection conn; public Form1() { InitializeComponent(); } //导出数据 private void btnOut_Click(object sender, EventArgs e) { string connect = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\\; "; OdbcConnection myconn = new OdbcConnection(connect); string sqlt ="CREATE TABLE aa.DBF (cc int(10))"; myconn.Open(); OdbcCommand olec = new OdbcCommand(sqlt, myconn); try { int i = olec.ExecuteNonQuery(); MessageBox.Show("'" + i + "'success"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { olec.Dispose(); myconn.Close(); } //string ole_connstring = @"Provider=microsoft.jet.oledb.5.0;Data Source=D:\;"; //System.Data.OleDb.OleDbConnection ole_conn = new System.Data.OleDb.OleDbConnection(ole_connstring); //try //{ // ole_conn.Open(); // System.Data.OleDb.OleDbCommand cmd1 = new System.Data.OleDb.OleDbCommand // ("Create Table TestTable (Field1 int, Field2 char(10),Field float(10,2))", // ole_conn); // System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand // ("Insert Into TestTable values (1,'Hello3',520.20)", ole_conn); // System.Data.OleDb.OleDbCommand cmd3 = new System.Data.OleDb.OleDbCommand // ("Insert Into TestTable values (2,'Hello4',18076.60)", ole_conn); // cmd1.ExecuteNonQuery(); // cmd2.ExecuteNonQuery(); // cmd3.ExecuteNonQuery(); //} //catch (Exception ex) //{ // MessageBox.Show(ex.Message); //} //finally //{ // ole_conn.Close(); //} } //导入数据 private void btnIn_Click(object sender, EventArgs e) { } private void Form1_Load(object sender, EventArgs e) { Bind(); } private void Bind() { try { conn = new System.Data.Odbc.OdbcConnection(); string table = @"C:\测试例子\Dbf\prepur.dbf"; string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + table + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO"; conn.ConnectionString = connStr; conn.Open(); string sql = @"select * from " + table; OdbcDataAdapter da = new OdbcDataAdapter(sql, conn); DataTable dt = new DataTable(); da.Fill(dt); this.dataGridView1.DataSource = dt.DefaultView; //MessageBox.Show(dt.Rows[0][0].ToString()); } catch { } finally { conn.Close(); } } private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { conn = new System.Data.Odbc.OdbcConnection(); string table = @"C:\测试例子\Dbf\table1.dbf"; string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + table + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO"; conn.ConnectionString = connStr; conn.Open(); string id = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); string sql = @"select * from " + table + " where id='" + id + "'"; OdbcDataAdapter da = new OdbcDataAdapter(sql, conn); DataTable dt = new DataTable(); da.Fill(dt); txtId.Text = id; txtName.Text = dt.Rows[0]["name"].ToString(); txtAddress.Text = dt.Rows[0]["address"].ToString(); } catch { } finally { conn.Close(); } } private void Add() { conn = new System.Data.Odbc.OdbcConnection(); string table = @"C:\temp\Dbf\table1.dbf"; string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + table + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO"; conn.ConnectionString = connStr; conn.Open(); OdbcCommand cmd = new OdbcCommand(); cmd.Connection = conn; string sql = "insert into " + table + " values('" + txtId.Text + "','" + txtName.Text + "','" + txtAddress.Text + "')"; cmd.CommandText = sql; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); Bind(); } private void btnTOSQL_Click(object sender, EventArgs e) { try { string sql = "Insert Into dbftosql select * From openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=C:\\temp\\Dbf','select * from table1.dbf')"; SqlConnection con = new SqlConnection("server=.;database=labelprint;uid=sa;pwd=sa"); con.Open(); SqlCommand cmd = new SqlCommand(sql, con); cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值