this.UserDataGridView.DefaultValuesNeeded += new DataGridViewRowEventHandler(UserDataGridView_DefaultValuesNeeded);

Here's the event handler:

        void UserDataGridView_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e)
        {
            e.Row.Cells["userIDDataGridViewTextBoxColumn"].Value = 1;
            foreach (DataRow dr in cCFUserTableAdapter.GetData().Rows)
            {
                Configure.ContactCenterDataSet.CCFUserRow ur =
                    (Configure.ContactCenterDataSet.CCFUserRow)dr;
                if (ur.UserID >
                    (Int32)e.Row.Cells["userIDDataGridViewTextBoxColumn"].Value)
                {
                    e.Row.Cells["userIDDataGridViewTextBoxColumn"].Value =
                        ur.UserID + 1;
                }
            }
        }

                if (ur.UserID >
                    (Int32)e.Row.Cells["userIDDataGridViewTextBoxColumn"].Value)

Hi taci,

The “e.Row.Cells[i].Value�in DefaultValuesNeeded handled method is for set. When you get its value before setting, it always return null.

Based on my understanding of your code, I think the purpose of it is to get the current max id in the data source. So you can generate the next id (max + 1). My suggestion is you can make a method which will return the max id (GetMaxID). That method will loop through the rows in the data source and get the max one. In the UserDataGridView_DefaultValuesNeeded method, set e.Row.Cells["userIDDataGridViewTextBoxColumn"].Value = GetMaxID() + 1; something like that.

Do you have any difficulty to code that GetMaxID method? If you need any help, please post the detail of your datasource (DataTable/DataSet) structure.

Sincerely,

Kira Qian

Send us any feedback you have about the help from MSFT at fbmsdn@microsoft.com

Hello taci,

I missed the “e.Row.Cells["userIDDataGridViewTextBoxColumn"].Value = 1�line at the first look, so sorry. After further test, I do find the e.Row.Cells[i].Value always return null even if I have set it first.

You have done right. This code is similar to my thinking. Actually my thinking is as follow.

private int GetMaxID()

{

int maxId = 1;

foreach (DataRow dr in cCFUserTableAdapter.GetData().Rows)

{

ContactCenterDataSet.CCFUserRow ur =

(ContactCenterDataSet.CCFUserRow)dr;

if (ur.UserID > newId)

{

maxId = ur.UserID;

}

}

return maxId;

}

void UserDataGridView_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e)

{

e.Row.Cells["userIDDataGridViewTextBoxColumn"].Value = GetMaxID() + 1;

}

If you want to find a more efficient solution, may be you can create a variable in your form, named MaxID. When the form loaded, you can put a loop to get the max id from data source and set MaxID variable. So you don’t need to do loop each time to set cell value. Just use MaxID + 1 as the value and make MaxID = MaxID + 1. This way is more efficient.

Hope it helps.

Sincerely,

Kira Qian