Sql Fill query how to get it working?

See more:

C#

Hey i want to filter my datagrid so i have put done a query in the fill with the following

SELECT        id, cardNumber, transactionType, transactionAmount, transactionDate
FROM            [Log]
WHERE        (cardNumber = @cardNumber) AND (transactionDate = GETDATE() - 7)

this is the code i am using then

Show2 show2 = new Show2();

        public Form3()
        {
            InitializeComponent();
        }


        private void Form3_Load(object sender, EventArgs e)
        {
            logTableAdapter1.Fill(boGDataSet1.Log, show2.cardNumber.ToString());
        }

This is not working as when i load the form it give me a blank datagrid and am not sure what i am doing wrong