ASP.NET

var query = (from c in dt.AsEnumerable() select new { FirstName = c.Field<string>("FirstName"), LastName = c.Field<string>("LastName") }).Distinct() ;

ganesh das wrote:

how can i create table in 1 database 2 another database in vb.netFrown

using Microsoft.Reporting.WebForms;

 
reportViewer1.Visible = true;
reportViewer1.ShowToolBar = true;
reportViewer1.SizeToReportContent = true;
reportViewer1.LocalReport.ReportPath = "report1.rdlc"; 
reportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
//Note:DisplayReport will be your method to get data based on your parameters with return type as datatable.  
DataTable dtReportSource = DisplayReport(fromDate,todate,process);

//Note schema for dtReport and dtReportSource should match.
//Note: name format of dataset and datatable in .xsd file

reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsReport_dtReport", dtReportSource ));