I'm trying to create a TableAdapter query in my child form's load event that will show the data of a selected row the user chooses(when the DGV's row header is double clicked)from the parent form. I have everything working fine except the child form's TableAdapter query that should load data of an individually selected row from the parent form's DGV (child form is used for editing data from the parent's DGV).
The parent form uses
DataGridView.SelectedRows(i).Index
to recognize the selected row the user chooses. How can I integrate this into a query to tell SQL I want it to fill my table where column name Task_ID = the value of the selected row choosen by the user.
The child form is currently using the default fill function
Me.TasksTableAdapter.Fill(Me.TodolistDataSet.tasks)
The current SQL statement is
SELECT Task_ID, Project_ID, Description_, Priority_Level, Sub_Level, Requested_Date, Comments, Fixed_Date, Software_Version, Requested_By FROM dbo.tasks
I'm using VS2010 professional,.NET Framework 4 Client Profile,MySQL2010
Thanks in advance for any help.
[edit]Sql converted from inline code to code block, Tags - OriginalGriff[/edit]