Problem with MS Access database...

[SkyDriver]

Welcome to the forum

Thanks

Your query is incorrect. You are giving a Where condition but you are not providing any value for the ID column. You should correct your query, something like this would return all records

string queryString = "SELECT ID, Name, LastName, Nick, MobileNumber, MobileNumber2, e-Mail, e-Mail2, Type FROM Table1";

Same message error (No value given for one or more required parameters)...

I have empty DataGridView... and when I start the aplication only the DataGridView to fullfill with the suitable base of...

// Code for load dataGridView...

string queryString = "SELECT ID, Name, LastName, Nick, MobileNumber, MobileNumber2, e-Mail, e-Mail2, Type FROM Table1";
                loadDataGrid(queryString);

...

// Code for dataGridView properties...

public void loadDataGrid(string sqlQueryString)
        {

            OleDbCommand SQLQuery = new OleDbCommand();
            DataTable data = null;
            dataGridView1.DataSource = null;
            SQLQuery.Connection = null;
            OleDbDataAdapter dataAdapter = null;
            dataGridView1.Columns.Clear();
            //---------------------------------
            SQLQuery.CommandText = sqlQueryString;
            SQLQuery.Connection = database;
            data = new DataTable();
            dataAdapter = new OleDbDataAdapter(SQLQuery);
            dataAdapter.Fill(data);
            dataGridView1.DataSource = data;
            dataGridView1.AllowUserToAddRows = false;
            dataGridView1.ReadOnly = true;
            dataGridView1.Columns[0].Visible = false;

            dataGridView1.Columns[1].Width = 90;
            dataGridView1.Columns[1].HeaderText = "Name";

            dataGridView1.Columns[2].Width = 110;
            dataGridView1.Columns[2].HeaderText = "Last Name";

            dataGridView1.Columns[3].Width = 60;
            dataGridView1.Columns[3].HeaderText = "Nick";

            dataGridView1.Columns[4].Width = 80;
            dataGridView1.Columns[4].HeaderText = "Mobile Number";

            dataGridView1.Columns[5].Width = 80;
            dataGridView1.Columns[5].HeaderText = "Mobile Number2";

            dataGridView1.Columns[6].Width = 90;
            dataGridView1.Columns[6].HeaderText = "e-Mail";

            dataGridView1.Columns[7].Width = 90;
            dataGridView1.Columns[7].HeaderText = "e-Mail2";

            // insert edit button into datagridview
            editButton = new DataGridViewButtonColumn();
            editButton.HeaderText = "Edit";
            editButton.Text = "Edit";
            editButton.UseColumnTextForButtonValue = true;
            editButton.Width = 80;
            dataGridView1.Columns.Add(editButton);

            // insert delete button to datagridview
            deleteButton = new DataGridViewButtonColumn();
            deleteButton.HeaderText = "Delete";
            deleteButton.Text = "Delete";
            deleteButton.UseColumnTextForButtonValue = true;
            deleteButton.Width = 80;
            dataGridView1.Columns.Add(deleteButton);
        }

I don't know where I wrong... :/