資源簡(jiǎn)介
c#實(shí)現(xiàn)從數(shù)據(jù)庫(kù)展示到DataGridView中,并通過(guò)按鈕導(dǎo)出到Excel表格,同時(shí)也可以通過(guò)按鈕將Excel數(shù)據(jù)導(dǎo)入到數(shù)據(jù)庫(kù)中

代碼片段和文件信息
/************************************************************************
?*???杭州申昊科技有限公司???http://www.shenhaoinfo.com/???????????? *
?************************************************************************/
/************************************************************************
?*??????????????????????????????????????????????????????????????????????*
?*?*
?*??????????????????????????????????????????????????????????????????????*
?************************************************************************/
/************************************************************************
?*??????????????????????????????????????????????????????????????????????*
?*??目的:??通過(guò)該類保存系統(tǒng)的一些常量??? *????????????????????????????????????
?
?************************************************************************
?*?作者:???????John
?*?創(chuàng)建日期:???2008-07-01
?*?版本?:???????V1.0??????????????????????????????????????????????????????????*
?*??????????????????????????????????????????????????????????????????????*
?************************************************************************
?*?版本修正歷史
?*??????修改時(shí)間:??????????????????????修改人:????????????????????
?*??????修改原因:
?*?
?*?
?*?************************************************************************
?*??杭州申昊科技有限公司?保留所有的版權(quán)?????????????????????????*
?************************************************************************/
using?System;
using?System.Collections.Generic;
using?System.Text;
namespace?ExcToDataset
{
class?Constants
????{
????????public?static?string?CONSTR?=?“server=localhost;Integrated?Security=SSPI;database?=DB_ROBOT_KY_V2“;
public?static?double?DB_MIN_VALUE?=?-999999999;
public?static?double?DB_MAX_VALUE?=?999999999;
????????public?const?string?STR_DEVICE_TYPE_Transducer?=?“2“;
????????public?const?string?STR_DEVICE_TYPE_VisualCamera?=?“5“;
????????public?const?string?STR_DEVICE_TYPE_InfraredCamera?=?“3“;
????????public?const?string?STR_DEVICE_TYPE_PTZ?=?“6“;
????????public?const?string?STR_DEVICE_TYPE_IPC?=?“7“;
}
????//任務(wù)類型
????public?struct?TaskTypeInfo
????{
????????public?string?TaskTypeID?{?get;?set;?}
????????public?string?TaskTypeName?{?get;?set;?}
????}
????//任務(wù)信息
????public?struct?TaskInfo
????{
????????public?string?TaskID?{?get;?set;?}
????????public?string?TaskName?{?get;?set;?}
????}
????//區(qū)域信息
????public?struct?RegionInfo
????{
????????public?string?RegionID?{?get;?set;?}
????????public?string?RegionName?{?get;?set;?}
???????
????}
????//線路信息
????public?struct?LineInfo
????{
????????public?string?LineID?{?get;?set;?}
????????public?string?LineName?{?get;?set;?}
????????public?string?SubStationID?{?get;?set;?}
????????public?string?Remark?{?get;?set;?}
????????public?string?RegionID?{?get;?set;?}
????}
????//檢測(cè)設(shè)備信息
????public?struct?MDeviceInfo
????{
????????public?string?MDeviceID?{?get;?set;?}
????????public?string?MDeviceName?{?get;?set;?}
????????public?string?DeviceTypeID?{?get;?set;?}
????????public?s
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-05-27?16:04??ExcToDataset\
?????目錄???????????0??2016-05-27?15:58??ExcToDataset\ExcToDataset\
?????文件?????????878??2016-05-11?13:13??ExcToDataset\ExcToDataset.sln
?????文件?????????217??2016-05-27?15:26??ExcToDataset\ExcToDataset\App.config
?????目錄???????????0??2016-05-27?15:23??ExcToDataset\ExcToDataset\bin\
?????目錄???????????0??2016-05-27?15:59??ExcToDataset\ExcToDataset\bin\databa
?????文件?????3988992??2016-05-27?15:59??ExcToDataset\ExcToDataset\bin\databa
?????目錄???????????0??2016-05-27?15:57??ExcToDataset\ExcToDataset\bin\Debug\
?????目錄???????????0??2016-05-11?13:13??ExcToDataset\ExcToDataset\bin\Release\
?????文件????????8601??2016-05-20?10:41??ExcToDataset\ExcToDataset\Constants.cs
?????文件????????4437??2016-05-27?12:20??ExcToDataset\ExcToDataset\ExcToDataset.csproj
?????文件?????????217??2016-05-20?10:22??ExcToDataset\ExcToDataset\ExcToDataset.exe.config
?????文件?????????217??2016-05-20?10:22??ExcToDataset\ExcToDataset\ExcToDataset.vshost.exe.config
?????文件??????101083??2016-05-27?15:43??ExcToDataset\ExcToDataset\ExcToDatasetFrm.cs
?????文件???????26710??2016-05-27?08:23??ExcToDataset\ExcToDataset\ExcToDatasetFrm.designer.cs
?????文件????????5817??2016-05-27?08:23??ExcToDataset\ExcToDataset\ExcToDatasetFrm.resx
?????文件????????7689??2016-05-11?13:13??ExcToDataset\ExcToDataset\ListToDataSet.cs
?????文件?????????503??2016-05-16?21:36??ExcToDataset\ExcToDataset\Program.cs
?????目錄???????????0??2016-05-27?15:23??ExcToDataset\ExcToDataset\Properties\
?????文件????????1374??2016-05-11?13:13??ExcToDataset\ExcToDataset\Properties\AssemblyInfo.cs
?????文件????????2876??2016-05-11?13:13??ExcToDataset\ExcToDataset\Properties\Resources.Designer.cs
?????文件????????5612??2016-05-11?13:13??ExcToDataset\ExcToDataset\Properties\Resources.resx
?????文件????????1099??2016-05-11?13:13??ExcToDataset\ExcToDataset\Properties\Settings.Designer.cs
?????文件?????????249??2016-05-11?13:13??ExcToDataset\ExcToDataset\Properties\Settings.settings
?????文件?????????122??2016-05-27?16:03??ExcToDataset\ReadMe.txt
評(píng)論
共有 條評(píng)論