thanks a lot for your message.
I tried in debug mode break points to check whether code is executed
in RowCommand event, but nothing. Only code in RowDataBound of child
gridview is executed. I tried to change the name of event of
RowCommand in asp and it gives an error that event is not found, so it
regognises it, just not executes it.
Here is the code:
Protected Sub btn_show_Click( ByVal sender As Object, ByVal e As
System.EventArg s) Handles btn_show.Click
refresh_gridvie w_data()
End Sub
Protected Sub refresh_gridvie w_data()
Dim sdsc As New SqlDataSource
Dim var_SQL As String
'------------------------------------------------------------------------------------------------------------------------------------
sdsc.Connection String =
ConfigurationMa nager.Connectio nStrings("Conne ctionString1"). ConnectionStrin g
sdsc.DataSource Mode = SqlDataSourceMo de.DataReader
var_SQL = "SELECT DISTINCT dbo.Report.coun try_no,
dbo.Report.prod uct_no, dbo.Report.clie nt_no, "
sdsc.SelectComm and = var_SQL
grv_batches.Dat aSource = sdsc
grv_batches.Dat aBind()
End Sub
Protected Sub grv_batches_Row Created(ByVal sender As Object, ByVal e
As System.Web.UI.W ebControls.Grid ViewRowEventArg s) Handles
grv_batches.Row Created
If e.Row.RowType = DataControlRowT ype.DataRow Then
Dim sdsc As New SqlDataSource
Dim grv_rep As GridView = e.Row.FindContr ol("grv_reports ")
sdsc.Connection String =
ConfigurationMa nager.Connectio nStrings("Conne ctionString1"). ConnectionStrin g
sdsc.SelectComm andType =
SqlDataSourceCo mmandType.Store dProcedure
sdsc.SelectComm and = "STP_slct_Repor ts"
sdsc.SelectPara meters.Add("cou ntry_no",
grv_batches.Dat aKeys(e.Row.Row Index).Values(" country_no"))
sdsc.SelectPara meters.Add("pro duct_no",
grv_batches.Dat aKeys(e.Row.Row Index).Values(" product_no"))
sdsc.SelectPara meters.Add("cli ent_no",
grv_batches.Dat aKeys(e.Row.Row Index).Values(" client_no"))
grv_rep.DataSou rce = sdsc
grv_rep.DataBin d()
End If
Protected Sub grv_subscr_repo rts_RowCommand( ByVal sender As Object,
ByVal e As System.Web.UI.W ebControls.Grid ViewCommandEven tArgs)
If e.CommandName = "Report" Then
'one_all = 1 'one report will be edited
If (Not
Page.ClientScri pt.IsStartupScr iptRegistered(M e.GetType(), "Report"))
Then 'Check to see if the startup script is already registered.
Page.ClientScri pt.RegisterStar tupScript(Me.Ge tType(),
"Report", "window.open('R eport.aspx',
'','dialogHeigh t=850px,Width=8 00px,menubar=No ,toolbar=no,scr ollbars=yes');
", True)
End If
End If
End Sub
Protected Sub grv_subscr_repo rts_RowDataBoun d(ByVal sender As
Object, ByVal e As System.Web.UI.W ebControls.Grid ViewRowEventArg s)
If e.Row.RowType = DataControlRowT ype.DataRow Then
Select Case e.Row.Cells(11) .Text 'report status
Case "Cancelled"
e.Row.BackColor = Drawing.Color.O rangeRed
Case "On-Hold"
e.Row.BackColor = Drawing.Color.O range
Case "Finished"
e.Row.BackColor = Drawing.Color.L ightSteelBlue
Case "New"
e.Row.BackColor = Drawing.Color.L ightGreen
End Select
End If
End Sub
<asp:Grid View ID="grv_batches " runat="server"
AutoGenerateCol umns="False"
DataKeyNames="c ountry_no,produ ct_no,client_no " CssClass="GridV iew" >
<Columns>
<asp:ButtonFiel d CommandName="Fi nish" Text="Finish" >
<ControlStyle CssClass="GridV iew_LinkButtons " />
</asp:ButtonField >
<asp:BoundFie ld DataField="Coun try_name"
HeaderText="Cou ntry" />
<asp:BoundFie ld DataField="prod uct_name"
HeaderText="Pro duct" />
<asp:BoundFie ld DataField="clie nt_name"
HeaderText="Com pany" />
<asp:BoundFie ld DataField="stat us_name"
HeaderText="Sta tus" />
<asp:BoundFie ld HeaderText="Fin ish Status" />
<asp:TemplateFi eld HeaderText="Sub s">
<ItemTemplate >
<asp:GridView ID="grv_reports " runat="server"
AutoGenerateCol umns="False" CssClass="GridV iew"
OnRowCommand="g rv_subscr_repor ts_RowCommand"
OnRowDataBound= "grv_subscr_rep orts_RowDataBou nd">
<Columns>
<asp:ButtonFiel d CommandName="Su b"
Text="S">
<ControlStyle
CssClass="GridV iew_LinkButtons " />
</asp:ButtonField >
<asp:ButtonFiel d CommandName="Re port"
Text="R">
<ControlStyle
CssClass="GridV iew_LinkButtons " />
</asp:ButtonField >
<asp:ButtonFiel d CommandName="Hi story"
Text="H">
<ControlStyle
CssClass="GridV iew_LinkButtons " />
</asp:ButtonField >
<asp:BoundFie ld DataField="note "
HeaderText="N">
<ItemStyle Font-Bold="True"
ForeColor="Red" HorizontalAlign ="Center" />
</asp:BoundField>
<asp:BoundFie ld DataField="comp any_name"
HeaderText="Com pany" />
<asp:BoundFie ld DataField="full _name"
HeaderText="Use r" />
<asp:BoundFie ld
DataField="proc _deliverable_na me" HeaderText="Del iverable" />
<asp:BoundFie ld
DataField="repo rt_deadline" HeaderText="Dea dline" />
<asp:BoundFie ld
DataField="repo rt_finished" HeaderText="Fin ish" />
<asp:BoundFie ld DataField="dela y"
HeaderText="Del ay">
<ItemStyle ForeColor="Red" />
</asp:BoundField>
<asp:BoundFie ld
DataField="repo rt_importance_s hort_name" HeaderText="Imp " />
<asp:BoundFie ld
DataField="repo rt_status_name" HeaderText="Rep ort Status" />
<asp:BoundFie ld
DataField="sub_ status_name" HeaderText="Sub . Status" />
<asp:BoundFie ld DataField="date _activated"
HeaderText="Dat e Activated" />
<asp:BoundFie ld DataField="sub_ no"
HeaderText="sub _no" Visible="False" />
<asp:BoundFie ld DataField="sub_ detail_no"
HeaderText="sub _detail_no"
Visible="False" />
<asp:BoundFie ld DataField="repo rt_no"
HeaderText="rep ort_no" Visible="False" />
</Columns>
<RowStyle CssClass="GridV iew_Row" />
<HeaderStyle CssClass="GridV iew_Header2" Font-
Size="XX-Small" />
<AlternatingRow Style
CssClass="GridV iew_AlternateRo w" />
</asp:GridView>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
<RowStyle CssClass="GridV iew_Row" />
<HeaderStyle CssClass="GridV iew_Header" />
<AlternatingRow Style CssClass="GridV iew_AlternateRo w" />
</asp:GridView>
