472,141 Members | 1,088 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,141 software developers and data experts.

TSQL select for populate datagridview

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,

Feb 25 '07 #1
0 1263

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by David Lozzi | last post: by
8 posts views Thread by David Lozzi | last post: by
1 post views Thread by =?Utf-8?B?SmVzcGVyLCBEZW5tYXJr?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.