hi
How do i show grid value based on select value from a listbox? I am using a stored procedures:
Create PROCEDURE [dbo].[spByInfoID]
@ID varchar(500)
AS
BEGIN
SET NOCOUNT ON;
SELECT * from tblInfo
WHERE ',' + @ID + ',' LIKE '%,' + CAST(infoID AS varchar(10)) + ',%'
I configured radgrid as SQLDatasource using this stored procedures and parameter source is Control and the Control id is a listbox. No default value.
I may have done it the wrong way. But do enlighten me. Thanks
How do i show grid value based on select value from a listbox? I am using a stored procedures:
Create PROCEDURE [dbo].[spByInfoID]
@ID varchar(500)
AS
BEGIN
SET NOCOUNT ON;
SELECT * from tblInfo
WHERE ',' + @ID + ',' LIKE '%,' + CAST(infoID AS varchar(10)) + ',%'
I configured radgrid as SQLDatasource using this stored procedures and parameter source is Control and the Control id is a listbox. No default value.
I may have done it the wrong way. But do enlighten me. Thanks
5 Answers, 1 is accepted
0

Princy
Top achievements
Rank 2
answered on 06 Jan 2009, 09:49 AM
Hi L,
I have implemented the desired scenario as shown below. Here I have bound the Grid with two fields and set those fields as the DataTextField and DataValueField for the ListBox. The StoredProcedure is receiving infoID from the ListBox.
ASPX:
StoredProcedure:
Hope this helps..
Princy
I have implemented the desired scenario as shown below. Here I have bound the Grid with two fields and set those fields as the DataTextField and DataValueField for the ListBox. The StoredProcedure is receiving infoID from the ListBox.
ASPX:
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" DataSourceID="SqlDataSource2" > |
<MasterTableView Name="RadGrid1" CommandItemDisplay="Top" DataSourceID="SqlDataSource2" > |
<Columns> |
<telerik:GridBoundColumn DataField="infoID " UniqueName="infoID " HeaderText="ID" ></telerik:GridBoundColumn> |
<telerik:GridBoundColumn DataField="LargeString" UniqueName="LargeString" HeaderText="LargeString" ></telerik:GridBoundColumn> |
</Columns> |
</MasterTableView> |
</telerik:RadGrid> |
<asp:ListBox ID="ListBox1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" |
DataTextField="LargeString" DataValueField="infoID "></asp:ListBox> |
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestDbConnectionString %>" |
SelectCommand="SELECT * FROM [tblInfo]"></asp:SqlDataSource> |
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TestDbConnectionString %>" |
SelectCommand="spByInfoID" SelectCommandType="StoredProcedure"> |
<SelectParameters> |
<asp:ControlParameter ControlID="ListBox1" Name="ID" PropertyName="SelectedValue" |
Type="String" /> |
</SelectParameters> |
</asp:SqlDataSource> |
StoredProcedure:
alter PROCEDURE [dbo].[spByInfoID] |
@ID varchar(500) |
AS |
BEGIN |
SET NOCOUNT ON; |
SELECT * from tblInfo |
WHERE ',' + @ID + ',' LIKE '%,' + CAST(infoID AS varchar(10)) + ',%' |
END |
Hope this helps..
Princy
0

L
Top achievements
Rank 1
answered on 06 Jan 2009, 01:45 PM
hi
Sorry if i asked too much. How do i implement this with a click of a button? Meaning i now select some items from the listbox and do a click of a button.
It seems that now is the postback of the listbox.
Thanks
Sorry if i asked too much. How do i implement this with a click of a button? Meaning i now select some items from the listbox and do a click of a button.
It seems that now is the postback of the listbox.
Thanks
0
Accepted

Shinu
Top achievements
Rank 2
answered on 07 Jan 2009, 04:41 AM
Hi L,
The above code performs the operation with the AutoPostBack property of the ListBox. For achieving the desired scenario you just need to set the AutoPostBack property of the ListBox to false and then clicking a button will cause a PostBack which will perform the operation.
Regards
Shinu
The above code performs the operation with the AutoPostBack property of the ListBox. For achieving the desired scenario you just need to set the AutoPostBack property of the ListBox to false and then clicking a button will cause a PostBack which will perform the operation.
Regards
Shinu
0

L
Top achievements
Rank 1
answered on 13 Jan 2009, 06:02 AM
hi
I have noticed from your given code that the listbox's selectionMode is not multi. But my listbox selecetionMode is Multi.
And when i tried selecting multi value it doesn't produce the desire result. thanks
I have noticed from your given code that the listbox's selectionMode is not multi. But my listbox selecetionMode is Multi.
And when i tried selecting multi value it doesn't produce the desire result. thanks
0
Accepted
Hello L,
In this case, you need to alter the select statement to include "AND"/"OR" clauses, which would allow you to include the other values from the listBox.
Sincerely yours,
Yavor
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
In this case, you need to alter the select statement to include "AND"/"OR" clauses, which would allow you to include the other values from the listBox.
Sincerely yours,
Yavor
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.