This is a migrated thread and some comments may be shown as answers.

RadGrid EditFormType="Template" sub control problem

1 Answer 106 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Sinan asked on 27 Jan 2012, 12:57 PM

Hi I can not see the code on my page not se it cmbSehir and cmbUlke: (

kayi_firmalar.aspx

using System; 

using System.Collections.Generic; 

using System.Linq; 

using System.Web; 

using System.Web.UI; 

using System.Web.UI.WebControls; 

using Telerik.Web.UI; 

using System.Data.SqlClient; 

using System.Data; 

using System.Configuration; 

 

public partial class kayi_firmalar : System.Web.UI.Page 

{ 

protected void Page_Load(object sender, EventArgs e) 

{ 

if (!Page.IsPostBack) 

// Fill the continents combo. 

LoadUlke(); 

else if (!Page.IsCallback) 

{ 

// On regular postbacks restore the items of the related ComboBoxes. 

// Their selected items will be automatically restored from their ClientState. 

LoadSehir(cmbSehir.SelectedValue); 

} 

protected void cmbKayit_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) 

{ 

dsFirma.DataBind(); 

} 

 

protected void LoadUlke() 

{ 

SqlConnection connection = new SqlConnection( 

ConfigurationManager.ConnectionStrings["DASHBOARD_KAYIConnectionString"].ConnectionString); 

 

SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM _ULKKE ORDER By ADI", connection); 

DataTable dt = new DataTable(); 

adapter.Fill(dt); 

 

cmbUlke.DataTextField = "ADI"; 

cmbUlke.DataValueField = "KOD"; 

cmbUlke.DataSource = dt; 

cmbUlke.DataBind(); 

// Insert the first item. 

cmbUlke.Items.Insert(0, new RadComboBoxItem("- Ülke Seçiniz... -")); 

} 

 

protected void LoadSehir(string ulke_kodu) 

{ 

SqlConnection connection = new SqlConnection( 

ConfigurationManager.ConnectionStrings["DASHBOARD_KAYIConnectionString"].ConnectionString); 

 

// Select a country based on the continentID. 

SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM _SEHIR WHERE ULKE_KOD=@ULKE_KOD ORDER By ADI", connection); 

adapter.SelectCommand.Parameters.AddWithValue("@ULKE_KOD", ulke_kodu); 

 

DataTable dt = new DataTable(); 

adapter.Fill(dt); 

 

cmbSehir.DataTextField = "ADI"; 

cmbSehir.DataValueField = "KOD"; 

cmbSehir.DataSource = dt; 

cmbSehir.DataBind(); 

} 

 

protected void cmbUlke_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) 

{ 

LoadUlke(); 

} 

 

protected void cmbSehir_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) 

{ 

LoadSehir(e.Text); 

} 

 

}

kayi_firmalar.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" 

CodeFile="kayi_firmalar.aspx.cs" Inherits="kayi_firmalar" %> 

 

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server"> 

<style type="text/css"> 

 

</style> 

<title>Kayı Grup Şirketleri</title> 

</asp:Content> 

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server"> 

<table> 

<tr> 

<td style="width: 70px"> 

<asp:Label ID="Label3" runat="server" Style="font-family: Verdana; font-size: xx-small" 

Text="Kayıt Durumu"></asp:Label> 

</td> 

<td> 

<telerik:RadComboBox ID="cmbKayit" runat="server" AutoPostBack="True" OnSelectedIndexChanged="cmbKayit_SelectedIndexChanged"> 

<Items> 

<telerik:RadComboBoxItem runat="server" Text="Aktif" Value="0" Owner="cmbKayit" /> 

<telerik:RadComboBoxItem runat="server" Text="Pasif" Value="1" Owner="cmbKayit" /> 

</Items> 

</telerik:RadComboBox> 

</td> 

</tr> 

</table> 

<table width="100%"> 

<tr> 

<td style="border: 1px solid #f0f0f0; text-align: center;"> 

<asp:Label ID="Label5" runat="server" Style="font-size: small; font-family: Verdana; 

font-weight: 700; color: #800000; text-align: center;" Text="Kayı Grup Şirketleri"></asp:Label> 

</td> 

</tr> 

</table> 

<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" 

CellSpacing="0" DataSourceID="dsFirma" GridLines="None" AllowSorting="True" ShowGroupPanel="True" 

AllowPaging="True" AllowFilteringByColumn="True" Width="100%"> 

<ClientSettings> 

<Selecting AllowRowSelect="True"></Selecting> 

<Scrolling UseStaticHeaders="true" /> 

</ClientSettings> 

<ClientSettings AllowDragToGroup="True"> 

<Selecting AllowRowSelect="True" /> 

<Selecting AllowRowSelect="True"></Selecting> 

<Scrolling UseStaticHeaders="True"></Scrolling> 

</ClientSettings> 

<GroupPanel Text="Gruplamak istediğiniz kolonu buraya sürükleyiniz."> 

</GroupPanel> 

<MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" DataKeyNames="KOD" 

DataSourceID="dsFirma" EditMode="PopUp" NoMasterRecordsText="Gösterilecek kayıt bulunamadı." 

HorizontalAlign="Center"> 

<CommandItemSettings ExportToPdfText="Export to PDF" AddNewRecordText="Ekle" RefreshText="Yenile"> 

</CommandItemSettings> 

<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"> 

</RowIndicatorColumn> 

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"> 

</ExpandCollapseColumn> 

<Columns> 

<telerik:GridEditCommandColumn ButtonType="ImageButton" EditText="Düzenle" FilterControlAltText="Filter EditCommandColumn column"> 

<FooterStyle Font-Bold="True" /> 

<ItemStyle HorizontalAlign="Center" Width="20px" /> 

</telerik:GridEditCommandColumn> 

<telerik:GridBoundColumn DataField="KOD" DataType="System.Int32" FilterControlAltText="Filter KOD column" 

HeaderText="KOD" ReadOnly="True" SortExpression="KOD" UniqueName="KOD" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="ADI" FilterControlAltText="Filter ADI column" 

HeaderText="Adı" SortExpression="ADI" UniqueName="ADI"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="ULKE_LBL" FilterControlAltText="Filter ULKE_LBL column" 

HeaderText="Ülke" SortExpression="ULKE_LBL" UniqueName="ULKE_LBL"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="SEHIR_LBL" FilterControlAltText="Filter SEHIR_LBL column" 

HeaderText="Şehir" SortExpression="SEHIR_LBL" UniqueName="SEHIR_LBL"> 

</telerik:GridBoundColumn> 

<telerik:GridCheckBoxColumn DataField="MUTEAHHIT" DataType="System.Boolean" FilterControlAltText="Filter MUTEAHHIT column" 

HeaderText="Müteahhit" SortExpression="MUTEAHHIT" UniqueName="MUTEAHHIT" DefaultInsertValue="true" 

Visible="False"> 

<HeaderStyle HorizontalAlign="Center" /> 

<ItemStyle HorizontalAlign="Center" Width="50px" /> 

</telerik:GridCheckBoxColumn> 

<telerik:GridCheckBoxColumn DataField="YUKLENICI" DataType="System.Boolean" FilterControlAltText="Filter YUKLENICI column" 

HeaderText="Yüklenici" SortExpression="YUKLENICI" UniqueName="YUKLENICI" DefaultInsertValue="false" 

Visible="False"> 

<HeaderStyle HorizontalAlign="Center" /> 

<ItemStyle HorizontalAlign="Center" Width="50px" /> 

</telerik:GridCheckBoxColumn> 

<telerik:GridCheckBoxColumn DataField="ISVEREN" DataType="System.Boolean" FilterControlAltText="Filter ISVEREN column" 

HeaderText="İşveren" SortExpression="ISVEREN" UniqueName="ISVEREN" DefaultInsertValue="false" 

Visible="False"> 

<HeaderStyle HorizontalAlign="Center" /> 

<ItemStyle HorizontalAlign="Center" Width="50px" /> 

</telerik:GridCheckBoxColumn> 

<telerik:GridBoundColumn DataField="ULKE_KODU" DataType="System.Int32" FilterControlAltText="Filter ULKE_KODU column" 

HeaderText="ULKE_KODU" SortExpression="ULKE_KODU" UniqueName="ULKE_KODU" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="SEHIR_KODU" DataType="System.Int32" FilterControlAltText="Filter SEHIR_KODU column" 

HeaderText="SEHIR_KODU" SortExpression="SEHIR_KODU" UniqueName="SEHIR_KODU" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="ADRES" FilterControlAltText="Filter ADRES column" 

HeaderText="ADRES" SortExpression="ADRES" UniqueName="ADRES" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="ACIKLAMA" FilterControlAltText="Filter ACIKLAMA column" 

HeaderText="ACIKLAMA" SortExpression="ACIKLAMA" UniqueName="ACIKLAMA" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="OZEL1" FilterControlAltText="Filter OZEL1 column" 

HeaderText="OZEL1" SortExpression="OZEL1" UniqueName="OZEL1" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="OZEL2" FilterControlAltText="Filter OZEL2 column" 

HeaderText="OZEL2" SortExpression="OZEL2" UniqueName="OZEL2" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="OZEL3" FilterControlAltText="Filter OZEL3 column" 

HeaderText="OZEL3" SortExpression="OZEL3" UniqueName="OZEL3" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="OZEL4" FilterControlAltText="Filter OZEL4 column" 

HeaderText="OZEL4" SortExpression="OZEL4" UniqueName="OZEL4" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridBoundColumn DataField="ERP_KODU" FilterControlAltText="Filter ERP_KODU column" 

HeaderText="ERP_KODU" SortExpression="ERP_KODU" UniqueName="ERP_KODU" Visible="False"> 

</telerik:GridBoundColumn> 

<telerik:GridCheckBoxColumn DataField="PASIF" DataType="System.Boolean" FilterControlAltText="Filter PASIF column" 

HeaderText="PASIF" SortExpression="PASIF" UniqueName="PASIF" Visible="False" 

DefaultInsertValue="false"> 

</telerik:GridCheckBoxColumn> 

</Columns> 

<EditFormSettings EditFormType="Template" InsertCaption="Kayı Grup Şirketleri" CaptionFormatString="Kayı Grup Şirketleri"> 

<FormTemplate> 

<table width="100%"> 

<tr> 

<td> 

  

</td> 

<td> 

  

</td> 

<td> 

  

</td> 

</tr> 

<tr> 

<td> 

</td> 

<td> 

<table style="width: 100%; border: 1px solid #f0f0f0;"> 

<tr> 

<td style="width: 160px;"> 

Adı 

</td> 

<td style="width: 160px;"> 

<telerik:RadTextBox ID="txtAdi" runat="server" Text='<%# Bind("ADI") %>' Width="195px" 

TabIndex="1" MaxLength="100"> 

</telerik:RadTextBox> 

<asp:RequiredFieldValidator runat="server" ForeColor="Red" ID="RequiredFieldValidator5" 

ControlToValidate="txtAdi" Display="Dynamic" ErrorMessage="*" ValidationGroup="FormValidationGroup" /> 

</td> 

<td style="width: 150px;"> 

</td> 

<td style="width: 160px;" rowspan="2"> 

Açıklama 

</td> 

<td style="width: 160px;" rowspan="2"> 

<telerik:RadTextBox ID="txtAciklama" runat="server" Text='<%# Bind("ACIKLAMA") %>' 

Width="195px" TabIndex="6" TextMode="MultiLine" MaxLength="150"> 

</telerik:RadTextBox> 

</td> 

</tr> 

<tr> 

<td> 

Ülke 

</td> 

<td> 

<telerik:RadComboBox ID="cmbUlke" runat="server" AppendDataBoundItems="true" SelectedValue='<%# Bind("ULKE_KODU")%>' 

DataSourceID="dsUlke" DataTextField="ADI" DataValueField="KOD" Width="200px" 

Culture="tr-TR" TabIndex="2"> 

</telerik:RadComboBox> 

</td> 

<td> 

</td> 

</tr> 

<tr> 

<td> 

Şehir 

</td> 

<td> 

<telerik:RadComboBox ID="cmbSehir" runat="server" AppendDataBoundItems="true" SelectedValue='<%# Bind("SEHIR_KODU")%>' 

DataSourceID="dsSehir" DataTextField="ADI" DataValueField="KOD" Width="200px" 

Culture="tr-TR" TabIndex="3"> 

</telerik:RadComboBox> 

</td> 

<td> 

</td> 

<td rowspan="3"> 

Adres 

</td> 

<td rowspan="3"> 

<telerik:RadTextBox ID="txtAdres" runat="server" Text='<%# Bind("ADRES") %>' Width="195px" 

TabIndex="7" TextMode="MultiLine" Height="60px" MaxLength="200"> 

</telerik:RadTextBox> 

</td> 

</tr> 

<tr> 

<td> 

Muhasebe Kodu 

</td> 

<td> 

<telerik:RadTextBox ID="txtMuhasebeKodu" runat="server" Text='<%# Bind("ERP_KODU") %>' 

Width="195px" TabIndex="4"> 

</telerik:RadTextBox> 

</td> 

<td> 

</td> 

</tr> 

<tr> 

<td> 

Pasif 

</td> 

<td> 

<asp:CheckBox ID="chkPasif" runat="server" Checked='<%#Bind("PASIF") %>' TabIndex="5" /> 

</td> 

<td> 

</td> 

</tr> 

</table> 

</td> 

<td> 

</td> 

</tr> 

<tr> 

<td> 

  

</td> 

<td> 

  

</td> 

<td> 

  

</td> 

</tr> 

<tr> 

<td> 

</td> 

<td style="border: 1px solid #f0f0f0;"> 

<telerik:RadButton ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Kaydet" : "Güncelle" %>' 

runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>' 

TabIndex="8" ValidationGroup="FormValidationGroup"> 

</telerik:RadButton> 

  

<telerik:RadButton ID="btnCancel" Text="Vazgeç" runat="server" CausesValidation="False" 

CommandName="Cancel" TabIndex="9"> 

</telerik:RadButton> 

</td> 

<td> 

</td> 

</tr> 

</table> 

</FormTemplate> 

<FormTableItemStyle Wrap="False"></FormTableItemStyle> 

<FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle> 

<FormMainTableStyle GridLines="None" CellSpacing="0" CellPadding="3" BackColor="White" 

Width="100%" /> 

<EditColumn UniqueName="EditCommandColumn1" FilterControlAltText="Filter EditCommandColumn1 column"> 

</EditColumn> 

<FormTableStyle CellSpacing="0" CellPadding="2" Height="110px" BackColor="White" /> 

<FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle> 

<FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle> 

<PopUpSettings CloseButtonToolTip="Kapat" ScrollBars="Auto" Width="720px" Height="260px" /> 

</EditFormSettings> 

</MasterTableView> 

<FilterMenu EnableImageSprites="False"> 

</FilterMenu> 

</telerik:RadGrid> 

<asp:SqlDataSource ID="dsFirma" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" 

DeleteCommand="DELETE FROM [_FIRMA] WHERE [KOD] = @KOD" InsertCommand="INSERT INTO _FIRMA(ADI, MUTEAHHIT, ULKE_KODU, SEHIR_KODU, ADRES, ACIKLAMA, ERP_KODU, PASIF) VALUES (@ADI, 1, @ULKE_KODU, @SEHIR_KODU, @ADRES, @ACIKLAMA, @ERP_KODU, @PASIF)"<

br>

SelectCommand="SELECT _FIRMA.KOD, _FIRMA.ADI, _FIRMA.MUTEAHHIT, _FIRMA.YUKLENICI, _FIRMA.ISVEREN, _FIRMA.ULKE_KODU, _FIRMA.SEHIR_KODU, _FIRMA.ADRES, _FIRMA.ACIKLAMA, _FIRMA.ERP_KODU, _FIRMA.PASIF, _ULKE.ADI AS ULKE_LBL, _SEHIR.ADI AS SEHIR_LBL FROM _FIRMA LEFT OUTER JOIN _SEHIR ON _FIRMA.SEHIR_KODU = _SEHIR.KOD LEFT OUTER JOIN _ULKE ON _FIRMA.ULKE_KODU = _ULKE.KOD WHERE (_FIRMA.PASIF = @PASIF) ORDER BY _FIRMA.ADI"<

br>

 

UpdateCommand="UPDATE _FIRMA SET ADI = @ADI, MUTEAHHIT = 1, ULKE_KODU = @ULKE_KODU, SEHIR_KODU = @SEHIR_KODU, ADRES = @ADRES, ACIKLAMA = @ACIKLAMA, ERP_KODU = @ERP_KODU, PASIF = @PASIF WHERE (KOD = @KOD)"><

br>

<DeleteParameters> 

<asp:Parameter Name="KOD" Type="Int32" /> 

</DeleteParameters> 

<InsertParameters> 

<asp:Parameter Name="ADI" Type="String" /> 

<asp:Parameter Name="MUTEAHHIT" Type="Boolean" /> 

<asp:Parameter Name="YUKLENICI" Type="Boolean" /> 

<asp:Parameter Name="ISVEREN" Type="Boolean" /> 

<asp:Parameter Name="ULKE_KODU" Type="Int32" /> 

<asp:Parameter Name="SEHIR_KODU" Type="Int32" /> 

<asp:Parameter Name="ADRES" Type="String" /> 

<asp:Parameter Name="ACIKLAMA" Type="String" /> 

<asp:Parameter Name="ERP_KODU" Type="String" /> 

<asp:Parameter Name="PASIF" Type="Boolean" /> 

</InsertParameters> 

<SelectParameters> 

<asp:ControlParameter ControlID="cmbKayit" Name="PASIF" PropertyName="SelectedValue" /> 

</SelectParameters> 

<UpdateParameters> 

<asp:Parameter Name="ADI" Type="String" /> 

<asp:Parameter Name="MUTEAHHIT" Type="Boolean" /> 

<asp:Parameter Name="YUKLENICI" Type="Boolean" /> 

<asp:Parameter Name="ISVEREN" Type="Boolean" /> 

<asp:Parameter Name="ULKE_KODU" Type="Int32" /> 

<asp:Parameter Name="SEHIR_KODU" Type="Int32" /> 

<asp:Parameter Name="ADRES" Type="String" /> 

<asp:Parameter Name="ACIKLAMA" Type="String" /> 

<asp:Parameter Name="ERP_KODU" Type="String" /> 

<asp:Parameter Name="PASIF" Type="Boolean" /> 

<asp:Parameter Name="KOD" Type="Int32" /> 

</UpdateParameters> 

</asp:SqlDataSource> 

<asp:SqlDataSource ID="dsUlke" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" 

SelectCommand="SELECT KOD, ADI, PARA_BIRIM, PASIF FROM _ULKE WHERE (PASIF = 0) ORDER BY ADI"> 

</asp:SqlDataSource> 

<asp:SqlDataSource ID="dsSehir" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" 

 

SelectCommand="SELECT KOD, ULKE_KOD, ADI, PASIF FROM _SEHIR WHERE (PASIF = 0) ORDER BY ADI"> 

</asp:SqlDataSource> 

</asp:Content> 

<div></div>

RadGrid EditFormType="Template" sub control problem

1 Answer, 1 is accepted