Hello All,

My question is what are datakeys, how to use them?, and a vb code to show how i can update and delete from DataGrid by using them...

Thanks,:)

Diana

If you set the DataKeyField of the datagrid to a column in the Datasource, a DataKeys collection is created that maintains all of the key values for each row.

If you are using some sort of Normalized Database the value that you are placing in the DataKeyField should be the Primary Key of the datasource, thus making it unique, so that you can preform SQL Statements against X Row. To access this in a code you would do something like this:

Private Sub dgDelete(ByVal Sender As Object, e as DataGridCommandEventArgs)
    Dim sDatabasePK as string = [datagrid_object].DataKeys(e.Item.ItemIndex)
    //Do something with the pk value
    //Rebind the datagrid
End Sub

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thanks,

Comd.Parameters("@Id").Value = DataGrid.DataKeys(CInt(E.Item.ItemIndex))

Can I ask what is CInt?

Diana

Hi

Basically the role of CInt is to convert a value into integer type.

Regards
Mike

Fortune favours the brave, so don't regret on missed oppurtunities.

Yes,
   CInt is the same as Convert.ToInt32() and is a VB only function. C# developers have to use Convert.ToInt32 or add a reference to Microsoft.VisualBasic to access that function. Though the only time that I have ever imported that namespace into a C# app is when I need to use the VB IsNumeric() function since C# doesnt have an IsNumeric() function =[

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature