R
Rob Edwards
Two tables: Employee, Salary
I want to be able to update the Salary information with the dates and
changes to each employee in a datagrid.
The EmployeeID is the foreign key in the Salary table.
OK... so I created a datagrid with the datasource being the Salary table.
I converted the EmployeeID column into a template column.
The datasource of that column is the employee table
The DataTextField is the name of the employee
The DataValueField is the EmployeeID
In DataBindings I have bound the SelectedValue to the EmployeeID in the
Salary table.
I fill the data adapter in:
If not Page.IsPostBack
daSalary.Fill(DsSalary1)
daEmployee.fill(DsEmployee1)
The problem is the same name is displayed in each of the rows (that being
the value of the first row returned).
How do you return the different SelectedValue for each row in the datagrid?
Thanks.
I want to be able to update the Salary information with the dates and
changes to each employee in a datagrid.
The EmployeeID is the foreign key in the Salary table.
OK... so I created a datagrid with the datasource being the Salary table.
I converted the EmployeeID column into a template column.
The datasource of that column is the employee table
The DataTextField is the name of the employee
The DataValueField is the EmployeeID
In DataBindings I have bound the SelectedValue to the EmployeeID in the
Salary table.
I fill the data adapter in:
If not Page.IsPostBack
daSalary.Fill(DsSalary1)
daEmployee.fill(DsEmployee1)
The problem is the same name is displayed in each of the rows (that being
the value of the first row returned).
How do you return the different SelectedValue for each row in the datagrid?
Thanks.