I create a small sdf database and put it into project folder.
Trying to bind a DataGridView with that database, I wrote:
. . .
string connString = "Provider=.NET Framework Data Provider for Microsoft SQL Server Compact 3.5;Data Source=|DataDirectory|\db01.sdf";
string query = "SELECT * FROM table01";
SqlDataAdapter dA = new SqlDataAdapter(query, connString);
SqlCommandBuilder cBuilder = new SqlCommandBuilder(dA);
DataTable dT = new DataTable();
BindingSource bS = new BindingSource();
bS.DataSource = dT;
dgv01.DataSource = bS;
Error: Keyword not supported: 'provider'.
Could someone explain, what is wrong, please.