Customize Gridview....facing 2 Problems.......

See more:

C#

ASP.NET

SQL-Server

C#4.0

I have a gridview with 4 columns....time,Collage,Personal and reminder

in first column + is a image Button and 8am is a linkbutton 8am,9am,10am.....etc

are coming from gridview binding with daytime.xml...

time || Collage || Personal || Reminder

8am+

9am+

10am+

11am+

12am+

------

8pm+



Problem (1)

I want to show data from table named PlannerMaster in the Collage,Personal,Reminder Column..

is it possible to show data in First Column From Any xml file And another 3 Columns from any other table/Datasource.........

Problem (2)

I also want to change the backcolor of column ..according to the saved event

For Example if any event for Personal Category (in our gridview Column no. 3) from 8am to 11am..at that condition i want to show the row 8am to 11 am with backcolor Yellow...

same for Functionality For Collage and Reminder Column .....

this will help user to visualize in which time duration he is engegged/busy.....

I have started to solve these tasks by my own...but want to do this in easy and proper manner.... so if u have any better idea, or way to solve these problems then Your Welcome

we will work together............ (if the objective hsnt cleared yet pls clear from me..)

pls suggest..

thanks in advance..........