26.11.txt

《Microsoft Visual C# .NET 2003开发技巧大全》源代码

Listing 26.11 Populating a DataGrid from a SQL Server CE Database
public Form1()
{
InitializeComponent();
sqlConnection = new SqlCeConnection(
@”Data Source=/My Documents/MusicCatalog.sdf;” );
string selectCmd = “SELECT * From Catalog”;
// create the adapter
sqlDataAdapter = new SqlCeDataAdapter();
// assign select command
sqlDataAdapter.SelectCommand = new SqlCeCommand(selectCmd, sqlConnection);
cmdBuilder = new SqlCeCommandBuilder( sqlDataAdapter );
// create dataset
catalogDataSet = new DataSet(“Catalog”);
// fill dataset
sqlDataAdapter.Fill(catalogDataSet, “Catalog” );
// databind datagrid
dataGrid1.DataSource = catalogDataSet.Tables[“Catalog”];
sqlConnection.Close();
}