91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 37KB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發布日期: 2021-06-06
  • 語言: C#
  • 標簽: C#??Excel??

資源簡介

C#從Excel中提取數據到DataGridView中顯示出來 以excel為數據源，建立連接，把excel中的數據讀到dataset中，再賦給datagridview，顯示出來。

資源截圖

代碼片段和文件信息 

using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.OleDb;

namespace?excel
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????string?strConn?=?“Provider=Microsoft.Jet.OLEDB.4.0;“?+?“Data?Source=d:\\Book1.xls;“?+?“Extended?Properties=‘Excel?8.0‘“;
????????????OleDbConnection?con=new?OleDbConnection?（strConn?）;
????????????OleDbDataAdapter?da?=?new?OleDbDataAdapter（“select?*?from?[Sheet1$]“con?）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds）;
????????????dataGridView1.DataSource?=?ds.Tables[0];?
????????}

????????private?void?dataGridView1_CellContentClick（object?sender?DataGridViewCellEventArgs?e）
????????{

????????}

????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-05-06?09:13??excel\
?????目錄???????????0??2013-05-06?18:23??excel\excel\
?????文件????????2486??2013-05-06?16:20??excel\excel\Form1.Designer.cs
?????文件????????1001??2013-05-06?18:23??excel\excel\Form1.cs
?????文件????????5814??2013-05-06?16:20??excel\excel\Form1.resx
?????文件?????????486??2013-05-06?09:13??excel\excel\Program.cs
?????目錄???????????0??2013-05-06?09:13??excel\excel\Properties\
?????文件????????1342??2013-05-06?09:13??excel\excel\Properties\AssemblyInfo.cs
?????文件????????2860??2013-05-06?09:13??excel\excel\Properties\Resources.Designer.cs
?????文件????????5612??2013-05-06?09:13??excel\excel\Properties\Resources.resx
?????文件????????1090??2013-05-06?09:13??excel\excel\Properties\Settings.Designer.cs
?????文件?????????249??2013-05-06?09:13??excel\excel\Properties\Settings.settings
?????目錄???????????0??2013-05-06?09:13??excel\excel\bin\
?????目錄???????????0??2013-05-06?16:20??excel\excel\bin\Debug\
?????文件????????8704??2013-05-06?17:53??excel\excel\bin\Debug\excel.exe
?????文件???????24064??2013-05-06?17:53??excel\excel\bin\Debug\excel.pdb
?????文件???????14328??2013-05-07?09:14??excel\excel\bin\Debug\excel.vshost.exe
?????文件?????????490??2009-06-11?05:14??excel\excel\bin\Debug\excel.vshost.exe.manifest
?????文件????????3756??2013-05-06?16:20??excel\excel\excel.csproj
?????目錄???????????0??2013-05-06?09:13??excel\excel\obj\
?????目錄???????????0??2013-05-06?17:53??excel\excel\obj\Debug\
?????目錄???????????0??2013-05-07?09:31??excel\excel\obj\Debug\TempPE\
?????文件?????????180??2013-05-06?16:20??excel\excel\obj\Debug\excel.Form1.resources
?????文件?????????180??2013-05-06?16:20??excel\excel\obj\Debug\excel.Properties.Resources.resources
?????文件?????????838??2013-05-07?09:14??excel\excel\obj\Debug\excel.csproj.FileListAbsolute.txt
?????文件?????????847??2013-05-06?16:20??excel\excel\obj\Debug\excel.csproj.GenerateResource.Cache
?????文件????????8704??2013-05-06?17:53??excel\excel\obj\Debug\excel.exe
?????文件???????24064??2013-05-06?17:53??excel\excel\obj\Debug\excel.pdb
?????文件?????????905??2013-05-06?09:13??excel\excel.sln
?????文件???????15360??2013-05-07?09:25??excel\excel.suo

評論

共有 條評論