C# dataGridView doesn't display table components?

[Arnold Agolli]

hello!
i tried to create a database program in c# in windows forms and i put a datagridview to the form!

than on form_load i put this code:

String strConnect = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\********\Desktop\Numeratori.mdb";
SqlConnection objConnect = new SqlConnection(strConnect);

String strQuery = "SELECT * FROM tabela";
SqlCommand objCommand = new SqlCommand(strQuery, objConnect);
SqlDataAdapter objDataAdapter = new SqlDataAdapter(objCommand);

DataTable objDataTable = new DataTable();
objDataAdapter.Fill(objDataTable);
objConnect.Close();

dataGridView1.DataSource = objDataTable;

i dont have any problem with the naming! i also tried it to make the connection with the ide but still doesnt display the information in the table!

thank you! :D

[Aimee Bailey]

I don't believe SqlConnection supports MS Access database files, you could instead use the OdbcConnection, OdbcCommand and OdbcDataAdapter found in Microsoft.Data. This should do the trick.

Aimee.