Click here to Skip to main content
15,886,919 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Modifying XML Nodes Pin
Dave Kreskowiak17-Apr-08 3:00
mveDave Kreskowiak17-Apr-08 3:00 
QuestionServiceProcessInstaller account? Pin
AHeavey16-Apr-08 5:57
AHeavey16-Apr-08 5:57 
AnswerRe: ServiceProcessInstaller account? Pin
Dave Kreskowiak16-Apr-08 6:37
mveDave Kreskowiak16-Apr-08 6:37 
GeneralRe: ServiceProcessInstaller account? Pin
AHeavey16-Apr-08 6:39
AHeavey16-Apr-08 6:39 
Generalbound combobox... Pin
sabr4916-Apr-08 3:43
sabr4916-Apr-08 3:43 
GeneralRe: bound combobox... Pin
Dave Kreskowiak16-Apr-08 4:13
mveDave Kreskowiak16-Apr-08 4:13 
GeneralRe: bound combobox... Pin
sabr4916-Apr-08 4:54
sabr4916-Apr-08 4:54 
GeneralRe: bound combobox... Pin
Dave Kreskowiak16-Apr-08 8:24
mveDave Kreskowiak16-Apr-08 8:24 
OK, I duplicated the problem. Using the designer to do database work does NOT relinquish you from knowing how all this stuff works. IMHO, it actually makes it more difficult to understand.

First, delete all of the DataSet, TableAdapter and BindingSource objects from the form.

You'll need to set this up so there is a single DataSet object that contains both of your tables. In the DataSet Designer, make sure there is a one-to-many relationship between the two tables on their Website ID columns.

You also need a single BindingSource that has it's DataSource property set to the DataSet.

The ComboBox's DataSource property should be set to the BindingSource.tblWebSites table. It's DisplayMember property should then be set to the Site_Name field. At this point you should have a couple of new objects added automatically, a tblWebsites BindingSource and TableAdapter.

The DataGrid's DataSource property should be set to the new tblWebSites BindingSource.FK_tbl_WebSites_tblProducts. This is the foreign key relationship between the two tables.

That's it! It should be good to go.


A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008




Questionprinting form Pin
asha_s16-Apr-08 0:45
asha_s16-Apr-08 0:45 
GeneralRe: printing form Pin
Zaegra16-Apr-08 1:40
Zaegra16-Apr-08 1:40 
GeneralRe: printing form Pin
asha_s16-Apr-08 6:52
asha_s16-Apr-08 6:52 
GeneralRe: printing form Pin
Steven J Jowett16-Apr-08 4:08
Steven J Jowett16-Apr-08 4:08 
GeneralRe: printing form Pin
asha_s16-Apr-08 6:51
asha_s16-Apr-08 6:51 
GeneralRe: printing form Pin
Steven J Jowett16-Apr-08 12:16
Steven J Jowett16-Apr-08 12:16 
QuestionRe: printing form Pin
asha_s19-Apr-08 8:15
asha_s19-Apr-08 8:15 
GeneralRe: printing form Pin
Steven J Jowett20-Apr-08 11:12
Steven J Jowett20-Apr-08 11:12 
GeneralRe: printing form Pin
asha_s21-Apr-08 0:39
asha_s21-Apr-08 0:39 
GeneralPrinting Problem² [modified] Pin
Zaegra16-Apr-08 0:14
Zaegra16-Apr-08 0:14 
GeneralRe: Printing Problem² Pin
Chinners16-Apr-08 0:55
Chinners16-Apr-08 0:55 
GeneralRe: Printing Problem² Pin
Zaegra16-Apr-08 1:37
Zaegra16-Apr-08 1:37 
QuestionCapture screen as movie Pin
Mohammad Al Hoss15-Apr-08 22:29
Mohammad Al Hoss15-Apr-08 22:29 
GeneralRe: Capture screen as movie Pin
Dave Kreskowiak16-Apr-08 4:04
mveDave Kreskowiak16-Apr-08 4:04 
QuestionHow manage scroll position in listview without using API function. Pin
Coban_15-Apr-08 21:43
Coban_15-Apr-08 21:43 
AnswerRe: How manage scroll position in listview without using API function. Pin
Dave Kreskowiak16-Apr-08 3:59
mveDave Kreskowiak16-Apr-08 3:59 
GeneralRe: How manage scroll position in listview without using API function. Pin
Coban_16-Apr-08 4:42
Coban_16-Apr-08 4:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.