RESOLVED [VS 2005]- asp.net 2.0 data binding help

[coolwater]

Hello. I'm trying to learn asp.net 2.0. i just started last week. i was wondering if someone can help me with data binding. I've have a hard time transitioning from vb6 to asp.net 2.0. I hope you guys can help me on this simple problem of mine.
I use sql server 2000 as my database. Below are my tables and questions.

My Tables:

tblStudent	
StudentID	bigint
StudentName	varchar
CourseID	bigint

tblCourse	
CourseID	bigint
CourseTitle	varchar

Typical asp.net 2.0 data binding in Gridview
     StudentID	StudentName	         CourseID
     100001	 George Washington	   100
     100002	 Jose Rizal	           101
     100003	 John Doe	           102
     100004	 Albert Einstein	   103

What I wanted to show in Gridview	(select, insert, update, delete enabled)	
     StudentID	StudentName	     CourseTitle
     100001	George Washington    Engineering
     100002	Jose Rizal	     Management
     100003	John Doe	     Criminology
     100004	Albert Einstein	     Nuclear Physics

I know this is very trivial to some of you guys. I was experimenting with the databinding technique of vs 2005 but got lost when i tried to inner join the tblCourse with tblStudent. I wanted to edit the template for field [CourseID] into a drop down list in edit/add mode so that i can choose freely a course title item and update the tblStudent table. Is there a way to this with databinding? Can I have my ddl show CourseTitle in the list items and post the CourseID as value into tblstudent? or do i have to do it manually in code? any help will be very appreciated. thanks.

[mendhak]

To start with, look at this tutorial

http://quickstarts.asp.net/QuickStar.../gridview.aspx

For the gridview. It also shows you how to use the sqldatasource with your gridview. For you, then, it's only a matter of writing the correct SQL statement, be it inline or in your stored procedure. (I would recommend stored procedures).

SELECT S.StudentID, S.StudentName, C.CourseTitle FROM tblStudent S LEFT JOIN tblCourse C ON C.CourseID = S.CourseID

[coolwater]

thank you mendhak.

[mendhak]

No problem.

Also, go through a quick SQL tutorial on www.w3schools.com/sql

It'll help in the long run.