那你们看这段代码可以吗？调试还是出问题~~

  string strSQL="SELECT 年，平均气温，平均最高气温，平均最低气温，极端最高气温，极端最低气温，降水量，最大日降水量，降水日数 from Sheet$ ORDER BY ID DESC";

  string connectionString = ConfigurationManager.ConnectionStrings["MyconnectionString"].ConnectionString;SqlConnection myConnection = new SqlConnection("server = localhost;uid = sa; pwd =zllty1314;database =Beijing");

  SqlConnection myConnection1=new SqlConnection(ConfigurationManager.AppSettings["MyconnectionString"]);

      

               try

               {

                   SqlDataAdapter da=new SqlDataAdapter(strSQL,myConnection1);

                   DataSet ds=new DataSet();

                   da=new SqlDataAdapter(strSQL,myConnection1);

                  

                   myConnection1.Open();

                   da.Fill(ds);

                   GridView1.DataSourceID = "";

                   GridView1.DataSource=ds;

                   GridView1.DataBind();

               }

            finally

               {

                   myConnection1.Close();

               }

        }

    } 

	<appSettings/>

	<connectionStrings>

  <add name="MyconnectionString" connectionString="Data Source=localhost;Initial Catalog=Beijing;Persist Security Info=True;User ID=sa;Password=zllty1314"

   providerName="System.Data.SqlClient" />

 </connectionStrings>

	<system.web>