private string GetViewSelectCommand() { List <string> columns = new List <string>(); //System.Data.Common.DbConnection con = ConnectionManager.Connection; foreach (ColumnInfo ci in TableInfo.Columns) { if (ci.IsPrimaryKey) { uxGrid.MasterTableView.DataKeyNames = new string[] { ci.Title != "" ? ci.Title : ci.ColumnName }; } ForeignKeyRelation fk = ci.ForeignKeyRelation; if (fk != null) { TableInfo ti = SchemaUtility.GetTable(fk.PKTable); string nameColumn = ti.GetNameColumn().ColumnName; columns.Add("( Select [" + nameColumn + "] From " + fk.PKTable + " Where " + fk.PKTable + ".[" + fk.PKField + "] = " + TableName + ".[" + fk.FKField + "] ) "); break; } else { columns.Add(ci.ColumnName + " as [" + ci.Title + "]");//+ " as [" + ci.Title + "]"); } } return("select " + string.Join(",", columns.ToArray()) + " from " + TableName); }