ASP.Net ºÍ ASPÓÐÊ²Ã´Çø±ð£¿
Ê×ÏÈ£¬ËûÃǵÄÔËÐлúÖÆ²»Í¬¡£aspÊÇÊôÓÚÒ»ÖÖ½âÊÍÐ͵Ŀò¼Ü£¡ÊǽâÊÍÖ´Ðеģ¬Êǽű¾¡£asp.netÊDZàÒëÐ͵ģ¡×îÖÕ»á±à³Ì¶þ½øÖƵĻúÆ÷´úÂë¡£´ÓÕâÒ»µãÀ´Ëµ£¬asp.netÖ´ÐÐЧÂÊÉÏÒª±Èasp¸ß£¡
Æä´Î£¬aspÖ»ÔÊÐíʹÓÃjs»òÕßvbs¡£¶øasp.netÔò²»Ò»Ñù£¬Ö»Òª·ûºÏ¹«¹²ÓïÑÔÔËÐÐ¿â¹æ·¶µÄÓïÑÔ£¬¶¼¿ÉÒÔʹÓã¡´ÓÕâÒ»µãÉÏÀ´Ëµ£¬aspÔڵײã²Ù×÷ÉϽÏasp.netÒªÀ§Äѵ㡣±ÈÈ磺½øÐÐÎļþ²Ù×÷µÄʱºò£¡aspÒª½èÖúÆäËûÓïÑÔ±àдµÄ×é¼þ¡£
ÔÙÕߣ¬asp.netÒª±Èasp¼òµ¥£¡ºÜ¶à¶«Î÷¶¼·â×°ºÃÁË£¬ÄÃÀ´ÓþÍÊÇ¡£´úÂëҲʩÐÐÁË·ÖÀ룬Õâ¾ÍʹµÃά»¤ºÍÖØÓøü¼òµ¥¡£
ÐèҪעÒâµÄÊÇ£ºËäÈ»ºÍjsͬΪ½âÊÍÐ͵쬵«ÊÇaspÊÇÔÚ·þÎñÆ÷½âÊ͵ģ¡jsÊÇÔÚä¯ÀÀÆ÷ÉϽâÊ͵ġ£
Ïà¹ØÎĵµ£º
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%response.ContentType ="application/vnd.ms-excel"
%>
<%
Set xlApplication = Server.CreateObject("Excel.Application") 'µ÷ÓÃexcel¶ÔÏó
xlApplication.Visible = False 'ÎÞÐè´ò¿ªexcel
xlApplication.SheetsInN ......
¿ª·¢Öо³£Óöµ½ÒªÖØÖÿؼþÖµµÃ²Ù×÷£¬ÏÂÃæÐ´Á˳£ÓÃHTML¿Ø¼þµÄÖØÖ÷½·¨¡£²»ÍêÕûµÄ£¬´ó¼Ò¿ÉÒÔÀ©³ä
function ResetControl() {
var v = document.forms[0].elements;
for (var i = ......
ASP.NET Excelµ¼Èëµ½SQL ServerÊý¾Ý¿â
Ìṩ°ÑExcelÀïµÄÊý¾Ýµ¼Èëµ½SQL Server Êý¾Ý¿â£¬Ç°ÌáÊÇExcelÀïµÄ×Ö¶ÎÔÚSql Server±íÀï¶¼ÓУ¬²»È»»á³öÏÖ´íÎó¡£×¢ÊͺÜÏêϸŶ£¡ÒªÒýÓõÄÃüÃû¿Õ¼äÊÇ£º
using System.Data.OleDb;
using System.Data.SqlClient;
//²Ù×÷Àà
public class ExcelToSQL
{
& ......
ASPÈçºÎÁ¬½ÓÊý¾ÝÔ´£¿(ϵͳDSN)Öн¨Á¢µÄÊý¾ÝÔ´£¿
ASPÔõô½¨Á¢Á¬½Ó£¬²»ÊÇOLEDB·½Ê½£¬ÓÃODBCÖеēÓû§DSN”½¨Á¢µÄÊý¾ÝÔ´½øÐÐÁ¬½Ó£¿ÈçºÎ²Ù×÷£¿
ÎÊÌâ²¹³ä£ºÎÒµÄÊÇODBCÖеēÓû§DSN”²»ÊǓϵͳDSN”£¬“Óû§DSN”ÔõôÁ¬½Ó£¿¶øÇÒÎÒµÄÊý¾Ý¿âÓÐÃÜÂë¡£
ÌáÎÊÕߣºÄäÃû
×î¼Ñ´ð°¸
Set co ......
ODBCÊý¾ÝÔ´¿É·ÖΪ“ϵͳÐÍ”ºÍ“ÎļþÐÍ”£¬ËûÃǵÄÇø±ðÔÚÓړϵͳÐÍ”ÊÇÁ¬½ÓÊý¾Ý¿âµÄÐÅÏ¢½¨Á¢Ôړϵͳע²á±í”À“ÎļþÐÍ”ÔòÊÇÒÔdsnÎļþÐÎʽ´æ´¢ÔÚODBCÔ´µÄĿ¼ÏÂÃæ
Ò»¡¢½¨Á¢ODBCÊý¾ÝÔ´µÄ·½·¨£º
¿ØÖÆÃæ°å - ¹ÜÀí¹¤¾ß - Êý¾ÝÔ´£¨ODBC£©
´ò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷£¬È»ºóÒ ......