£¨c#£©ExcelÓëSqlServer¼äÊý¾ÝÏ໥µ¼Èë
ÔÚÊý¾Ý¿â±à³ÌÖУ¬³£»áÓöµ½Òª°ÑÊý¾Ý¿â±íÐÅÏ¢µ¼ÈëExcelÖУ¬ ÓÐʱÔòÊÇ°ÑExcelÄÚÈݵ¼ÈëÊý¾Ý¿âÖС£ÔÚÕâÀ½«½éÉÜÒ»ÖֱȽϷ½±ã¿ì½ÝµÄ·½Ê½£¬Ò²ÊDZȽÏÆÕ±éµÄ¡£Æäʵ£¬Õâ·½·¨Äã²¢²»Ä°Éú¡£ÔÀíºÜ¼òµ¥£¬°ÑÊý¾Ý¿â±í»òExcelÄÚÈݶÁÈ¡µ½datasetÀàÐ͵ıäÁ¿ÖУ¬ÔÙÖðÌõ²åÈëµ½ÄãÏëÒªµ¼ÈëµÄµØ·½¡£²»¹ÜÊÇExcelתSqlServer£¬»¹ÊÇSqlServerתExcel£¬Ò²ÊÇÊÊÓõġ£
Æäʵ£¬ExcelµÄÒ²¿ÉÒÔÓÃsqlÓï¾äÀ´²Ù×÷µÄ¡£Ëµµ½ÕâÀÄãÒ²´ó¸ÅÖªµÀÔõÑù×ö°É£¡½ÓÏÂÀ´£¬Í¨¹ýÒ»¸öʵÀýÀ´ÂýÂý½²½â¡£(¸ÃʵÀýÏÂÔصØÖ·)
Ê×ÏÈ£¬Ìṩ¸ÃʵÀýµÄÊý¾Ý¿âºÍ±í£º
Êý¾Ý¿âÃûΪ£ºMyDataBase
±íÃûΪ£º CutClassTable
±í´´½¨Óï¾äÈçÏ£º
use MyDataBase
go
Create Table CutClassTable(
StudentID varchar(20) Primary key,
Name varchar(20) not null,
CutClassSum int default(0),
Cause varchar(200) default('δ֪')
)
¸ÃʵÀýÔËÐÐͼ£º
Ò».Excel µ¼Èëµ½ SqlServer
´ó¸Å²½Ö裺
a.ÓÃsqlÓï¾äÖГselect * from [Sheet1$]”Óï¾ä»ñÈ¡ ExcelÄÚÈÝ£¬´æ·Åµ½datasetÀàÐͱäÁ¿ÖС£
b.ÓÃinsert Óï¾ä°ÑdatasetÄÚÈݲåÈëµ½SqlServerÀïÃæ¡£
Ô´´úÂëÈçÏ£º
using System.Data.SqlClient; //ÓÃÓÚSqlServerÊý¾Ý¿â²Ù×÷
using System.Data.OleDb; //ÓÃÓÚExcelÊý¾Ý¿â²Ù×÷
#region Excelµ¼Èëµ½Sqlserver
//Ö¸¶¨µÄExcelÎļþÃû
private string strFileName;
//ÊÇ·ñÒѾ»ñÈ¡µ½ExcelÎļþµÄ·¾¶
private bool hasFile;
/
Ïà¹ØÎĵµ£º
±¾ÎĽ«c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿âµÄ·½·¨¼ÓÒÔ×ܽᣬÖ÷Òª½â¾öµÄÎÊÌâÈçÏ£º
´´½¨mdb
´´½¨table
¶ÁÈ¡tableÄÚÈÝ
²é
ѯtableÖеÄÄÚÈÝ
ÏòtableÖвåÈëÊý¾Ý
ɾ³ýtableÖеļǼ
ÏòtableÖвåÈëÕÕƬ
¶ÁÈ¡tableÖеÄÕÕƬµÈ¡£
ÎÄ
½éÉÜC#
·ÃÎʲÙ×÷AccessÊý¾Ý¿âµÄ»ù´¡ÖªÊ¶£¬²¢Ìá
¹©Ò»¸öÏà¹ØµÄÀý³Ì¡£C#µÄADO.NET»¹²»ÄÜͨ¹ý±à³Ì·½Ê½´ ......
´ó²¿·ÖµÄ½âÊÍÐͽű¾ÓïÑÔ¶¼Ìṩ eval ·½·¨À´Íê³É¶¯Ì¬´úÂëµÄ½âÊÍÖ´ÐУ¬ C# È´²¢²»Ìṩ£¨Ïò Java ѧϰ£©¡£²»¹ýÔÚ .NET Framework Àà¿âÀïÃæÌṩµÄ Microsoft.JScript ÃüÃû¿Õ¼äµ¹ÊÇ°üº¬ÁËÖ§³ÖʹÓÃJScript ÓïÑÔ±àÒëºÍÉú³É´úÂëµÄÀà¡£
ÏÈÉÏ´úÂ룺
¡¡¡¡¸ÃÀàÐèÒªÄãÌí¼Ó¶Ô³ÌÐò¼¯ Microsoft.JScript µÄÒýÓã»Èç¹û°Ñ“current v ......
¡¡¡¡¡¡ÓÃc#¸øPDA×öÁËÒ»¸öPC¶ËµÄͨѶ³ÌÐò£¬ÐèÒª±£´æÁ½¸ö²ÎÊý¡£ÓÃDelphiʱ£¬ÊDZ£´æÔÚiniÎļþÖУ¬c#¶ÁдXML±È½Ï·½±ã£¬¾ÍÓÃxmlÎļþÀ´±£´æÁË¡£
¡¡¡¡¡¡
¡¡
class CXmlClass
{
private string XmlFilePath;
/// <summary>
/// ÏÂÔص½PDAµÄTXTÎļþ·¾¶¡¡
/// </summary>
......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
public partial class _Default : Syste ......
//´´½¨DBhelperÊý¾Ý¿âÁ´½ÓÎļþ
private static string sqlcon = "server=.;database=myschool;uid=sa;pwd=sa";
public static SqlConnection connection = new SqlConnection(sqlcon ......