将DBF,XLS,XML,MDB文件导入C#DataGrid的方法
发布日期:2021-06-30 19:10:54
浏览次数:2
分类:技术文章
本文共 6845 字,大约阅读时间需要 22 分钟。
以下的源码里分别给出了将DBF,XLS,XML,MDB文件导入C#DataGrid的方法,供各位参考。 //PutInDataSet.cs的源码 using System; using System.Data.Odbc; using System.Data.OleDb; using System.Data; using System.Collections; namespace PutInDataSet { /// <summary> /// DataSetTransIn 的摘要说明。 /// </summary> public class PutInDataSet { /// <summary> /// 传入的文件变量 /// </summary> private DataSet my_Ds;//存放文件的数据集 private string my_Err;//错误信息 private string my_TableName;//传入的文件名 private TableType my_TableType;//传入的文件类型 private string my_TablePath;//传入的文件路径 private int my_TableIndex;//表的索引 OleDbCommandBuilder my_Builder;//命令串 /// <summary> /// 数据库连接变量 /// </summary> private string my_StrConnection;//连接字符串 private string my_StrSelect;//select语句 /// <summary> /// 可以处理的文件类型 /// </summary> public enum TableType { MDB,XLS,DBF,DOC,TXT,XML,HTML } public PutInDataSet(string TablePath,string TableName,TableType TableType) { ///<summary> ///获得传入的路径,文件名及文件类型; ///</summary> this.my_TablePath=TablePath;//路径 this.my_TableName=TableName;//文件名 this.my_TableType=TableType;//文件类型 } public DataSet Convert() { DataSet iRtn_Ds=new DataSet(); switch (this.my_TableType) { case TableType.DBF: iRtn_Ds = this.DbfToDs(); break; case TableType.MDB: iRtn_Ds = this.MdbToDs(); break; case TableType.XLS: iRtn_Ds = this.XlsToDs(); break; case TableType.XML: iRtn_Ds = this.XmlToDs(); break; } return iRtn_Ds; } ///<summary> ///将DBF文件放入DataSet ///</summary> private DataSet DbfToDs() { //数据库连接定义 OdbcConnection my_conn; //数据连接 OdbcDataAdapter my_Adapter;//数据适配器 //数据库连接 this.my_StrConnection= "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + this.my_TablePath; this.my_StrSelect="SELECT * FROM " + this.my_TableName; my_conn = new OdbcConnection(this.my_StrConnection); my_conn.Open(); my_Adapter = new OdbcDataAdapter(this.my_StrSelect,my_conn); this.my_Ds=new DataSet(); //填充数据集 my_Adapter.Fill(this.my_Ds,this.my_TableName); return this.my_Ds; } ///<summary> ///将MDB文件放入DataSet ///</summary> private DataSet MdbToDs() { //数据库连接定义 OleDbConnection my_conn; OleDbDataAdapter my_Adapter; //数据库连接 this.my_StrConnection= "Provider=Microsoft.JET.OLEDB.4.0;data source=" + this.my_TablePath; this.my_StrSelect="SELECT * FROM " + this.my_TableName; my_conn = new OleDbConnection(this.my_StrConnection); my_conn.Open(); my_Adapter = new OleDbDataAdapter(this.my_StrSelect,my_conn); this.my_Ds=new DataSet(); //填充数据集 my_Adapter.Fill(this.my_Ds,this.my_TableName); return this.my_Ds; } ///<summary> ///将XML文件放入DataSet ///</summary> private DataSet XmlToDs() { //填充数据集 this.my_Ds=new DataSet(); this.my_Ds.ReadXml(this.my_TablePath+this.my_TableName,XmlReadMode.ReadSchema); this.my_Ds.DataSetName="XmlData"; return this.my_Ds; } ///<summary> ///将Excel文件放入DataSet ///</summary> private DataSet XlsToDs() { OleDbConnection my_conn; OleDbDataAdapter my_Adapter; //数据库连接 this.my_StrConnection= "Provider=Microsoft.JET.OLEDB.4.0;Extended Properties=Excel 8.0;data source="+this.my_TablePath+this.my_TableName; this.my_StrSelect="SELECT * FROM [SHEET1$]"; my_conn = new OleDbConnection(this.my_StrConnection); my_conn.Open(); my_Adapter = new OleDbDataAdapter(this.my_StrSelect,my_conn); this.my_Builder=new OleDbCommandBuilder(my_Adapter); this.my_Ds=new DataSet(); //填充数据集 my_Adapter.Fill(this.my_Ds,"ExcelData"); return this.my_Ds; } } } //Form_PutInDataSet.cs的源码 using System; using System.Data; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using DataAccess.SysManage; using BusinessRules; using DataSetTrans; namespace WinForm.Common { /// <summary> /// FormDesktop 的摘要说明。 /// </summary> public class FormDesktop : System.Windows.Forms.Form { private WinForm.Common.DeskTop deskTop1; private System.Windows.Forms.Button button1; /// <summary> /// 必需的设计器变量。 /// </summary> private System.ComponentModel.Container components = null; private DataSet m_ds = new DataSet(); private System.Windows.Forms.DataGrid dataGrid1; //数据源 private string m_TableName; //外部文件名称 public FormDesktop() { // // Windows 窗体设计器支持所必需的 // InitializeComponent(); // // TODO: 在 InitializeComponent 调用后添加任何构造函数代码 // } /// <summary> /// 清理所有正在使用的资源。 /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.deskTop1 = new WinForm.Common.DeskTop(); this.button1 = new System.Windows.Forms.Button(); this.dataGrid1 = new System.Windows.Forms.DataGrid(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.SuspendLayout(); // // deskTop1 // this.deskTop1.BackColor = System.Drawing.SystemColors.Desktop; this.deskTop1.Location = new System.Drawing.Point(168, 440); this.deskTop1.Name = "deskTop1"; this.deskTop1.Size = new System.Drawing.Size(16, 24); this.deskTop1.TabIndex = 0; // // button1 // this.button1.Location = new System.Drawing.Point(256, 216); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(88, 40); this.button1.TabIndex = 1; this.button1.Text = "GetData"; this.button1.Click += new System.EventHandler(this.button1_Click); // // dataGrid1 // this.dataGrid1.DataMember = ""; this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid1.Location = new System.Drawing.Point(192, 40); this.dataGrid1.Name = "dataGrid1"; this.dataGrid1.Size = new System.Drawing.Size(216, 152); this.dataGrid1.TabIndex = 2; // // FormDesktop // this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); this.BackColor = System.Drawing.SystemColors.AppWorkspace; this.ClientSize = new System.Drawing.Size(624, 485); this.Controls.Add(this.dataGrid1); this.Controls.Add(this.button1); this.Controls.Add(this.deskTop1); this.Name = "FormDesktop"; this.Text = "系统控制台"; this.Resize += new System.EventHandler(this.FormDesktop_Resize); this.Load += new System.EventHandler(this.FormDesktop_Load); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.ResumeLayout(false); } #endregion private void FormDesktop_Load(object sender, System.EventArgs e) { } /// <summary> /// 当窗口改变大小时自动居中。 /// </summary> private void FormDesktop_Resize(object sender, System.EventArgs e) { if (this.WindowState != FormWindowState.Minimized) { if (this.Width > this.deskTop1.Width && this.Height > this.deskTop1.Height ) { this.deskTop1.Left = (this.Width - this.deskTop1.Width) / 2; this.deskTop1.Top = (this.Height- this.deskTop1.Height)/ 2; } } } private void button1_Click(object sender, System.EventArgs e) { DataSet out_Ds=new DataSet(); PutInDataSet obj=new PutInDataSet("文件路径","文件名",PutInDataSet.TableType.文件格式);//调用PutInDataSet类 out_Ds=obj.Convert();//转换到DataSet中 this.dataGrid1.DataSource=out_Ds.Tables["表名"];//在DataGrid中显示 } } }转载地址:https://linuxstyle.blog.csdn.net/article/details/1539786 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!
发表评论
最新留言
路过按个爪印,很不错,赞一个!
[***.219.124.196]2024年04月17日 00时49分36秒
关于作者
喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!
推荐文章
基于MATLAB的模拟调制信号与解调的仿真——SSB
2019-04-30
操作系统实验之生产者和消费者程序
2019-04-30
操作系统实验之猴子过桥问题的模拟程序
2019-04-30
POJ - 3067 Japan (树状数组 思维)
2019-04-30
POJ - 2352 Stars (树状数组 入门题)
2019-04-30
HDU - 1166 敌兵布阵 (树状数组模板题/线段树模板题)
2019-04-30
CodeForces - 761C Dasha and Password (思维 暴力)
2019-04-30
POJ - 2481 Cows (树状数组 入门题)
2019-04-30
ACM-ICPC 2018 焦作赛区网络预赛 I. Save the Room
2019-04-30
CodeForces - 987C Three displays (暴力/dp)
2019-04-30
计蒜客 NAIPC 2016 F. Mountain Scenes(dp)
2019-04-30
牛客国庆集训派对Day4——I 连通块计数(思维)
2019-04-30
牛客国庆集训派对Day4——G 区间权值(找规律,双重前缀和)
2019-04-30
牛客国庆集训派对Day5——L 数论之神(找规律/数论)
2019-04-30
CodeForces - 629B Far Relative’s Problem(模拟)
2019-04-30
CodeForces - 1059B Forgery (思维)
2019-04-30