Oct 25, 2010, 8:19 PM
combobox editor problem
hi to all
i have to tables one master and one detail table. they are connected to each other il_id=sehir_id columns. i have two sqldatasource and i cannot update or i can't see the problem. for your helps
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="grid.aspx.cs" Inherits="_Default" %>
<%@ Register assembly="Coolite.Ext.Web" namespace="Coolite.Ext.Web" tagprefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<ext:ScriptManager ID="ScriptManager1" runat="server" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:WebConnectionString %>"
DeleteCommand="DELETE FROM kisi WHERE (id = @id)" InsertCommand="INSERT INTO KUL_WEB
(ad, soyad, yas, il_id, dogum_tarihi)
VALUES
(@ad, @soyad, @yas, @il_id, @dogum_tarihi);
SELECT @newId = @@Identity;"
OnInserted="SqlDataSource1_Inserted" SelectCommand="SELECT kisi.id, kisi.ad, kisi.soyad, kisi.yas, kisi.dogum_tarihi, sehir.il_adi,sehir.sehir_id FROM kisi INNER JOIN
sehir ON kisi.il_id = sehir.sehir_id " UpdateCommand="UPDATE kisi SET
ad=@ad, soyad=@soyad, yas=@yas, il_id=@il_id, dogum_tarihi=@dogum_tarihi
WHERE (id = @id)">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ad" Type="String" />
<asp:Parameter Name="soyad" Type="String" />
<asp:Parameter Name="yas" Type="Int32" />
<asp:Parameter Name="il_id" Type="Int32" />
<asp:Parameter Name="dogum_tarihi" Type="DateTime" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ad" Type="String" />
<asp:Parameter Name="soyad" Type="String" />
<asp:Parameter Name="yas" Type="Int32" />
<asp:Parameter Name="il_id" Type="Int32" />
<asp:Parameter Name="dogum_tarihi" Type="DateTime" />
<asp:Parameter Direction="Output" Name="newId" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:WebConnectionString %>"
SelectCommand="SELECT * from sehir" >
</asp:SqlDataSource>
<ext:Store ID="Store1" runat="server" DataSourceID="SqlDataSource1"
OnAfterAjaxEvent="Store1_AfterAjaxEvent"
OnAfterRecordInserted="Store1_AfterRecordInserted"
OnBeforeAjaxEvent="Store1_BeforeAjaxEvent"
OnBeforeRecordInserted="Store1_BeforeRecordInserte d"
OnRefreshData="Store1_RefershData" UseIdConfirmation="true">
<Reader>
<ext:JsonReader ReaderID="id">
<Fields>
<ext:RecordField Name="ad" />
<ext:RecordField Name="soyad" />
<ext:RecordField Name="yas" />
<ext:RecordField Name="il_adi" />
<ext:RecordField Name="dogum_tarihi" />
<ext:RecordField Name="sehir_id" />
</Fields>
</ext:JsonReader>
</Reader>
<SortInfo Direction="ASC" Field="ad" />
<Listeners>
<LoadException Handler="Ext.Msg.alert('KULLANICILAR - Load failed', e.message || e )" />
<CommitFailed Handler="Ext.Msg.alert('KULLANICILAR - Commit failed', 'Reason: ' + msg)" />
<SaveException Handler="Ext.Msg.alert('KULLANICILAR - Save failed', e.message || e)" />
<CommitDone Handler="Ext.Msg.alert('KULLANICILAR - Commit', 'The data successfully saved');" />
</Listeners>
</ext:Store>
<ext:Store ID="StoreCombo" runat="server" DataSourceID="SqlDataSource2">
<Reader>
<ext:JsonReader ReaderID="id">
<Fields>
<ext:RecordField Name="sehir_id" />
<ext:RecordField Name="il_adi" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
<ext:ViewPort ID="ViewPort1" runat="server" >
<Body>
<ext:BorderLayout ID="BorderLayout1" runat="server">
<North MarginsSummary="5 5 5 5">
<ext:Panel ID="Panel1"
runat="server"
Title="Description"
Height="100"
BodyStyle="padding: 5px;"
Frame="true"
Icon="Information">
<Body>
ahanda bu bir demodur
</Body>
</ext:Panel>
</North>
<Center MarginsSummary="0 5 0 5">
<ext:Panel
ID="Panel2"
runat="server"
Height="300"
Header="false">
<Body>
<ext:FitLayout ID="FitLayout1" runat="server">
<ext:GridPanel
ID="GridPanel1"
runat="server"
Title="KULLANICILAR"
AutoExpandColumn="ad"
StoreID="Store1"
Border="false"
Icon="Lorry">
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ColumnID="id" DataIndex="ad" Header="Adı">
<Editor>
<ext:TextField ID="TextField1" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="soyad" Header="Soyadı">
<Editor>
<ext:TextField ID="TextField2" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="yas" Header="Yaşı">
<Editor>
<ext:TextField ID="TextField3" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="sehir_id" Header="İli" MenuDisabled="true" ColumnID="sehir_id">
<Editor>
<ext:ComboBox ID="cbDepartment" runat="server" Shadow="Drop"
ForceSelection="true" StoreID="StoreCombo" DisplayField="il_adi" ValueField="sehir_id">
</ext:ComboBox>
</Editor>
<Renderer Handler="return store.getById(value).get('il_adi')" />
</ext:Column>
<ext:Column DataIndex="dogum_tarihi" Header="Doğum Tarihi">
<Editor>
<ext:DateField ID="dateField1" runat="server" />
</Editor>
</ext:Column>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
</SelectionModel>
<BottomBar>
<ext:PagingToolBar ID="PagingToolBar1"
runat="server"
StoreID="Store1"
PageSize="10"
DisplayInfo="false"
/>
</BottomBar>
<SaveMask ShowMask="true" />
<LoadMask ShowMask="true" />
</ext:GridPanel>
</ext:FitLayout>
</Body>
<Buttons>
<ext:Button ID="btnSave" runat="server" Text="Save" Icon="Disk">
<Listeners>
<Click Handler="#{GridPanel1}.save();" />
</Listeners>
</ext:Button>
<ext:Button ID="btnDelete" runat="server" Text="Delete selected records" Icon="Delete">
<Listeners>
<Click Handler="#{GridPanel1}.deleteSelected();" />
</Listeners>
</ext:Button>
<ext:Button ID="btnInsert" runat="server" Text="Insert" Icon="Add">
<Listeners>
<Click Handler="#{GridPanel1}.insertRecord(0, {});#{GridPanel1}.getView().focusRow(0);#{GridPane l1}.startEditing(0, 0);" />
</Listeners>
</ext:Button>
<ext:Button ID="btnRefresh" runat="server" Text="Refresh" Icon="ArrowRefresh">
<Listeners>
<Click Handler="#{GridPanel1}.reload();" />
</Listeners>
</ext:Button>
<ext:Button ID="btnEmulError" runat="server" Text="Refresh with Emulated error" Icon="Exclamation">
<Listeners>
<Click Handler="#{GridPanel1}.reload({params:{EmulateErro r: 1}});" />
</Listeners>
</ext:Button>
</Buttons>
</ext:Panel>
</Center>
</ext:BorderLayout>
</Body>
</ext:ViewPort>
</div>
</form>
</body>
</html>
i have to tables one master and one detail table. they are connected to each other il_id=sehir_id columns. i have two sqldatasource and i cannot update or i can't see the problem. for your helps
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="grid.aspx.cs" Inherits="_Default" %>
<%@ Register assembly="Coolite.Ext.Web" namespace="Coolite.Ext.Web" tagprefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<ext:ScriptManager ID="ScriptManager1" runat="server" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:WebConnectionString %>"
DeleteCommand="DELETE FROM kisi WHERE (id = @id)" InsertCommand="INSERT INTO KUL_WEB
(ad, soyad, yas, il_id, dogum_tarihi)
VALUES
(@ad, @soyad, @yas, @il_id, @dogum_tarihi);
SELECT @newId = @@Identity;"
OnInserted="SqlDataSource1_Inserted" SelectCommand="SELECT kisi.id, kisi.ad, kisi.soyad, kisi.yas, kisi.dogum_tarihi, sehir.il_adi,sehir.sehir_id FROM kisi INNER JOIN
sehir ON kisi.il_id = sehir.sehir_id " UpdateCommand="UPDATE kisi SET
ad=@ad, soyad=@soyad, yas=@yas, il_id=@il_id, dogum_tarihi=@dogum_tarihi
WHERE (id = @id)">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ad" Type="String" />
<asp:Parameter Name="soyad" Type="String" />
<asp:Parameter Name="yas" Type="Int32" />
<asp:Parameter Name="il_id" Type="Int32" />
<asp:Parameter Name="dogum_tarihi" Type="DateTime" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ad" Type="String" />
<asp:Parameter Name="soyad" Type="String" />
<asp:Parameter Name="yas" Type="Int32" />
<asp:Parameter Name="il_id" Type="Int32" />
<asp:Parameter Name="dogum_tarihi" Type="DateTime" />
<asp:Parameter Direction="Output" Name="newId" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:WebConnectionString %>"
SelectCommand="SELECT * from sehir" >
</asp:SqlDataSource>
<ext:Store ID="Store1" runat="server" DataSourceID="SqlDataSource1"
OnAfterAjaxEvent="Store1_AfterAjaxEvent"
OnAfterRecordInserted="Store1_AfterRecordInserted"
OnBeforeAjaxEvent="Store1_BeforeAjaxEvent"
OnBeforeRecordInserted="Store1_BeforeRecordInserte d"
OnRefreshData="Store1_RefershData" UseIdConfirmation="true">
<Reader>
<ext:JsonReader ReaderID="id">
<Fields>
<ext:RecordField Name="ad" />
<ext:RecordField Name="soyad" />
<ext:RecordField Name="yas" />
<ext:RecordField Name="il_adi" />
<ext:RecordField Name="dogum_tarihi" />
<ext:RecordField Name="sehir_id" />
</Fields>
</ext:JsonReader>
</Reader>
<SortInfo Direction="ASC" Field="ad" />
<Listeners>
<LoadException Handler="Ext.Msg.alert('KULLANICILAR - Load failed', e.message || e )" />
<CommitFailed Handler="Ext.Msg.alert('KULLANICILAR - Commit failed', 'Reason: ' + msg)" />
<SaveException Handler="Ext.Msg.alert('KULLANICILAR - Save failed', e.message || e)" />
<CommitDone Handler="Ext.Msg.alert('KULLANICILAR - Commit', 'The data successfully saved');" />
</Listeners>
</ext:Store>
<ext:Store ID="StoreCombo" runat="server" DataSourceID="SqlDataSource2">
<Reader>
<ext:JsonReader ReaderID="id">
<Fields>
<ext:RecordField Name="sehir_id" />
<ext:RecordField Name="il_adi" />
</Fields>
</ext:JsonReader>
</Reader>
</ext:Store>
<ext:ViewPort ID="ViewPort1" runat="server" >
<Body>
<ext:BorderLayout ID="BorderLayout1" runat="server">
<North MarginsSummary="5 5 5 5">
<ext:Panel ID="Panel1"
runat="server"
Title="Description"
Height="100"
BodyStyle="padding: 5px;"
Frame="true"
Icon="Information">
<Body>
ahanda bu bir demodur
</Body>
</ext:Panel>
</North>
<Center MarginsSummary="0 5 0 5">
<ext:Panel
ID="Panel2"
runat="server"
Height="300"
Header="false">
<Body>
<ext:FitLayout ID="FitLayout1" runat="server">
<ext:GridPanel
ID="GridPanel1"
runat="server"
Title="KULLANICILAR"
AutoExpandColumn="ad"
StoreID="Store1"
Border="false"
Icon="Lorry">
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:Column ColumnID="id" DataIndex="ad" Header="Adı">
<Editor>
<ext:TextField ID="TextField1" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="soyad" Header="Soyadı">
<Editor>
<ext:TextField ID="TextField2" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="yas" Header="Yaşı">
<Editor>
<ext:TextField ID="TextField3" runat="server" />
</Editor>
</ext:Column>
<ext:Column DataIndex="sehir_id" Header="İli" MenuDisabled="true" ColumnID="sehir_id">
<Editor>
<ext:ComboBox ID="cbDepartment" runat="server" Shadow="Drop"
ForceSelection="true" StoreID="StoreCombo" DisplayField="il_adi" ValueField="sehir_id">
</ext:ComboBox>
</Editor>
<Renderer Handler="return store.getById(value).get('il_adi')" />
</ext:Column>
<ext:Column DataIndex="dogum_tarihi" Header="Doğum Tarihi">
<Editor>
<ext:DateField ID="dateField1" runat="server" />
</Editor>
</ext:Column>
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
</SelectionModel>
<BottomBar>
<ext:PagingToolBar ID="PagingToolBar1"
runat="server"
StoreID="Store1"
PageSize="10"
DisplayInfo="false"
/>
</BottomBar>
<SaveMask ShowMask="true" />
<LoadMask ShowMask="true" />
</ext:GridPanel>
</ext:FitLayout>
</Body>
<Buttons>
<ext:Button ID="btnSave" runat="server" Text="Save" Icon="Disk">
<Listeners>
<Click Handler="#{GridPanel1}.save();" />
</Listeners>
</ext:Button>
<ext:Button ID="btnDelete" runat="server" Text="Delete selected records" Icon="Delete">
<Listeners>
<Click Handler="#{GridPanel1}.deleteSelected();" />
</Listeners>
</ext:Button>
<ext:Button ID="btnInsert" runat="server" Text="Insert" Icon="Add">
<Listeners>
<Click Handler="#{GridPanel1}.insertRecord(0, {});#{GridPanel1}.getView().focusRow(0);#{GridPane l1}.startEditing(0, 0);" />
</Listeners>
</ext:Button>
<ext:Button ID="btnRefresh" runat="server" Text="Refresh" Icon="ArrowRefresh">
<Listeners>
<Click Handler="#{GridPanel1}.reload();" />
</Listeners>
</ext:Button>
<ext:Button ID="btnEmulError" runat="server" Text="Refresh with Emulated error" Icon="Exclamation">
<Listeners>
<Click Handler="#{GridPanel1}.reload({params:{EmulateErro r: 1}});" />
</Listeners>
</ext:Button>
</Buttons>
</ext:Panel>
</Center>
</ext:BorderLayout>
</Body>
</ext:ViewPort>
</div>
</form>
</body>
</html>