´ÓÊý¾Ý¿âµ¼³öÊý¾Ýµ½word¡¢excel¡¢.txt _asp.net¼¼ÇÉ
ת×Ôhttp://martinyang2010.bokee.com/2598999.html
using System;
using System.Data;
using System.Drawing;
using System.Data.SqlClient;
using Excel;
using Word;
using System.IO;
namespace Common
{
/// <summary>
/// °ÑÊý¾Ýµ¼Èëµ½.doc¡¢.txt¡¢.xlsÎļþÖÐ
/// </summary>
public class Export
{
private const string DATAWORDPATH = @"C:\folder\doc\datadoc\";
private const string IMAGEWORDPATH = @"C:\folder\doc\imagedoc\";
private const string IMAGEPATH = @"C:\folder\image\";
private const string EXCELPATH = @"C:\folder\excel\";
private const string TXTPATH = @"C:\folder\txt\";
private const string IMAGEPOSTFIX = ".bmp";
private const string WORDPOSTFIX = ".doc";
private const string EXCELPOSTFIX = ".xls";
private const string TXTPOSTFIX = ".txt";
private const int DATADISTANCE = 5;
private const int TABDISTANCE = 8;
public Export()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
//
}
/// <summary>
/// »ñµÃÊý¾Ý¼¯Dataset--------------------------------ÓÃÓÚµ÷ÊÔ
/// </summary>
/// <returns>Dataset</returns>
public DataSet GetData()
{
try
{
string sConnectionString;
sConnectionString = "workstation id=GUOFU;packet size=4096;user id=sa;data source=GUOFU;persist security info=True;initial catalog=YC;password=sc";
SqlConnection objConn = new SqlConnection(sConnectionString);
objConn.Open();
SqlDataAdapter daPoint = new SqlDataAdapter("Select * from Point", objConn);
DataSet dsYC = new DataSet("YC");
daPoint.FillSchema(dsYC,SchemaType.Mapped, "Point");
&nb
Ïà¹ØÎĵµ£º
×î½ü×öÒ»¸öÍøÕ¾£¬ÀïÃæÉæ¼°µ½¼¶ÁªµÄÎÊÌ⣨ÈçÊ¡-ÊУ¬Æ·ÅÆ-ÐͺŵÈ), ÎÒÓõÄÊÇDropDownListÀ´ÊµÏֵģ¬ÉèÖø¸¼¶µÄAutoPostBackÊôÐÔÎªÕæ.È»ºóÔÚËüµÄSelectedIndexChanged()ʼþÀïдÏàÓ¦µÄ´úÂ룬ÕâÑù¾ÍÄÜʵÏÖ¼¶Áª¹ØÏµ£¨µ±È»ÕâÀïҪעÒâIsPostBackµÄÎÊÌ⣩. ×öºÃÖ®ºóÓÃʱ·¢ÏÖÒ»¸ö·Ç³£²»Ë¬µÄÎÊÌ⣬ÄǾ ......
ÔÚÍøÉÏÕÒÁ˺ö࣬ʵÏÖ·½Ê½´ó¶àÊÇʹÓö¨Ê±Æ÷
¸öÈ˾õµÃ¶¨Ê±Æ÷»áÔì³ÉÒ»¶¨³Ì¶ÈÉϵļÙÏó
£¨È磺¶¨Ê±Æ÷»¹Ã»½áÊøÒ³ÃæÒѾ¼ÓÔØÍê±Ï£¬»ò¶¨Ê±Æ÷½áÊøºóÒ³Ãæ»¹Ã»¼ÓÔØÍê³É£©
±¾·½·¨ÀûÓõÄÊÇjavascript£¬ÏÈÍøÒ³ÃæÀïÃæÐ´ÈëÒ»¸ö²ã£¬ÏÔʾ¼ÓÔØ¿ò£¬È»ºóµÈÒ³Ãæ½áÊøºó
ÔÚbodyµÄonloadÖÐдÈëʼþ£¬Òþ²Ø¸Ã¶Ô»°¿ò
·½·¨£¨ÎÒµÄϵͳÊǶà¸öÒ³Ãæ£¬Ëù ......
ASP.NET IIS ×¢²á¹¤¾ß (Aspnet_regiis.exe)
ÔÚһ̨¼ÆËã»úÉϲ¢ÐÐÖ´Ðжà¸ö .NET Framework °æ±¾Ê±£¬Ó³Éäµ½ ASP.NET Ó¦ÓóÌÐòµÄ ASP.NET ISAPI °æ±¾¾ö¶¨Á˸ÃÓ¦ÓóÌÐòËùʹÓõĹ«¹²ÓïÑÔÔËÐпâ (CLR) °æ±¾¡£Ê¹Óà ASP.NET IIS ×¢²á¹¤¾ß (Aspnet_regiis.exe)£¬¹ÜÀíÔ±»ò°²×°³ÌÐò¿ÉÒÔ·½±ãµØ¸üРASP.NET Ó¦ÓóÌÐòµÄ½Å±¾Ó³É䣬ʹÆäÖ¸Ï ......
Ö÷Ìå¼Ü¹¹
¡¡¡¡¸÷ƵµÀ·Ö±ðλÓÚ²»Í¬µÄWeb Project(¾ßÓжÀÁ¢µÄ¶þ¼¶ÓòÃû)£¬²¢½«ËùÓеÄÒµÎñÂß¼ÒÔ¼°Êý¾Ý·ÃÎʹ¦ÄÜ·â×°³ÉClass Library£¬ËùÓÐÆµµÀ¹²ÓÃÕâ¸öClass Library¡£
¡¡¡¡ÏÂÃæÏêϸ½éÉÜʵÏÖ·½·¨¡£
¡¡¡¡¼ÙÉèÍøÕ¾ÓÐÈý¸öƵµÀ£¬ÐÂÎÅ¡¢ÂÛ̳ÒÔ¼°²©¿Í£¬¶ÔÓ¦µÄ¶þ¼¶ÓòÃûΪ"news"¡¢"forum"¡¢"blog"¡£³ ......
asp.netµÄµ×²ãÔË×÷ÒѾҲÂÒ̸¹ýÒ»·¬£¬ ½ñÌì¼ÇÒ»ÏÂURLRewriteµÄ·½·¨¡£
IISÊÕµ½ÇëÇó-->ISAPIÓÃÓÚ´¦Àí¸ÃÇëÇó-->BeginRequest¿ªÊ¼-->EndRequest½áÊø-->Êä³öResponse
ÖмäÓкöàÆäËüµÄÁ÷³Ì¾Í²»±ê¼ÇÁË£¬ÕâÀïÖ»ÊÇÁгöURLRewriteËù×ßµÄÁ÷³Ì¡£
Æäʵ¾ÍÊÇÔÚBeginRequestʼþÖе÷ÓÃHttpContextµÄRewritePath·½·¨£¬½«¸ÃÇë ......