Dear all,
I want to display and UPDATE the data of a certain table using DataGridView.
I need help to create a typed DataSet to be the DataSource for my BindingSource object.
My problem is :
1- Not all of my columns come from one table. One column (
dept_name) should be retrieved from another table by a subquery, but It’s not gonna be updated.
2- Select statement that should be used by the TableAdapter has a (
where condition) with parameters inserted by the user before populating the grid with correct data.
Here's a simplified version of my query:
Select dept_id , SEQ ,time_stamp ,
(selec dept _name from Departments D where D.dept_id = H.dept_id)
From History H
Where seq = v_input_seq
Note: i don't want to use JOIN in my query, because TableAdapter wouldn't generate (insert, update...) statements automatically for me.
Can anyone help me with creating the DataSet and configuring and TableAdapter throw the WIZARD, please?
Thanks in advance