Dataset - Select Command Query

[thepalace1]

)Hi could anybody help me out here,

I have added a DataGridView bound to a MySql Database, Now the current DataSet bound to the DataGridView's Select Command is as follows

SELECT `note_id`, `date_column`, `time_column`, `type_column`, `regarding_column`, `attachment_column`, `record_manager`, `record_id` FROM `notes`

but i need to add a the following on to it:-

WHERE `record_id` = TextBox1.text

How can this be done, Do i need to create the dataset manually at run-time? or can it be added to the query in some way?

Thanks in advance..


David



UPDATE, I think I may have solved this myself, I added something called a Parameter to the Fill Query called @rec_num

then i changed this

 Me.NotesTableAdapter.Fill(Me.Note_DATASET.notes)

to this

 Me.NotesTableAdapter.Fill(Me.Note_DATASET.notes[B], rec_num.Text[/B])

Is this the correct way to have done it, because its working!!!!!!