Adding new column to dataset

[satria]

hi all,

i have a accesslevel table's that has 2 field, id and accesslevelname.
i successfully binded the table to datagrid, but i'd like to display a
new column, called number. so it 'll display :
number | accesslevelname
1 user
2 supervisor
....

i dont want to add the new column to the database.

i tried this code :
DataSet ds=new DataSet();
ds=CFM.component.accesslevel.GetDS();
DataTable table = ds.Tables["AccessLevel"];
table.Columns.Add(new DataColumn("no",typeof(int)));
int rowcount=table.Rows.Count;
for(int i=1;i<rowcount-1;i++)
{
table.Rows[i]["no"]=i;
}

DataGrid1.DataSource=table;
DataGrid1.DataBind();

but i always get error
"Object reference not set to an instance of an object." at line
"table.Columns.Add(new DataColumn("no",typeof(int)));".

pls hlp me

regards

satria

[satria]

is there anyone could help me?

[ViewState]

I did not get your problema

"satria" <sa*****@gmail.com> escreveu na mensagem
news:11**********************@g14g2000cwa.googlegr oups.com...

hi all,

i have a accesslevel table's that has 2 field, id and accesslevelname.
i successfully binded the table to datagrid, but i'd like to display a
new column, called number. so it 'll display :
number | accesslevelname
1 user
2 supervisor
...

i dont want to add the new column to the database.

i tried this code :
DataSet ds=new DataSet();
ds=CFM.component.accesslevel.GetDS();
DataTable table = ds.Tables["AccessLevel"];
table.Columns.Add(new DataColumn("no",typeof(int)));
int rowcount=table.Rows.Count;
for(int i=1;i<rowcount-1;i++)
{
table.Rows[i]["no"]=i;
}

DataGrid1.DataSource=table;
DataGrid1.DataBind();

but i always get error
"Object reference not set to an instance of an object." at line
"table.Columns.Add(new DataColumn("no",typeof(int)));".

pls hlp me

regards

satria

[satria]

yes, just change ds.Tables["AccessLevel"] to ds.Tables[0] .
thx