£¨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#ÓëFlash½»»¥ £¨×ª×ÔСÀÚÔÚÏߣ©
C#ÓëFlash½»»¥
Ç°¶ÎÈÕ×Ó¹«Ë¾ÒªÇó×öÒ»¸öC#ÓëFlash½»»¥µÄ¶«Î÷£¬ÓÃÀ´C#Óë¶ÌÐÅèͨѶ½«Êý¾Ý´«µ½FlashÉÏÏÔʾÓë²Ù×÷µÄÓ¦Óá£
µÚÒ»²½C#Ìí¼Ó×é¼þ
´ò¿ªVS2005-¹¤¾ß-Ñ¡Ôñ¹¤¾ßÏäÏî-COM×é¼þ-Ñ¡ÔñShockwave Flash Object-È·¶¨
Ìí¼ÓºÃ×é¼þÍù³¡¾°ÉÏÍÏ·Å£¬Èç¹ûÌáʾע²áÐèÇó×¢²á
c# ×¢²á¿Ø¼þ-ÔÚÔËÐÐÊä ......
±¾ÎĽ«c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿âµÄ·½·¨¼ÓÒÔ×ܽᣬÖ÷Òª½â¾öµÄÎÊÌâÈçÏ£º
´´½¨mdb
´´½¨table
¶ÁÈ¡tableÄÚÈÝ
²é
ѯtableÖеÄÄÚÈÝ
ÏòtableÖвåÈëÊý¾Ý
ɾ³ýtableÖеļǼ
ÏòtableÖвåÈëÕÕƬ
¶ÁÈ¡tableÖеÄÕÕƬµÈ¡£
ÎÄ
½éÉÜC#
·ÃÎʲÙ×÷AccessÊý¾Ý¿âµÄ»ù´¡ÖªÊ¶£¬²¢Ìá
¹©Ò»¸öÏà¹ØµÄÀý³Ì¡£C#µÄADO.NET»¹²»ÄÜͨ¹ý±à³Ì·½Ê½´ ......
ÔÚsqlserver2005ÏÂʹÓÃÏÂÃæÓï¾ä
WITH t AS (
SELECT ROW_NUMBER() OVER(ORDER BY id DESC) as row_number, id,ss
&nb ......
--Óï ¾ä¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT¡¡¡¡¡¡--ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE¡¡¡¡¡¡--¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE¡¡¡¡--´´½¨Ò»¸öÊý¾Ý¿â ......
SQL×¢ÈëÊÇʲô?
¡¡¡¡Ðí¶àÍøÕ¾³ÌÐòÔÚ±àдʱ£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂë(Ò»°ãÊÇÔÚä¯ÀÀÆ÷µØÖ·À¸½øÐÐ,ͨ¹ýÕý³£µÄwww¶Ë¿Ú·ÃÎÊ)£¬¸ù¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijЩÏëµÃÖªµÄÊý¾Ý£¬Õâ¾ÍÊÇËùνµÄSQL Injection£¬¼´SQL×¢Èë¡£
¡¡¡¡ÍøÕ¾µÄ¶ñÃΗ—SQL×¢Èë
......