DataGrid Update Command

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"))
 
E

Eliyahu Goldin

By any chance, do you call Emaildata1.AccaptChanges()?

Eliyahu

Antony Futter said:
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"))
Click to expand...
 
A

Antony Futter

Hi,

No I do not. Do I need to do this before the update command.

Thanks
Antony


Eliyahu Goldin said:
By any chance, do you call Emaildata1.AccaptChanges()?

Eliyahu

Antony Futter said:
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"))
Click to expand...
Click to expand...
 
E

Eliyahu Goldin

No. Calling AcceptChanges() could've been the reason for your problem.

Eliyahu

Antony Futter said:
Hi,

No I do not. Do I need to do this before the update command.

Thanks
Antony


Eliyahu Goldin said:
By any chance, do you call Emaildata1.AccaptChanges()?

Eliyahu

Antony Futter said:
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",
Click to expand...
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"))
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP with dataset update 0
datagrid woes 0
sorting problem! 0
Problem With Editing Datagrid... 0
Performance issues with Retrieving data 1
DataGrid with no data, not showing data 0
Public/Global Variable recommendation for URL Param and SQL 1
add one input parameter to stored procedure 0

Members online

No members online now.
Total: 37 (members: 0, guests: 37)
Robots: 212

Forum statistics

Threads
473,756
Messages
2,569,535
Members
45,008
Latest member
obedient dusk

Latest Threads

Top