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

Ajay Kumar

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 me,it is very urgent
Thanks in advance

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikavelu Velayutham16y ago
Accepted 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.
0
Ajay Kumar16y ago
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\testlinq\testlinq\DataClasses1.cs 381 43 testlinq

can u help me in this...
0
Manikavelu Velayutham16y ago
http://www.c-sharpcorner.com/UploadFile/VIMAL.LAKHERA/LINQResultsetToDatatable06242008042629AM/LINQResultsetToDatatable.aspx

Hope this link will help you convert the return type,.
0
Madhu K16y ago
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);
0

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

Ajay Kumar

16y4kLINQ

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikavelu Velayutham16y ago
Accepted 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.
0
Ajay Kumar16y ago
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\testlinq\testlinq\DataClasses1.cs 381 43 testlinq

can u help me in this...
0
Manikavelu Velayutham16y ago
http://www.c-sharpcorner.com/UploadFile/VIMAL.LAKHERA/LINQResultsetToDatatable06242008042629AM/LINQResultsetToDatatable.aspx

Hope this link will help you convert the return type,.
0
Madhu K16y ago
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);
0