How do i rewrite this code to handle Optimistic concurrency!

To start with, I like your PM, pure code is always better in that you have all the control you need and I never use databound controls, way too many problems with them.  I have never needed to use stored procs so this part I am not that familiar with.

Do you have an email address I can send you some code?

This is one function in the class I will send you, it executes queries -  insert, update or delete to run stored procs you could send this function something like this - execSQL("EXECUTE(stored_proc_name)" );

    //-----------------------------------------------------------------
    public bool execSQL(string s)
        {
        bool success = true;
        sqlCon con = new sqlCon();
        try
            {
            con.connect();
            con.command(s);
            con.beginTrans();
            con.write();
            con.commitTrans();
            }
        catch (Exception err)
            {
            con.rollbackTrans();
            success = false;
            }
        finally
            {
            con.terminate();
            }
        return (success);

    }
  //-----------------------------------------------------------------

other functions allow you to easily get fields from returned result set and populate text boxes etc.

functions like get("field_name") would be used like this TextBox1.text = con.get("CustomerName");

other syntax - to load combo boxes

 while(con.read())
    {
     ComboBox1.Items.Add(con.get("CustomerName"));
     }

Does this make sense.