ARCGIS-ENGINE二次开发常用代码.doc

需积分: 19 154 浏览量更新于2024-01-15 评论收藏 137KB DOC 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

}

break;

case "ZoomOut":

{

ICommand command = new ControlsSceneZoomOutTool();

command.OnCreate(this.axSceneControl1.Object);

this.axSceneControl1.CurrentTool = command as ESRI.ArcGIS.SystemUI.ITool;

}

break;

case "Pan":

{

ICommand command = new ControlsScenePanTool();

command.OnCreate(this.axSceneControl1.Object);

this.axSceneControl1.CurrentTool = command as ESRI.ArcGIS.SystemUI.ITool;

}

break;

case "Navigate":

{

ICommand command = new ControlsSceneNavigateTool();

command.OnCreate(this.axSceneControl1.Object);

this.axSceneControl1.CurrentTool = command as ESRI.ArcGIS.SystemUI.ITool;

10. C# ACCESS�� ݿ�

using System.Data.OleDb

public string myConnstring="Provider=Microsoft.Jet.OLEDB.4.0;

Data Source="+HttpContext.Current.Server.MapPath("data.mdb"); //data.mdb��

ݿ��

OleDbConnection MyConnection;

MyConnection = new OleDbConnection(myConnstring);

strInsert=""; //strinsert sql��

OleDbCommand MyCommand = new OleDbCommand(strInsert,MyConnection);

MyConnection.Open();

MyCommand.ExecuteNonQuery();

MyConnection.Close();

11. ļ word // ļ System.Object Nothing = ��

System.Reflection.Missing.Value; Directory.CreateDirectory("c:/CNSI");

// ļ Ŀ¼ string name = "CNSI_" + DateTime.Now.ToLongDateString() + ��

".doc"; object filename = "c://CNSI//" + name; // ļ ·� ��

// Word ĵ Microsoft.Office.Interop.Word.Application WordApp = new ��

Microsoft.Office.Interop.Word.ApplicationClass();

Microsoft.Office.Interop.Word.Document WordDoc = WordApp.Documents.Add(ref

Nothing, ref Nothing, ref Nothing, ref Nothing); IQueryFilter pQueryFilter;

pQueryFilter = pFeatureWorkspace;

ĵ string name = "y00"; object filename = "c://CNSI//" + ��

name;// ļ · object Nothing = System.Reflection.Missing.Value; ��

//Microsoft.Office.Interop.Word.Application WordApp = new

Microsoft.Office.Interop.Word.ApplicationClass();

Microsoft.Office.Interop.Word.Document WordDocs = WordApp.Documents.Add(ref

Nothing, ref Nothing, ref Nothing, ref Nothing); WordDocs.Close(ref Nothing, ref

Nothing, ref Nothing); WordApp.Quit(ref Nothing, ref Nothing, ref Nothing);

WordDocs.SaveAs(ref filename, ref Nothing, ref Nothing, ref Nothing, ref

Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref

Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing, ref Nothing);

//WordApp.Quit(ref Nothing, ref Nothing, ref Nothing); message = name +

" ĵ ɳɹ� �� Ա��浽 C:CNSI "; hy catch { message = " ļ�� 쳣��"; } string path =

"E:\\yxl\\tianjia\\database2.mdb"; IWorkspace iW =

AccessWorkspaceFromPropertySet(path); IFeatureWorkspace pFeatureWorkspace =

(IFeatureWorkspace)iW; ITable pTable = pFeatureWorkspace.OpenTable("database2");

12. C# Access�� ݿ�ķ��

//ȡ public OleDbConnection getConn() { ConnectDatabase connstr=new ��

ConnectDatabase(); string connStr=connstr.GetConnectionString(); OleDbConnection

oledb=new OleDbConnection(connStr); return oledb; }

1 OleDbCommand,OleDbDataReader�� ݿ�

1. ѯ��

public User getUserFromName(string Searchname) { User tempUser=new User(); try {

OleDbConnection oleconn=getConn();//��ݿ �� string strSel="select * from MyUser

where UserName='"+Searchname+"'";// ѯ OleDbCommand myCommand=new ��

OleDbCommand(strSel,oleconn);// ѯ oleconn.Open();//�� ݿ ��

OleDbDataReader reader; reader=myCommand.ExecuteReader();//ִ�в ѯ ꣺꣺꣺꣺� �� ؼ�¼ ��

if(reader.Read()) { tempUser.ID=(int)reader["UserID"];

tempUser.Name=reader["UserName"].ToString();

tempUser.Salary=(float)reader["UserSalary"];

tempUser.Password=reader["UserPassword"].ToString();

tempUser.Memo=reader["UserMemo"].ToString();

tempUser.Birthday=(DateTime)reader["UserBirthday"];

tempUser.Address=reader["UserAddress"].ToString(); } else

{ throw new Exception("û м ¼"); } reader.Close();//� � �ر ¼ oleconn.Close();//ռ� ��

ر��

} catch(Exception e) { throw new Exception("��ݿ��"+e.Message); } return

tempUser; }

2. ¼��

public void InsertUser(User insertuser) { try { OleDbConnection

oleconn=getConn();//��ݿ �� oleconn.Open();//��ݿ �� string strSel="insert

into [MyUser]([UserName],[UserPassword],

[UserSalary],[UserAddress],[UserBirthday],[UserMemo])"; // strSel+=" ��

values

('"+insertuser.Name+"','"+insertuser.Password+"',"+insertuser.Salary.ToSt

ring(); strSel+=",'"+insertuser.Address+"',#"+insertuser.Birthday.ToString()

+"#,'"+insertuser.Memo+"')"; OleDbCommand myCommand=new

OleDbCommand(strSel,oleconn);// ѯ myCommand.ExecuteNonQuery(); ��

oleconn.Close();//�ر��

} catch(Exception e) { throw new Exception("��ݿ��"+e.Message); } }

3.ɾ ¼��

public void DeleteUser(int m_id) { try { OleDbConnection oleconn=getConn();

oleconn.Open(); string strSel="Delete From [Myuser] where

UserID="+m_id.ToString(); OleDbCommand myCommand=new

OleDbCommand(strSel,oleconn); myCommand.ExecuteNonQuery(); oleconn.Close(); }

catch(Exception e) { throw new Exception("ɾ ¼ "+e.Message); } }��

2 OleDbDataAdapter,OleDbCommandBuilder,DataSet,DataTable,DataRow��

��ݿ�

Ӽ ¼��

public void InsertUserA(User insertUser) { using(OleDbConnection conn=getConn())

{ OleDbDataAdapter adapter = new OleDbDataAdapter(); string queryString="Select

* from MyUser order by UserID"; adapter.SelectCommand = new

OleDbCommand(queryString, conn);

OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter); //

builder.QuotePrefix="["; // builder.QuoteSuffix="]"; conn.Open();

DataSet users = new DataSet(); adapter.Fill(users,"MyUser"); DataTable dt=new

DataTable(); dt=users.Tables["MyUser"]; DataRow r=dt.NewRow();

r["UserName"]=insertUser.Name; r["UserPassword"]=insertUser.Password;

r["UserAddress"]=insertUser.Address; r["UserSalary"]=insertUser.Salary;

r["UserBirthday"]=insertUser.Birthday; r["UserMemo"]=insertUser.Memo;

dt.Rows.Add(r); adapter.Update(users, "MyUser");

} }

Ҫ�� ע�� ֶβ��꣺ؼ ꣺꣺꣺꣺꣺꣺꣺꣺꣺꣺�� Insert into ʾ�� 취��

ǰһƪ

(3) ò ѯ ķ ʽ��

public class AccessUtil { public AccessUtil() { } private string connString;

public string ConnString {

get { return connString; } set { connString = value; } } public

AccessUtil(string connstr) { this.connString = connstr; }

// Ĳ ,�� ֵΪid�ؼ��ֵ�ֵ, public int ExecuteInsert(string SQL, ��

OleDbParameter[]

parameters) { using(OleDbConnection conn=new OleDbConnection(connString))

{ OleDbCommand cmd = new OleDbCommand(SQL, conn); try { conn.Open(); if

(parameters!=null) { cmd.Parameters.AddRange(parameters); }

cmd.ExecuteNonQuery(); cmd.CommandText = @"Select @@identity"; int value =

Int32.Parse(cmd.ExecuteScalar().ToString

剩余63页未读，继续阅读

maycactus

粉丝: 0
资源: 9

会员权益专享

"ARCGIS-ENGINE二次开发常用代码：生成面及文件操作"

评论0

会员权益专享

最新资源

"ARCGIS-ENGINE二次开发常用代码：生成面及文件操作"

评论0

ArcEngine最全的实验代码（GIS程序设计教程所有源码）

ArcGIS-Engine基础开发教程(C#)C#二次开发ArcGis.pdf

ArcGIS+Engine二次开发常用源代码

arcgisengine二次开发源代码

arcgisengine二次开发 例子下载

基于arcgisengine二次开发

arcgis engine二次开发书籍

有什么arcgis engine二次开发教程推荐

arcgis-android-100.4.0

arcgis-for-javascript最全中文api.pdf

arcgisengine二次开发最短路径

arcgis engine二次开发c#

terraformer-arcgis-parser

gis二次开发 平移的代码 C#语言

c#arcgis 二次开发

Arcgis engine二次开发中实现编辑功能

arcgis engine c#开发实例

arcengine二次开发

arcgis二次开发属性查询

arcgis engine和ENVI联合开发实例

会员权益专享

最新资源

arcgisengine二次开发例子下载

gis二次开发平移的代码 C#语言