i don't know if i can explain this good.
i want to add a data view in my wss3 site using the sharepoint designer.
this dataview has the vacation days of an employee. now by using windows authentication my user log in to the wss3 site.
the employee open a page where he can view his vacation days. now i want that dataview to show the employee his vacation days. but only that employee's vacation days.
how can i filter the dataview to only show that employee his vacation days is this something i have to do in my sql server?