how to display a single column value of a table in a DataGridView

[ssknov]

hi
i need to populate a DatagridView1 with a single column values of a table.

I tried like this.

Dataset ds=new dataset();
my dataset ds retrieves and filles a single column from a table.

DataGridView1.Datasource=ds;

but grid shows empty without rows and cols when executes.

suggest me
ssknov

[nateraaaa]

Did you call DataGridView1.DataBind() after you assigned the datasource of your DataGridView?

Nathan

[ssknov]

hi nathan,

i did so but error is prompting Error 1 "'System.Windows.Forms.Control.DataBindings' is a 'property' but is used like a 'method'"


DatGridVw1.DataSource = ds;
DatGridVw1.DataBindings();

what to do?

[Shashi Sadasivan]

hi nathan,

i did so but error is prompting Error 1 "'System.Windows.Forms.Control.DataBindings' is a 'property' but is used like a 'method'"


DatGridVw1.DataSource = ds;
DatGridVw1.DataBindings();

what to do?

The Databind is a method for the gridview for Asp .Net and databindings is to assign data to a control (this is usually a field value)
So remove the databindings line.

Are you sure that your dataset is getting populated?

Try running into debug mode and check the contents of your dataset before you set the data source of the gridview.

[ssknov]

halo shashi

i checked my DataSet ds whether it gets populated , it is ok.

but datagridview shows nothing

ssk

[Shashi Sadasivan]

Hi ssk,
i think you cant directly assign a complete dataset to a datagridview.

you would have to to something like

datagridview.DataSource=ds.Tables[0].DefaultView;

Cheers

[ssknov]

Hi ssk,
i think you cant directly assign a complete dataset to a datagridview.

you would have to to something like

datagridview.DataSource=ds.Tables[0].DefaultView;

Cheers

thank u for ur suggestion

i ll try this


ssk

[ssknov]

Hi ssk,
i think you cant directly assign a complete dataset to a datagridview.

you would have to to something like

datagridview.DataSource=ds.Tables[0].DefaultView;

Cheers

hi
i checked through debugging , it holds the value but not comes to display
in form.......what would be???
ssk