I am using this example

 

http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/Filtering/radgrid-filtered-by-radcombobox

I want to choose the data for the grid by selecting an item in a drop down list.

I want to initialise the grid from the code behind.

How do I do this? My grid is not refreshing at the moment.

This is the code for my aspx page

 

<div class="panel panel-primary">
<div class="panel-heading">
Your Notes
</div>
</div>
<telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanelN"></telerik:RadAjaxLoadingPanel>
<telerik:RadDropDownList runat="server" ID="RadDropDownStudents" DefaultMessage="Select a student" DropDownWidth="300px" Width="350px"
DataValueField="student_id" DataTextField="Studentname" OnItemSelected="RadDropDownStudents_ItemSelected"
OnSelectedIndexChanged="RadDropDownStudents_SelectedIndexChanged" AutoPostBack="true">
</telerik:RadDropDownList>
<telerik:RadGrid runat="server" ID="RadGridNotes" ShowFooter="false" Width="100%" enableajax="true" ShowStatusBar="true" OnItemCommand="Grid_RowSelect"
allowaddingrecords="false" AutoGenerateColumns="false" AllowSorting="false" allowpagesizeselection="False" OnItemDataBound="OnItemDataBoundHandler" Autobind="false"
AllowPaging="True" Skin="Bootstrap" PageSize="5" OnNeedDataSource="RadGridNotes_NeedDataSource" OnPreRender="RadGridNotes_PreRender" CssClass="table table-striped">
<MasterTableView AutoGenerateColumns="false" DataKeyNames="note_ref" TableLayout="Auto" EditMode="EditForms">
<Columns>
<telerik:GridButtonColumn CommandName="View" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" Text="View" UniqueName="View">
</telerik:GridButtonColumn>
<telerik:GridBoundColumn DataField="note_ref" DataType="System.Int32" HeaderText="note_ref" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" UniqueName="note_ref" Display="false" runat="server" ReadOnly="true">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="course" HeaderText="code" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" UniqueName="course" Display="false" runat="server" ItemStyle-Width="10px" HeaderStyle-Width="10px">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="courseName" HeaderText="Subject" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" UniqueName="qualname" HeaderStyle-Width="200px" ItemStyle-Width="200px" ItemStyle-HorizontalAlign="Left" ItemStyle-Wrap="true">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="NewNoteType" HeaderText="Type" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" UniqueName="noteType" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="typeDesc" HeaderText="Note Type" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" UniqueName="typeDesc" ItemStyle-HorizontalAlign="Left" ItemStyle-Wrap="true">
</telerik:GridBoundColumn>
<telerik:GridDateTimeColumn DataField="created" HeaderText="Created" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" UniqueName="created" DataFormatString="{0:dd/MM/yyyy}">
</telerik:GridDateTimeColumn>
<telerik:GridBoundColumn DataField="created_by" HeaderText="Created" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" UniqueName="created_by" Display="false" ItemStyle-HorizontalAlign="Left">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="note_content" HeaderText="Created" HeaderStyle-BackColor="#428bca" HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true" HeaderStyle-HorizontalAlign="Center" HeaderStyle-VerticalAlign="Middle" UniqueName="note_content" Display="false" ItemStyle-HorizontalAlign="Center">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings EditFormType="Template">
<EditColumn UniqueName="View">
</EditColumn>
<FormTemplate>
<table style="width: 100%" border="0">
<tr>
<td><b>Details</b><br /><br />
<asp:Label ID="LabelDetails" runat="server" Text='<%# Bind("note_content") %>'></asp:Label>
</td>
</tr>
</table>
</FormTemplate>
</EditFormSettings>
<PagerStyle Mode="NextPrev" Position="Bottom" PageSizeControlType="RadComboBox"></PagerStyle>
</MasterTableView>
<ClientSettings EnablePostBackOnRowClick="True">
<Selecting AllowRowSelect="True" />
<ClientEvents OnRowDblClick="RowDblClick" OnRowSelected="RowSelected" />
</ClientSettings>

 

Hi,

I am creating a multiple ComboBox. RadComboBox1 for region and the other RadComboBox2 for product. Both controllers have a checkbox option. Sample data as per below;

RadComboBox1;
A
B
C

RadComboBox2;
1
2
3

What do I need are, when user choose Region [A,C] and product [1,2,3], the result would be [A1,A2,A3,C1,C2,C3]. Please help.

 

Thanks.

 

 

 

To whoever cares:

Why don't  you just get rid of the Telerik name and quit moving incrementally in that direction. The need to stamp Progress on everything is now literally moving useful information out of sight.

 

 

Unable to get property 'trackChanges' of undefined or null reference in IE 9 and above and chrome.   No issues in IE 8.  Using jQuery on page load. 

var resultsDropDowlist = Terlerk.web.UI.RadComboBox.ComboBoxes[2];

resultsDropDownlist.trackChanges();

//To Clear the Selected Item

resultsDropDownList.get_items().clear();

Hello!

I try to create dynamic url like https://mylink.com/?parameter1={0}&parameter2={1}, but I can get only single parameter  from field DataNavigateUrlFields="myfield".

Any ideas?

After that, I tried to resolve my issue dynamically with code:

protected void OrdersRadGrid_ItemDataBound(object sender, GridItemEventArgs e)
        {
            if (e.Item is GridDataItem)
            {
                GridDataItem item = (GridDataItem)e.Item;

                TableCell tb = item["item1"];
                HyperLink lnk = new HyperLink();
                lnk.ID = "routeId";
                lnk.Text = item["item1"].Text;
                string str1 = item["item2"].Text;
                string str2 = item["item3"].Text;
                lnk.NavigateUrl = string.Format("https://mylink.com/?parameter={0}{1}", str1, str2);
                tb.Controls.Clear();
                tb.Controls.Add(lnk);

}

}

But, I get an interesting bug: in construction item["item"].Text not all fields displays correct. In debugger, i can see in the item all the fields with their correct values. But some of them (right these I need to use!), give me '&nbsp' value. Thus, expression siring str=item["item1"].Text returns me value '&nbsp' (not in all text type fields, but only in several in the same item). May it be encoding problem? Or any other ideas?

               

 

 

I am getting the following error message sometimes when my scheduler is trying to display.  I am feeding it a dataset with start and end dates that traverse anywhere from one day to many weeks.  All of the data looks good and no end dates are less than the start dates.  Are there any quick things I could check to fix this.

I have implemented a custom appointment comparing class and when I use this the scheduler does initially display all values, but once I click to access anything else I get the error below.

Please help when you can.

Error:
Unable to sort because the IComparer.Compare() method returns inconsistent results. Either a value does not compare equal to itself, or one value repeatedly compared to another value yields different results. IComparer: 'Telerik.Web.UI.AppointmentComparer'.

Type:
System.ArgumentException

Stack Trace:
at System.Collections.Generic.IntrospectiveSortUtilities.ThrowOrIgnoreBadComparer(Object comparer)
at System.Collections.Generic.ArraySortHelper`1.Sort(T[] keys, Int32 index, Int32 length, IComparer`1 comparer)
at System.Collections.Generic.List`1.Sort(Int32 index, Int32 count, IComparer`1 comparer)
at Telerik.Web.UI.Scheduler.Views.Month.Model.CreateDaySlot(DateTime dayStart, DateTime dayEnd, Int32 dayIndex, DateTime weekStart, IList`1 trimmedAppointments)
at Telerik.Web.UI.Scheduler.Views.Month.Model.DataBind(AppointmentCollection appointments)
at Telerik.Web.UI.RadScheduler.CreateContent()
at Telerik.Web.UI.RadScheduler.CreateChildControls(Boolean bindFromDataSource)
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.FindControl(String id, Int32 pathOffset)
at System.Web.UI.Page.ProcessPostData(NameValueCollection postData, Boolean fBeforeLoad)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I have a ComboBox that I would like to change the Text value on the client side using JavaScript.  How can I go about setting the text of a CB by passing a custom parameter.  I would like this to be a universal function so I need to find the object calling the function, set the Substring value based on a passed parameter, and then set the text property of the CB to that.  For example, options are:  

1 | Item 1

2 | Item 2

3 | Item 3

On the event OnClientSelectedIndexChanged I would like to change the text to only the left character.  What I am looking for is something like this, but works:

Hello, 

I am currently using the checkbox template column to bind a boolean column which seems to be working fine except for one major problem. 

When I click the checkbox (changed state) I will have to click multiple times around and/or above the checkbox row location to trigger the edited flag.

I need the flag triggered in order to call my batch edit save button function. (Batch save wont trigger without having edit flag up)

Everything seems to be binding properly without issue but except for getting the flag to trigger. Again, only multiple clicks around the checkbox will finally trigger the flag (exact position isn't clear). 

 

Best, 

-R

 

ASP Code:

 

<telerik:GridTemplateColumn ColumnEditorID="CompletedBox" Reorderable="true" AllowSorting="true" HeaderText="Complete" >
                  <HeaderStyle Width="60px" />
                  <ItemStyle CssClass="float-right" />
                   <ItemTemplate> 
                    <asp:CheckBox ID="CheckBox3" runat="server" Checked='<%# Bind("CompletedAsBool") %>' /> 
                   </ItemTemplate>
                  <EditItemTemplate >
                    <asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("CompletedAsBool") %>' />
                  </EditItemTemplate>
</telerik:GridTemplateColumn>

Hi,
On client side  button click event, I want to get control id that are place in Item template of List-view

Hi 
I have a RadTabStrip with 3 tabs which has a User Control on each tab. Each User Control has a Radgrid on it, I am trying to add filtering to some of the columns. The filters are showing but has no response when entering anything in them, they just don't do anything at all..
Please advise me on this, here is my markup:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="RadGridsUserControlCS.ascx.cs" Inherits="RadGridsUserControlCS1" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>

<div>

    <asp:Label ID="lblEmpID" runat="server"></asp:Label>

    <br />
    <br />

    <asp:Label ID="Label1" runat="server" Text="Project:"></asp:Label>

    <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource4" DataTextField="projno" DataValueField="dbcsuffix">
    </asp:DropDownList>

    <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:DMCONFIGConnectionString %>" SelectCommand="SELECT projno, dbcsuffix FROM fProject"></asp:SqlDataSource>

    <br />

    <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="gridFilesDisplay" >
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="gridFilesDisplay" LoadingPanelID="RadAjaxLoadingPanel1" />                
                </UpdatedControls>          
            </telerik:AjaxSetting>      
        </AjaxSettings>
    </telerik:RadAjaxManagerProxy>

    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Vista" ></telerik:RadAjaxLoadingPanel>

    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

        <script type="text/javascript">

            function onRequestStart(sender, args)
            {
                if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 || args.get_eventTarget().indexOf("ExportToPdfButton") >= 0)
                {
                    args.set_enableAjax(false);
                }
            }

        </script>    

         <script type="text/javascript">

             function openDocumentComments(position, Documentno)
             {
                 var oWnd = radopen("DocumentComments.aspx?position=" + position, + "&Documentno=" + Documentno, "DocumentComments");
                 oWnd.center();
             }

             function RefreshPageForGrid()
             {
                 window.location.href = "RadGridsUserControlCS.aspx";
             }

         </script> 

        <script  type="text/javascript">

                    Sys.Application.add_load(AppLoad);

                    function AppLoad() {
                        Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequest);
                        Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(BeginRequest);
                    }

                    function BeginRequest(sender, args) {
                        // Clear the error if it's visible from a previous request.
                        if ($get('Error').style.visibility == "visible")
                            CloseError();
                    }

                    function EndRequest(sender, args) {
                        // Check to see if there's an error on this request.
                        if (args.get_error() != undefined) {
                            // If there is, show the custom error.
                            $get('Error').style.visibility = "visible";

                            // Let the framework know that the error is handled, 
                            //  so it doesn't throw the JavaScript alert.
                            args.set_errorHandled(true);
                        }
                    }

                    function CloseError() {
                        // Hide the error div.
                        $get('Error').style.visibility = "hidden";
                    }
        </script>

    </telerik:RadCodeBlock>

    <telerik:RadWindowManager ID="RadWindowManager1" runat="server" Skin="Vista">

        <Windows>

            <telerik:RadWindow Skin="Vista" ID="DocumentComments" runat="server" Title="Document Comments"
                Height="400px" Width="300px" Left="150px" ReloadOnShow="true" Modal="true" 
                OpenerElementID="btnProjReject" NavigateUrl="~/DocumentComments.aspx"/>

        </Windows>

    </telerik:RadWindowManager>

    <br />

</div>

<div>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            

            <telerik:RadGrid ID="gridFilesDisplay" 
                Skin="WebBlue" 
                runat="server" 
                AutoGenerateColumns="False" 
                OnNeedDataSource="gridFilesDisplay_NeedDataSource" 
                OnItemCommand="gridFilesDisplay_ItemCommand" 
                OnPreRender="gridFilesDisplay_PreRender" 
                OnLoad="gridFilesDisplay_Load"
                OnItemDataBound="gridFilesDisplay_ItemDataBound" 
                AllowFilteringByColumn="True">

                    <ClientSettings EnablePostBackOnRowClick="true">
                        <Selecting AllowRowSelect="True" />
                    </ClientSettings>

                    <MasterTableView DataKeyNames="position" CommandItemDisplay="Top">

                        <DetailTables>

                            <telerik:GridTableView DataKeyNames="position,category" DataSourceID="SqlDataSource2" Width="100%" runat="server" Name="Categories">

                                <DetailTables>
                                    <telerik:GridTableView runat="server" DataKeyNames="position,category" DataSourceID="SqlDataSource3" Name="Documents" Width="100%">

                                        <ParentTableRelation>
                                            <telerik:GridRelationFields DetailKeyField="category" MasterKeyField="category" />
                                        </ParentTableRelation>

                                        <Columns>

                                            <telerik:GridTemplateColumn DataType="System.Char"  UniqueName="DocumentComments" DataField="DocumentComments" AllowFiltering="false" FilterControlAltText="test"><%--HeaderText="Appr/Reject"--%>

                                               <ItemTemplate>

                                                   <a href="#"  style="text-decoration:none; color: red" onclick="openDocumentComments('<%# DataBinder.Eval(Container.DataItem, "position") %>, <%# DataBinder.Eval(Container.DataItem, "Documentno") %>'); return false;">Reviewed</a> 
                                               
                                               </ItemTemplate>
                           
                                                <EditItemTemplate>

                                                    <%--<asp:Button runat="server" ID="btnDocApprove" Text="Approve" Width="60px" OnClick="btnDocApprove_Click" />--%>

                                                    <%--<a href="#" onclick="openDocRadWindow('<%# DataBinder.Eval(Container.DataItem, "WBSEmpDocId") %>', '<%# DataBinder.Eval(Container.DataItem, "LineNbr") %>'); return false;" style="color: red">Reject</a>--%>

                                                </EditItemTemplate>

                                                <HeaderStyle Width="12%" Font-Bold="True" />
                                                <ItemStyle Font-Bold="true" HorizontalAlign="Center"/>

                                            </telerik:GridTemplateColumn>


                                            <telerik:GridBoundColumn DataField="position" HeaderText="Position" UniqueName="position" Visible="false" AllowFiltering="false">
                                                
                                            </telerik:GridBoundColumn>

                                            <telerik:GridBoundColumn DataField="category" HeaderText="Category" UniqueName="category" Visible="false" AllowFiltering="false">
                                                
                                                <HeaderStyle Font-Bold="true" />
                                            </telerik:GridBoundColumn>

                                            <telerik:GridBoundColumn DataField="Documentno" HeaderText="Document No" UniqueName="Documentno" AllowFiltering="true">
                                                
                                                <HeaderStyle Font-Bold="true" Width="10%" />
                                            </telerik:GridBoundColumn>

                                            <telerik:GridBoundColumn DataField="Rev_Now" HeaderText="Rev Now" UniqueName="Rev_Now" AllowFiltering="false">
                                                
                                                <HeaderStyle Font-Bold="true" Width="10%" />
                                            </telerik:GridBoundColumn>

                                            <telerik:GridBoundColumn DataField="STS_Now" HeaderText="STS Now" UniqueName="STS_Now" AllowFiltering="false">
                                                
                                                <HeaderStyle Font-Bold="true" Width="10%" />
                                            </telerik:GridBoundColumn>

                                            <telerik:GridBoundColumn DataField="MDR_Title" HeaderText="MDR Title" UniqueName="MDR_Title" AllowFiltering="true" FilterControlWidth="100px" >
                                                
                                                <HeaderStyle Font-Bold="true" Width="35%" />
                                            </telerik:GridBoundColumn>

                                            <telerik:GridBoundColumn DataField="storename" HeaderText="storename" UniqueName="storename" Visible="false" AllowFiltering="false">
                                                
                                                <HeaderStyle Font-Bold="true" />
                                            </telerik:GridBoundColumn>

                                            <telerik:GridTemplateColumn HeaderText="Download Document" AllowFiltering="false">

                                                <ItemTemplate>
                                                    <asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("storename") %>' CommandName="DownloadMyFile" Text="Download"></asp:LinkButton>
                                                    <%--<telerik:RadButton RenderMode="Lightweight" ID="DownloadMyFile" OnClientClicked="DownloadMyFile" CommandName="DownloadMyFile" Text="Download" AutoPostBack="false" runat="server" Width="90px">
                                                    </telerik:RadButton>--%>
                                                    <%--Text='<%# Eval("storename") %>'--%>
                                                </ItemTemplate>

                                                <HeaderStyle Font-Bold="true" />
                                            </telerik:GridTemplateColumn>

                                        </Columns>

                                    </telerik:GridTableView>
                                </DetailTables>

                                <ParentTableRelation>

                                    <telerik:GridRelationFields DetailKeyField="position" MasterKeyField="position"></telerik:GridRelationFields>

                                </ParentTableRelation>

                                <Columns>

                                    <telerik:GridBoundColumn HeaderText="Position" DataField="position" UniqueName="position" Visible="false" AllowFiltering="false">
                                        
                                    </telerik:GridBoundColumn>

                                    <telerik:GridBoundColumn HeaderText="Category" DataField="category" UniqueName="category" AllowFiltering="false">
     
                                        <HeaderStyle Width="10%" Font-Bold="true" />

                                    </telerik:GridBoundColumn>

                                    <telerik:GridBoundColumn HeaderText="Category Description" DataField="categorydesc" UniqueName="categorydesc" AllowFiltering="false">

                                        <HeaderStyle Width="90%" Font-Bold="true" />

                                    </telerik:GridBoundColumn>

                                </Columns>

                            </telerik:GridTableView>

                        </DetailTables>

                        <Columns>

                            <telerik:GridBoundColumn HeaderText="Position" DataField="position" UniqueName="position" Visible="false" AllowFiltering="false">
                                
                            </telerik:GridBoundColumn>

                            <telerik:GridBoundColumn HeaderText="First Name" DataField="firstname" UniqueName="firstname" AllowFiltering="false">

                                <HeaderStyle Width="20%" Font-Bold="true" />

                            </telerik:GridBoundColumn>

                            <telerik:GridBoundColumn HeaderText="Last Name" DataField="lastname" UniqueName="lastname" AllowFiltering="false">

                                <HeaderStyle Width="80%" Font-Bold="true" />

                            </telerik:GridBoundColumn>

                        </Columns>
                    </MasterTableView>

            </telerik:RadGrid>

            <asp:Button ID="btnApprove" runat="server" Text="Approve" Visible="false" OnClick="btnApprove_Click" />

        </ContentTemplate>
    </asp:UpdatePanel>
</div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DocViewConnectionString %>"
    DeleteCommand=""
    InsertCommand=""
    SelectCommand="xLevel1Names" SelectCommandType="StoredProcedure"
    UpdateCommand="" UpdateCommandType="Text" >
       
    <SelectParameters>

        <asp:SessionParameter Name="User" SessionField="User" Type="String" />
      <%--  <asp:SessionParameter Name="User" SessionField="User" Type="String" />--%>

    </SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:DocViewConnectionString %>"
    DeleteCommand=""
    InsertCommand=""
    SelectCommand="xLevel2Categories" SelectCommandType="StoredProcedure"
    UpdateCommand="" UpdateCommandType="Text" >
       
    <SelectParameters>

        <asp:SessionParameter Name="User" SessionField="User" Type="String" />

    </SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:DocViewConnectionString %>"
    DeleteCommand=""
    InsertCommand=""
    SelectCommand="xLevel3Docs" SelectCommandType="StoredProcedure"
    UpdateCommand="" UpdateCommandType="Text" >
       
    <SelectParameters>

        <asp:SessionParameter Name="User" SessionField="User" Type="String" />

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

    </SelectParameters>

</asp:SqlDataSource>

<br />

<asp:Label ID="lblMessage" runat="server"></asp:Label>