Problem in calling Linq method which return group by result on page load

Question

Hi I hv method in class file and i need to call it on page load...I just want to knw what shud be exact return type here... public static void GetPaymentGroupBy() { DataClasses1DataContext obj = new DataClasses1DataContext (); var query = ( from pay in obj.GetTable Payplan_Installment >() group pay.Frequency by new { pay.InstallmentAmount pay.PaymentMode pay.PlanStatus } into details select details); } === I m calling on page load like this: dataGridView1.DataSource = DataClasses1DataContext .GetPaymentGroupBy(); please help meit is very urgent Thanks in advance

Manikavelu Velayutham · Answer

In your code function return type is void. It should be of DataTable or DataSet so that it can be assigned to a DataSource. Without that you can assign it to the DataSource. Please refer the above link in my post. It has the code to convert the LINQ resultset to data table. That will solve your problem.

Madhu K · Answer

May not be the best solution but it works public static void GetPaymentGroupBy(GridView gv) { DataClasses1DataContext obj = new DataClasses1DataContext (); var query = ( from pay in obj.GetTable Payplan_Installment >() group pay.Frequency by new { pay.InstallmentAmount pay.PaymentMode pay.PlanStatus } into details select details); gv.DataSource = query; gv.DataBind(); } DataClasses1DataContext .GetPaymentGroupBy( dataGridView1 );

Ajay Kumar · Answer

Thanks a lot dear..But My method is defined in class file and there Grid view is not detecting...I m making a windows application. It is showing error like this: Error 1 The type or namespace name 'GridView' could not be found (are you missing a using directive or an assembly reference?) D:\Work	estlinq	estlinq\DataClasses1.cs 381 43 testlinq can u help me in this...

Manikavelu Velayutham · Answer

http://www.c-sharpcorner.com/UploadFile/VIMAL.LAKHERA/LINQResultsetToDatatable06242008042629AM/LINQResultsetToDatatable.aspx Hope this link will help you convert the return type.