Hi . Just add following code to your application to Update data gridview on index changed event of drop down list.
void UpdateGrid()
{
using (SqlCeConnection c = new SqlCeConnection("ConnectionString"))
{
c.Open();
using (SqlCeDataAdapter a = new SqlCeDataAdapter("SELECT * FROM table WHERE empID="+EmpId, c))
{
DataTable t = new DataTable();
a.Fill(t);
dataGridView1.DataSource = t;
}
}
}
Kindly revert if you have any issues..