using System.Data.SqlClient;
            DataSet ds = new DataSet();
            SqlConnection conn = null;
            SqlDataAdapter da = null;   //数据适配器
             string DRIVER = "server=.;database=xxxxx;uid=xxxxxx;password=xxxxx";
            string sql_select = str;
            conn = new SqlConnection(DRIVER);
            da = new SqlDataAdapter(sql_select, conn);
            ds = new DataSet();
            da.Fill(ds, "table");
            this.dataGridView1.DataSource = ds.Tables["table"];