資源簡(jiǎn)介
C# 從Excel導(dǎo)入數(shù)據(jù)到DataGridView、SqlServer,C# 從Excel導(dǎo)入數(shù)據(jù)到DataGridView、SqlServerC# 從Excel導(dǎo)入數(shù)據(jù)到DataGridView、SqlServerC# 從Excel導(dǎo)入數(shù)據(jù)到DataGridView、SqlServerC# 從Excel導(dǎo)入數(shù)據(jù)到DataGridView、SqlServerC# 從Excel導(dǎo)入數(shù)據(jù)到DataGridView、SqlServer

代碼片段和文件信息
using?System;
using?System.Data;
using?System.Text;
using?System.Data.SqlClient;
using?System.Configuration;
using?System.Security.Cryptography;
using?System.Security.Authentication;
///?
///DB?的摘要說明
///?
public?class?DB
{
public?DB()
{
//
//TODO:?在此處添加構(gòu)造函數(shù)邏輯
//
}
????public?SqlConnection?GetCon()
????{
????????return?new?SqlConnection(“Server=;User?Id=sa;Pwd=sa;Database=“);
????}
????public?DataSet?returnDS(string?cmdstr)
????{
????????SqlConnection?con?=?GetCon();
????????SqlDataAdapter?da?=?new?SqlDataAdapter(cmdstr?con);
????????DataSet?ds?=?new?DataSet();
????????da.Fill(ds);
????????return?ds;
????}
????public?int?ExecuteSql(string?strSql)
????{
????????SqlConnection?con?=?GetCon();
????????SqlCommand?cmd?=?new?SqlCommand(strSql?con);
????????try
????????{
????????????con.Open();
????????????int?rowsAffected?=?cmd.ExecuteNonQuery();
????????????return?rowsAffected;
????????}
????????catch?(System.Data.SqlClient.SqlException?e)
????????{
????????????throw?e;
????????}
????????finally
????????{
????????????con.Close();
????????}
????}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????923??2011-11-10?10:22??ExcelImport\ExcelImport.sln
????..A..H.?????15360??2011-11-18?10:51??ExcelImport\ExcelImport.suo
?????文件???????1178??2011-11-18?10:52??ExcelImport\ExcelImport\DB.cs
?????文件???????3766??2011-11-10?14:06??ExcelImport\ExcelImport\ExcelImport.csproj
?????文件???????8887??2011-11-18?10:50??ExcelImport\ExcelImport\Form1.cs
?????文件???????8829??2011-11-17?18:01??ExcelImport\ExcelImport\Form1.Designer.cs
?????文件???????7107??2011-11-17?18:01??ExcelImport\ExcelImport\Form1.resx
?????文件????????492??2011-11-10?10:22??ExcelImport\ExcelImport\Program.cs
?????文件???????1378??2011-11-10?10:21??ExcelImport\ExcelImport\Properties\AssemblyInfo.cs
?????文件???????2872??2011-11-10?10:21??ExcelImport\ExcelImport\Properties\Resources.Designer.cs
?????文件???????5612??2011-11-10?10:21??ExcelImport\ExcelImport\Properties\Resources.resx
?????文件???????1096??2011-11-10?10:22??ExcelImport\ExcelImport\Properties\Settings.Designer.cs
?????文件????????249??2011-11-10?10:21??ExcelImport\ExcelImport\Properties\Settings.settings
?????文件????????840??2011-11-18?10:42??ExcelImport\ExcelImport\obj\Debug\ExcelImport.csproj.FileListAbsolute.txt
?????文件????????847??2011-11-15?14:34??ExcelImport\ExcelImport\obj\Debug\ExcelImport.csproj.GenerateResource.Cache
?????文件??????16384??2011-11-16?17:06??ExcelImport\ExcelImport\obj\Debug\ExcelImport.exe
?????文件????????180??2011-11-15?14:34??ExcelImport\ExcelImport\obj\Debug\ExcelImport.Form1.resources
?????文件??????34304??2011-11-16?17:06??ExcelImport\ExcelImport\obj\Debug\ExcelImport.pdb
?????文件????????180??2011-11-10?14:09??ExcelImport\ExcelImport\obj\Debug\ExcelImport.Properties.Resources.resources
?????文件??????16384??2011-11-16?17:06??ExcelImport\ExcelImport\bin\Debug\ExcelImport.exe
?????文件??????34304??2011-11-16?17:06??ExcelImport\ExcelImport\bin\Debug\ExcelImport.pdb
?????文件??????14328??2011-11-18?10:42??ExcelImport\ExcelImport\bin\Debug\ExcelImport.vshost.exe
?????文件????????490??2007-07-21?01:33??ExcelImport\ExcelImport\bin\Debug\ExcelImport.vshost.exe.manifest
?????目錄??????????0??2011-11-18?10:51??ExcelImport\ExcelImport\obj\Debug\TempPE
?????目錄??????????0??2011-11-18?10:51??ExcelImport\ExcelImport\obj\Debug\Refactor
?????目錄??????????0??2011-11-18?10:51??ExcelImport\ExcelImport\obj\Debug
?????目錄??????????0??2011-11-18?10:51??ExcelImport\ExcelImport\bin\Debug
?????目錄??????????0??2011-11-18?10:51??ExcelImport\ExcelImport\Properties
?????目錄??????????0??2011-11-18?10:51??ExcelImport\ExcelImport\obj
?????目錄??????????0??2011-11-18?10:51??ExcelImport\ExcelImport\bin
............此處省略5個(gè)文件信息
評(píng)論
共有 條評(píng)論