You don’t need this for the example we’re working on, so you can select it and delete it from the design. The combo box will be created and at the same time a Binding Navigator will be added to the form. Next, drag the Names data set from the Data Sources window and drop it on the surface of the form. When you click OK to confirm and close the dialog, the ComboBox display option will have been added to the choices in the Data Sources window: But because the request was specifically for a combo box, I’ll show you how to make this change.Ĭlick on the Customize… menu item and then select ComboBox from the Associated Controls options that appear in the dialog box that appears next: I really should have thought that through!).īy default, table data will be displayed in a DataGridView and most times you’d be happy to use this.
The Data Source will now be available to the project:Ĭlick on the small down arrow to the right of the data table name (which I’ve rather unhelpfully named ‘Names’. Note that I ticked the Tables checkbox in the previous step. When you select Add New Data Source in the Data Sources window, you’ll see a wizard that guides you through the steps: If you can’t see the Data Sources window in Visual Studio, you can make it visible by selecting Show Data Sources from the Data tab in the main VS menu: You can see the structure of this database as shown here in SQL Server Management Studio.įirst of all, I need to create a new data source for the project. So, I have a simple two-column database named ‘Nicknames’. The CodePlex example creates the data in code, but I thought it’d be more realistic to use an existing database although that will make the explanation a bit longer. As it happens, there’s an example of how to do this on CodePlex and I’ll quickly run through that here. I came across a question recently where the developer wanted to display two columns of data from a database in the dropdown list of a combo box.
0 kommentar(er)
