Report Viewer using linq to sql and vb.net

Question

Good morning, how to use the report viewer in vb.net using Linq to Sql?

Daniel Rosa · Answer

I tried to do so, but the report is empty, What should I do to improve the code? Private Sub TxtPesquisarNomeDocumento_TextChanged(sender As Object , e As EventArgs ) Handles TxtPesquisarNomeDocumento.TextChanged Try Dim ListaGeralPesquisaCodigoFuncao As IList ( Of DAL. LT_DocIdentificacaoResult ) = ListaGeralDocumentosIdent.Where( Function (w) w.NOME_DOC_IDENTIFICAÇÃO.Contains(TxtPesquisarNomeDocumento.Text)).ToList() CarregarGridDocumentos(ListaGeralPesquisaCodigoFuncao) Catch ex As Exception MsgBox( "erro : " & ex.Message, MsgBoxStyle .Exclamation) End Try End Sub Public Function DatagridviewToDataset() As System.Data. DataSet Dim ds As New System.Data. DataSet Try 'Add a new table to the dataset ds.Tables.Add( "Main" ) 'Add the columns Dim col As System.Data. DataColumn 'For each colum in the datagridveiw add a new column to your table For Each dgvCol As DataGridViewColumn In DGVListaDocIdentificacao.Columns col = New System.Data. DataColumn (dgvCol.Name) ds.Tables( "Main" ).Columns.Add(col) Next 'Add the rows from the datagridview Dim row As System.Data. DataRow Dim colcount As Integer = DGVListaDocIdentificacao.Columns.Count - 1 For i As Integer = 0 To DGVListaDocIdentificacao.Rows.Count - 1 row = ds.Tables( "Main" ).Rows.Add For Each column As DataGridViewColumn In DGVListaDocIdentificacao.Columns row.Item(column.Index) = DGVListaDocIdentificacao.Rows.Item(i).Cells(column.Index).Value Next Next Return ds Catch ex As Exception 'Catch any potential errors and display them to the user MessageBox .Show( "Error Converting from DataGridView" & ex.InnerException.ToString, _ "Error Converting from DataGridView" , MessageBoxButtons .OK, MessageBoxIcon .Error) Return Nothing End Try End Function Thanks

Ramesh Maruthi · Answer

Hello Daniel, Please look at this links :) http://blogs.msdn.com/b/bethmassi/archive/2009/08/19/using-the-reportviewer-with-ado-net-data-services-and-entity-framework.aspx http://social.msdn.microsoft.com/Forums/en-US/7877c101-8920-4f3a-8a5e-0abe71f48c44/linq-as-a-datasource-for-reportviewer?forum=linqprojectgeneral

Report Viewer using linq to sql and vb.net

Answers (2)