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

Recommended Answers

All 3 Replies

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.

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

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.:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.