ASP.NET

 string custsrc = custsrccode.Text;            
            string name = custname.Text;
            string city = custcity.Text;
            string state = custstate.Text;
            string postcode = custpostalcode.Text;
            string actcode = activitycode.SelectedItem.Text;
            string id = labelID.Text;
            string activityid = labelactivityid.Text;

  OracleConnection conn = new OracleConnection();  // C#
                conn.ConnectionString = strConnection;
                conn.Open();

                OracleCommand cmd = new OracleCommand();
                cmd.Connection = conn;
                cmd.CommandText = "INSERT INTO BUYING_ACTIVITY (CUSTOMER_SOURCE_CODE, CUSTOMER_NAME, CUSTOMER_CITY, CUSTOMER_STATE, CUSTOMER_POSTAL_CODE, BUYING_ACTIVITY_CODE, ID) " +
                "VALUES (:custsrc, :name, :city, :state, :postcode, :actcode, :id)";


                cmd.Parameters.Add(new OracleParameter("custsrc", custsrc));
                cmd.Parameters.Add(new OracleParameter("name", name));
                cmd.Parameters.Add(new OracleParameter("city", city));
                cmd.Parameters.Add(new OracleParameter("state", state));
                cmd.Parameters.Add(new OracleParameter("postcode", postcode));
                cmd.Parameters.Add(new OracleParameter("actcode", actcode));
                cmd.Parameters.Add(new OracleParameter("id", id));

                cmd.ExecuteNonQuery();
                
                conn.Close();

Response.Redirect("contractinfo.aspx?Id=" + labelRID.Text);

string contnumber = contractnumber.Text;
            string solnumber = solicitationnumber.Text;
            string ordnumber = ordernumber.Text;
            string contstartdate = contractstartdate.Value;
            string contenddate = contractenddate.Value;
            string solstartdate = solicitationstartdate.Value;
            string solenddate = solicitationenddate.Value;
            string soltype = solicitationtype.Text;
            string pasnum = pasnumber.Text;
            string commnts = comments.Text;
            string contkind = contractkind.SelectedItem.Text;
            string conttype = contracttype.SelectedItem.Text;
            string ponum = ponumber.Text;
            string instrtype = instrumenttype.SelectedItem.Text;
            string totcontractamount = totalcontractamount.Text;
            string estimloddate = estloddate.Value;
            string contfirstname = contractfirstname.Text;
            string contmiddleinit = contractmiddleinit.Text;
            string contlastname = contractlastname.Text;
            string lodsigned = datelodsigned.Value;
            string contractid = contractinfoid.Text;

OracleConnection conn = new OracleConnection();  // C#
               conn.ConnectionString = strConnection;
               conn.Open();

               OracleCommand cmd = new OracleCommand();
               cmd.Connection = conn;
               cmd.CommandText = "UPDATE CONTRACT_INFO SET  CONTRACT_SELECTION = :contractselection, CONTRACT_NUMBER = :contnumber, SOLICITATION_NUMBER = :solnumber, ORDER_SELECTION = :orderselection, ORDER_NUMBER = :ordnumber, CONTRACT_START_PERIOD = to_date(:contstartdate, 'MM/DD/YYYY'), CONTRACT_END_PERIOD =  to_date(:contenddate, 'MM/DD/YYYY'), SOLICITATION_START_DATE = to_date(:solstartdate, 'MM/DD/YYYY'), SOLICITATION_END_DATE =  to_date(:solenddate, 'MM/DD/YYYY'), SOLICITATION_TYPE = :soltype, SURVEY_REQUESTED = :preaward, PAS_NUMBER = :pasnum, COMMENTS = :commnts, CONTRACT_KIND = :contkind, CONTRACT_TYPE = :conttype, PO_ASSOCIATED = :poselection, PO_NUMBER = :ponum, INSTRUMENT_TYPE = :instrtype, TOTAL_CONTRACT_AMOUNT = :totcontractamount, EST_LOD_COMPLETION_DATE = to_date(:estimloddate, 'MM/DD/YYYY'), FIRST_NAME = :contfirstname, MIDDLE_INIT = :contmiddleinit, LAST_NAME = :contractlastname, DATE_LOD_SIGNED = to_date(:lodsigned, 'MM/DD/YYYY') CONTRACT_INFO_ID = :contractid";

               cmd.Parameters.Add(new OracleParameter("contractid", contractid));

               cmd.Parameters.Add(new OracleParameter("contractselection", contselection));
               cmd.Parameters.Add(new OracleParameter("contnumber", contnumber));
               cmd.Parameters.Add(new OracleParameter("solnumber", solnumber));
               cmd.Parameters.Add(new OracleParameter("orderselection", ordselection));
               cmd.Parameters.Add(new OracleParameter("ordnumber", ordnumber));
               cmd.Parameters.Add(new OracleParameter("contstartdate", contstartdate));
               cmd.Parameters.Add(new OracleParameter("contenddate", contenddate));
               cmd.Parameters.Add(new OracleParameter("solstartdate", solstartdate));
               cmd.Parameters.Add(new OracleParameter("solenddate", solenddate));
               cmd.Parameters.Add(new OracleParameter("soltype", soltype));
               cmd.Parameters.Add(new OracleParameter("preaward", preawardselection));
               cmd.Parameters.Add(new OracleParameter("pasnum", pasnum));
               cmd.Parameters.Add(new OracleParameter("commnts", commnts));
               cmd.Parameters.Add(new OracleParameter("contkind", contkind));
               cmd.Parameters.Add(new OracleParameter("conttype", conttype));
               cmd.Parameters.Add(new OracleParameter("poselection", purselection));
               cmd.Parameters.Add(new OracleParameter("ponum", ponum));
               cmd.Parameters.Add(new OracleParameter("instrtype", instrtype));
               cmd.Parameters.Add(new OracleParameter("totcontractamount", totcontractamount));
               cmd.Parameters.Add(new OracleParameter("estimloddate", estimloddate));
               cmd.Parameters.Add(new OracleParameter("contfirstname", contfirstname));
               cmd.Parameters.Add(new OracleParameter("contmiddleinit", contmiddleinit));
               cmd.Parameters.Add(new OracleParameter("contlastname", contlastname));
               cmd.Parameters.Add(new OracleParameter("lodsigned", lodsigned));



               cmd.ExecuteNonQuery();

               conn.Close();

OracleConnection conn = new OracleConnection();
            OracleCommand cmd = new OracleCommand();
            conn.ConnectionString = strConnection;
            conn.Open();

            cmd.Connection = conn;
            cmd.CommandText = "Select RID, CODE, CUSTOMER_NAME from ACTIVITY WHERE ID = :IDValue";
            //Add values to paramter
            cmd.Parameters.Add(new OracleParameter("IDValue", Request.QueryString["ID"]));

            OracleDataAdapter da = new OracleDataAdapter(cmd);
            cmd.CommandType = CommandType.Text;
            OracleDataReader dr = cmd.ExecuteReader();

            name.Text = dr["customer_name"].ToString();
            code.SelectedItem.Text = dr["code"].ToString();

            dr.Close();
            conn.Close();

private void cvactivitycode_ServerValidate(object source, ServerValidateEventArgs args)
        {
            args.IsValid = false;
            for (short I = 1; (I
                        <= (activitycode.Items.Count - 1)); I++)
            {
                if (activitycode.Items(I).Value)
                {
                    args.IsValid = true;
                    break;
                }

            }

        }