SqlCommand sqlcomm = new SqlCommand(query, sqlconn);
        sqlconn.Open();
        SqlDataAdapter sdr = new SqlDataAdapter(sqlcomm);
        DataTable dt = new DataTable();
        sdr.Fill(dt);
        GridView1.DataSource = dt;
        sqlconn.Close();