I want to update two tables in one page. So I created two FormView bound on two SqlDataSource controls, and I create a Update button on the bottom of page. And I writen some codes as below:
btnUpate_Click(object sender, EventArgs e)
{
sqlDataSource1.Update();
sqlDateSource2.Update();
}
But, the records haven't updated.
In SqlDataSource2_Updating() function, I found all the parameters is null.
So, how to modify my code to do it.
Zhang
You need to actually set the update parameters. Take a look at this link.
http://msdn2.microsoft.com/en-us/library/fkzs2t3h(VS.80).aspx
Sub EmployeeDetailsSqlDataSource_OnInserted(senderAsObject, eAs SqlDataSourceStatusEventArgs)
Dim commandAs System.Data.Common.DbCommand = e.Command
EmployeeDetailsSqlDataSource.SelectParameters("EmpID").DefaultValue = _
command.Parameters("@.EmpID").Value.ToString()
EmployeesGridView.DataBind()
EmployeeFormView.DataBind()
EndSub
|||
I set the parameters' DafaultValue in the Clicked Event of the Update button. And it work fine.
But it is too hard to set so much parameters by codes. Are there any ways to set them automatically as the update link button had done in the FormView?
No comments:
Post a Comment