Hi Dharmendr,
Thanks for the sample. Actually I have two different bind nested gridview. One is by year and another one is by month.
Here my code :
'Nested Gridview bind by month:
Protected Sub BindGridviewByMonth()
Dim strConnString As String = ConfigurationManager.ConnectionStrings("ConString").ConnectionString
Dim adapter As New SqlDataAdapter()
Dim ds As New DataSet()
Dim con As New SqlConnection(strConnString)
Dim cmd As New SqlCommand()
con.Open()
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "SP_byMonth"
cmd.Connection = con
adapter = New SqlDataAdapter(cmd)
adapter.Fill(ds)
con.Close()
gvParentGrid.DataSource = ds.Tables(0)
gvParentGrid.DataBind()
End Sub
'Nested Gridview bind by year:
Protected Sub BindGridviewByYear()
Dim strConnString As String = ConfigurationManager.ConnectionStrings("ConString").ConnectionString
Dim adapter As New SqlDataAdapter()
Dim ds As New DataSet()
Dim con As New SqlConnection(strConnString)
Dim cmd As New SqlCommand()
con.Open()
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "SP_byYear"
cmd.Connection = con
adapter = New SqlDataAdapter(cmd)
adapter.Fill(ds)
con.Close()
gvParentGrid.DataSource = ds.Tables(0)
gvParentGrid.DataBind()
End Sub
'the sample code you given:
Protected Sub OnProductsGrid_PageIndexChanging(sender As Object, e As GridViewPageEventArgs)
Dim gvProducts As GridView = TryCast(sender, GridView)
gvProducts.PageIndex = e.NewPageIndex
BindProducts(Integer.Parse(gvProducts.ToolTip), gvProducts)
End Sub
BindProducts(Integer.Parse(gvProducts.ToolTip), gvProducts) --> how to call the two different binds to one?
Please advice
