there is no 4 in the SP
i even checked with select * from table1
i am not sure where do i get it from but i found this on debugging
?cmdupdate.CommandText
"4"
?cmdupdate
{System.Data.SqlClient.SqlCommand}
CommandText: "4"
CommandTimeout: 30
CommandType: Text {1}
Connection: {System.Data.SqlClient.SqlConnection}
Container: Nothing
DesignTimeVisible: True
Notification: Nothing
NotificationAutoEnlist: True
Parameters: {System.Data.SqlClient.SqlParameterCollection}
Site: Nothing
Transaction: Nothing
UpdatedRowSource: Both {3}
cmdupdate is the sqlcommand
cmdupdate.CommandText = "4"
CommandType.StoredProcedure = StoredProcedure {4}
i get this on debugging the application