完成第一步：通过新库指标选出老库数据

 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.ComponentModel;
using System.Xml;
using System.Data.SqlClient;
using System.IO;
using System.Xml.Serialization;
using System.Diagnostics;
using System.Text;
using DataAccess.PO;
using BusinessFacade;

public partial class DataManagement_IndicatorConfiguration : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {  
    }


    protected void ShowButton_Click(object sender, EventArgs e)
    {
        try
        {
            /**////从EWS库取指标
            StringBuilder indiCodes = new StringBuilder();
            if (IndicatorMultiSelectControl1.SelectedIndicatorList != null)
            {
                foreach (Indicator indi in IndicatorMultiSelectControl1.SelectedIndicatorList)
                    indiCodes.Append("'"+indi.IndicatorCode+"',");//加逗号是因为参数里有逗号分隔符
            }
            if (indiCodes == null || indiCodes.Length == 0)
                return;
            
            indiCodes.Remove(indiCodes.Length - 1, 1);//去掉加上的逗号


            /**////从PBC库中取出数据                                   
            SqlConnection PBCconn = new SqlConnection("server=localhost;Integrated Security=SSPI;database=PBCDataBaseTest;");
            PBCconn.Open();
            SqlCommand PBCCommand = PBCconn.CreateCommand();
            PBCCommand.CommandText = "SELECT * FROM MonthBase where IndicatorID  in ( " + indiCodes.ToString() + " )";//将参数放进SQL语句中
            //PBCCommand.CreateParameter()  //这方法也能将参数放进SQL语句中
            SqlDataReader PBCdr = PBCCommand.ExecuteReader();

            /**////将数据放入GridView中
            if (PBCdr.Read())
            {
                    ImportGridView.DataSource = PBCdr;
                    ImportGridView.DataBind();
            }
            else
            {
                nodataLabel.Text = "抱歉，PBC库无对应数据！";
                return;
            }
            PBCdr.Close();
            PBCconn.Close();


        }
        catch (Exception ex)
        {
            throw ex;
        }
  }
    protected void Import_Click(object sender, EventArgs e)
    {

    }
}