[RESOLVED] [2005] Tableadapter SQL select command - Command text query

[Stuw]

Is it possible to change a Tableadapter's SQL Command text property using code?

Im filling my datagridview with data as below. But i want to put in a where clause in my sql statement using a variable

i.e - SELECT * FROM Faults WHERE Callnumber = ('" + callopen + "')"

Try
            Me.FaultsTableAdapter1.usercall(Me.Database1DataSet1.Faults)
        Catch ex As System.Exception
            System.Windows.Forms.MessageBox.Show(ex.Message)
        End Try
    End Sub

Any ideas?