[Solved] Select Query

[Tony]

Hi,

  Since I am using MS Access 2007, I cannot use the AccessDataSource control 
(It won't recognize 2007 databases—Odd!), so I have to write the data 
connection to select the record(s) that I want to bind to the radgrid.   I can't find any help with writing  the  select command (I think 
it should be like this:  "SELECT [ScheduledDay], [Date], [Campus], [Room], 
[Seats] FROM [Schedule1] WHERE ([SessionID] = ?)"  However, I am not sure how 
to bind the query to a textbox.  Can anyone explain to me the coding for 
Visual Basic?  I am assuming that I have to set up some parameter command, 
but I can't find any examples that I can learn from.

Thanks,
Anthony

[Shinu]

Hi Tony,

Go through the following help articles.

Simple Data-binding
Advanced Databinding (using NeedDataSource event)

Shinu.