winform 绑定数据 dataGridView

 /// <summary>        /// 绑定数据        /// </summary>        public void   bdData()        {            string connstr = ConfigurationManager.ConnectionStrings["licai_MrConnectionString"].ToString();            OleDbConnection conn = new OleDbConnection(connstr);            conn.Open();            //MessageBox.Show(conn.State.ToString());            string sql = "select * from Mr_xflx_Class ";            //创建DataAdapter对象,用来连接sql语句和连接数据库语句.           // OleDbCommand cmd = new OleDbCommand(sql, conn);

            OleDbDataAdapter da = new OleDbDataAdapter(sql,conn);// (cmd);            //在创建一个DataSet对象            DataSet ds = new DataSet();

            //在用DataAdapter的Fill对象添加数据.            da.Fill(ds);

//修改名称            ds.Tables[0].Columns["id"].ColumnName = "ID";            ds.Tables[0].Columns["xflx"].ColumnName = "消费类型";            ds.Tables[0].Columns["Parentid"].ColumnName = "父ID";            dataGridView1.DataSource = ds.Tables[0].DefaultView;//指定数据源ds.Tables[0].DefaultView;            conn.Close();        }