Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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();


    }
    }
    }
Working...
X