Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tyecom
Starting Member
12 Posts |
 Posted - 2009-02-26 : 11:17:27
|
| Hi,I am creating a simple movie database that will allow me to search for movies. I'm using SQL Server 2005 and VB.Net. On my form I have a ComboBox and a TextBox. The ComboBox is populated with the Movie Titles and the TextBox "should be" populated with the corresponding MovieID number. I've been trying to figure out how to do this, but is having problems figuring it out. Any help would be appreciated. Thank in advance. |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-02-26 : 14:07:41
|
| Are you asking for the T-SQL code or the VB Code? Are you asking how you should design the tables?Jim |
 |
|
|
Tyecom
Starting Member
12 Posts |
Posted - 2009-02-26 : 15:08:54
|
| I believe the table are alright. I guess since the application is in VB.Net, I guess I looking for the VB Code. If SQL is involved, can you please supply that too. I've been at this a long time and is pretty much burned out. I know I probably have to bind the control, but can't get them to act as I want them to. Thanks in advance. |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-02-26 : 17:31:29
|
| This is a MS SQL Server forum, you'll have to try another a forum for your vb questions. If you provide us with your table structures and sample data, and what you want back, we can help you with the sql code. Jim |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2009-02-26 : 21:49:38
|
| Assuming that you have the database and tables set up to your satisfaction and assuming that what you really need is help with the VB code, as jimf suggested, you might get better responses in a VB.Net forum.That said, what you want to look for is "simple data binding" (as opposed to complex data binding, which is useful when you have a data grid view). Google for vb.net + simple data binding and you will find several walk-throughs and tutorials. |
|
|
|
|
|
|
|
|
Populating a Textbox?