or
<MasterTableView DataKeyNames="ID" DataSourceID="sqlBidDetail" EditMode="InPlace" CommandItemDisplay="Top" HierarchyLoadMode="ServerBind"> <DetailTables> <telerik:GridTableView runat="server" AllowSorting="False" AutoGenerateColumns="True" DataKeyNames="DescriptionDetailID,BidDetailID" DataSourceID="sqlDescriptionDetail" EditMode="InPlace" CommandItemDisplay="Top" HierarchyLoadMode="ServerBind"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="tblDescriptionDetail.BidDetailID" MasterKeyField="ID" /> </ParentTableRelation> </DetailTables>
</MasterTableView>
and my 2 SQL data sources.
<asp:SqlDataSource ID="sqlBidDetail" runat="server" ConnectionString="<%$ ConnectionStrings:dbBidManager %>"
SelectCommand="SELECT tblBidDetail.ID, tblBidDetail.BidID, tblBidDetail.ULAID, tblBidDetail.ProductID FROM tblBidDetail" />
<asp:SqlDataSource ID="sqlDescriptionDetail" runat="server" ConnectionString="<%$ ConnectionStrings:dbBidManager %>"
SelectCommand="SELECT tblDescriptionDetail.DescriptionDetailID, tblDescriptionDetail.BidDetailID, tblDescriptionDetail.DescriptionTypeID FROM tblDescriptionDetail" />
There is a FK relationship between tblDescriptionDetail.BidDetailID and tblBidDetail.ID. Note though that
tblDescriptionDetail.DescriptionDetailID is the primary key in that table.
GridEditableItem item = e.Item as GridEditableItem;//this is within a loop for the columns and another loop for my custom objects (metaData)//set edit textbox max lengthitem[column.UniqueName].Enabled = true;TextBox txtbx = (TextBox)item[column.UniqueName].Controls[0];txtbx.MaxLength = metaData.MaxFieldLength;//set regular expression for validationRegularExpressionValidator regex = new RegularExpressionValidator();GridTextBoxColumnEditor editor = (GridTextBoxColumnEditor)item.EditManager.GetColumnEditor(column.UniqueName);TableCell cell = (TableCell)editor.TextBoxControl.Parent;editor.TextBoxControl.ID = "Validation" + column.UniqueName;regex.Display = ValidatorDisplay.Dynamic;regex.ControlToValidate = editor.TextBoxControl.ID;regex.ForeColor = System.Drawing.Color.Red;regex.ValidationExpression = @"^";//custom regex expression buildingregex.ValidationExpression = regex.ValidationExpression + @"$";cell.Controls.Add(regex);
//get selected rowGridEditableItem item = (GridEditableItem)e.Item;//get values from the rowHashtable newValues = new Hashtable();e.Item.OwnerTableView.ExtractValuesFromItem(newValues, item);RadComboBox1.DataSource = ds.Tables[0];RadComboBox1.DataTextField = "Text";RadComboBox1.DataValueField = "ID";RadComboBox1.DataBind();if (ds.Tables[1].Rows.Count > 0){ RadComboBox1.SelectedValue = ds.Tables[1].Rows[0]["ID"].ToString();}this works great when I want to run the script TestWbform1 on my radwindow
function Test2(arg0, arg1, arg2, arg3, arg4) { var oWnd = $find("<%=AssmntContentWindow.ClientID%>"); oWnd.get_contentFrame().contentWindow.TestWbform1(arg0, arg1, arg2, arg3, arg4);}
if I place the script in the masterpage of my radwindow, it no longer works. Can you tell me how to access it there?