databind in gridview

string query = "your query";
SqlCommand cmd = new SqlCommand(query, conn); //conn is your SqlConnection
DataTable results = new DataTable();
 
 try
            {
 
                SqlDataAdapter adapter = new SqlDataAdapter(command);
 
                adapter.Fill(results);
            }
catch (Exception ex)
            {
              //handle the error message here
            }
 

GridView.DataSource=results;
GridView.DataBind();