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;
}
}