accessing an sql database in visual studio 2008 asp.net page

[julien_h]

Hello ,
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 ???



using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{



foreach (Author Name in ds.Tables[0].Columns)

response.write<Author.books>;


}



protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
{
if (!this.IsPostBack)
{


string ConnectionString = "Data Source=DELL-FF646ED476;Initial Catalog=julien;Integrated Security=True";
string selectSQL = "SELECT [name] FROM [julien]";
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection("julienCS");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(selectSQL, con);
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(cmd);
DataSet ds = new DataSet();



adapter.Fill(ds, "julien ");

GridView1.DataSource = ds;
GridView1.DataBind();


}
}
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
if (!this.IsPostBack)
{


string ConnectionString = "Data Source=DELL-FF646ED476;Initial Catalog=julien;Integrated Security=True";
string selectSQL = "SELECT [category], [title] FROM [books] ORDER BY [title], [category]";
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection("julienCS");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(selectSQL, con);
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(cmd);
DataSet ds = new DataSet();



adapter.Fill(ds, "books ");

GridView2.DataSource = ds;
GridView2.DataBind();


}
}
}