/// <summary>
        /// 把DataTable数据显示于DataGridView中
        /// 当列名第一个这字符为'_'时则该列不可见
        /// </summary>
        /// <param name="dbg">显示的DataGridView</param>
        /// <param name="dt">数据表DataTable</param>
        public static void FillDataTableToDataGrid(System.Windows.Forms.DataGridView dbg, System.Data.DataTable dt)
        {
            dbg.DataSource = dt;
            int[] nColSize = new int[dbg.Columns.Count];
            if (dbg.Columns.Count > 0)
            {
                for (int i = 0; i < dbg.Columns.Count; i++)
                {
                    nColSize[i] = dbg.Columns[i].Width;
                    if (dbg.Columns[i].Name.Substring(0, 1) == "_")
                    {
                        dbg.Columns[i].Visible = false;
                    }
                }
            }
            //dbg.ReadOnly = true;        //用到第三方控件(DotNetBar2)时,此处要注释,不用时可取消注释
        }

        /// <summary>
        /// 把BindingSource数据显示于DataGridView中
        /// 当列名第一个这字符为'_'时则该列不可见
        /// </summary>
        /// <param name="dbg">显示的DataGridView</param>
        /// <param name="bds">数据BindingSource</param>
        public static void FillBindingDataToDataGrid(System.Windows.Forms.DataGridView dbg, System.Windows.Forms.BindingSource bds)
        {
            dbg.DataSource = bds;
            int[] nColSize = new int[dbg.Columns.Count];
            if (dbg.Columns.Count > 0)
            {
                for (int i = 0; i < dbg.Columns.Count; i++)
                {
                    nColSize[i] = dbg.Columns[i].Width;
                    if (dbg.Columns[i].Name.Substring(0, 1) == "_")
                    {
                        dbg.Columns[i].Visible = false;
                    }
                }
            }
            //dbg.ReadOnly = true;        //用到第三方控件(DotNetBar2)时,此处要注释,不用时可取消注释
        }

 

posted on 2015-06-05 10:05  清风暮雨  阅读(392)  评论(0)    收藏  举报