当前位置:软件学习 > Excel >>

ASP.NET 利用MD.DLL 转EXCEL

1、建立无CS文件的DownExcel.aspx 文件


<%@ Page Language="C#" %>

<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<%@ import Namespace="MD" %>
<script runat="server">     
  string tableName = "";
    string procName ="";   
    private string selectSql( string selstr )
    {
     string sp =selstr + " WHERE";
     int iwhere;
         iwhere=sp.IndexOf("WHERE");
        iwhere=iwhere+7;
        string sall = Server.UrlDecode(Request.QueryString.ToString());
        string[] sparams;
        sparams=sall.Split('&');
        int i=0;
        if (sparams.Length>1){
            while (i<sparams.Length){
                if (!(sparams[i].StartsWith("table"))){
                    if ((sparams[i].StartsWith("str") )){
                        sp=sp+" and " + sparams[i].Replace("=","='").Substring(3) + "'";
                    }
                    if ((sparams[i].StartsWith("num") ))
                    {
                        sp=sp+" and " + sparams[i].Substring(3) + "";
                    }
                }
             i++;
            }
        }
        if (sp.IndexOf("and") >0 ){
        sp = (sp.Substring(0,sp.IndexOf("and")) + sp.Substring(sp.IndexOf("and")+3));
        }
        //sp=sp.Replace("=","='");
        if (sp.Length<iwhere) {
        sp=sp.Substring(0,(iwhere-8));
        }
        return sp;
    }

    private string selectProc( string selstr )
    {
        string sp =selstr + " ";
       
        string sall = Server.UrlDecode(Request.QueryString.ToString());
        //Server.UrlDecode(Request.QueryString.ToString());
        string[] sparams;
        sparams=sall.Split('&');
        int i=0;
        if (sparams.Length>1)
        {
            while (i<sparams.Length)
            {
                if (!(sparams[i].StartsWith("procedure")))
                {
                    if ((sparams[i].StartsWith("str") ))
                    {
                        sp=sp + "'" + sparams[i].Substring( sparams[i].IndexOf("=")+1) + "',";
                    }
                    if ((sparams[i].StartsWith("num") ))
                    {
                        sp=sp + sparams[i].Substring( sparams[i].IndexOf("=")+1) + ",";
                    }
                }
                i++;
            }
        }
        if (sp.EndsWith(",")){
        sp=sp.Substring(0, (sp.Length -1));
        }
        return sp;
    }

    private void Page_Load(object sender, System.EventArgs e)
    {   
        // setup connection
        //Response.Write(selectSql("start test!"));  
        string conn = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;  /// System.Configuration.ConfigurationSettings.AppSettings["connectionString"];
        if (Request.QueryString["table"]== null && Request.QueryString["procedure"]==null)
        {
            this.Response.Write("not supply correct parameters!");
            this.Response.End();
            return; 
        }
        DataSet ds = ne

补充:Web开发 , ASP.Net ,
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,