devexpress gridcontrol 显示数据库查询结果

通过按钮实现 查询结果显示到gridControl,显示空白

 private void uiButton1_Click_1(object sender, EventArgs e)
        {
            string ce = uiTextBox2.Text.Trim();
            StringBuilder sql = new StringBuilder();
            string shi = uiDatetimePicker1.Value.ToString("yyyyMMdd");
            string s = uiDatetimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss");
            string j = uiDatetimePicker2.Value.ToString("yyyy-MM-dd HH:mm:ss");
            

            sql.Append("SELECT k.UniqueID AS 唯一编码,dr.AddrName AS 地址, d.StatusID AS 状态,d.DataFlag AS 值,d.iotime  AS 时间 ");
            sql.Append(" FROM KJ90X.dbo.DeviceModifyDetail AS k LEFT JOIN KJ90Detail.dbo.DetailRealData"+shi+" AS d ON d.UniqueID = k.UniqueID LEFT JOIN KJ90X.dbo.Address AS dr ON dr.AddrID = k.AddrID ");
            sql.Append(" WHERE k.DevLabel LIKE '%"+ ce + "%' AND(d.iotime <= '"+j+"' AND d.iotime >= '"+s+"')");
                string sqlStr = sql.ToString();
            SqlDataAdapter myDataAdapter;
            DataSet myDataSet = new DataSet();



            //Fill 方法会执行一系列操作 connection.open command.reader 等等
            //反正到最后就把 sql语句执行一遍,然后把结果集插入到 ds 里.

            myDataAdapter = new SqlDataAdapter(sqlStr, connstr);

            myDataAdapter.Fill(myDataSet, "sjk");
            var dt = myDataSet.Tables[0];
            foreach (DataRow row in dt.Rows)
            {
                byte[] value = smethod_10(row["值"].ToString());
                double num3 = BitConverter.ToDouble(value, 0);
                row["值"] = num3;
            }
            
            gridControl2.DataSource = myDataSet.Tables["sjk"];

        }

前端控件里面要做显示字段的映射配置