displaying with filter in vb.net through sql server table

See more:

VB

SQL-Server

Hi everyone.. can you help me to manipulate a sample program that basically this how it works:

I have a log-in page having an admin roles for example admin, marketing and sales. Then there will be a data that already uploaded in the SQL database wherein in that database indicate the columns for example id, address , code, status. After that the users has identified code indicate admin = 1, marketing = 2 and sales =3. So my question is how i will manipulate in vb.net to filter the data in which if marketing will log on on his page only code for marketing will be viewed and admin and sales data will not viewed .. how it will coded in vb.net or else in SQL database with a very good example..

thanks in advance.. i hope you will understand my thoughts..