DataGrid---UpdateCommand... problem...

[just4ulove7]

Hi.. I have a datagrid and an EditCommand Now, when I click the UpdateCommand- link button... private void dgProjects_ItemUpdate(object sender,DataGridCommandEventArgs e ) { string ProjectId = e.Item.Cells[0].Text .... } It should return me the first column value in the clicked row??? But its not... Is something wrong.. or some other way...??? Thanks

[Snowblind37]

The answer is a little more complicated than it should be....Or at least I thought it should be. The following code is meant to take the value of the cell (that the user has selected and changed)and write this value into the database. It then refreshes the DataGrid to show the new value. The hardest part to understand is that you have to create a DataGridTableStyle object to do this. The reason for creating this object is that the class provides the necessary methods and properties that you need to access. private void updateButton_Click(object sender, System.EventArgs e) { //DataGridTableStyle provides the mechanisms DataGridTableStyle ts1 = new DataGridTableStyle(); //DataGridCell allows you to hold the contents of the specified cell DataGridCell myCell; myCell = UserdataGrid.CurrentCell; // map the DataGridTableStyle object to the database source ts1.MappingName = "SessionTable"; //Add the DataGridTableStyle object to the grid's TableStyles collection UserdataGrid.TableStyles.Add(ts1); string infoStr = null; int j = 0; //The two foreach statements is a loop within a loop //The outer loop deals with the row index //The inner loop returns the column number (j) if there is a match //and the infoStr(column to change) foreach(DataGridTableStyle gridStyle in UserdataGrid.TableStyles) { foreach(DataGridColumnStyle colStyle in gridStyle.GridColumnStyles) { if (j == myCell.ColumnNumber) { infoStr = colStyle.MappingName; } j++; } //end inner foreach } //end outer foreach //The element selection has been found //and the current row index is where it can be found int i = UserdataGrid.CurrentRowIndex; //Get the unique id associated with this row //Note that I needed to make this GUID id part of //my DataTable so that when I update the sql table //I am updating only that particular record //and not other records that may have similiar entries String userId = UserdataGrid[i, 7].ToString(); //The UpdateRecord method creates an SQL update statement //Parameters are: //Table to change //Column to change //Column to search for GUID id //match on GUID id will determine row index //Value to update sql.UpdateRecord("SessionTable", infoStr, "UserId", userId, UserdataGrid[myCell].ToString()); //Now all we need to do is show the changes in the DataGrid FillData(); UserdataGrid.SetDataBinding(dataSet, "SessionTable"); UserdataGrid.Refresh(); } Whoooo!!! It sure seems like alot of work just to get a value, change it and then display t