[Theocharis]

i display my query in a datagridview using c#
here it is:

SqlCommand cmd = new SqlCommand(" SELECT RFIDtag, Title, Author, Description, 1 AS QuerySource
FROM Library.dbo.books 
WHERE RFIDtag  in (SELECT tags  FROM Library.dbo.readertags)
Union all
SELECT  RFIDtag, Title, Author, Description, 2 AS QuerySource
FROM Library.dbo.RentedBooks 
WHERE RFIDtag  in (SELECT tags  FROM Library.dbo.readertags); ", UGIcon);

 SqlDataAdapter da1 = new SqlDataAdapter(cmd);

 DataTable ds = new DataTable();
 da1.Fill(ds);
 dataGridView1.DataSource = ds;

mod edit


how can i display the second query in red?

[tlhIn`toq]

WinForms or WPF ?

[Skydiver]

I don't think WPF has a DataGridView. I know that WPF has a DataGrid.

Anyway, the answer for painting a row a custom color is in MSDN:
How to: Customize the Appearance of Rows in the Windows Forms DataGridView Control