<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>ReadMe</title>
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Originator" content="Microsoft Visual Studio.NET 7.0">
</head>
<body>
<h1>
Data Access: Bind Data to a ComboBox</h1>
<P>
This sample shows some how to bind data to a combo box
control .
</P>
<P>
<h2>Featured Highlights:</h2>
<P>The code demonstrates how to bind data to a combo box from a variety of
different data sources. Data is bound from an array, array list, datatable and
dataview. When the main form loads, the products table from the Northwind
database is retrieved into a dataset using a simple SQL Select
statement. A dataview which provides a sorted view of the
ProductName column is also created at this time. The user can then
populate the combo box control by binding to another array of colors,
an array list of shapes, an advanced array list containing sales divisions
defined with a structure, the products table residing in the dataset, or the
sorted dataview. If the user binds to the dataset, dataview or the advanced
array list of sales divisions, when an entry is selected from the combo box, an
associated value for that entry is also displayed.</P>
<h2>Requirements:</h2>
<UL>
<LI>
Trial or Release version of Visual Studio .NET Professional (or greater).
<LI>
Access to the Northwind database residing in SQL Server or the Microsoft Data
Engine (MSDE). To install MSDE, do the following:
<UL>
<LI>
<DIV align="left">Open the Start menu, then click Programs, the click Microsoft
.NET Framework SDK, and then click Samples and Quickstart Tutorials.
</DIV>
<LI>
<DIV align="left">Click "Step 1: Install the .NET Framework Samples Database".</DIV>
<LI>
<DIV align="left">Open a command window, and CD to
<FRAMEWORKSDK>
\Samples\Setup This is typically : C:\Program Files\Microsoft Visual Studio
.NET\FrameworkSDK\Samples\Setup</DIV>
<LI>
<DIV align="left">Type: osql -E -S (local)\NetSDK -i InstNwnd.sql</DIV>
</LI>
</UL>
</LI>
</UL>
<H2>Running the Sample</H2>
<P>Simply press <b>F5</b>.</P>
<OL>
<LI>
The advanced array list, dataset and dataview binding displays one set of
values, but also associates a corresponding values that are available when an
entry is selected. For example if the user selects the product entry Chai
from products table bound to the combo box, Chai is displayed as the
selected entry, but its associated ProductId is also available
through the selectedValue property. The ValueMember propery of the combo box
allows an alternate value to be made available.
<LI>
When the datasource property is used to bind data to a combo box, the sorted
property is unavailable to ensure that the data is displayed in sorted order.
The data source itself must be sorted.</LI>
</OL>
<H3>See Also:</H3>
<P><A href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskdatabindingcomboboxcheckedlistboxorlistboxcontrol.asp">Data
Binding a Windows Forms ComboBox, ListBox, or CheckedListBox Control</A>,
<A href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconprovidersofdatatowindowsforms.asp">
Providers of Data to Windows Forms</A>, <A href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpqstart/html/cpsmpnetsamples-windowsformsdatabinding.asp">
ComboBox Binding Sample ,</A> <A href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWindowsFormsComboBoxClassTopic.asp">
ComboBox Class</A>
</P>
<UL>
</UL>
</body>
</html>
c#数据库操作实例适合初学者 （131个子文件） 
Global.asax 82B UseDataRel.aspx 3KB UseDataComp.aspx 3KB DataGridEditUpdate.aspx 3KB UseDataComp2.aspx 2KB NonDataComp.aspx 1KB UseDataReader.aspx 1KB UseDataReader2.aspx 675B deptodoc.btr 324B doctodep.btr 324B service.cnf 1KB access.cnf 112B services.cnf 3B Web.config 3KB frmMain.cs 103KB frmMain.cs 66KB frmMain.cs 64KB dsCustomerOrder.cs 53KB UseDataRel.aspx.cs 37KB CustomersDataSet.cs 25KB dsStore.cs 19KB frmMain.cs 18KB UseDataComp2.aspx.cs 10KB DataGridEditUpdate.aspx.cs 10KB UseDataComp.aspx.cs 10KB frmAbout.cs 7KB frmAbout.cs 7KB frmAbout.cs 7KB frmAbout.cs 7KB frmStatus.cs 5KB AssemblyInfo.cs 3KB AssemblyInfo.cs 3KB AssemblyInfo.cs 3KB AssemblyInfo.cs 3KB frmStatus.cs 3KB frmStatus.cs 2KB frmStatus.cs 2KB AssemblyInfo.cs 2KB UseDataReader2.aspx.cs 2KB UseDataReader.aspx.cs 2KB NonDataComp.aspx.cs 2KB Global.asax.cs 1KB DevConADO.csproj 11KB How-To Create An Offline Application.csproj 6KB How-To Build a Master-Details Windows Forms App.csproj 5KB How-To Use Custom DataBinding Format Handlers.csproj 5KB How-To Bind Data to a ComboBox.csproj 5KB DevCon200209ADO.dll 112KB CustomersDataSet.cs.dll 16KB
How-To Use Custom DataBinding Format Handlers.exe 148KB How-To Use Custom DataBinding Format Handlers.exe 148KB How-To Build a Master-Details Windows Forms App.exe 124KB How-To Build a Master-Details Windows Forms App.exe 124KB How-To Bind Data to a ComboBox.exe 36KB How-To Bind Data to a ComboBox.exe 36KB ReadMe.htm 4KB ReadMe.htm 3KB ReadMe.htm 3KB ReadMe.htm 2KB service.lck 0B How-To Build a Master-Details Windows Forms App.sln.lnk 1KB DevCon200209ADO.pdb 266KB How-To Create An Offline Application.pdb 88KB How-To Create An Offline Application.pdb 88KB How-To Build a Master-Details Windows Forms App.pdb 50KB How-To Build a Master-Details Windows Forms App.pdb 50KB How-To Use Custom DataBinding Format Handlers.pdb 48KB How-To Use Custom DataBinding Format Handlers.pdb 48KB How-To Bind Data to a ComboBox.pdb 36KB How-To Bind Data to a ComboBox.pdb 36KB How-To Create An Offline Application.projdata 33KB How-To Build a Master-Details Windows Forms App.projdata 21KB How-To Use Custom DataBinding Format Handlers.projdata 21KB How-To Bind Data to a ComboBox.projdata 13KB frmMain.resources 130KB frmMain.resources 74KB frmMain.resources 65KB frmStatus.resources 9KB frmMain.resources 5KB frmAbout.resources 2KB frmAbout.resources 2KB frmAbout.resources 2KB frmAbout.resources 2KB frmStatus.resources 651B frmStatus.resources 651B frmStatus.resources 651B frmMain.resx 156KB frmMain.resx 90KB frmMain.resx 79KB frmStatus.resx 13KB UseDataRel.aspx.resx 13KB frmMain.resx 10KB UseDataComp.aspx.resx 9KB UseDataComp2.aspx.resx 9KB DataGridEditUpdate.aspx.resx 9KB frmAbout.resx 7KB frmAbout.resx 7KB frmAbout.resx 7KB frmAbout.resx 7KB UseDataReader.aspx.resx 6KB共 131 条
- 1
- 2
资源评论
zl2001b2011-11-08讲解的比较明确易懂。不错的入门资料。
