如何使用Windows CE将Excel文件导入和导出到SQL CE DB [英] How to Import and export Excel File to SQL CE DB using Windows CE

问题描述

问候，

谁能拥有将Excel文件数据导入和导出到SQLCE数据库表的示例应用程序.
我正在使用dot net 2008创建可以在Windows CE设备上运行的应用程序.
我创建了数据库为MyData.SDF的应用程序.在内部，我用商品代码，描述，数量，有效日期和价格创建了产品表.
现在我有一个Excel文件，其中包含项目代码，描述，数量，到期日期和价格等数据.Excel文件已复制到我的Windows CE设备应用程序路径.
当我尝试从设备应用程序路径中读取Excel文件时，它给了我错误.文件未找到.有人可以建议我其他方法来完成这些导入和导出过程吗?

Greetings,

Can anyone have sample application for Import and Export Excel file data to SQLCE database table.
I am using dot net 2008 to create an application which can work on Windows CE devices.
I created the application with database as MyData.SDF. inside i created Product table with Itemcode,Description,Qty,Expirydate and price.
Now i have an excel file with data such as Itemcode,Description,Qty,Expirydate and price.The excel file is copied to my Windows CE device application path.
While i am trying the read the Excel file from the device application path, it gives me error. File not found. Can some one suggest me any other methods to complete these import and export process. your help will be highly appreciated.

推荐答案

首先，我要感谢您提出的宝贵意见和答复.
突然我意识到问题不是因为方式，而是因为我的疏忽大意.我删除了整个编码，然后重新开始.这次，我做到了.问题是通过在我的项目中添加相同的文件并为其属性赋予复制到"权限，可以解决文件路径.
要从仿真器运行，需要将文件添加到项目中.

Hi ,
First of all, i want to thank you for all the valuable comments and replies.
Suddenly i realize that the problem is not because of the way, but it is because of my sheer negligence. I delete the entire coding and start fresh. This time, i made it. The problem is of the file path is solved by adding the same file in my project and given "Copy to" permission to its properties.
Running from an emulator need the file to be added in the project.

这篇关于如何使用Windows CE将Excel文件导入和导出到SQL CE DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！