[Solved] Display Value - inner join

[ITA]

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)?

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

[Princy]

Hi,

Please try the following query string for inner join, add TableName.ColumnName to display the columns in Grid.

C#:

string query = "SELECT kommentare.id, kommentare.paketid, . . . , rating.produkt FROM [kommentare] INNER JOIN [rating] ON kommentare.paketid = rating.id";

Thanks,
Princy

[ITA]

Hi,

i changed the SQL-String:

string query = "SELECT kommentare.id, kommentare.paketid, kommentare.kommentar, kommentare.bewertung, rating.produkt FROM [kommentare] INNER JOIN [rating] ON kommentare.paketid = rating.id";

and the aspx:

<telerik:GridBoundColumn AllowSorting="true" DataField="rating.produkt" HeaderText="Produkt" SortExpression="Produkt" UniqueName="produkt"  />

But without any success.

Thanks
Best Regards
Rene

[ITA]

Hi,

solved, the Problem was the DataField="Rating.Produkt" - bettes ist DataField=Produkt".

thanks for your Help
Rene