not find control RadDatePicker1 in ControlParameter In Gridview

[noyan]

 I am trying to put raddatetime picker and some other control inside my Gridview for editing purpose but always getting errors like in subject could not find control inside gridview pls help me how can I solve this problem. All help will be appreciated and thank you in advance

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
            DataSourceID="SqlDataSource1" DataKeyNames="ID"
            PageSize="20"  >
            <PagerSettings Position="TopAndBottom" />
            <Columns>
                <asp:CommandField ButtonType="Button" CancelText="Çık" EditText="Düzenle"
                    ShowEditButton="True" UpdateText="Güncelle" />
                <asp:TemplateField HeaderText="ID" InsertVisible="False" SortExpression="ID">
                    <ItemTemplate>
                        <asp:Label ID="Label8" runat="server" Text='<%# Bind("ID") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="UserName" SortExpression="UserName">
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("UserName") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Name" SortExpression="Name">
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("Name") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="SicilNo" SortExpression="SicilNo">
                    <ItemTemplate>
                        <asp:Label ID="Label3" runat="server" Text='<%# Bind("SicilNo") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="CartNo" SortExpression="CartNo">
                    <EditItemTemplate>
                 <asp:TextBox ID="txtCard" runat="server" Text='<%# Bind("CartNo") %>'
                   ToolTip="5 karakter" Width="50px"></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label4" runat="server" Text='<%# Bind("CartNo") %>'></asp:Label>
                    </ItemTemplate>
                    <ItemStyle Width="50px" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="CartNoStartDate"
                    SortExpression="CartNoStartDate">
                    <EditItemTemplate>
                        <telerik:RadDatePicker ID="RadDatePicker1" SelectedDate='<%# Bind("CartNoStartDate") %>' runat="server">
                        </telerik:RadDatePicker>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label5" runat="server" Text='<%# Bind("CartNoStartDate") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="CartNoEndDate" SortExpression="CartNoEndDate">
                    <EditItemTemplate>
                        <telerik:RadDatePicker ID="RadDatePicker2" SelectedDate='<%# Bind("CartNoEndDate") %>' runat="server">
                        </telerik:RadDatePicker>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label6" runat="server" Text='<%# Bind("CartNoEndDate") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="IsDeleted" SortExpression="IsDeleted">
                    <EditItemTemplate>
                        <asp:DropDownList ID="ddlBool" runat="server" SelectedValue= '<%# Bind("IsDeleted") %>'>
                        <asp:ListItem Text="Evet" Value="1" />
                        <asp:ListItem Text="Hayır" Value="0" />
                        </asp:DropDownList>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label7" runat="server" Text='<%# Bind("IsDeleted") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:pdksConnectionString %>"
            SelectCommand="SELECT UserName, Name, SicilNo, CartNo, CartNoStartDate, CartNoEndDate, IsDeleted, ID FROM Users WHERE (SicilNo LIKE '%' + @SicilNo + '%') OR (UserName LIKE '%' + @username + '%') ORDER BY Name, SicilNo, CartNo"
            UpdateCommand="UPDATE Users SET CartNoEndDate = @CardNoEndDate, CartNoStartDate = @CardNoStartDate,CartNo = @CartNo,IsDeleted = @IsDeleted WHERE (ID = @ID)"
            InsertCommand="INSERT INTO Users(UserName, Name, SicilNo, CartNo, CartNoStartDate, CartNoEndDate, IsDeleted, vardiya) VALUES (@username, @name, @SicilNo, @CartNo, GETDATE(), @CartNoEndDate, 0, 1)">
            <SelectParameters>
                <asp:ControlParameter ControlID="txtSicil" DefaultValue="NULL" Name="SicilNo"
                    PropertyName="Text" Type="String" />
                <asp:ControlParameter ControlID="txtSicil" DefaultValue="" Name="username"
                    PropertyName="Text" />
            </SelectParameters>
            <DeleteParameters>
                <asp:Parameter Name="ID" />
            </DeleteParameters>
            <UpdateParameters>
               <asp:ControlParameter ControlID="RadDatePicker1"
                    ConvertEmptyStringToNull="False" DbType="DateTime" DefaultValue=""
                    Name="CardNoStartDate" PropertyName="SelectedDate" />
                <asp:ControlParameter ControlID="RadDatePicker2"
                    ConvertEmptyStringToNull="False" DbType="DateTime" DefaultValue=""
                    Name="CardNoEndDate" PropertyName="SelectedDate" />
                <asp:ControlParameter ControlID="txtCard"
                    ConvertEmptyStringToNull="False" DbType="String" DefaultValue=""
                    Name="CartNo" PropertyName="Text" />
                <asp:ControlParameter ControlID="ddlBool"
                    ConvertEmptyStringToNull="False" DbType="Boolean" DefaultValue=""
                    Name="IsDeleted" PropertyName="Value" />
                <asp:ControlParameter ControlID="GridView1" DefaultValue="0" Name="ID"
                    PropertyName="SelectedValue" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="username" />
                <asp:Parameter Name="name" />
                <asp:Parameter Name="SicilNo" />
                <asp:Parameter Name="CartNo" />
                <asp:Parameter Name="CartNoEndDate" />
            </InsertParameters>
        </asp:SqlDataSource>

[Pavlina]

Hello,

Binding a RadDatePicker to a data source is easy provided you use the DbSelectedDate property.  It works almost like the SelectedDate one, but will not throw an exception when it has been given a null value.
Data binding
Online demo

I hope this information helps.

Best wishes,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.