Customer Equipment Card

Mario Byttebier

On the customer card, i have added a tabsheet, which give me an overview of all equipment cards of this customer.
I want to select a specific serial number and click on the orange flag, to select the corresponding equipment card.
When i try to do this, i get an error message.

This is the code that i have used :

public void FillGridOCRD(Grid grid, string cardCode)
{
// Query to Select the Speciale Prices based on the Customer Number

string query = @"SELECT itemcode as 'Artikel',
itemname as 'Artikelomschrijving',
convert(char(10),dlvrydate,103) as 'Leveringsdatum',
'Nieuwe aanvraag' as 'Service-Aanvraag',
internalsn as 'Serienummer',
technician as 'Standaardtechnicus',
cntrctstrt as 'Begin contract',
cntrctend as 'Einde contract'
FROM oins
WHERE customer = '" + cardCode +
"' ORDER BY ITEMCODE";

grid.ExecuteQuery(query);

grid.Columns["Artikel"].Type = GridColumn.Types.TextEdit;
TextEditGridColumn tTyp;
tTyp = (TextEditGridColumn)grid.Columns["Artikel"].SpecificGridColumn;

//// Form die je oproept : 4 = Item Object
tTyp.LinkObjectType = "4";
grid.Columns["Artikel"].Width = 80;
grid.Columns["Artikelomschrijving"].Width = 150;
grid.Columns["Service-Aanvraag"].Width = 100;
grid.Columns["Leveringsdatum"].Width = 80;
grid.Columns["Serienummer"].Width = 100;
grid.Columns["Standaardtechnicus"].Width = 100;
grid.Columns["Begin contract"].Width = 85;
grid.Columns["Einde contract"].Width = 85;

// Form die je oproept : 191 = Service-aanvraag
((SwissAddonFramework.UI.Components.TextEditGridColumn)grid.Columns["Service-Aanvraag"].SpecificGridColumn).LinkObjectType = "191";

// Form die je oproept : 176 = Service-aanvraag
((SwissAddonFramework.UI.Components.TextEditGridColumn)grid.Columns["Serienummer"].SpecificGridColumn).LinkObjectType = "176";

grid.CollapseLevel = 1;
grid.AffectsFormMode = true;
}

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/mbyttebiericorda-be/CustEquipCard.jpg]CustEquipCard.jpg[/url]