GridView Select

Please i am trying to find out if its possible to select a row in a parent gridview and once that is selected....all the other rows in the Parent gridview is invisible...and the one i am working with is only seen on the gridview at that time.

Re: GridView Select

you can hide the other rows by setting Visible as false to other rows.

can you explain the requirement little more pls.

Re: GridView Select

Alright,

I currently have a gridview binded to the database which is the parent and when its selected it post the child based on the ID.Now i have couple records on the gridview and once i select the one i need i want the others to be invinsible. so the one i am working on will show alone. using visible="flase" will work for the whole Gridview,

I hope you understand.

Re: GridView Select

What I understood from your description was

You are using a nested gridview in which you are doing a postback to load some child gridview and once you select the row in the child gridview,

You want to hide the others.

You can do like this

find the Child gridview in the code behind and in the selectedIndexChangedEvent,

find the Gridviewrow selected and then

gv.Rows.OfType<GridViewRow>().ToList().Where(a=>a.RowIndex !=row.RowIndex).ToList().ForEach(b=>b.Visible=false)

it will get all the rows in teh child gridview and hide all rows except the row selected.

Correct me if I understood your requirement wrong.

Re: GridView Select

Yeah... You kind of onpoint but not quite... You are right about the nested grid. and i can only see my child grid based on the selection i make on the parent grid. Now.... once i select a row from the Parent grid.....it will automatically show me the child grid based on the selection

Now my point is... if i have five records on the parent grid and select one of the records.... i only want the selected row to show instead of all the other 4.... Currently its highlights the selected record. but i will like to make the other records invisible while another record is seleted....

I hope i explained better this time around

Re: GridView Select

In the Parent gridview selected index change event,

get the row index from e.CommandArgument and then you can do like this

gridviewParent.Rows.OfType<GridViewRow>().ToList().Where(a=>a.RowIndex !=selectedRowIndex.RowIndex).ToList().ForEach(b=>b.Visible=false)

That should get all rows except selected row and hide other rows.

Re: GridView Select

Thanks Sansan... Am so confused about your syntax.... i used it and it game me errors. The only thing i changed was the gridviewparent to its name on my code....My gridview name is "GridViewAll".... Could you please help write based on my gridview name.... my event handler is "Protected Sub GridviewAll_SelectIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs).....Thanks

Re: GridView Select

u can try like this

protected void GridViewAll_SelectedIndexChanged(object sender, EventArgs e)
        {
            GridViewAll.Rows.OfType<GridViewRow>().ToList().
                        Where(a => a.RowIndex != GridViewAll.SelectedIndex).
                        ToList().ForEach(b => b.Visible = false);
        }

Thanks

Re: GridView Select

Thanks Again Sansan, just so you know .. i am using asp 3.5 so my handler will not accept void but sub... when i put in the code... it does not allowe <GridviewRow> and the "a" and "b". i guess it needs to be declared. but i am woundering if it as to do with the event handler. What do you think

Re: GridView Select

If you are using C#,

add using System.Linq;

If you are using VB,

add Imports System.Linq;

Protected Sub GridViewAll_SelectedIndexChanged(sender As Object, e As EventArgs)
	GridViewAll.Rows.OfType(Of GridViewRow)().ToList().Where(Function(a) a.RowIndex <> GridViewAll.SelectedIndex).ToList().ForEach(Function(b) b.Visible= False)
End Sub

Hope this helps

Re: GridView Select

Hi oluts ...

Try this

Protected Sub GridViewAll_SelectedIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSelectEventArgs) Handles GridView1.SelectedIndexChanging
GridViewAll.Rows.OfType(Of GridViewRow)().ToList().Where(Function(a) a.RowIndex <> GridViewAll.SelectedIndex).ToList().ForEach(Function(b) b.Visible = False)
End Sub

Re: GridView Select

Thanks Again and am so sorry if it taken me so long to get this.. .i am new to ASP. i tried the code and nothing happens. this is my event handler

Protected Sub GridViewAll_SelectedIndexChanged(ByVal sender As Object, ByVal e As System. EventArgs)


And also how do i add "Import system.linq

Re: GridView Select

add that import at the beginning of the class

Imports System.Linq

and use this

Protected Sub GridViewAll_SelectedIndexChanged(ByVal sender As Object, ByVal e As System. EventArgs) Handles GridView1.SelectedIndexChanged

Re: GridView Select

Hisham,

Thanks Your code did not work either. Not sure whats wrong...

Re: GridView Select

can you please post the code that you have written.

Re: GridView Select

Protected Sub GridViewAll_SelectedIndexChanged(ByVal sender As Object, ByVal e As System. EventArgs) Handles GridViewAll.SelectedIndexChanged

Imports System.Linq()

GridViewAll.Rows.OfType(Of GridViewRow)().ToList().Where(Function(a) a.RowIndex <> GridViewAll.SelectedIndex).ToList().ForEach(Function(b) b.Visible = False)

End Sub.

This does not work either

Re: GridView Select

what do you mean by not working.

Did you set a breakpoint and see if that code is working.

what did you use for showing select button.

can you post the parent gridview code.

Thanks.

Re: GridView Select

Sansan,

Sorry what i mean by not working is that .... with the code being there it does not perform what is intended. so pretty much its not working. here is my gridview code

<asp:GridView ID="GridViewAll" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="RelationshipAll" ForeColor="#333333" OnRowDeleting="GridviewAll_rowdeleting"

GridLines="None" Visible ="False" onselectedindexchanged="GridViewAll_SelectedIndexChanged" style="text-align: center; margin-bottom: 0px; margin-left: 59px;" Width="1109px" Height="215px" DataKeyNames="recordid,banknumber">

<AlternatingRowStyle BackColor="White" ForeColor="#284775" />

<Columns>

<asp:TemplateField ShowHeader="false">

<ItemTemplate>

<asp:Button ID="butEntityEdit" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" Font-Size="Smaller" Height="25px" style="font-size: x-small; font-weight: 700;" Width="50px" />

<asp:Button ID="BtnDelete" runat="server" CausesValidation="false" CommandName="Delete" Text="Delete" OnClientClick="return confirm('Delete this record?');" Font-Size="Smaller" Height="25px" style="font-size: x-small; font-weight: 700;" Width="50px"/>

</ItemTemplate>

<EditItemTemplate>

<asp:Button ID="butEntityUpdate" runat="server" CausesValidation="True" CommandName="Update" Text="Update" ValidationGroup="ValidGrpEntityUpdt" Height="25px" Width="50px" style="font-size: x-small; font-weight: 700; color: #FF0000;" />

 <asp:Button ID="butEntityCancel" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" Height="25px" Width="50px" style="font-size: x-small; font-weight: 700; color: #FF0000;" />

</EditItemTemplate>

<HeaderTemplate>

<asp:Button ID="butAddEntity" runat="server" CommandName="Insert" Font-Size="Smaller" Height="25px" style="font-weight: 700; color: #0066FF; font-size: x-small;" Text=" Add " ValidationGroup="ValidGrpEntityAdd" Width="50px" OnClick="butAddEntity_Click"/>

 <asp:Button ID="butCancel" runat="server" CausesValidation="False" CommandName="Cancel" Font-Size="Smaller" Height="25px" style="color: #000099; font-weight: 700; font-size: x-small;" Text="Return" Width="50px" />

</HeaderTemplate>

<HeaderStyle Wrap="False" />

</asp:TemplateField>

<asp:TemplateField HeaderText="RecordId" SortExpression="RecordId" Visible="False">

<ItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("RecordId") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:Label ID="lblAcctLegalID" runat="server" Text='<%# Eval("RecordId") %>'></asp:Label>

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="BankName" InsertVisible="False" SortExpression="BankNumber" Visible="False">

<ItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Bind("BankNumber") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:Label ID="lblAcctID" runat="server" Text='<%# Eval("BankNumber") %>'></asp:Label>

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="BankNum" SortExpression="BankNum">

<EditItemTemplate>

<asp:TextBox ID="TxtEditBankNum" runat="server" Enabled="False" style="font-size: small" Text='<%# Bind("BankNumber") %>' Width="100px" Wrap="False"></asp:TextBox>

</EditItemTemplate>

<HeaderTemplate >

<asp:Label ID="lblAddBankNum" runat="server" style="font-size: small; font-weight: 700; text-align: left;" Text="Bank"></asp:Label>

<br />

<asp:DropDownList ID="dropAddBankNum" runat="server" AutoPostBack="True" CssClass="style4" DataSourceID="bankcodes" DataTextField="BankDirectory" DataValueField="Bank_Number" onselectedindexchanged="gridview2_SelectedIndexChanged"

SelectedValue='<%# Bind("Bank_Number") %>' style="font-size: x-small" TabIndex="2" AppendDataBoundItems="true" Width="100px" Height="23px">

</asp:DropDownList>

</HeaderTemplate>

<ItemTemplate>

<asp:Label ID="lblBankNum" runat="server" Text='<%# Bind("BankNumber") %>' Width="100px"></asp:Label>

</ItemTemplate>

<HeaderStyle HorizontalAlign="Left" />

</asp:TemplateField>

<asp:TemplateField HeaderText="NoteAccountNumber" SortExpression="NoteAccountNumber">

<ItemTemplate>

<asp:Label ID="lblAcctNoteNum" runat="server" Height="17px" Text='<%# Bind("NoteAccountNumber") %>' Width="150px"></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="txtEditAcctNumber" runat="server" Enabled="False" Text='<%# Bind("NoteAccountNumber") %>' Width="150px" Wrap="False"></asp:TextBox>

</EditItemTemplate>

<HeaderTemplate>

<asp:Label ID="lblAddAcctNum" runat="server" style="font-size: small; font-weight: 700; text-align: left;" Text="Account Number"></asp:Label>

<br />

<asp:DropDownList ID="dropAddAcctNumber" runat="server" CssClass="style4" DataSourceID="Riskfactordaily" DataTextField="Balanceinfo" OnDataBound ="DropAddacctnum_databound"

DataValueField="NoteAccountNumber" TabIndex="3" Width="400px" AppendDataBoundItems="true" style="font-size: x-small"

Height="23px">

</asp:DropDownList>

</HeaderTemplate>

<HeaderStyle HorizontalAlign="Left" />

</asp:TemplateField>

</Columns>

<EditRowStyle BackColor="#999999" />

<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />

<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />

<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />

<SortedAscendingCellStyle BackColor="#E9E7E2" />

<SortedAscendingHeaderStyle BackColor="#506C8C" />

<SortedDescendingCellStyle BackColor="#FFFDF8" />

<SortedDescendingHeaderStyle BackColor="#6F8DAE" />

</asp:GridView>

Re: GridView Select

Hi again ...

Why it doesn work?!! Are you sure you 're working on ASP.NET 3.5?

about the handler automatically added whenever you clicked the GridView control.

Re: GridView Select

Have you got any errors here? And you maybe post some issues of your problem or debugging information for us through images or words...