btnupdate9 not working :(
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="UC_tahsilat.ascx.cs" Inherits="SNN.islemler_tahsilat_UC_tahsilat" %><table width="100%"> <tr> <td> </td> </tr> <tr> <td> </td> </tr></table><telerik:RadTabStrip runat="server" ID="RadTabStrip1" SelectedIndex="0" MultiPageID="RadMultiPage1"> <Tabs> <telerik:RadTab Text="Genel Bilgiler" Selected="True"> </telerik:RadTab> <telerik:RadTab Text="Tutar Giriş"> </telerik:RadTab> </Tabs></telerik:RadTabStrip><telerik:RadMultiPage runat="server" ID="RadMultiPage1" SelectedIndex="0" Height="218px" Width="100%" CssClass="multiPage"> <telerik:RadPageView runat="server" ID="Genel_Bilgiler"> <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;"> Proje </td> <td style="width: 50px;"> </td> <td style="width: 195px;"> <telerik:RadComboBox ID="cmbProje" runat="server" AppendDataBoundItems="true" SelectedValue='<%# DataBinder.Eval( Container, "DataItem.PROJE_KODU")%>' DataSourceID="dsProje" DataTextField="KISA_ADI" DataValueField="PROJEKOD" Width="200px" Culture="tr-TR" TabIndex="1" AllowCustomText="True" AutoPostBack="True" OnSelectedIndexChanged="cmbProje_SelectedIndexChanged"> </telerik:RadComboBox> <asp:RequiredFieldValidator runat="server" ForeColor="Red" ID="RequiredFieldValidator4" ControlToValidate="cmbProje" Display="Dynamic" ErrorMessage="*" ValidationGroup="FormValidationGroup" /> </td> <td style="width: 150px;"> </td> <td style="width: 180px;"> İşlem Tutarı </td> <td style="width: 50px;"> <telerik:RadComboBox ID="cmbParaBirim" runat="server" AppendDataBoundItems="true" Culture="tr-TR" DataSourceID="dsParaBirim" DataTextField="PARABIRIM" DataValueField="PARABIRIM" TabIndex="6" Width="50px"> </telerik:RadComboBox> </td> <td style="width: 195px;"> <telerik:RadNumericTextBox ID="txtTutarLokal" runat="server" Culture="tr-TR" NumberFormat-DecimalDigits="0" TabIndex="7" Width="195px"> <NumberFormat DecimalDigits="0" ZeroPattern="n" /> <EnabledStyle HorizontalAlign="Right" /> </telerik:RadNumericTextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtTutarLokal" Display="Dynamic" ErrorMessage="*" ForeColor="Red" ValidationGroup="FormValidationGroup" /> </td> </tr> <tr> <td> İşveren </td> <td> </td> <td> <telerik:RadComboBox ID="cmbIsveren" runat="server" AppendDataBoundItems="true" SelectedValue='<%# DataBinder.Eval( Container, "DataItem.ISVEREN_KODU")%>' DataSourceID="dsIsveren" DataTextField="ADI" DataValueField="KOD" Width="200px" Culture="tr-TR" TabIndex="2"> </telerik:RadComboBox> <asp:RequiredFieldValidator runat="server" ForeColor="Red" ID="RequiredFieldValidator7" ControlToValidate="cmbIsveren" Display="Dynamic" ErrorMessage="*" ValidationGroup="FormValidationGroup" /> </td> <td> </td> <td> Tutar (€) </td> <td> </td> <td> <telerik:RadNumericTextBox ID="txtTutarEuro" runat="server" Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="0" TabIndex="9"> <EnabledStyle HorizontalAlign="Right" /> </telerik:RadNumericTextBox> <asp:RequiredFieldValidator runat="server" ForeColor="Red" ID="RequiredFieldValidator1" ControlToValidate="txtTutarEuro" Display="Dynamic" ErrorMessage="*" ValidationGroup="FormValidationGroup" /> </td> </tr> <tr> <td> Tarih </td> <td> </td> <td> <mark:DateTimePicker ID="dateTarih" runat="server" ShowClearButton="true" UseImageButtons="true" PickerCssClass="Picker" Culture="tr-TR" Format="dd-MM-yyyy" Text='<%# DataBinder.Eval( Container, "DataItem.ISLEM_TARIHI") %>' CancelButtonText="Seç" ClearButtonText="Temizle" SelectButtonText="Seç..." TabIndex="3" NoCurrentValueText="Tarih Seçilmedi" OKButtonText="Tamam" Width="150px" /> <asp:RequiredFieldValidator runat="server" ForeColor="Red" ID="RequiredFieldValidator2" ControlToValidate="dateTarih" Display="Dynamic" ErrorMessage="*" ValidationGroup="FormValidationGroup" /> </td> <td> </td> <td> Tutar ($) </td> <td> </td> <td> <telerik:RadNumericTextBox ID="txtTutarDolar" runat="server" Culture="tr-TR" NumberFormat-DecimalDigits="0" TabIndex="11" Width="195px"> <EnabledStyle HorizontalAlign="Right" /> </telerik:RadNumericTextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtTutarDolar" Display="Dynamic" ErrorMessage="*" ForeColor="Red" ValidationGroup="FormValidationGroup" /> </td> </tr> <tr> <td> İşlem </td> <td> </td> <td> <telerik:RadComboBox ID="cmbIslem" runat="server" AppendDataBoundItems="true" SelectedValue='<%# DataBinder.Eval( Container, "DataItem.HAREKET_TIPI")%>' DataSourceID="dsIslemTip" DataTextField="ADI" DataValueField="KOD" Width="200px" Culture="tr-TR" TabIndex="4"> </telerik:RadComboBox> </td> <td> </td> <td> Pasif </td> <td> </td> <td> <asp:CheckBox ID="chkPasif" runat="server" Checked='<%# (DataBinder.Eval(Container,"DataItem.PASIF")) %>' TabIndex="13" /> </td> </tr> <tr> <td> Tahsilat Ülkesi </td> <td> </td> <td> <telerik:RadComboBox ID="cmbTahsilatUlke" runat="server" AppendDataBoundItems="true" SelectedValue='<%# DataBinder.Eval( Container, "DataItem.ULKE_KODU")%>' DataSourceID="dsUlke" DataTextField="ADI" DataValueField="KOD" Width="200px" Culture="tr-TR" TabIndex="5" EnableAutomaticLoadOnDemand="False" EnableTextSelection="True" AllowCustomText="True"> </telerik:RadComboBox> <asp:RequiredFieldValidator runat="server" ForeColor="Red" ID="RequiredFieldValidator6" ControlToValidate="cmbTahsilatUlke" Display="Dynamic" ErrorMessage="*" ValidationGroup="FormValidationGroup" /> </td> <td> <asp:Label ID="lblHareketID" runat="server" Text='<%# DataBinder.Eval( Container, "DataItem.ID") %>'></asp:Label> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td style="width: 25px; vertical-align: middle;"> Açıklama </td> <td align="left"> </td> <td colspan="5" align="left"> <telerik:RadTextBox ID="txtAciklama" runat="server" Text='<%# DataBinder.Eval( Container, "DataItem.ACIKLAMA") %>' TextMode="MultiLine" TabIndex="14" Width="99%" MaxLength="150"> </telerik:RadTextBox> </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="Güncelle" runat="server" CommandName="Update" Visible='<%# !(DataItem is Telerik.Web.UI.GridInsertionObject) %>' ValidationGroup="FormValidationGroup"> </telerik:RadButton> <telerik:RadButton ID="btnInsert" Text="Kaydet" runat="server" CommandName="PerformInsert" Visible='<%# DataItem is Telerik.Web.UI.GridInsertionObject %>' ValidationGroup="FormValidationGroup"> </telerik:RadButton> <telerik:RadButton ID="btnCancel" Text="Kapat" runat="server" CausesValidation="False" CommandName="Cancel"> </telerik:RadButton> </td> <td> </td> </tr> </table> </telerik:RadPageView> <telerik:RadPageView runat="server" ID="Tutar_Giris"> <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> <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" CellSpacing="0" DataSourceID="dsTutar" GridLines="None" ShowFooter="True"> <ClientSettings> <Selecting AllowRowSelect="True" /> </ClientSettings> <MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" DataKeyNames="KOD" DataSourceID="dsTutar" EditMode="PopUp" NoMasterRecordsText="Gösterilecek kayıt bulunamadı." Width="100%"> <CommandItemSettings ExportToPdfText="Export to PDF" AddNewRecordText="Ekle" RefreshText="Yenile"> </CommandItemSettings> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column" Visible="True"> </RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" Visible="True"> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="KOD" DataType="System.Int64" FilterControlAltText="Filter KOD column" HeaderText="KOD" ReadOnly="True" SortExpression="KOD" UniqueName="KOD" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="HAREKET_ID" DataType="System.Int64" FilterControlAltText="Filter HAREKET_ID column" HeaderText="HAREKET_ID" SortExpression="HAREKET_ID" UniqueName="HAREKET_ID"> </telerik:GridBoundColumn> <telerik:GridDropDownColumn DataField="DOVIZ" FilterControlAltText="Filter DOVIZ column" HeaderText="Döviz" SortExpression="DOVIZ" UniqueName="DOVIZ" DataSourceID="dsDoviz" DataType="System.String" ListTextField="PARA_BIRIM" ListValueField="PARA_BIRIM"> </telerik:GridDropDownColumn> <telerik:GridBoundColumn DataField="SOZLESME_TUTAR" DataType="System.Double" FilterControlAltText="Filter SOZLESME_TUTAR column" HeaderText="Tahsilat Tutarı" SortExpression="SOZLESME_TUTAR" UniqueName="SOZLESME_TUTAR" DataFormatString="{0:N0}"> <HeaderStyle HorizontalAlign="Right" /> <FooterStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="YEREL_PARITE" DataType="System.Double" FilterControlAltText="Filter YEREL_PARITE column" HeaderText="Yerel Parite" SortExpression="YEREL_PARITE" UniqueName="YEREL_PARITE" DataFormatString="{0:N4}"> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="YEREL_TUTAR" DataType="System.Double" FilterControlAltText="Filter YEREL_TUTAR column" HeaderText="Yerel Tutar" SortExpression="YEREL_TUTAR" UniqueName="YEREL_TUTAR" DataFormatString="{0:N0}" Aggregate="Sum" FooterAggregateFormatString="{0:N0}" ReadOnly="true"> <FooterStyle HorizontalAlign="Right" Font-Bold="True" /> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EUR_PARITE" DataType="System.Double" FilterControlAltText="Filter EUR_PARITE column" HeaderText="EUR Parite" SortExpression="EUR_PARITE" UniqueName="EUR_PARITE" DataFormatString="{0:N4}"> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EUR_TUTAR" DataType="System.Double" FilterControlAltText="Filter EUR_TUTAR column" HeaderText="EUR Tutar" SortExpression="EUR_TUTAR" UniqueName="EUR_TUTAR" ReadOnly="true" DataFormatString="{0:N0}" Aggregate="Sum" FooterAggregateFormatString="{0:N0}"> <FooterStyle HorizontalAlign="Right" Font-Bold="True" /> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="USD_PARITE" DataType="System.Double" FilterControlAltText="Filter USD_PARITE column" HeaderText="USD Parite" SortExpression="USD_PARITE" UniqueName="USD_PARITE" DataFormatString="{0:N4}"> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="USD_TUTAR" DataType="System.Double" FilterControlAltText="Filter USD_TUTAR column" HeaderText="USD Tutar" SortExpression="USD_TUTAR" UniqueName="USD_TUTAR" ReadOnly="true" DataFormatString="{0:N0}" Aggregate="Sum" FooterAggregateFormatString="{0:N0}"> <FooterStyle HorizontalAlign="Right" Font-Bold="True" /> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="KDV_ORANI" DataType="System.Double" FilterControlAltText="Filter KDV_ORANI column" HeaderText="Kdv Oranı" SortExpression="KDV_ORANI" UniqueName="KDV_ORANI" DataFormatString="{0:N0}"> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="YEREL_TUTAR_KDVLI" DataType="System.Double" FilterControlAltText="Filter YEREL_TUTAR_KDVLI column" HeaderText="Yerel Tutar + Kdv" SortExpression="YEREL_TUTAR_KDVLI" UniqueName="YEREL_TUTAR_KDVLI" ReadOnly="true" DataFormatString="{0:N0}" Aggregate="Sum" FooterAggregateFormatString="{0:N0}"> <FooterStyle HorizontalAlign="Right" Font-Bold="True" /> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EUR_TUTAR_KDVLI" DataType="System.Double" FilterControlAltText="Filter EUR_TUTAR_KDVLI column" HeaderText="EUR Tutar + Kdv" SortExpression="EUR_TUTAR_KDVLI" UniqueName="EUR_TUTAR_KDVLI" ReadOnly="true" DataFormatString="{0:N0}" Aggregate="Sum" FooterAggregateFormatString="{0:N0}"> <FooterStyle HorizontalAlign="Right" Font-Bold="True" /> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="USD_TUTAR_KDVLI" DataType="System.Double" FilterControlAltText="Filter USD_TUTAR_KDVLI column" HeaderText="USD Tutar + Kdv" SortExpression="USD_TUTAR_KDVLI" UniqueName="USD_TUTAR_KDVLI" ReadOnly="true" DataFormatString="{0:N0}" Aggregate="Sum" FooterAggregateFormatString="{0:N0}"> <FooterStyle HorizontalAlign="Right" Font-Bold="True" /> <HeaderStyle HorizontalAlign="Right" /> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridEditCommandColumn CancelText="Kapat" EditText="Düzenle" FilterControlAltText="Filter EditCommandColumn column" InsertText="Kaydet" UpdateText="Güncelle"> <ItemStyle Width="30px" /> </telerik:GridEditCommandColumn> </Columns> <EditFormSettings EditFormType="Template" InsertCaption="Tutar Giriş" CaptionFormatString="Tutar Giriş"> <FormTemplate> <table width="100%"> <tr> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> <table style="width: 100%; border: 1px solid #f0f0f0;"> <tr> <td style="width: 160px;"> Döviz </td> <td style="width: 160px;"> <telerik:RadComboBox ID="cmbDoviz1" runat="server" DataSourceID="dsDoviz" DataTextField="PARA_BIRIM" Filter="Contains" DataValueField="PARA_BIRIM" TabIndex="2" Width="200px" SelectedValue='<%# Bind("DOVIZ")%>'> </telerik:RadComboBox> </td> </tr> <tr> <td> Tahsilat Tutarı </td> <td> <telerik:RadNumericTextBox ID="RadNumericTextBox3" runat="server" DbValue='<%# Bind("SOZLESME_TUTAR")%>' Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="0" TabIndex="3"> <EnabledStyle HorizontalAlign="Right" /> </telerik:RadNumericTextBox> </td> </tr> <tr> <td> Yerel Parite </td> <td> <telerik:RadNumericTextBox ID="RadNumericTextBox1" runat="server" DbValue='<%# Bind("YEREL_PARITE")%>' Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="4" TabIndex="4"> <EnabledStyle HorizontalAlign="Right" /> </telerik:RadNumericTextBox> </td> </tr> <tr> <td> EUR Parite </td> <td> <telerik:RadNumericTextBox ID="RadNumericTextBox2" runat="server" DbValue='<%# Bind("EUR_PARITE")%>' Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="4" TabIndex="5"> <EnabledStyle HorizontalAlign="Right" /> </telerik:RadNumericTextBox> </td> </tr> <tr> <td> USD Parite </td> <td> <telerik:RadNumericTextBox ID="RadNumericTextBox4" runat="server" DbValue='<%# Bind("USD_PARITE")%>' Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="4" TabIndex="6"> <EnabledStyle HorizontalAlign="Right" /> </telerik:RadNumericTextBox> </td> </tr> <tr> <td> Kdv Oran </td> <td> <telerik:RadNumericTextBox ID="RadNumericTextBox5" runat="server" DbValue='<%# Bind("KDV_ORANI")%>' Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="0" TabIndex="7"> <EnabledStyle HorizontalAlign="Right" /> </telerik:RadNumericTextBox> </td> </tr> </table> </td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td> </td> <td style="border: 1px solid #f0f0f0;"> <telerik:RadButton ID="btnUpdate9" Text='<%# (Container is GridEditFormInsertItem) ? "Kaydet" : "Güncelle" %>' runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>' TabIndex="8" ValidationGroup="FormValidationGroup"> </telerik:RadButton> <telerik:RadButton ID="btnCance9" Text="Kapat" runat="server" CausesValidation="False" CommandName="Cancel" TabIndex="9"> </telerik:RadButton> </td> </tr> </table> </FormTemplate> <EditColumn FilterControlAltText="Filter EditCommandColumn column" CancelText="Kapat" InsertText="Kaydet" UpdateText="Güncelle"> </EditColumn> <PopUpSettings CloseButtonToolTip="Kapat" Width="310px" Height="300px" /> </EditFormSettings> </MasterTableView> <FilterMenu EnableImageSprites="False"> </FilterMenu> </telerik:RadGrid> </td> </tr> </table> </td> <td> </td> </tr> <tr> <td> </td> <td> <asp:SqlDataSource ID="dsTutar" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" DeleteCommand="DELETE FROM [HAREKET_TUTAR] WHERE [KOD] = @KOD" InsertCommand="INSERT INTO HAREKET_TUTAR(HAREKET_ID, DOVIZ, SOZLESME_TUTAR, YEREL_PARITE, EUR_PARITE, USD_PARITE, KDV_ORANI) VALUES (@HAREKET_ID, @DOVIZ, @SOZLESME_TUTAR, @YEREL_PARITE, @EUR_PARITE, @USD_PARITE, @KDV_ORANI)" SelectCommand="SELECT KOD, HAREKET_ID, DOVIZ, SOZLESME_TUTAR, YEREL_PARITE, YEREL_TUTAR, EUR_PARITE, EUR_TUTAR, USD_PARITE, USD_TUTAR, KDV_ORANI, YEREL_TUTAR_KDVLI, EUR_TUTAR_KDVLI, USD_TUTAR_KDVLI FROM HAREKET_TUTAR WHERE (HAREKET_ID = @HAREKET_ID)" UpdateCommand="UPDATE HAREKET_TUTAR SET DOVIZ = @DOVIZ, SOZLESME_TUTAR = @SOZLESME_TUTAR, YEREL_PARITE = @YEREL_PARITE, EUR_PARITE = @EUR_PARITE, USD_PARITE = @USD_PARITE, KDV_ORANI = @KDV_ORANI WHERE (KOD = @KOD)"> <DeleteParameters> <asp:Parameter Name="KOD" Type="Int64" /> </DeleteParameters> <InsertParameters> <asp:ControlParameter ControlID="lblHareketID" Name="HAREKET_ID" PropertyName="Text" Type="Int64" /> <asp:Parameter Name="DOVIZ" Type="String" /> <asp:Parameter Name="SOZLESME_TUTAR" Type="Double" /> <asp:Parameter Name="YEREL_PARITE" Type="Double" /> <asp:Parameter Name="EUR_PARITE" Type="Double" /> <asp:Parameter Name="USD_PARITE" Type="Double" /> <asp:Parameter Name="KDV_ORANI" Type="Double" /> </InsertParameters> <SelectParameters> <asp:ControlParameter ControlID="lblHareketID" Name="HAREKET_ID" PropertyName="Text" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="DOVIZ" Type="String" /> <asp:Parameter Name="SOZLESME_TUTAR" Type="Double" /> <asp:Parameter Name="YEREL_PARITE" Type="Double" /> <asp:Parameter Name="EUR_PARITE" Type="Double" /> <asp:Parameter Name="USD_PARITE" Type="Double" /> <asp:Parameter Name="KDV_ORANI" Type="Double" /> <asp:Parameter Name="KOD" Type="Int64" /> </UpdateParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="dsDoviz" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" SelectCommand="SELECT [PARA_BIRIM] FROM [_ULKE] ORDER BY [ADI]"></asp:SqlDataSource> </td> <td> </td> </tr> <tr> <td> </td> <td style="border: 1px solid #f0f0f0;"> </td> <td> </td> </tr> </table> </telerik:RadPageView></telerik:RadMultiPage><asp:SqlDataSource ID="dsParaBirim" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" SelectCommand="SELECT PARA_BIRIM AS PARABIRIM FROM _ULKE ORDER BY PARABIRIM"></asp:SqlDataSource><asp:SqlDataSource ID="dsProje" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" SelectCommand="SELECT KOD AS PROJEKOD, KISA_ADI FROM _PROJE WHERE (PASIF = 0) ORDER BY KISA_ADI"></asp:SqlDataSource><asp:SqlDataSource ID="dsUlke" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" SelectCommand="SELECT KOD, ADI FROM _ULKE WHERE (PASIF = 0) ORDER BY ADI"></asp:SqlDataSource><asp:SqlDataSource ID="dsIslemTip" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" SelectCommand="SELECT KOD, ADI, PASIF FROM _HAREKET_TIPI WHERE (PASIF = 0) ORDER BY ADI"></asp:SqlDataSource><asp:SqlDataSource ID="dsIsveren" runat="server" ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>" SelectCommand="SELECT _FIRMA.KOD, _FIRMA.ADI, _PROJE_ISVEREN.PROJE_KODU FROM _PROJE_ISVEREN INNER JOIN _FIRMA ON _PROJE_ISVEREN.FIRMA_KODU = _FIRMA.KOD WHERE (_PROJE_ISVEREN.PASIF = 0) AND (_PROJE_ISVEREN.PROJE_KODU = @PROJE)"> <SelectParameters> <asp:ControlParameter ControlID="cmbProje" Name="PROJE" PropertyName="SelectedValue" /> </SelectParameters></asp:SqlDataSource>