A
Antony Futter
Hi,
I am relatively new to .Net and have an question regarding updates from a
Datagrid on an Webform.
I have successfully got the data to display and then changed to the edit
mode in the Grid, but when the update command is triggered, it seems to skip
lines of code in the dataadaptor's auto-created code and it does not ever
execute the update SProc on the SQL server.
I have included the event code. Does anyone have any advice.
Regards,
Antony
Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As
System.Web.UI.WebControls.DataGridCommandEventArgs) Handles
DataGrid1.UpdateCommand
SqlDataAdapter1.Update(Emaildata1)
SqlDataAdapter1.Fill(Emaildata1)
DataGrid1.DataBind()
End Sub
Me.SqlUpdateCommand1.CommandText = "[sp_web_emailaddress_update]"
Me.SqlUpdateCommand1.CommandType = System.Data.CommandType.StoredProcedure
Me.SqlUpdateCommand1.Connection = Me.SqlConnection1
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@RETURN_VALUE",
System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue,
False, CType(0, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@emailaddress",
System.Data.SqlDbType.VarChar, 200, "emailaddress"))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@password",
System.Data.SqlDbType.VarChar, 50, "password"))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@enabled", System.Data.SqlDbType.Bit, 1,
"enabled"))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@passwordchange",
System.Data.SqlDbType.Bit, 1, "passwordchange"))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_email_address_id",
System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False,
CType(0, Byte), CType(0, Byte), "email_address_id",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_emailaddress",
System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input,
False, CType(0, Byte), CType(0, Byte), "emailaddress",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_enabled",
System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False,
CType(0, Byte), CType(0, Byte), "enabled",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_password",
System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input,
False, CType(0, Byte), CType(0, Byte), "password",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_passwordchange",
System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False,
CType(0, Byte), CType(0, Byte), "passwordchange",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@email_address_id",
System.Data.SqlDbType.Int, 4, "email_address_id"))
I am relatively new to .Net and have an question regarding updates from a
Datagrid on an Webform.
I have successfully got the data to display and then changed to the edit
mode in the Grid, but when the update command is triggered, it seems to skip
lines of code in the dataadaptor's auto-created code and it does not ever
execute the update SProc on the SQL server.
I have included the event code. Does anyone have any advice.
Regards,
Antony
Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As
System.Web.UI.WebControls.DataGridCommandEventArgs) Handles
DataGrid1.UpdateCommand
SqlDataAdapter1.Update(Emaildata1)
SqlDataAdapter1.Fill(Emaildata1)
DataGrid1.DataBind()
End Sub
Me.SqlUpdateCommand1.CommandText = "[sp_web_emailaddress_update]"
Me.SqlUpdateCommand1.CommandType = System.Data.CommandType.StoredProcedure
Me.SqlUpdateCommand1.Connection = Me.SqlConnection1
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@RETURN_VALUE",
System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue,
False, CType(0, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@emailaddress",
System.Data.SqlDbType.VarChar, 200, "emailaddress"))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@password",
System.Data.SqlDbType.VarChar, 50, "password"))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@enabled", System.Data.SqlDbType.Bit, 1,
"enabled"))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@passwordchange",
System.Data.SqlDbType.Bit, 1, "passwordchange"))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_email_address_id",
System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False,
CType(0, Byte), CType(0, Byte), "email_address_id",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_emailaddress",
System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input,
False, CType(0, Byte), CType(0, Byte), "emailaddress",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_enabled",
System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False,
CType(0, Byte), CType(0, Byte), "enabled",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_password",
System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input,
False, CType(0, Byte), CType(0, Byte), "password",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_passwordchange",
System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False,
CType(0, Byte), CType(0, Byte), "passwordchange",
System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@email_address_id",
System.Data.SqlDbType.Int, 4, "email_address_id"))