Incorrect syntax near '?'.

[burak]

Hello ;

I want to do a page like this. But when I update a row get this 'Incorrect syntax near '?'.' error. It's highly because of my SqlDataSource
but I can't find the reason of the error. Here is my codes...

 <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AllowPaging="True"
            AllowSorting="True" DataSourceID="SqlDataSource1" PageSize="20" ShowGroupPanel="True"
            Skin="Web20" AllowMultiRowSelection="False" GridLines="None" AllowAutomaticDeletes="True"
            AllowAutomaticInserts="True" AllowAutomaticUpdates="True">
            <MasterTableView AutoGenerateColumns="False" DataKeyNames="modul_kodu, ekran_kodu"
                DataSourceID="SqlDataSource1" Caption="Ekran Tanımları">
                <RowIndicatorColumn>
                    <HeaderStyle Width="20px"></HeaderStyle>
                </RowIndicatorColumn>
                <ExpandCollapseColumn>
                    <HeaderStyle Width="20px"></HeaderStyle>
                </ExpandCollapseColumn>
                <Columns>
                    <telerik:GridEditCommandColumn ButtonType="ImageButton" />
                    <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmText="Eminmisiniz ?"
                        ConfirmTitle="Kayıt Silme" Text="Delete" UniqueName="Deletecolumn" />
                        
                    <telerik:GridBoundColumn DataField="modul_kodu" HeaderText="modul_kodu" ReadOnly="True"
                        SortExpression="modul_kodu" UniqueName="modul_kodu">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ekran_kodu" HeaderText="ekran_kodu" ReadOnly="True"
                        SortExpression="ekran_kodu" UniqueName="ekran_kodu">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="window_adi" HeaderText="window_adi" SortExpression="window_adi"
                        UniqueName="window_adi">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ekran_adi" HeaderText="ekran_adi" SortExpression="ekran_adi"
                        UniqueName="ekran_adi">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ekran_adi_e" HeaderText="ekran_adi_e" SortExpression="ekran_adi_e"
                        UniqueName="ekran_adi_e">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ekran_adi_f" HeaderText="ekran_adi_f" SortExpression="ekran_adi_f"
                        UniqueName="ekran_adi_f">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ekran_adi_d" HeaderText="ekran_adi_d" SortExpression="ekran_adi_d"
                        UniqueName="ekran_adi_d">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Ekran_tipi" HeaderText="Ekran_tipi" SortExpression="Ekran_tipi"
                        UniqueName="Ekran_tipi">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ust_ekran_kodu" HeaderText="ust_ekran_kodu" SortExpression="ust_ekran_kodu"
                        UniqueName="ust_ekran_kodu">
                    </telerik:GridBoundColumn>
                </Columns>
                <EditFormSettings>
                    <EditColumn UniqueName="EditCommandColumn1" >
                    </EditColumn>
                </EditFormSettings>
            </MasterTableView>
            <ClientSettings AllowDragToGroup="True" >
            </ClientSettings>
            <StatusBarSettings LoadingText="Yükleniyor..." ReadyText="Hazır" />
        </telerik:RadGrid>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DEMOConnectionString %>"
            SelectCommand="SELECT modul_kodu, ekran_kodu, window_adi, ekran_adi, ekran_adi_e, ekran_adi_f, ekran_adi_d, ekran_tipi, ust_ekran_kodu FROM [sisekr]"
            InsertCommand="INSERT INTO [sisekr] (modul_kodu, ekran_kodu, window_adi, ekran_adi, ekran_adi_e, ekran_adi_f, ekran_adi_d, ekran_tipi, ust_ekran_kodu) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
            UpdateCommand="UPDATE [sisekr] SET [window_adi] = ? , [ekran_adi] = ?, [ekran_adi_e] = ? , [ekran_adi_f] = ? , [ekran_adi_d] = ? , [ekran_tipi] = ? , [ust_ekran_kodu] = ? WHERE [modul_kodu] = ? [and ekran_kodu] = ? "
            DeleteCommand="DELETE [sisekr] WHERE [modul_kodu] = ? and [ekran_kodu] = ?"
            ProviderName="System.Data.SqlClient" DataSourceMode="DataSet"  DeleteCommandType="Text" UpdateCommandType="Text" InsertCommandType="Text">
            <InsertParameters>
                <asp:Parameter Name="modul_kodu" Type="String" />
                <asp:Parameter Name="ekran_kodu" Type="String" />
                <asp:Parameter Name="window_adi" Type="String" />
                <asp:Parameter Name="ekran_adi" Type="String" />
                <asp:Parameter Name="ekran_adi_e" Type="String" />
                <asp:Parameter Name="ekran_adi_f" Type="String" />
                <asp:Parameter Name="ekran_adi_d" Type="String" />
                <asp:Parameter Name="ekran_tipi" Type="String" />
                <asp:Parameter Name="ust_ekran_kodu" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="window_adi" Type="String" />
                <asp:Parameter Name="ekran_adi" Type="String" />
                <asp:Parameter Name="ekran_adi_e" Type="String" />
                <asp:Parameter Name="ekran_adi_f" Type="String" />
                <asp:Parameter Name="ekran_adi_d" Type="String" />
                <asp:Parameter Name="ekran_tipi" Type="String" />
                <asp:Parameter Name="ust_ekran_kodu" Type="String" />
                <asp:Parameter Name="modul_kodu" Type="String" />
                <asp:Parameter Name="ekran_kodu" Type="String" />
            </UpdateParameters>
            <DeleteParameters>
                <asp:Parameter Name="modul_kodu" Type="String" />
                <asp:Parameter Name="ekran_kodu" Type="String" />
            </DeleteParameters>
        </asp:SqlDataSource>

Besides, the example uses sds:SessionDataSource. is it the reason of the error ?

Thanks

[Princy]

Hi,

Try replacing the parameters using variables rather than '?' as given in the example in the following code library submission:
Automatic operations with SqlDataSource control

Thanks
Princy.

[burak]

Thanks for your answer... It's solved... :)