手动连接

string connectionStringcsyhm = System.Configuration.ConfigurationManager.ConnectionStrings["classTreeConnectionString"].ConnectionString;


           // string connectionStringcsyhm = "Data Source=.;Initial Catalog=classTree;User ID=sa;pwd=123456;";
            SqlConnection conncsyhm = new SqlConnection(connectionStringcsyhm);
            string sqlcsyhm = "select * from view_computer where bgdb='" + 8 + "' order by sydw  desc";
            SqlCommand cmdcsyhm = new SqlCommand(sqlcsyhm, conncsyhm);


            conncsyhm.Open();
            SqlDataReader sdr = cmdcsyhm.ExecuteReader();
            this.GridView1.DataSource = sdr;
            this.GridView1.DataBind();