Hide a coloumn in DataGridview

Srikanth Suryadevara

I have a Oracle Table with two columns as follows:

Did

Dname

Now i have a data Adapter with the select query as follows "select * from OracleTable order by did";

when i was binding it to a datagridview using dataset i will get two coloumns as above

the Question is i need to hide the details of Did or completely the Did column

the another factor is that i am using the same query for another operation so the query need not to be changed but column have to appear hidden

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tulasi13y ago
Either put autogenerates columns to false and specify columns in column Field , or put Did column as Date key in Gridview .
Srikanth Suryadevara13y ago
the problem is that i have been using visual studio2012 i cant find a statement

dataGridView1.Columns["Did"].Visible = false;

it is showing a error

and i have wrote the dataadapter in another class and that class method returns data set
this dataset will be used in my applctn
Satyapriya Nayak13y ago
private void Form1_Load(object sender, EventArgs e)
        {

            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from test ";
            com = new OleDbCommand(str, con);
            oledbda = new OleDbDataAdapter(com);
            DataSet ds = new DataSet();
            oledbda.Fill(ds, "test");
            dataGridView1.DataMember = "test";
            dataGridView1.DataSource = ds;
            //dataGridView1.Columns[0].Visible = false;
            dataGridView1.Columns["Did"].Visible = false;

        }