WinForm的ＤａｔａＧｒｉｄ中代码添加标题列

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

 

namespace DeviceApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

 

        private void Form1_Load(object sender, EventArgs e)

        {

            InitDataGridColumnHeader();

            try

            {

                //string strConn = "Data Source=KCSQLBI;Initial Catalog=TEST;User ID=sa;Password=14377434";

                //string sql = "select rle_cUserName,rle_cAddress,rle_cTelephone from dbo.Role_rle";

 

                //SqlConnection cnn = new SqlConnection(strConn);

                //if (cnn.State == ConnectionState.Closed)

                //{

                //    cnn.Open();

                //}

                //SqlDataAdapter da = new SqlDataAdapter(sql, cnn);

                //DataTable dt = new DataTable();

                

                //dt.Columns.Add("rle_cUserName", typeof(string));

                //dt.Columns.Add("rle_cAddress", typeof(string));

                //dt.Columns.Add("rle_cTelephone", typeof(string));

                //DataRow dr = dt.NewRow();

 

                //dr["rle_cUserName"] = "34";

                //dr["rle_cAddress"] = "sdf";

                //dr["rle_cTelephone"] = "dfdsf";

                //dt.Rows.Add(dr);

                //dt.AcceptChanges();

 

                DataSet ds = new DataSet();

                ds.Tables.Add("Role");

                ds.Tables["Role"].Columns.Add("rle_cUserName", typeof(string));

                ds.Tables["Role"].Columns.Add("rle_cAddress", typeof(string));

                ds.Tables["Role"].Columns.Add("rle_cTelephone", typeof(string));

 

                DataRow dr = ds.Tables["Role"].NewRow();

                dr["rle_cUserName"] = "34";

                dr["rle_cAddress"] = "sdf";

                dr["rle_cTelephone"] = "dfdsf";

                ds.Tables["Role"].Rows.Add(dr);

                ds.Tables["Role"].AcceptChanges();

                dataGrid1.DataSource = ds.Tables["Role"];

          

                

            }

            catch (SqlException ex)

            {

                textBox1.Text = ex.StackTrace;

                

            }

         

 

        }

 

 

        private void InitDataGridColumnHeader()

        {

            DataGridTableStyle dts = new DataGridTableStyle();            

            dts.MappingName = "Role";   //指定Grid的Table名称

            dataGrid1.TableStyles.Add(dts);

            dataGrid1.TableStyles[0].GridColumnStyles.Clear();

 

 

            DataGridTextBoxColumn userName = new DataGridTextBoxColumn();

            userName.Width = 80;

            userName.HeaderText = "用户名";

            userName.MappingName = "rle_cUserName";

 

            dataGrid1.TableStyles[0].GridColumnStyles.Add(userName);

 

            DataGridTextBoxColumn address = new DataGridTextBoxColumn();

            address.Width = 200;

            address.HeaderText = "地址";

            address.MappingName = "rle_cAddress";

 

            dataGrid1.TableStyles[0].GridColumnStyles.Add(address);

 

 

            DataGridTextBoxColumn tel = new DataGridTextBoxColumn();

            tel.Width = 100;

            tel.HeaderText = "电话号码";

            tel.MappingName = "rle_cTelephone";

 

            dataGrid1.TableStyles[0].GridColumnStyles.Add(tel);

 

        }

 

 

    }

}