Entity framework -Linq

Amenda Aisha

10y891LINQ

I have two table called Change Request and Task list

change request has one or many task ,

task list task is belongs to an exactly one change request

so in a different form there is a combo box which contain change request ids from change request table ----> here my requirement is to display task list data in a datagrid when selecting a change request id

furthermore it should search for that selected id with the task list table and retrieve only matching records.

here is my code

----------------------------------------------

// load task detalis

private void LoadtaskList()

{

//cr id from change request table -----> match with task table and get data belongs to that cr id

var crId = Int32.Parse(cbsearch.SelectedValue.ToString());

BindingSource task = new BindingSource();

task.DataSource = db.cr_tasks.Where(e => e.change_request_id == crId && e.is_active == true)

.Select(x => new

{

x.task_id,

x.task_name,

x.responsible_person,

x.service.name,

x.task_start_date,

x.task_completion_date,

x.is_completed_status,

x.service_id

}).ToList();

if (task.DataSource != null)

{

dgvtask_details.DataSource = task;

}

5 Replies

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

Amenda Aisha10y ago
Here i have attached my code and UI.
When i select a change request id from a search bar it should compare change request with foreign key of task table and return task details to the datagrid
Amenda Aisha10y ago
check this out
Vinay Singh10y ago
Hi
Please provide the error and table structure and possible to provide some data and expected result.
Amenda Aisha10y ago
Hi Vinay
I tried but it won't work :(
Vinay Singh10y ago
Hi
check the query
var date= db.cr_tasks.Where(e => e.change_request_id == crId && e.is_active == true)
.Select(x => new
{
x.task_id,
x.task_name,
x.responsible_person,
x.service.name,
x.task_start_date,
x.task_completion_date,
x.is_completed_status,
x.service_id
}).ToList();
if ( date != null)
{
dgvtask_details.DataSource = date;
}
}