954,518 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Gridview - Adding new column

Hello,

My question is: Can I add in new column(S) in the gridview if the column is not found in the database?
- E.g. An indicator if a certain lecturer is a ML/Lec (roles).

I have a gridview that is "extracted" out from the database.
But I want to add in a new row which is not in the database but links to the data in the database.
For example, in the database, I know that a certain lecturer is a module leader, staff.
But I want to have an extra column which can indicate in itself (probably a tick/mark) that the following name (prev column) is a module leader or staff; and i am not allowed to add new column in the database.

Any help appreciated.
Need me to further explain my queries, let me know. :)

husna_
Newbie Poster
5 posts since Sep 2009
Reputation Points: 10
Solved Threads: 0
 

DataTable class.

DataTable dt=new DataTable();
dt.Columns.Add("Col1",typeof(int));
__avd
Posting Genius (adatapost)
Moderator
8,648 posts since Oct 2008
Reputation Points: 2,136
Solved Threads: 1,241
 

Hello adatapost,
Ohs. OKies. Thank you. I shall try.

husna_
Newbie Poster
5 posts since Sep 2009
Reputation Points: 10
Solved Threads: 0
 

without touching the datasource, you can add your column to your gridview directly.

the project is attached to this post.

Form1.cs :

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsApplication2
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView1.Columns.Add("columnName", "columnHeader");
            dataGridView1.Rows.Add(new object[]{"cell content"});
        }
    }
}


Form1.Designer.cs :

namespace WindowsApplication2
{
    partial class Form1
    {
        /// <summary>
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Windows Form Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.dataGridView1 = new System.Windows.Forms.DataGridView();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
            this.SuspendLayout();
            // 
            // dataGridView1
            // 
            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView1.Location = new System.Drawing.Point(0, 0);
            this.dataGridView1.Name = "dataGridView1";
            this.dataGridView1.Size = new System.Drawing.Size(240, 150);
            this.dataGridView1.TabIndex = 0;
            // 
            // Form1
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(292, 266);
            this.Controls.Add(this.dataGridView1);
            this.Name = "Form1";
            this.Text = "Form1";
            this.Load += new System.EventHandler(this.Form1_Load);
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.DataGridView dataGridView1;
    }
}
Attachments WindowsApplication2.zip (30.91KB)
serkan sendur
Postaholic
Banned
2,062 posts since Jan 2008
Reputation Points: 854
Solved Threads: 127
 

Hello Serkan Sendur,

Thank you for your help.
Although i have download the application, i am not able to run it cuz i am using visual studio 2005 and they are unable to convert it.

Hmmm. I have read the codes, i can understand that you just have to .add it. but for the rest, i cant really understand.

husna_
Newbie Poster
5 posts since Sep 2009
Reputation Points: 10
Solved Threads: 0
 

i created it in VS 2005, i dont understand why it didnt open. the rest of the code is from the designer, it is generated code, dont worry about it.

serkan sendur
Postaholic
Banned
2,062 posts since Jan 2008
Reputation Points: 854
Solved Threads: 127
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: