Editing Datagrids

[Helen Trim]

I have a datagrid on a webform that will allow the user to
edit data in a list. I have added the edit column in as a
link, but when it is clicked nothing happens. Do I need
to set something else in the Columns property or is it a
property of the dataset that needs changing?

Thanks
Helen

[Cor Ligthert]

Helen,

Yes there is a property what is by default false by other controls than the
different buttons which is "autopostba ck"

I hope this helps?

Cor
"Helen Trim"

I have a datagrid on a webform that will allow the user to
edit data in a list. I have added the edit column in as a
link, but when it is clicked nothing happens. Do I need
to set something else in the Columns property or is it a
property of the dataset that needs changing?

Thanks
Helen

[Helen Trim]

Thanks for the suggestion, but a datagrid doesn't have an
AutoPostback property.

Anything else I can do?

-----Original Message-----
Helen,

Yes there is a property what is by default false by other controls than thedifferent buttons which is "autopostba ck"

I hope this helps?

Cor
"Helen Trim"

I have a datagrid on a webform that will allow the user to edit data in a list. I have added the edit column in as a link, but when it is clicked nothing happens. Do I need
to set something else in the Columns property or is it a
property of the dataset that needs changing?

Thanks
Helen

.

[Cor Ligthert]

Helen,

I thought you where talking about the list and I thougth it was the
dataslist that you wanted to activate.

For the datagrid you would have to add a button column, what is the most
easy to do using the designer, which has a kind of wizard for that (look
beneath in the property box for that).
(And the buttons have autopostback standard activated)

I hope this helps?

Cor

Thanks for the suggestion, but a datagrid doesn't have an
AutoPostback property.

Anything else I can do?

-----Original Message-----
Helen,

Yes there is a property what is by default false by other

controls than the

different buttons which is "autopostba ck"

I hope this helps?

Cor
"Helen Trim"

I have a datagrid on a webform that will allow the user to edit data in a list. I have added the edit column in as a link, but when it is clicked nothing happens. Do I need
to set something else in the Columns property or is it a
property of the dataset that needs changing?

Thanks
Helen

.

[Ken Tucker [MVP]]

Hi,

Right click on the datagrid and select property grid. Under columns
expand the button column and move edit, update, and cancel to the selected
columns. Here is some code on how to handle the edit. I left the code on
how to handle paging just in case you needed it. Please note i left the
code to edit the actual datasource up to you in the updateitem event. I can
provide code if needed.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

'Put user code to initialize the page here

If Not Me.IsPostBack Then

doDataBind()

End If

End Sub

Protected Sub doDataBind()

Dim bc As BoundColumn

Dim ds As DataSet

Dim cn As New SqlConnection(" server=localhos t;" & _

"Integrated Security=SSPI;I nitial Catalog=GolfArt icles")

Dim da As New SqlDataAdapter( "Select * from Customer ORDER BY CustomerID",
cn)

ds = New DataSet("Custom ers")

da.Fill(ds, "Customers" )

Me.DataGrid1.Da taSource = ds.Tables("Cust omers").Default View

DataGrid1.DataB ind()

Label1.Text = ds.GetXml

End Sub

Private Sub DataGrid1_PageI ndexChanged(ByV al source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridPageChanged EventArgs) Handles
DataGrid1.PageI ndexChanged

' For the DataGrid control to navigate to the correct page when

' paging is allowed, the CurrentPageInde x property must be updated

' programmaticall y. This process is usually accomplished in the

' event-handling method for the PageIndexChange d event.

' Set CurrentPageInde x to the page the user clicked.

DataGrid1.Curre ntPageIndex = e.NewPageIndex

' Rebind the data to refresh the DataGrid control.

doDataBind()

End Sub

Private Sub DataGrid1_EditC ommand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
DataGrid1.EditC ommand

DataGrid1.EditI temIndex = e.Item.ItemInde x

doDataBind()

End Sub

Private Sub DataGrid1_Updat eCommand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
DataGrid1.Updat eCommand

'

' Update command goes here

'

DataGrid1.EditI temIndex = -1

doDataBind()

End Sub

Private Sub DataGrid1_Cance lCommand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
DataGrid1.Cance lCommand

DataGrid1.EditI temIndex = -1

doDataBind()

End Sub

Ken

-------------------------

"Helen Trim" <he************ *********@porth osp.nhs.uk> wrote in message
news:8a******** *************** *****@phx.gbl.. .
I have a datagrid on a webform that will allow the user to
edit data in a list. I have added the edit column in as a
link, but when it is clicked nothing happens. Do I need
to set something else in the Columns property or is it a
property of the dataset that needs changing?

Thanks
Helen