Aug 20, 2012, 5:42 PM
[CLOSED] DataBind as Distinct in ComboBox
Hi, I want that when I make a DataBind with a SqlDataSource and Store (It's the same with DataGrid) with a ComboBox they can to make a distinct as sql, I want to don't repeat of data equals, I attachment my code and image:
It is my gridoanel with my column "Categoria":
It is the same column but the combobox with databind the same store:
It is a part of my code:
It is my gridoanel with my column "Categoria":
It is the same column but the combobox with databind the same store:
It is a part of my code:
<asp:SqlDataSource
ID="sqldsCxPPorTipo"
runat="server"
ConnectionString="<%$ ConnectionStrings:SmartSystems %>"
ProviderName="System.Data.SqlClient"
SelectCommand="web_spS_ObtenerCxPPorTipoTotal"
SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
<ext:GridPanel
ID="gpCxPPorTipo"
runat="server"
Height="410"
Width="930"
Title="CxP por tipo"
Frame="true"
Icon="ApplicationViewColumns"
ColumnLines="true"
EnableColumnHide="false"
EnableColumnMove="false"
EnableColumnResize="false"
RowLines="true"
TitleAlign="Left">
<Store>
<ext:Store ID="Store1" runat="server" DataSourceID="sqldsCxPPorTipo" GroupField="Tipo">
<Model>
<ext:Model ID="Model1" runat="server">
<Fields>
<ext:ModelField Name="Empresa" />
<ext:ModelField Name="Proveedor" />
<ext:ModelField Name="Tipo" />
<ext:ModelField Name="Moneda" />
<ext:ModelField Name="Saldo" Type="Float" />
<ext:ModelField Name="Nombre" />
<ext:ModelField Name="NombreCorto" />
<ext:ModelField Name="Categoria" />
<ext:ModelField Name="Familia" />
<ext:ModelField Name="Estatus" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<ColumnModel>
<Columns>
<ext:Column
ID="gpCxPPorTipocTipo"
runat="server"
Text="Tipo"
DataIndex="Tipo"
TdCls="task">
</ext:Column>
<ext:SummaryColumn
ID="gpCxPPorTipocProveedor"
runat="server"
Text="Tipo"
DataIndex="Proveedor"
Width="150"
SummaryType="Count">
<HeaderItems>
<ext:ComboBox
ID="cmbTipo"
runat="server"
DisplayField="Tipo"
ValueField="Tipo">
<Store>
<ext:Store ID="sTipo" runat="server" DataSourceID="sqldsCxPPorTipo">
<Model>
<ext:Model ID="Model2" runat="server">
<Fields>
<ext:ModelField Name="Tipo" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
</ext:ComboBox>
</HeaderItems>
<SummaryRenderer Handler="return ((value === 0 || value > 1) ? '(' + value + ' Registros)' : '(1 Registro)');" />
</ext:SummaryColumn>
<ext:Column
ID="gpCxPPorTipocNombre"
runat="server"
Text="Nombre"
DataIndex="Nombre"
Width="350">
<HeaderItems>
<ext:ComboBox
ID="ComboBox1"
runat="server"
DisplayField="Familia"
ValueField="Familia">
<Store>
<ext:Store ID="Store4" runat="server" DataSourceID="sqldsCxPPorTipo">
<Model>
<ext:Model ID="Model6" runat="server">
<Fields>
<ext:ModelField Name="Familia" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
</ext:ComboBox>
</HeaderItems>
</ext:Column>
<ext:Column
ID="gpCxPPorTipocMoneda"
runat="server"
Text="Moneda"
DataIndex="Moneda"
Width="100">
<HeaderItems>
<ext:ComboBox
ID="cmbMoneda"
runat="server"
DisplayField="Moneda"
ValueField="Moneda">
<Store>
<ext:Store ID="Store3" runat="server" DataSourceID="sqldsCxPPorTipo">
<Model>
<ext:Model ID="Model5" runat="server">
<Fields>
<ext:ModelField Name="Moneda" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
</ext:ComboBox>
</HeaderItems>
</ext:Column>
<ext:SummaryColumn
ID="gpCxPPorTiposmSaldo"
runat="server"
Text="Saldo"
DataIndex="Saldo"
Width="100"
SummaryType="Sum">
<Renderer Format="UsMoney" />
<SummaryRenderer Fn="Ext.util.Format.usMoney" />
</ext:SummaryColumn>
<ext:Column
ID="gpCxPPorTipocCategoria"
runat="server"
Text="Categoria"
DataIndex="Categoria"
Width="100">
<HeaderItems>
<ext:ComboBox
ID="cmbCategoria"
runat="server"
DisplayField="Categoria"
ValueField="Categoria">
<Store>
<ext:Store ID="sCategoria" runat="server" DataSourceID="sqldsCxPPorTipo">
<Model>
<ext:Model ID="Model3" runat="server">
<Fields>
<ext:ModelField Name="Categoria" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
</ext:ComboBox>
</HeaderItems>
</ext:Column>
<ext:Column
ID="gpCxPPorTipocFamilia"
runat="server"
Text="Familia"
DataIndex="Familia"
Width="100">
<HeaderItems>
<ext:ComboBox
ID="cmbFamilia"
runat="server"
DisplayField="Familia"
ValueField="Familia">
<Store>
<ext:Store ID="Store2" runat="server" DataSourceID="sqldsCxPPorTipo">
<Model>
<ext:Model ID="Model4" runat="server">
<Fields>
<ext:ModelField Name="Familia" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
</ext:ComboBox>
</HeaderItems>
</ext:Column>
</Columns>
</ColumnModel>
<View>
<ext:GridView ID="GridView1" runat="server">
<Listeners>
<Refresh Handler="updateTotal(this.panel, #{Container1});" />
</Listeners>
</ext:GridView>
</View>
<Features>
<ext:GroupingSummary ID="Group1" runat="server" GroupHeaderTplString="{name}" HideGroupedHeader="true" EnableGroupingMenu="false" StartCollapsed="false">
</ext:GroupingSummary>
</Features>
<DockedItems>
<ext:Container ID="Container1" runat="server" Layout="HBoxLayout" Dock="Bottom" StyleSpec="margin-top:2px;">
<Items>
<ext:DisplayField ID="DisplayField2" runat="server" Name="Proveedor" Cls="total-field-blank" Text="" />
<ext:DisplayField ID="DisplayField3" runat="server" Name="Moneda" Cls="total-field-blank" Text="" />
<ext:DisplayField ID="DisplayField4" runat="server" Name="Saldo" Cls="total-field" Text="-" />
<ext:DisplayField ID="DisplayField6" runat="server" Name="Nombre" Cls="total-field-blank" Text="" />
<ext:DisplayField ID="DisplayField8" runat="server" Name="Categoria" Cls="total-field-blank" Text="" />
<ext:DisplayField ID="DisplayField9" runat="server" Name="Familia" Cls="total-field-blank" Text="" />
</Items>
</ext:Container>
</DockedItems>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
</SelectionModel>
</ext:GridPanel>
Last edited by Daniil; Aug 26, 2012 at 10:03 AM.
Reason: [CLOSED]