插入数据

private void button1_Click(object sender, System.EventArgs e)
  {
   OracleConnection conn = new OracleConnection("server = neusoft; uid = student; password = student;");
   string insertcmd = "insert into stud_info(stud_id,name,birthday,gender,address,telcode,zipcode,mark) values (:id,:name,:birthday,:gender,:address,:telcode,:zipcode,:mark)";
   try
   {
    OracleCommand mycommand = new OracleCommand(insertcmd,conn);

    mycommand.Parameters.Add(new OracleParameter("id",OracleType.Char,10));
    mycommand.Parameters["id"].Value = sid.Text;

    mycommand.Parameters.Add(new OracleParameter("name",OracleType.Char,8));
    mycommand.Parameters["name"].Value = sname.Text;

    mycommand.Parameters.Add(new OracleParameter("birthday",OracleType.DateTime));
    string sb = sbirthday.Text;
    mycommand.Parameters["birthday"].Value = new DateTime(Convert.ToInt32(sb.Substring(0,4)),Convert.ToInt32(sb.Substring(5,2)),Convert.ToInt32(sb.Substring(8,2)));
  
    mycommand.Parameters.Add(new OracleParameter("gender",OracleType.Char,2));
    mycommand.Parameters["gender"].Value = sgender.Text;

    mycommand.Parameters.Add(new OracleParameter("address",OracleType.NVarChar,20));
    mycommand.Parameters["address"].Value = saddress.Text;

    mycommand.Parameters.Add(new OracleParameter("telcode",OracleType.Char,12));
    mycommand.Parameters["telcode"].Value = stelcode.Text;

    mycommand.Parameters.Add(new OracleParameter("zipcode",OracleType.Char,6));
    mycommand.Parameters["zipcode"].Value = szipcode.Text;

    mycommand.Parameters.Add(new OracleParameter("mark",OracleType.Number,3));
    mycommand.Parameters["mark"].Value =smark.Text;

  
    mycommand.Connection.Open();

    try
    {
     mycommand.ExecuteNonQuery();
     MessageBox.Show("插入成功");
    }

    catch(OracleException ex)
    {
     MessageBox.Show("插入的数据有错！" + ex.Message.ToString());
    }

    finally
    {
     mycommand.Connection.Close();
    }
   }
   catch (Exception oe)
   {
    MessageBox.Show(oe.ToString());
   }
  }