Hi,
i use a Grid to Display a Datatable. I select the Data with an SQL-Statement. But how do i display the value from the inner join (second table)?
How do is diaply "produkt " which is a field from table "kommentare"?
will not work!
Thanks
best Regards
Rene
i use a Grid to Display a Datatable. I select the Data with an SQL-Statement. But how do i display the value from the inner join (second table)?
DataTable Kommentare
{
get
{
if
(Object.Equals(Session[
"Kommentare"
],
null
))
{
string
query =
"SELECT id, paketid, kommentar, bewertung, produkt FROM [kommentare] INNER JOIN [rating] ON kommentare.paketid = rating.id"
;
DataTable dt = GetDataTable(query);
Session[
"Kommentare"
] = dt;
}
return
(DataTable)Session[
"Kommentare"
];
}
set
{
Session[
"Kommentare"
] = value;
}
}
How do is diaply "produkt " which is a field from table "kommentare"?
<telerik:GridBoundColumn AllowSorting=
"true"
DataField=
"produkt"
HeaderText=
"Produkt"
SortExpression=
"Produkt"
UniqueName=
"produkt"
/>
will not work!
Thanks
best Regards
Rene