Database

<br />
DECLARE @ident INT<br />
<br />
SET @ident = SCOPE_IDENTITY()<br />
<br />
IF @ident >= {max value here} BEGIN<br />
    DBCC CHECKIDENT({table name here}, reseed, {new seed value here})<br />
END<br />
<br />

<br />
public override void InitializeNewComponent()<br />
{<br />
  base.InitializeNewComponent();<br />
<br />
  CustomData = new CustomData();<br />
<br />
  //at least one grouping is required for both rows and columns<br />
<br />
  //initialize a static row grouping<br />
  CustomData.DataRowGroupings = new DataRowGroupings();<br />
  CustomData.DataRowGroupings.DataGroupings = new List<DataGrouping>(1);<br />
  CustomData.DataRowGroupings.DataGroupings.Add(new DataGrouping());<br />
  CustomData.DataRowGroupings.DataGroupings[0].Static = true;<br />
  <br />
  // initialize a Static column grouping<br />
  CustomData.DataColumnGroupings = new DataColumnGroupings();<br />
  CustomData.DataColumnGroupings.DataGroupings = new List<DataGrouping>(1);<br />
  CustomData.DataColumnGroupings.DataGroupings.Add(new DataGrouping());<br />
  CustomData.DataColumnGroupings.DataGroupings[0].Static = true;<br />
<br />
  //initialize data row with empty values for designer<br />
  CustomData.DataRows = new List<DataRow>(1);<br />
  CustomData.DataRows.Add(new DataRow());<br />
  CustomData.DataRows[0].Add(new DataCell());<br />
<br />
  //define the fields you will store (these will be populated with expressions by custom designer properties you define)<br />
  CustomData.DataRows[0][0].Add(new DataValue("Label", String.Empty));<br />
  CustomData.DataRows[0][0].Add(new DataValue("X", String.Empty));<br />
  CustomData.DataRows[0][0].Add(new DataValue("Y", String.Empty));<br />
  }<br />

<br />
[Browsable(true), Category("Data")]<br />
public string XValue<br />
{<br />
	get<br />
	{<br />
		if (CustomData.DataRows.Count > 0 && CustomData.DataRows[0].Count > 0)<br />
			return GetDataValue(CustomData.DataRows[0][0], "X");<br />
		else<br />
			return "X Coordinate";<br />
	}<br />
	set<br />
	{<br />
		SetDataValue(CustomData.DataRows[0][0], "X", value);<br />
	}<br />
}<br />
<br />
<br />
private string GetDataValue(DataCell cell, string name)<br />
{<br />
	foreach (DataValue value in cell)<br />
		if (value.Name == name)<br />
			return value.Value;<br />
	return null;<br />
}<br />
<br />
private void SetDataValue(DataCell cell, string name, string expression)<br />
{<br />
	foreach (DataValue value in cell)<br />
		if (value.Name == name)<br />
		{<br />
			value.Value = expression;<br />
			return;<br />
		}<br />
	DataValue datavalue = new DataValue(name, expression);<br />
	cell.Add(datavalue);<br />
}<br />

<br />
private void ReadCustomData()<br />
{	<br />
	DataCellCollection rows = m_CRI.CustomData.DataCells;<br />
<br />
	//get the position of each field in the data value collection<br />
	int xpos = -1, ypos = -1, labelpos = -1;<br />
<br />
	for (int field = 0; field < rows[0, 0].DataValues.Count; field++)<br />
	{<br />
		switch (rows[0, 0].DataValues[field].Name)<br />
		{<br />
			case "X":<br />
				xpos = field;<br />
				break;<br />
			case "Y":<br />
				ypos = field;<br />
				break;<br />
			case "Label":<br />
				labelpos = field;<br />
				break;<br />
		}<br />
	}<br />
<br />
	//populate the series for the chart data<br />
	for (int row = 0; row < rows.RowCount; row++)<br />
	{<br />
		DataValueCollection values = rows[row, 0].DataValues;<br />
		<br />
		double x = Convert.ToDouble(values[xpos].Value);<br />
		double y = Convert.ToDouble(values[ypos].Value);<br />
		string label = (string)values[labelpos].Value;<br />
	}<br />
}<br />