This is a migrated thread and some comments may be shown as answers.

Two Grids are not working on the same page

3 Answers 338 Views

Grid

This is a migrated thread and some comments may be shown as answers.

3 Answers, 1 is accepted

answered on 17 May 2020, 06:14 PM

Hi Vasil

i have also problem.do i need two NeedDataSource events to bind the data.The first grid is binding data properly whereas second grid is not binding even though using second NeedDataSource event.Please help me

Thanks

Phani

Protected Sub AvailableUsersGrid_NeedDataSource(sender As Object, e As GridNeedDataSourceEventArgs)
Dim dt As DataTable = New DataTable
If oConn.State = ConnectionState.Closed Then
oConn.ConnectionString = sConn
oConn.Open()
End If
TestTitle = ddlTestTitle.SelectedValue
If TestTitle <> "" Then
strtDate = radstartdate.SelectedDate
endDate = radenddate.SelectedDate
CheckAssignedTest(strtDate, endDate)
Else
Try
Dim da As OleDbDataAdapter = New OleDbDataAdapter("select USER_ID,EMAIL_ID,NAME,FACILITY.FACILITY_NAME as FACILITY,ROLES.ROLE_DETAILS as ROLE from USER_DETAILS,ROLES,FACILITY where user_details.facility = facility.facility_id and user_details.role = roles.role_id", oConn)
da.Fill(dt)
AvailableUsersGrid.DataSource = dt
If oConn.State = ConnectionState.Open Then
oConn.Close()
End If
oConn.Dispose()
Catch ex As Exception
Dim ss As String = ex.Message
End Try
dt.Dispose()
oConn.Dispose()
End If
End Sub

Protected Sub TestAssignedGrid_NeedDataSource(sender As Object, e As GridNeedDataSourceEventArgs)

Dim dt1 As DataTable = New DataTable
If oConn.State = Data.ConnectionState.Closed Then
oConn.ConnectionString = sConn
oConn.Open()
End If
Dim DataAdapter1 As OleDbDataAdapter = New OleDbDataAdapter("select TEST_ASSIGN_ID, TEST_SUITES.TEST_NAME as TEST_NAME,USER_ID,ASSIGN_DATE,SCHEDULE_START,SCHEDULE_END from TEST_SUITES_ASSIGNED,TEST_SUITES where TEST_SUITES_ASSIGNED.TEST_ID = TEST_SUITES.TEST_ID", oConn)
Try
DataAdapter1.Fill(dt1)
TestAssignedGrid.DataSource = dt1

Catch ex As Exception
Dim ss As String = ex.Message
End Try
dt1.Clear()
dt1.Dispose()
oConn.Dispose()

End Sub

answered on 20 May 2020, 04:25 PM

Hi Phani,

Thank you for the code provided!

In general, each Radgrid needs a DataSource to have data to populate and process further. DataSource can be assigned in the OnNeedDataSource event or also in the markup if a DataSource component is used, see How to bind RadGrid properly on server-side

I couldn't find any obvious reason for the described behavior so I would suggest you following steps to narrow down the issue:

Ensure the DataTables assigned as data sources to both RadGrid(s) contain entries retuned from the database queries.
Make sure you are not calling DataBind() method anywhere in the page, see Programmatic Data Binding Using the NeedDataSource Event
Ensure the AJAX is properly implemented and you are not having any nested Ajaxified controls on the page, see Understanding AJAX Controls
Check for JavaScript errors on the Browsers' Developer Tools Console. If there are such, make sure to eliminate them as they will prevent the execution of further JavaScript and that could cause unexpected behavior of the controls.
Temporarily disable AJAX on the page as it may "hide" some server errors as JavaScript errors. Test the application while monitoring for JavaScript errors again, see Get more descriptive errors by disabling AJAX

If suggests steps are not helping in troubleshooting the case I would need more information to help further. Please provide the whole markup and code-behind of the page containing the RadGrid controls so that I have a more complete overview.

Looking forward to your feedback!

Kind regards,
Doncho
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.