Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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#ÖеÄAjaxÉÏÊÖƪ£­£­£­·Çͬ²½ÇëÇóresponseXML

ÎÒÃÇ¿ÉÒÔʹÓÃXML×÷ΪÊý¾Ý´«ËÍ¡¢¹µÍ¨µÄ¸ñʽ£¬Ajax¿Í»§¶ËÈôÒª·¢ËÍXML£¬»ù±¾ÉϾÍÊǽ«XML×÷Ϊ×Ö·û´®£¬ÔÚPOSTÇëÇóʱ·¢ËÍ£¬ÀýÈ磺
*HelloAjax.js
view plaincopy to clipboardprint?
var xmlHttp;  
function createXMLHttpRequest() {  
    if (window.XMLHttpRequest) {   ......

C#Öе÷ÓÃmysql´æ´¢¹ý³Ì³öÏÖµÄÎÊÌâ

ÔÚrootÕ˺ÅÖÐ,¿ÉÒÔÕý³£µ÷Óô洢¹ý³Ì.
»»µ½common_userÕ˺Åʱ,ͬһ´æ´¢¹ý³ÌÃûµ÷ÓóöÏÖÎÊÌâ.
×·×Ùµ÷ÊÔʱ³öÏÖ:
SELECT command denied to user 'common_user'@'localhost' for table 'proc'
ËÑË÷½â¾ö·½°¸:
MySqlConnection myconnection = new MySqlConnection("server=localhost;user id=common_user; password=***;dat ......

sqlserver·ÖÒ³(¶þ)sqlserver2005ǧÍò¼¶·ÖÒ³²éѯ

ÔÚsqlserver2005ÏÂʹÓÃÏÂÃæÓï¾ä
WITH t AS (
                    SELECT ROW_NUMBER() OVER(ORDER BY id DESC) as row_number, id,ss
            &nb ......

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ºÅ