Forms Over Data

Question

Hi...friends.! I have a form with a gridview and dataset called CommingBdaysDataSet.xsd .what I want to do is; I want to configure the tableAdapter of above xsd file to get the following output to the gridview when the form loading.. I'm developing a birthday reminder and I want to get the comming/future birthdays(ex:today is 21st Nov and bdays until the end of yr 2008). I wrote a query to the above tableAdapter using query builder.here it is; SELECT Lname, Fname, Address, BirthDay, EmpID FROM Employee WHERE (BirthDay BETWEEN GETDATE() AND 365-GETDATE() ) I think this should b corrected.And is it enough to attach this xsd to gridview using its datasource link?Or do I need to do some additinal coding. And I have only one table called Employee in my DB.I want to get some fields from table.(EID,Fname,Lname,Bday,Address)I have already designed dataset using this table. I have stuck with this issue. If anyone can please help me to obtain a solution for this. Thank you Charith