0

Hi there!

In my Library project i want to replace some text with images.

I have this:
[img]http://img33.imageshack.us/img33/8425/antesx.jpg[/img]

Wich is generated by the following code:

SELECT IDLivro,Titulo
	,LEFT(Nome, LEN(Nome) - 2) AS Nome
	,LEFT(Categoria, LEN(Categoria) - 2) AS Categoria
	,Posicao
    ,Classificacao
    ,Comentario
    
FROM
(
	SELECT L.Titulo
		,(
			SELECT A.Nome + ' ; ' AS "text()"
			FROM dbo.Autor A
				JOIN dbo.LivroAutor LA
					ON A.IDAutor = LA.IDAutor
			WHERE LA.IDLivro = L.IDLivro
			ORDER BY A.Nome DESC
			FOR XML PATH('')
		) AS Nome
		,(
			SELECT C.Categoria + ' ; ' AS "text()"
			FROM dbo.Categoria C
				JOIN dbo.LivroCategoria LC
					ON C.IDCategoria = LC.IDCategoria
			WHERE LC.IDLivro = L.IDLivro
			ORDER BY C.Categoria DESC
			FOR XML PATH('')
		) AS Categoria
		,L.Posicao
		,L.Classificacao
		,L.IDLivro
		,L.Comentario
	FROM dbo.Livro L
) D

And my goal is to have this: (Generated my PAINT lol)
[img]http://img33.imageshack.us/img33/9396/depoisolk.jpg[/img]

Anyone can help me please?

Thanks

2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by lighthead
0

Is that the screen shot of MSSQL management studios?
If it is then you cannot replace it with an image. If it is in your application then it is possible. To answer further we need to know more about the application.

0

Problem Solved!

Its in your application (not SQL) that you manage this.

In my case (i´m using C#) i used the CellFormatting event of the dataGridView to solve this.

Thanks

0

I assumed it was MS SQLMS as you didnt mention the datagridview and posted the question in the MS SQL forum.
If you have solved your problem mark this thread as solved.:)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.