or
<asp:Panel ID="pn1" runat="server" CssClass="popup" Width="1200px" Style="display: none;"> <div class="body"><telerik:RadComboBox runat="server" ID="RadComboBox1" ZIndex="10000000" HighlightTemplatedItems="true">
<Items>
<telerik:RadComboBoxItem Text="One" Value="One" />
<telerik:RadComboBoxItem Text="Two" Value="Two" />
<telerik:RadComboBoxItem Text="Three" Value="Three" />
</Items>
<ItemTemplate>
<asp:CheckBox runat="server" ID="CheckBox" onclick="stopPropagation(event);" Text="" />
<%
# DataBinder.Eval(Container, "Text") %> </ItemTemplate> </telerik:RadComboBox> </div> </asp:Panel>
Thanks.
| protected void Page_Load(object sender, EventArgs e) |
| { |
| if (! IsPostBack) |
| { |
| string id = "dc945a82-d738-df11-b155-080027bfbfb8"; |
| LlenaGrid(id); |
| this.GridCompromisoHeader.DataBind(); |
| } |
| } |
| private void LlenaGrid(string id) |
| { |
| SqlDataAdapter ADA = new SqlDataAdapter(); |
| StringBuilder sSql = new StringBuilder(); |
| sSql.Append(" SELECT CAMPO1 'CAMPO1', "); |
| sSql.Append(" CAMPO2 'CAMPO2'"); |
| sSql.Append(" FROM TABLA"); |
| sSql.Append(" WHERE"); |
| sSql.Append(" LLAVE = @id"); |
| SqlCommand sqlcmd = new SqlCommand(sSql.ToString()); |
| SqlParameter sqlParam = new SqlParameter("@id", SqlDbType.NVarChar); |
| sqlParam.Value=id; |
| sqlcmd.Parameters.Add(sqlParam); |
| ADA.SelectCommand = sqlcmd; |
| this.GridCompromisoHeader.DataSource = ObtenerDataTable(ADA); |
| } |
| static DataTable ObtenerDataTable(SqlDataAdapter sqlAda) |
| { |
| SqlConnection sqlCnn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyCnnStr"].ConnectionString); |
| DataTable dt = new DataTable(); |
| try |
| { |
| sqlAda.SelectCommand.Connection = sqlCnn; |
| sqlCnn.Open(); |
| sqlAda.Fill(dt); |
| sqlCnn.Close(); |
| } |
| catch (Exception ex) |
| { |
| if (sqlCnn.State == ConnectionState.Open) |
| { |
| sqlCnn.Close(); |
| } |
| } |
| return dt; |
| } |
| protected void GridCompromisoHeader_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e) |
| { |
| GridDataItem dataItem = ((GridDataItem)(e.DetailTableView.ParentItem)); |
| SqlDataAdapter ADA = new SqlDataAdapter(); |
| StringBuilder sSql = new StringBuilder(); |
| sSql.Append(" SELECT CAMPO1 "); |
| sSql.Append(" FROM TABLA2"); |
| sSql.Append(" WHERE"); |
| sSql.Append(" LLAVE2 = @id"); |
| SqlCommand sqlcmd = new SqlCommand(sSql.ToString()); |
| SqlParameter sqlParam = new SqlParameter("@id", SqlDbType.NVarChar); |
| sqlParam.Value = dataItem["CAMPO1"].Text; |
| sqlcmd.Parameters.Add(sqlParam); |
| ADA.SelectCommand = sqlcmd; |
| try |
| { |
| e.DetailTableView.DataSource = ObtenerDataTable(ADA); |
| } |
| catch (System.Exception ex) |
| { |
| } |
| } |
| DataRowView dataItem = (DataRowView)commandEventArgs.Item.DataItem; |
| int _value= Convert.ToInt32(dataItem.Row["valueToRetrieve"]); |
| dataItem.Row[NUMBER] = GetDisplay(value); |
