DataGrid + BoundColumn + UpdateCommand

[niki]

Hello.
I have a problem with custom columns inside the datagrid.
I've set up a datagrid that populates from a database; I can edit the
datagrid values and update the db, so that's ok.
(btw, it's not as easy as the book claims...)

Now I'd like to format some columns, say date values, and what's more,
I'd like to make some columns not visible and some read-only.
I thought BoundColumn could be the solution, but as I create columns
this way and invoke the updatecommand event, the datagrid has no more
columns.
Inside the updatecommand event, the datagrid has just 1 column, I guess
it's the button one...

I've search this ng for some advice, but I couldn't understand how it
can be done.

Can you help me?

Thanks :)

[Elton W]

Hi Niki,

You can use BoundCloumns and set Visible, ReadOnly properties for the
BoundCloumns like follows.:

<asp:datagrid id="datagrid" runat="server">
<Columns>
<asp:EditComman dColumn ButtonType="Lin kButton" UpdateText="Upd ate"
CancelText="Can cel" EditText="Edit" ></asp:EditCommand Column>
<asp:BoundColum n Visible="False" DataField="ID" ></asp:BoundColumn >
<asp:BoundColum n DataField="Fiel dName" ReadOnly="True" HeaderText="Fil ed
Name"></asp:BoundColumn >
<asp:BoundColum n DataField="Edid _FieldName" HeaderText="Fil ed
Name"></asp:BoundColumn >
....

</Columns>
</asp:datagrid>

Updatecommand event is trggered by clicking Update button. You can get data
by e.Item.Cells[col_index].Text.

HTH

Elton Wang
el********@hotm ail.com

"niki" wrote:

Hello.
I have a problem with custom columns inside the datagrid.
I've set up a datagrid that populates from a database; I can edit the
datagrid values and update the db, so that's ok.
(btw, it's not as easy as the book claims...)

Now I'd like to format some columns, say date values, and what's more,
I'd like to make some columns not visible and some read-only.
I thought BoundColumn could be the solution, but as I create columns
this way and invoke the updatecommand event, the datagrid has no more
columns.
Inside the updatecommand event, the datagrid has just 1 column, I guess
it's the button one...

I've search this ng for some advice, but I couldn't understand how it
can be done.

Can you help me?

Thanks :)