how can i add data to a datagridview cell from a SQL client database file(mdf file)
is the below code correct, it dosen't work , why is it???

C# Syntax

            String query = @"Select FirstName from Emplooyee";
            SqlCommand command = new SqlCommand(query,DB.getConnection());

            SqlDataAdapter adapter = new SqlDataAdapter();
            DataTable dt = new DataTable();

            dgvPAction.Rows[0].Cells[1].Value = adapter.Fill(dt).ToString();

simple glance I see

SqlDataAdapter adapter = new SqlDataAdapter();

you need to declare it as something?

I presume as you you want to so this:

SqlDataAdapter adapter = new SqlDataAdapter(command);