Data Grid

→   This control provides ability to display images, dropdown control or lock columns along with displaying contents of table in usual way.

→   It has binding capability same as data grid control so it can bind array, data table, data view and data set.

→   Data can be displayed in data grid view by setting data source property of data grid view. Here we are displaying data from a dataset class into data grid view.

OracleConnection cn = new OracleConnection("Data

Source=atmiya;User

ID=dce0857;Password=vivek;Unicode=True");

cn.Open();

           

OracleCommand cmd = new OracleCommand("select * from

studentluck", cn);

           

OracleDataAdapter da = new OracleDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

dataGridView1.DataSource = ds.Tables[0];