Он показывает только столбцы, но данные не появляются...? Пожалуйста, помогите мне в этом

---

public partial class Window_search : Window
    {
        public Window_search()
        {
            InitializeComponent();
        }

        private void Search_button_Click_1(object sender, RoutedEventArgs e)
        {
            var id = Device_id_TextBox.ToString(); 
            MySqlConnection con = new MySqlConnection("database");
            con.Open();
            DataTable devicetable = new DataTable();
            MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT `Device_ID`, `Device_Name`, `Devic_Category`, `Status`, `Description`, `Customer_ID`, `Customer_Name` FROM `devicedetails` WHERE `Device_ID` = 'id'",con);

            try
            {
                
                adapter.Fill(devicetable);
                table_grid_view.DataContext = devicetable;
                con.Close();
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
            }
      

        }

        
    }

<pre lang="c#"><pre lang="c#">

Что я уже пробовал:

public partial class Window_search : Window
    {
        public Window_search()
        {
            InitializeComponent();
        }

        private void Search_button_Click_1(object sender, RoutedEventArgs e)
        {
            var id = Device_id_TextBox.ToString(); 
            MySqlConnection con = new MySqlConnection("database");
            con.Open();
            DataTable devicetable = new DataTable();
            MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT `Device_ID`, `Device_Name`, `Devic_Category`, `Status`, `Description`, `Customer_ID`, `Customer_Name` FROM `devicedetails` WHERE `Device_ID` = 'id'",con);

            try
            {
                
                adapter.Fill(devicetable);
                table_grid_view.DataContext = devicetable;
                con.Close();
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
            }
      

        }

        
    }

---