By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,650 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,650 IT Pros & Developers. It's quick & easy.

TSQL select for populate datagridview

P: n/a
Hello everyone,

I'm programming in VB.NET 2005 and I habe not much experience with database
programming. I'm in search for some sql for the following :

I have 3 database tables: Movies, Theaters and a MovieProgram. Now I'm
looking for some TSQL (SQL SERVER 2005) that can do the following:

In a combobox a select a movie and the sql will serve to populate a
datagridview with all the theaters that are linked true the programma-table
where that movies play; on the other hand if a select an theater in a
combobox I want to fill a datagridview with all the movies that are playing
in that theater.

Thanks in advance,

Benny
Feb 25 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.