private void dataGridView1_CellValueNeeded(object sender, System.Windows.Forms.DataGridViewCellValueEventArgs e)
{
// If this is the row for new records, no values are needed.
if (e.RowIndex == this.dataGridView1.RowCount - 1)
{
return;
}
Customer customerTmp = null;
// Store a reference to the Customer object for the row being painted.
if (e.RowIndex == rowInEdit)
{
customerTmp = this.customerInEdit;
}
else
{
customerTmp = (Customer)this.customers[e.RowIndex];
}
// Set the cell value to paint using the Customer object retrieved.
switch (this.dataGridView1.Columns[e.ColumnIndex].Name)
{
case "Company Name":
e.Value = customerTmp.CompanyName;
break;
case "Contact Name":
e.Value = customerTmp.ContactName;
break;
}
}
private void dgMySuordinate_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
for (int i = 0; i < totalRecords; i++)
{
if (e.RowIndex == i)
{
string employeeId = Convert.ToString(dgMySuordinate.Rows[e.RowIndex].Cells[0].Value);
if (e.ColumnIndex == 2)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatusForSalesManager(employeeId, OrderStatus.OnChatting);
}
if (e.ColumnIndex == 3)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatusForSalesManager(employeeId, OrderStatus.Signed);
}
if (e.ColumnIndex == 4)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatusForSalesManager(employeeId, OrderStatus.NotSigned);
}
if (e.ColumnIndex == 5)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatusForSalesManager(employeeId, OrderStatus.Denied);
}
if (e.ColumnIndex == 6)
{
e.Value = orderManager.GetLastMonthToCurrentMonthCountByOrderStatus(employeeId, OrderStatus.OnChatting);
}
}
}
}
private void dataGridView1_CellValueNeeded(object sender,
DataGridViewCellValueEventArgs e)
{
if (store.ContainsKey(e.RowIndex))
{
// Use the store if the e value has been modified
// and stored.
e.Value = store[e.RowIndex];
}
else if (newRowNeeded && e.RowIndex == numberOfRows)
{
if (dataGridView1.IsCurrentCellInEditMode)
{
e.Value = initialValue;
}
else
{
// Show a blank value if the cursor is just resting
// on the last row.
e.Value = String.Empty;
}
}
else
{
e.Value = e.RowIndex;
}
}
//</Snippet120>
//<Snippet130>
private void dataGridView1_CellValuePushed(object sender,
System.Windows.Forms.DataGridViewCellValueEventArgs e)
{
Customer customerTmp = null;
// Store a reference to the Customer object for the row being edited.
if (e.RowIndex < this.customers.Count)
{
// If the user is editing a new row, create a new Customer object.
this.customerInEdit ??= new Customer(
((Customer)this.customers[e.RowIndex]).CompanyName,
((Customer)this.customers[e.RowIndex]).ContactName);
customerTmp = this.customerInEdit;
this.rowInEdit = e.RowIndex;
}
else
{
customerTmp = this.customerInEdit;
}
// Set the appropriate Customer property to the cell value entered.
String newValue = e.Value as String;
switch (this.dataGridView1.Columns[e.ColumnIndex].Name)
{
case "Company Name":
customerTmp.CompanyName = newValue;
break;
case "Contact Name":
customerTmp.ContactName = newValue;
break;
}
}
private void dgUnSubordinate_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.ColumnIndex == 0)
{
e.Value = (pageIndex - 1) * pageSize + e.RowIndex + 1;//set serial number of the table rows.
}
}
private void DatabaseGridView_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.RowIndex >= 0 && e.ColumnIndex == 0)
{
e.Value = e.RowIndex + 1;
}
}
private void dgMyDesigner_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
for (int i = 0; i < totalRecords; i++)
{
if (e.RowIndex == i)
{
string employeeId = Convert.ToString(dgMyDesigner.Rows[e.RowIndex].Cells[0].Value);
if (e.ColumnIndex == 1)
{
e.Value = empManager.GetGroupNameByEmployeeId(employeeId);
}
if (e.ColumnIndex == 2)
{
e.Value = empManager.GetEmployeeById(employeeId).Name;
}
if (e.ColumnIndex == 3)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatus(employeeId, OrderStatus.OnChatting);
}
if (e.ColumnIndex == 4)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatus(employeeId, OrderStatus.Signed);
}
if (e.ColumnIndex == 5)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatus(employeeId, OrderStatus.NotSigned);
}
if (e.ColumnIndex == 6)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatus(employeeId, OrderStatus.Denied);
}
}
}
}
private void dgVisitContent_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.ColumnIndex == 0)
{
e.Value = e.RowIndex + 1;//set serial number of the table rows.
}
}
private void Watch_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
switch (e.ColumnIndex)
{
case 0: e.Value = "Variable"; break;
case 1: e.Value = "3.14159 mV"; break;
case 2: e.Value = "0x00000000"; break;
case 3: e.Value = "100 ms"; break;
}
}
private void dataGridView1_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
//this function will populate unbound grid row and column wise. debug it then u can understand how grid is populating.
e.Value = memoryCache.RetrieveElement(e.RowIndex, e.ColumnIndex);
//if (e.RowIndex == 14)
//{
// //here it populated all rows of the grid
// //label1.Text = "Data loading completed";
//}
}
private void dataGridView_CellValueNeeded( object sender, DataGridViewCellValueEventArgs e )
{
if( pointList == null )
throw new InvalidOperationException( "cell value needed but point list is null" );
if( e.ColumnIndex == 0 )
e.Value = pointList[e.RowIndex].X;
else
e.Value = pointList[e.RowIndex].Y;
}
protected override void OnCellValueNeeded(DataGridViewCellValueEventArgs e)
{
base.OnCellValueNeeded(e);
IList list = this.DataSource as IList;
int index = e.RowIndex;
if (list == null) { return; }
if (index < 0 || (index+1) > list.Count) { return; }
if (e.ColumnIndex == 0 )
{
e.Value = IsItemSelected(list[index]);
}
}
private void dataGridView2_CellValueNeeded(object sender,
System.Windows.Forms.DataGridViewCellValueEventArgs e)
{
// If this is the row for new records, no values are needed.
if (e.RowIndex == this.dataGridView2.RowCount - 1)
{
return;
}
// Set the cell value to paint using the Customer object retrieved.
if (strarr2[e.RowIndex] != null)
{
e.Value = strarr2[e.RowIndex][e.ColumnIndex];
}
}
// -----------------------------------------
// DataGrid Events
// read from internal ArrayList
public virtual void dataGrid_CellValueNeeded(DataGridView dg, DataGridViewCellValueEventArgs e)
{
if (e.RowIndex < dlist.Count)
{
cBaseItem d = (cBaseItem)dlist[e.RowIndex];
e.Value = d.RenderCell(e.ColumnIndex);
} else {
// if displaying new row
if (current_editrow != null)
{
cBaseItem d = current_editrow;
e.Value = d.RenderCell(e.ColumnIndex);
}
}
}
private void ExtensionTableGrid_CellValueNeeded(object sender, System.Windows.Forms.DataGridViewCellValueEventArgs e)
{
try
{
if (FITSBINTABLE.GetTableDataTypes(e.ColumnIndex) == TypeCode.Char)
{
e.Value = ((string[])DATATABLE[e.ColumnIndex])[e.RowIndex];
}
else
{
e.Value = ((double[])DATATABLE[e.ColumnIndex])[e.RowIndex];
}
}
catch
{
}
}
private void dataPaymentInfo_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
Payment c = paymentInfo[e.RowIndex];
if (e.ColumnIndex == 2)
{
int i = 0;
for (; i < goodsInfo.Length; i++)
{
if (goodsInfo[i].Id == c.GoodsId)
{
e.Value = goodsInfo[i].Name;
break;
}
}
if (i == goodsInfo.Length) e.Value = "无";
}
}
public CellContent GetCellContentFromPoint(int x, int y)
{
HitTestInfo hit = HitTest(x, y);
if (hit.Type == DataGridViewHitTestType.Cell)
{
DataGridViewCellValueEventArgs args = new DataGridViewCellValueEventArgs(hit.ColumnIndex, hit.RowIndex);
OnCellValueNeeded(args);
for (int i = 0; i < this.ColumnCount; ++i)
{
Rectangle r = this.GetColumnDisplayRectangle(i, false);
if (x > r.Left && x < r.Right)
{
return new CellContent(args.Value as string, r.Left);
}
}
}
return null;
}
private void dgvTemplates_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.RowIndex >= 0 && e.RowIndex < templates.Count)
{
switch(e.ColumnIndex)
{
case 0:
e.Value = e.RowIndex;
break;
case 1:
e.Value = templates[e.RowIndex].name;
break;
case 2:
e.Value = templates[e.RowIndex].preferredAngleNoMore90;
break;
}
}
}
private void dgIAList_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
for (int i = 0; i < totalRecords; i++)
{
if (e.RowIndex == i)
{
string employeeId = Convert.ToString(dgMySuordinate.Rows[e.RowIndex].Cells[0].Value);
if (e.ColumnIndex == 1)
{
e.Value = i + 1;
}
if (e.ColumnIndex == 3)
{
e.Value = mySubordinateManager.GetVisitCount(employeeId);
}
if (e.ColumnIndex == 4)
{
e.Value = mySubordinateManager.GetInformationAssistantCount(employeeId);
}
if (e.ColumnIndex == 5)
{
e.Value = mySubordinateManager.GetCustomerCount(employeeId);
}
if (e.ColumnIndex == 6)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatusForSalesManager(employeeId, OrderStatus.OnChatting);
}
if (e.ColumnIndex == 7)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatusForSalesManager(employeeId, OrderStatus.Signed);
}
if (e.ColumnIndex == 8)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatusForSalesManager(employeeId, OrderStatus.NotSigned);
}
if (e.ColumnIndex == 9)
{
e.Value = orderManager.GetCurrentMonthCountByOrderStatusForSalesManager(employeeId, OrderStatus.Denied);
}
}
}
}
private void dataGridView1_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
// Check if the item is in the local cache.
DataRow match = null;
if (dtCachedItems != null)
match = dtCachedItems.Rows.Find(e.RowIndex + 1);
if (match == null)
{
// The item isn't in memory.
// Get a new range of 100 records.
int from, to;
if (e.RowIndex < 50)
from = 0;
else
from = (e.RowIndex - 50);
to = from + 100;
dtCachedItems = NorthwindDB.GetOrders(from, to);
// Don't use the MessageBox to show this information.
// Hiding any part of the ListView can retrigger this event.
lblStatus.Text = String.Format(
"Fetched rows from {0} to {1} at {2}.",
from.ToString(), to.ToString(),
DateTime.Now.ToLongTimeString());
match = dtCachedItems.Rows.Find(e.RowIndex + 1);
}
switch (e.ColumnIndex)
{
case 0:
e.Value = match["OrderID"];
break;
case 1:
e.Value = match["ShippedDate"];
break;
}
}
private void Event_CellValueNeeded(object sender, System.Windows.Forms.DataGridViewCellValueEventArgs e)
{
string byte_string;
int address;
int row_start;
string row_start_string;
row_start = CellToRowStart(e.RowIndex);
row_start_string = row_start.ToString("X6");
if (
(this.Rows[e.RowIndex].HeaderCell.Value == null) ||
(this.Rows[e.RowIndex].HeaderCell.Value.ToString() != row_start_string)
)
{
this.Rows[e.RowIndex].HeaderCell.Value = row_start_string;
}
address = this.CellToAddress(e.RowIndex, e.ColumnIndex);
byte_string = this.GetByteString(address);
e.Value = byte_string;
}
void dataGridView1_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
try
{
if (e.RowIndex >= dt.Rows.Count)
return;
if (e.ColumnIndex >= dt.Columns.Count)
return;
if (dt.Rows[e.RowIndex][e.ColumnIndex] == null || dt.Rows[e.RowIndex][e.ColumnIndex] is DBNull)
{
e.Value = "null";
return;
}
Type dtype = dt.Columns[e.ColumnIndex].DataType;
if (dtype == typeof(byte[]))
{
e.Value = "blob/byte[]";
}
else if (dtype == typeof(DateTime))
{
e.Value = ((DateTime)dt.Rows[e.RowIndex][e.ColumnIndex]).ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
e.Value = dt.Rows[e.RowIndex][e.ColumnIndex] + "";
}
}
catch (Exception ex)
{
MessageBox.Show("An error has occured.\r\n\r\n" + ex.ToString());
this.Close();
}
}
private void dataGridView1_CellValueNeeded(object sender, System.Windows.Forms.DataGridViewCellValueEventArgs e)
{
// If this is the row for new records, no values are needed.
if (e.RowIndex == this.dataGridView1.RowCount - 1)
{
return;
}
// Set the cell value to paint using the Customer object retrieved.
if (e.RowIndex >= 0 && e.RowIndex < DisplayedMsgs.Count)
{
Frame msg = DisplayedMsgs[e.RowIndex];
switch (this.dataGridView1.Columns[e.ColumnIndex].Name)
{
case "ID": e.Value = msg.Header.Identifier; break;
case "NameColumn": e.Value = msg.Defn.Name; break;
case "Description": e.Value = msg.Defn.Description; break;
case "Source": e.Value = msg.Header.Source; break;
case "Time": e.Value = msg.TimeStamp.ToString(); break;
case "Destination": e.Value = msg.Header.Destination; break;
case "Priority": e.Value = msg.Header.Priority; break;
case "Length": e.Value = msg.Length; break;
case "Fields": e.Value = msg.Defn.FieldsString(msg); break;
case "EnumFields": e.Value = msg.Defn.EnumFieldsString(msg); break;
}
}
}
protected override void OnCellValueNeeded(System.Windows.Forms.DataGridViewCellValueEventArgs e)
{
base.OnCellValueNeeded(e);
if (e.RowIndex >= _list.Count)
{
return;
}
var cur = _list[e.RowIndex];
if (e.ColumnIndex == _nameColumn.Index)
{
e.Value = cur.Name;
}
else if (e.ColumnIndex == _valueColumn.Index)
{
e.Value = _info.GetValue(cur);
}
else
{
Debug.Fail("Unexpected");
e.Value = string.Empty;
}
}
private void cellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.RowIndex >= records.Count)
{
e.Value = string.Empty;
return;
}
switch (dgViewLog.Columns[e.ColumnIndex].Name)
{
case "timeColumn":
e.Value = records[e.RowIndex].Time;
break;
case "typeColumn":
e.Value = records[e.RowIndex].Type;
if ((string)e.Value == exceptionText)
{
dgViewLog.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Red;
dgViewLog.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else
{
if ((string)e.Value == errorText)
{
dgViewLog.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.DarkRed;
dgViewLog.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else
{
if ((string)e.Value == completedText)
{
dgViewLog.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.Green;
dgViewLog.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
else
{
if ((string)e.Value == summaryText)
{
dgViewLog.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.DarkSlateBlue;
dgViewLog.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.White;
}
}
}
}
break;
case "detailColumn":
e.Value = records[e.RowIndex].Detail;
break;
default:
break;
}
dgViewLog.Rows[e.RowIndex].Height = 16;
}
private void dataGridView1_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
try
{
e.Value = m_dtCSV.DefaultView[e.RowIndex][e.ColumnIndex].ToString();
}
catch { }
}
private void grdSamples_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.RowIndex == -1) return;
var sampleModel = GetSampleModelByIndex(e.RowIndex);
if (sampleModel == null) e.Value = "";
else if (e.ColumnIndex == 0)
{
e.Value = sampleModel.Description;
}
else if (e.ColumnIndex == 1)
{
e.Value = sampleModel.Bpm.ToString("0.00");
}
}
private void CalDataGridView_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.RowIndex >= VersionToShow.Count)
{
return;
}
switch (e.ColumnIndex)
{
case 0:
e.Value = VersionToShow[e.RowIndex].date.ToLongTimeString() + " " + VersionToShow[e.RowIndex].date.ToLongDateString();
break;
case 1:
e.Value = "test version";
break;
case 2:
e.Value = null;
break;
case 3:
e.Value = "test notes";
break;
case 4:
// DataGridViewRow datrow2 = this.CalDataGridView.Rows[e.RowIndex];
// DataGridViewComboBoxCell data4 = datrow2.Cells["Changes"] as DataGridViewComboBoxCell;
// data4.Items.Add("test change1");
// data4.Items.Add("test change2");
// e.Value = data4;
e.Value = "test version";
break;
}
}
private void dataGridViewGroups_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.RowIndex < allLines.Count)
e.Value = allLines[e.RowIndex];
}
private void dataGridView1_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
// Set the Sent Column
if (e.ColumnIndex == 0)
{
// Get Image
Object obj = ((this.messageBS[e.RowIndex] as MailMessage).Read ? _readImage : _unreadImage);
if (obj != null)
{
e.Value = obj;
}
else
{
e.Value = Properties.Resources.Unread;
}
}
}
/// ------------------------------------------------------------------------------------
/// <summary>
/// Handles the CellValueNeeded event of the gridInspector control.
/// </summary>
/// ------------------------------------------------------------------------------------
protected override void OnCellValueNeeded(DataGridViewCellValueEventArgs e)
{
e.Value = null;
base.OnCellValueNeeded(e);
if (e.Value != null || m_list == null || m_list.Count <= e.RowIndex)
return;
IInspectorObject io = m_list[e.RowIndex];
if (io == null)
e.Value = "null";
else
{
if (e.ColumnIndex == 0)
e.Value = io.DisplayName;
else if (e.ColumnIndex == 1)
e.Value = io.DisplayValue;
else
e.Value = io.DisplayType;
}
}
protected virtual object GetValue (int rowIndex) {
if (DataGridView != null && (RowIndex < 0 || RowIndex >= DataGridView.Rows.Count))
throw new ArgumentOutOfRangeException ("rowIndex", "Specified argument was out of the range of valid values.");
if (OwningRow != null && DataGridView != null && OwningRow.Index == DataGridView.NewRowIndex)
return DefaultNewRowValue;
if (DataProperty != null && OwningRow.DataBoundItem != null)
return DataProperty.GetValue (OwningRow.DataBoundItem);
if (valuex != null)
return valuex;
DataGridViewCellValueEventArgs dgvcvea = new DataGridViewCellValueEventArgs (columnIndex, rowIndex);
if (DataGridView != null)
DataGridView.OnCellValueNeeded (dgvcvea);
return dgvcvea.Value;
}
/// ------------------------------------------------------------------------------------
/// <summary>
/// Called when cell value needed.
/// </summary>
/// ------------------------------------------------------------------------------------
protected override void OnCellValueNeeded(DataGridViewCellValueEventArgs e)
{
KeyTermRef keyTermRef = m_list[e.RowIndex] as KeyTermRef;
if (keyTermRef == null)
{
e.Value = null;
return;
}
switch (e.ColumnIndex)
{
case KeyTermRenderingsControl.kRefCol:
e.Value = keyTermRef.Reference;
break;
case KeyTermRenderingsControl.kRenderingCol:
e.Value = keyTermRef.Rendering;
break;
case KeyTermRenderingsControl.kStatusCol:
e.Value = keyTermRef.RenderingStatus;
break;
case KeyTermRenderingsControl.kCommentCol:
e.Value = keyTermRef.KeyWordString;
break;
}
}
protected virtual bool SetValue (int rowIndex, object value)
{
object oldValue = this.Value;
if (DataProperty != null && !DataProperty.IsReadOnly) {
DataProperty.SetValue (OwningRow.DataBoundItem, value);
} else if (DataGridView != null && DataGridView.VirtualMode) {
DataGridViewCellValueEventArgs ea = new DataGridViewCellValueEventArgs(ColumnIndex, RowIndex);
ea.Value = value;
DataGridView.OnCellValuePushed(ea);
} else {
valuex = value;
}
if (!Object.ReferenceEquals (oldValue, value) || !Object.Equals (oldValue, value)) {
RaiseCellValueChanged (new DataGridViewCellEventArgs (ColumnIndex, RowIndex));
// Set this dirty flag back to false
if (this is IDataGridViewEditingCell)
(this as IDataGridViewEditingCell).EditingCellValueChanged = false;
if (DataGridView != null)
DataGridView.InvalidateCell (this);
return true;
}
return false;
}
protected internal virtual void OnCellValuePushed (DataGridViewCellValueEventArgs e)
{
DataGridViewCellValueEventHandler eh = (DataGridViewCellValueEventHandler)(Events [CellValuePushedEvent]);
if (eh != null)
eh (this, e);
}
void HandleCellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
e.Value = GetCellValue(e.ColumnIndex, e.RowIndex);
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
private void dataGridView1_CellValueNeeded(object sender, System.Windows.Forms.DataGridViewCellValueEventArgs e)
{
int temp = (e.RowIndex * columns) + e.ColumnIndex;
e.Value = DataStorage[temp];
}
private void orderGrid_CellValueNeeded(object sender, DataGridViewCellValueEventArgs e)
{
if (e.ColumnIndex == 1)
{
e.Value = (pageIndex - 1) * pageSize + e.RowIndex + 1;//set serial number of the table rows.
}
if (e.ColumnIndex == 2)
{
if (datas.Tables[0].Rows.Count > 0)
{
//e.Value = datas.Tables[0].Rows[e.RowIndex][e.ColumnIndex + 1] + " " +
//datas.Tables[0].Rows[e.RowIndex][e.ColumnIndex + 2];
}
}
if (e.ColumnIndex == 4)
{
if (datas.Tables[0].Rows.Count > 0)
{
e.Value = Convert.ToDateTime(datas.Tables[0].Rows[e.RowIndex][e.ColumnIndex + 2]).ToLongDateString();
}
}
}
