Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

£¨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Êý¾Ý¿â

±¾ÎĽ«c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿âµÄ·½·¨¼ÓÒÔ×ܽᣬÖ÷Òª½â¾öµÄÎÊÌâÈçÏ£º
´´½¨mdb
´´½¨table
¶ÁÈ¡tableÄÚÈÝ
²é
ѯtableÖеÄÄÚÈÝ
ÏòtableÖвåÈëÊý¾Ý
ɾ³ýtableÖеļǼ
ÏòtableÖвåÈëÕÕƬ
¶ÁÈ¡tableÖеÄÕÕƬµÈ¡£
ÎÄ
½éÉÜC#
·ÃÎʲÙ×÷AccessÊý¾Ý¿âµÄ»ù´¡ÖªÊ¶£¬²¢Ìá
¹©Ò»¸öÏà¹ØµÄÀý³Ì¡£C#µÄADO.NET»¹²»ÄÜͨ¹ý±à³Ì·½Ê½´ ......

C#ÖнâÎöjavascript´úÂë


´ó²¿·ÖµÄ½âÊÍÐͽű¾ÓïÑÔ¶¼Ìṩ eval ·½·¨À´Íê³É¶¯Ì¬´úÂëµÄ½âÊÍÖ´ÐУ¬ C# È´²¢²»Ìṩ£¨Ïò Java ѧϰ£©¡£²»¹ýÔÚ .NET Framework Àà¿âÀïÃæÌṩµÄ Microsoft.JScript ÃüÃû¿Õ¼äµ¹ÊÇ°üº¬ÁËÖ§³ÖʹÓÃJScript ÓïÑÔ±àÒëºÍÉú³É´úÂëµÄÀà¡£
ÏÈÉÏ´úÂ룺
¡¡¡¡¸ÃÀàÐèÒªÄãÌí¼Ó¶Ô³ÌÐò¼¯ Microsoft.JScript µÄÒýÓã»Èç¹û°Ñ“current v ......

c# ¶ÁдXMLÎļþ

¡¡¡¡¡¡ÓÃc#¸øPDA×öÁËÒ»¸öPC¶ËµÄͨѶ³ÌÐò£¬ÐèÒª±£´æÁ½¸ö²ÎÊý¡£ÓÃDelphiʱ£¬ÊDZ£´æÔÚiniÎļþÖУ¬c#¶ÁдXML±È½Ï·½±ã£¬¾ÍÓÃxmlÎļþÀ´±£´æÁË¡£
¡¡¡¡¡¡
¡¡
class CXmlClass
{
private string XmlFilePath;
/// <summary>
/// ÏÂÔص½PDAµÄTXTÎļþ·¾¶¡¡
/// </summary>
......

ÓÃC#(ASP.NET)ÔõôʵÏÖÎļþÏÂÔع¦ÄÜ

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 ......

datagirdviewºÍlistview,ɾ¸Ä²ésqlserverÊý¾Ý¿âµÄС½á

        //´´½¨DBhelperÊý¾Ý¿âÁ´½ÓÎļþ
        private static string sqlcon = "server=.;database=myschool;uid=sa;pwd=sa";
        public static SqlConnection connection = new SqlConnection(sqlcon ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ