Grid view with SqlDatasource

Question

I have in my Web a GridView that use SqlDatasource to insert data into the rows of the gridview.

the grid have for example: id name genre_id

now i have a table with songs and table with genres(genre_id,genre_name), and i want that in the grid will use genres_name and not the genres_id

This is the SqlDataSource for the GridView:

<asp:SqlDataSource ID="StationsDataSource" runat="server" 
        ConflictDetection="CompareAllValues" 
        ConnectionString="<%$ ConnectionStrings:TvSQLManagerConnectionString %>" 
        SelectCommand="SELECT [id],[name],[genre] FROM songs ORDER BY [name]" 
</asp:SqlDataSource>

Kumar V · Accepted Answer · 2014-02-22 09:55:07Z

1

Use SQL Join to get data from Genre table as well.

Replace your Query in SelectCommand like this

SELECT S.ID,S.NAME.G.GENRE_NAME AS GENRE FROM SONGS S
INNER JOIN 
GENERES G ON S.GENRE=G.GENRE_ID

edited Feb 22, 2014 at 9:55

Kumar V

8,8289 gold badges44 silver badges60 bronze badges

answered Apr 22, 2012 at 14:34

Shyju

220k106 gold badges420 silver badges499 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

YosiFZ Over a year ago

The problem is that i define in the gridview genre as the DataField of his colmun,and then he except to get genre but he get G.GENRE_NAME and he give me an error when i run it

Shyju Over a year ago

@MTA : Either change the name in datagrid or change the query to have an alias ( i updated my answer for this)

Collectives™ on Stack Overflow

Grid view with SqlDatasource

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related