Problem In Deleting A Record From Tale

hai dears i want to delete a row from the table on the basis of key sent in beusers obj

 

"connection myConn = new connection();" this is ma own class that establishes the connetion which works fine in other caseseg insert

'' it shows no error or exception ' but do not delete record

so plz tell me how to do this...

 or whats wrong in this

public void delete(BEusers obj)

{

connection myConn = new connection();

 oCommand = new SqlCommand("sp_delete_tbl_users_by_userid",myConn.sqlCon);

oCommand.CommandType = CommandType.StoredProcedure;

 

 try {

 myConn.OpenConnection();

 sp = oCommand.Parameters.Add("@User_Id", SqlDbType.VarChar);

 sp.Size = 20;

sp.Value = obj.user_id;

oCommand.ExecuteNonQuery();

 }

catch (Exception oException)

{ throw oException; }

finally { myConn.CloseConnection(); }

 }