gridview inside datagrid doen't raise RowCommand event

G

Guest

Hi all!

I have a gridview inside a datagrid (nested) for which (gridview) the
rowcommand is not raised in order to delete a row from the grid!

I also tried OnRowCommand="method", didn't work either!

Does anyone know how can I make this work?

Thanks in advance!
 
G

Guest

Hi,

As long as you bind the datasource for the nested - Inner gridview in
the ItemDataBound event and not in the ItemCreated Event of the outer Data
grid, it shd work...the RowCommand event of the inner Gridview will fire.

// dgMyGrid is my outer DataGrid.
// gvMyGridView is the inner GridView.


protected void dgMyGrid_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternatingItem )
{
((GridView)e.Item.FindControl("gvMyGridView")).DataSource = dt;
((GridView)e.Item.FindControl("gvMyGridView")).DataBind();
}
}

public void gvMyGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
// Your delete code for the RowCommand...

}

In the HTML Source:


<asp:DataGrid ID="dgMyGrid" runat="server" AutoGenerateColumns="false"
OnItemDataBound="dgMyGrid_ItemDataBound" >
<Columns>
<asp:BoundColumn DataField="col1" HeaderText="Colum 1" />
<asp:TemplateColumn HeaderText="Nested GridView Column">
<ItemTemplate >
<asp:GridView ID="gvMyGridView" runat="server"
OnRowCommand="gvMyGridView_RowCommand"
AutoGenerateColumns="false" >
<Columns>
<asp:BoundField DataField="col2"
HeaderText="InnerCol1" />
<asp:BoundField DataField="col3"
HeaderText="InnerCol2"/>
<asp:ButtonField ButtonType="button"
CommandName="Delete"
Text="delete"
HeaderText="Delete" />
</Columns>
</asp:GridView>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>


I guess this shd work...

-Parvathy Padmanabhan
 
G

Guest

oops... sorry,
it's actually a gridview inside a datalist, sorry for that...
I DO bind the gridview inside the datalist's ItemDataBound event and doesn't
work!!!
Please help me out, I can't figure out what is going wrong here!
 
G

Guest

Hi,

The RowCommand event of the inner gridview wld fire, provided you bind
your Datalist in the first request and not again in the subsequent post backs.

//dlMyDataList is the datalist am using and dt is my datatable, which will
be the source.

if (! IsPostBack)
{
dlMyDataList.DataSource = dt;
dlMyDataList.DataBind();
}

if you have bound your datalist on the page load and if you are rebinding it
during every post back, the onRowCommand event will not fire because, the
grid view gets created every single time.

I guess that shd resolve your problem....

- Parvathy Padmanabhan
 
G

Guest

No, I don't!
Well here is my code:

Code:
<asp:datalist id="lstTicketsInfo" cellspacing="0" cellpadding="0" 
repeatdirection="Vertical" enableviewstate="false" runat="Server" >
    <ItemTemplate>
      <asp:gridview id="gvBasket" runat="server"
        CssClass="myGrid" GridLines="None" ShowHeader="True" 
ShowFooter="True" autogeneratecolumns="False" 
OnRowCommand="gvBasket_RowCommand">
        <headerstyle horizontalalign="Right"></headerstyle>
        <rowstyle HorizontalAlign="Right"/>
        <FooterStyle HorizontalAlign="Right"/>
        <columns>
          <asp:TemplateField HeaderText="Quantity">
            <headerstyle horizontalalign="Right"></headerstyle>
            <ItemTemplate><input id="txtQuantity" style="text-align: right;" 
runat="server" Value='<%# Eval("Quantity") %>' /></ItemTemplate>
            <FooterTemplate><input id="txtQuantityTotal" style="text-align: 
right;" readonly="readonly" runat="server" /></FooterTemplate>
          </asp:TemplateField>

          <asp:TemplateField HeaderText="Price">
            <ItemTemplate><asp:Label ID="lblPrice" runat="server" Text='<%# 
Eval("Price") %>'></asp:Label></ItemTemplate>
          </asp:TemplateField>

          <asp:TemplateField HeaderText="Total">
            <ItemTemplate><asp:Label ID="lblTotalSingle" runat="server" 
Text='<%# Eval("Total") %>'></asp:Label></ItemTemplate>
            <FooterTemplate><input id="txtPriceTotal" style="text-align: 
right;" readonly="readonly" runat="server" /></FooterTemplate>
          </asp:TemplateField>

          <asp:TemplateField>
            <ItemTemplate><asp:button id="btnDelete" text="" CommandName = 
"Delete" CommandArgument='<%# Eval("EventID").ToString() & "~" & 
Eval("D13_D05_IDs").ToString() & "|" & Eval("E01_i03_id").ToString() & "~" & 
Eval("E01_index").ToString() %>' runat="server" OnCommand="DeleteTicket" 
/></ItemTemplate>
          </asp:TemplateField>
        </columns>
      </asp:gridview>
  </ItemTemplate>
</asp:datalist>

Code:
Imports System.Data

Partial Class Basket
  Inherits System.Web.UI.Page

  Private m_QuantitySubTotal As Byte
  Private m_PriceSubTotal As Double
  Private WithEvents gvBasket As GridView
  Private m_ActiveGridCounter As Byte

  Private m_QuantityTotal As Byte
  Private m_PriceTotal As Double

  Private ReadOnly Property colBasketItems() As helperclasses.BasketItems
    Get
      If Session("colBasketItems") Is Nothing Then
        Return Nothing
      Else
        Return CType(Session("colBasketItems"), helperclasses.BasketItems)
      End If
    End Get
  End Property

  Protected Sub Page_Load(ByVal sender As Object, ByVal e As 
System.EventArgs) Handles Me.Load

    Master.BasketControl.Visible = False

    If Me.IsPostBack Then Exit Sub

    LoadMasterData()

  End Sub

  Private Sub LoadMasterData()

    If colBasketItems Is Nothing OrElse (Not CBool(colBasketItems.Count)) Then
      If Session("EventId") Is Nothing OrElse (Not 
IsNumeric(Session("EventId"))) Then Exit Sub
      Response.Redirect("~/BookingSteps/EventBookStep1.aspx?id=" & 
Session("EventId").ToString)
      Exit Sub
    End If

    Dim dsBasketItems As New DataSet
    With dsBasketItems
      .Tables.Add("BasketItems")
      With .Tables(0).Columns
        .Add("EventName", GetType(String))
        .Add("VenueName", GetType(String))
        .Add("EventDate", GetType(String))
        .Add("EventID", GetType(Integer))
        .Add("D13_D05_IDs", GetType(String))
      End With
    End With

    For Each colTickets As helperclasses.Tickets In colBasketItems
      Dim dr As DataRow = dsBasketItems.Tables(0).NewRow
      With colTickets
        dr("EventName") = .EventName
        dr("VenueName") = .VenueName
        dr("EventDate") = String.Format("{0:dd\/MM\/yyyy - HH:mm}", 
..EventDate)
        dr("EventID") = .EventID
        dr("D13_D05_IDs") = .D13_D05_IDs
      End With
      dsBasketItems.Tables(0).Rows.Add(dr)
    Next

    If Not CBool(dsBasketItems.Tables(0).Rows.Count) Then
      InfoLabel1.InnerHtml = "Δεν βÏέθηκαν δεδομένα."
      Exit Sub
    End If

    lstTicketsInfo.DataSource = dsBasketItems
    lstTicketsInfo.DataBind()

    txtQuantityTotal.Value = m_QuantityTotal.ToString
    txtPriceTotal.Value = String.Format("{0:##,##0.00;(##,##0.00);0}", 
m_PriceTotal)

  End Sub

  Protected Sub lstTicketsInfo_ItemDataBound(ByVal sender As Object, ByVal e 
As System.Web.UI.WebControls.DataListItemEventArgs) Handles 
lstTicketsInfo.ItemDataBound

    gvBasket = CType(e.Item.FindControl("gvBasket"), 
System.Web.UI.WebControls.GridView)
    LoadDetailData(gvBasket, _
                   CType(CType(e.Item.FindControl("lblEventID"), 
Label).Text, Integer), _
                   CType(e.Item.FindControl("lblD13_D05_IDs"), Label).Text)

  End Sub

  Protected Sub lstTicketsInfo_ItemCreated(ByVal sender As Object, ByVal e 
As System.Web.UI.WebControls.DataListItemEventArgs) Handles 
lstTicketsInfo.ItemCreated

    Dim gvInnerBasket As GridView = CType(e.Item.FindControl("gvBasket"), 
GridView)
    AddHandler gvInnerBasket.RowCommand, AddressOf gvBasket_RowCommand

  End Sub

  Private Sub LoadDetailData(ByRef gvBasket As GridView, ByVal nEventId As 
Integer, ByVal sD13_D05_IDs As String)

    Dim dsTickets As New DataSet
    With dsTickets
      .Tables.Add("Tickets")
      With .Tables(0).Columns
        .Add("Quantity", GetType(String))
        .Add("Price", GetType(String))
        .Add("Total", GetType(String))
        .Add("EventID", GetType(Integer))
        .Add("D13_D05_IDs", GetType(String))
        .Add("E01_i03_id", GetType(Integer))
        .Add("E01_index", GetType(Integer))
      End With
    End With

    For Each ticket As helperclasses.Ticket In 
colBasketItems(nEventId.ToString & "~" & sD13_D05_IDs)
      Dim dr As DataRow = dsTickets.Tables(0).NewRow()
      With ticket
        dr("Price") = String.Format("{0:##,##0.00;(##,##0.00);0}", .Price + 
..ServiceCharge)
        If .Section = "" Then
          dr("Quantity") = .E01_index.ToString
        Else
          dr("Quantity") = colBasketItems(nEventId.ToString & "~" & 
sD13_D05_IDs).Count
        End If
        dr("Total") = String.Format("{0:##,##0.00;(##,##0.00);0}", (.Price + 
..ServiceCharge) * .E01_index)
        dr("EventID") = nEventId.ToString
        dr("D13_D05_IDs") = sD13_D05_IDs
        dr("E01_i03_id") = .E01_i03_id
        dr("E01_index") = .E01_index
      End With
      dsTickets.Tables(0).Rows.Add(dr)
    Next

    If Not CBool(dsTickets.Tables(0).Rows.Count) Then
      Exit Sub
    End If

    m_QuantitySubTotal = 0
    m_PriceSubTotal = 0

    gvBasket.DataSource = dsTickets
    gvBasket.DataBind()

    m_QuantityTotal += m_QuantitySubTotal
    m_PriceTotal += m_PriceSubTotal

  End Sub

  Protected Sub gvBasket_RowDataBound(ByVal sender As Object, ByVal e As 
System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvBasket.RowDataBound

    If e.Row.RowType = DataControlRowType.DataRow Then
      m_QuantitySubTotal += 
CType(Val(CType(e.Row().FindControl("txtQuantity"), HtmlInputText).Value), 
Integer)
      m_PriceSubTotal += 
CType(Val(CType(e.Row().FindControl("lblTotalSingle"), Label).Text), Double)
    ElseIf e.Row.RowType = DataControlRowType.Footer Then
      CType(e.Row.FindControl("txtQuantityTotal"), HtmlInputText).Value = 
m_QuantitySubTotal.ToString
      CType(e.Row.FindControl("txtPriceTotal"), HtmlInputText).Value = 
String.Format("{0:##,##0.00;(##,##0.00);0}", m_PriceSubTotal)
    End If

  End Sub

  Protected Sub gvBasket_RowCommand(ByVal sender As Object, ByVal e As 
System.Web.UI.WebControls.GridViewCommandEventArgs) Handles 
gvBasket.RowCommand

    If e.CommandName = "Delete" Then
      colBasketItems(Split(e.CommandArgument.ToString, 
"|")(0)).Remove(Split(e.CommandArgument.ToString, "|")(1))
      LoadMasterData()
    End If

  End Sub

  Protected Sub DeleteTicket(ByVal sender As Object, ByVal e As 
System.Web.UI.WebControls.CommandEventArgs)

    colBasketItems(Split(e.CommandArgument.ToString, 
"|")(0)).Remove(Split(e.CommandArgument.ToString, "|")(1))
    LoadMasterData()

  End Sub
End Class
 
G

Guest

Hi,

You need not have to handle your ItemCreated event for the datalist and
also it is not necessary to create an event handler for the rowCommand of the
grid view.

You cld take a look at my sample code for the same.

Html:

<asp:DataList ID="dlDataList" runat="Server"
OnItemDataBound="dlDataList_ItemDataBound">
<ItemTemplate>
<asp:GridView ID="gvMyGridView_1" runat="server"
OnRowCommand="gvMyGridView_1_RowCommand"
AutoGenerateColumns="false" >
<Columns>
<asp:BoundField DataField="col2" HeaderText="InnerCol1" />
<asp:BoundField DataField="col3" HeaderText="InnerCol2"/>
<asp:ButtonField ButtonType="button"
CommandName="test" Text="delete"
HeaderText="Delete" />
</Columns>
</asp:GridView>
</ItemTemplate>
</asp:DataList>


Source Code C#:

// I am using the same datatable for both the girdView and the
datalist,
// but that shd not have any effect here..

DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{

dt.Columns.Add("col1");
dt.Columns.Add("col2");
dt.Columns.Add("col3");

DataRow dr = dt.NewRow();
dr[0] = "A11";
dr[1] = "A12";
dr[2] = "A13";
dt.Rows.Add(dr);

dr = dt.NewRow();
dr[0] = "A21";
dr[1] = "A22";
dr[2] = "A23";
dt.Rows.Add(dr);

dr = dt.NewRow();
dr[0] = "A31";
dr[1] = "A32";
dr[2] = "A33";
dt.Rows.Add(dr);

if (! IsPostBack)
{
dlDataList.DataSource = dt;
dlDataList.DataBind();
}

}

protected void dlDataList_ItemDataBound(object sender, DataListItemEventArgs
e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem ||
e.Item.ItemType == ListItemType.Item)
{
((GridView)e.Item.FindControl("gvMyGridView_1")).DataSource
= dt;
((GridView)e.Item.FindControl("gvMyGridView_1")).DataBind();
}
}

public void gvMyGridView_1_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if (e.CommandName == "test")
Response.Write("My rowCommand jus fired");

}


The code above works fine...
Probably jus try removing the itemCreated event of the datalist and re-run
your code.
I guess the rest of it is completely fine.

Let me know how it goes.....

- Parvathy Padmanabhan
 
G

Guest

thanks for your herp Parvathy Padmanabhan!

The ItemCreated event is just for testing in order to make that event work!

I'll try tomorrow and I'll let you know!
 
G

Guest

found that!

it was not working because I had enableviewstate="false" on the datalist
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,763
Messages
2,569,562
Members
45,038
Latest member
OrderProperKetocapsules

Latest Threads

Top