Adding a new Column to datagrid with repeating values on button click.

See more:

C#

Windows

Visual-Studio

, +

I have a datagrid in my form.

in addition to the datasource im using, i want to add additional columns on a button click.these coloumn cells contains same text (string) in every row.

i know how to add column and textboxcell. my below code does that well.
but i dont know how to show some values in this new created textboxcell .

there are no 'object textboxcell.text = "EDR";' to assign values.
code below. pls help.
expecting helping codes too.thanks.

(pls note i just want to show this on datagrid. update to the database is not required)

        public void loadDataGrid(string sqlQueryString)
        {
            OleDbCommand SQLQuery = new OleDbCommand();
            DataTable data = null;
            dataGridView1.DataSource = null;
            SQLQuery.Connection = null;
            OleDbDataAdapter dataAdapter = null;
            dataGridView1.Columns.Clear();
            SQLQuery.CommandText = sqlQueryString;
            SQLQuery.Connection = conn;
            data = new DataTable();
            dataAdapter = new OleDbDataAdapter(SQLQuery);
            dataAdapter.Fill(data);
            dataGridView1.DataSource = data;
            dataGridView1.AllowUserToAddRows = false;
            dataGridView1.ReadOnly = true;
          
            dataGridView1.Columns[0].Width = 20; 
            dataGridView1.Columns[1].Width = 90;
            dataGridView1.Columns[2].Width = 90;
            dataGridView1.Columns[3].Width = 90;
          }

         DataGridViewColumn EDR; // new column
         DataGridViewCell EDRcell; // textbox cell in column

         private void button1_Click(object sender, EventArgs e)
         {
            
         EDR = new DataGridViewColumn();
            EDRcell = new DataGridViewTextBoxCell();
            EDR.CellTemplate = EDRcell;
            EDR.HeaderText = "RedcordType";
            EDR.Name = "RedcordType";
            EDR.Visible = true;
            EDR.Width = 45;
            dataGridView1.Columns.Add(EDR);
            //is there something like 
 
            // EDRcell.text = "EDR"; ???
        }