I'm julien , beginner in visual studio 2008 using c# language
I Have this task that I seem to be stuck in !
I've created a database using sql server express 2005 of 4 tables :"BOOKS , AUTHORS , CATEGORIES and PUBLISHERS ".
I've connected this database to my gridview in visual studio , it shows me all the books like this : " BOOK publisher , TITLE, CATEGORY "
the problem is that my task is to show what every author has in terms of books .
and I cant figure out how to do that !!!!
can u tell me if any of this code that I'm using is helpfull or not ???
public partial class _Default : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
string ConnectionString = "Data Source=-------;Initial Catalog=julien;Integrated Security=True";
string selectSQL = "SELECT