grid view connection to a data in a table ?!
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 ???
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
Software/Hardware used:
Software/Hardware used:
ASKED:
June 24, 2009 7:20 AM
UPDATED:
June 24, 2009 1:47 PM
RELATED QUESTIONS
- Error inserting data in table
- I have code for search button which only access on table in databaseI want sql query which access All tables in database.Iam pasting following code
- ASP.NET C# database connection in external file
- Database connectivity ASP.NET using C#
- how to display images from database on datalist in asp.net 2.0
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
You will probably need to change your SQL statement.
Could you please explain this:
“my task is to show what every author has in terms of books ”
Could you post some example data ?