#Eval for inner joined table

Question

0.00/5 (No votes)

See more:

Hi, i have a mysql query that inner joins two tables and i have griview on my asp page. Is there way to get a value from the inner joined table using <%# Eval %>. For example <%# Eval ("inner_joined_table_name.column_name")%>

Posted 4-Jul-12 22:08pm

Ruwaldo

Add a Solution

Comments

Sandeep Mewara 5-Jul-12 5:54am

Updated my answer - check out.

2 solutions

Solution 1

Eval (from documentation[^]) -
"The navigation path from the container object to the public property value to be placed in the bound control property. This must be a string of property or field names separated by periods, such as Tables[0].DefaultView.[0].Price in C# or Tables(0).DefaultView.(0).Price in Visual Basic."

As far as I understand, you cannot directly bind to a table.
However, you could use a datatable or gridview column and bind to it.

Posted 4-Jul-12 22:23pm

Abhinav S

Updated 4-Jul-12 22:26pm

v3

Comments

Ruwaldo 5-Jul-12 4:43am

I do have a gridview with the following fields:
<asp:Label ID="Desc" runat="server" Text='<%# Eval("description") %>'/>
<asp:Label runat="server" ID="Type" Text='<%# Eval("description")%>'/>
The first field is fine and it gets the description from the first table, the second field needs to get the description from the inner joined table. My query looks like this:
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT rank_distribution.rank_distribution_id,rank_distribution.description ,rank_distribution.amount,transaction_distribution.description FROM rank_distribution INNER JOIN transaction_distribution ON transaction_distribution.transaction_distribution_id = rank_distribution.transaction_distribution_id WHERE rank_distribution.rank_transaction_type_id = @rank_transaction_type_id", con);
cmd.Parameters.AddWithValue("@rank_transaction_type_id", Request.QueryString["rank_transaction_type_id"]);

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2012-07-04T22:24:00

Yes!

Eval will look for the column in the query result. Just make sure that your query fetches the column after the join of tables.

UPDATE:
based on what you ask:
I do have a gridview with the following fields:

<asp:Label ID="Desc" runat="server" Text='<%# Eval("description") %>'/> 
<asp:Label runat="server" ID="Type" Text='<%# Eval("description")%>'/>
The first field is fine and it gets the description from the first table, the second field needs to get the description from the inner joined table. My query looks like this:
        MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT rank_distribution.rank_distribution_id,rank_distribution.description ,rank_distribution.amount,transaction_distribution.description FROM rank_distribution INNER JOIN transaction_distribution ON transaction_distribution.transaction_distribution_id = rank_distribution.transaction_distribution_id WHERE rank_distribution.rank_transaction_type_id = @rank_transaction_type_id", con);
        cmd.Parameters.AddWithValue("@rank_transaction_type_id", Request.QueryString["rank_transaction_type_id"]);

All you need to do is to have alias of the column names such that there are two description columns clearly identifiable at the end.

Try:

HTML

<asp:Label ID="Desc" runat="server" Text='<%# Eval("RD_description") %>'/> 
<asp:Label runat="server" ID="Type" Text='<%# Eval("TD_description")%>'/>

Query:

SQL

MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT rank_distribution.rank_distribution_id,rank_distribution.description as RD_description,rank_distribution.amount,transaction_distribution.description as TD_description FROM rank_distribution INNER JOIN transaction_distribution ON transaction_distribution.transaction_distribution_id = rank_distribution.transaction_distribution_id WHERE rank_distribution.rank_transaction_type_id = @rank_transaction_type_id", con);