ORACLE显示表单项目

private void Form1_Load(object sender, System.EventArgs e)
  {
     OracleConnection conn = new OracleConnection("server = neusoft; uid = student; password = student;");
   string sql = @"select * from stud_info";
   OracleDataAdapter da = new OracleDataAdapter(sql,conn);
   DataSet ds = new DataSet();

   da.Fill(ds,"stud_info");
   dataGrid1.SetDataBinding (ds,"stud_info");
  }

        /*-----------执行鼠标移动时数据跳跃事件-----------*/
  private void dataGrid1_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
  {
   int rn= dataGrid1.CurrentCell.RowNumber;
   string [] vv=new string[8];
   for(int i=0; i<=7; i++)
   {
    vv[i] = dataGrid1[rn,i].ToString().Trim();
   }
   sid.Text=vv[0];
   sname.Text=vv[1];
   sbirthday.Text=vv[2];
   sgender.Text=vv[3];
   saddress.Text=vv[4];
   stelcode.Text=vv[5];
   szipcode.Text=vv[6];
   smark.Text=vv[7];

  }

  private void button1_Click(object sender, System.EventArgs e)
  {
   OracleConnection conn = new OracleConnection("server = neusoft; uid = student; password = student;");
   OracleCommand comm = new OracleCommand();
   try
   {
    conn.Open();
    comm.Connection = conn;

    string delesql = "delete stud_info where stud_id = '"+sid.Text+"'";
    this.sid.Text = "";

    comm.CommandText= delesql;

    try
    {
     comm.ExecuteNonQuery();
     MessageBox.Show("删除成功！");

     /*------重新填充数据-------*/
     OracleConnection conn1 = new OracleConnection("server = neusoft; uid = student; password = student;");
     string sql = @"select * from stud_info";
     OracleDataAdapter da = new OracleDataAdapter(sql,conn1);
     DataSet ds = new DataSet();
     da.Fill(ds,"stud_info");
     dataGrid1.SetDataBinding (ds,"stud_info");
     
    }
    catch (Exception ex)
    {
     MessageBox.Show(ex.ToString());
    }
    finally
    {
     conn.Close();
    }
   }
   catch(Exception oExcept)
   {
    MessageBox.Show(oExcept.Message);
   }

  }

  private void button2_Click(object sender, System.EventArgs e)
  {
   string sb = sbirthday.Text;
   int bt = sb.IndexOf(" ");
   /*------注意SQL语句的时间-----*/
   string updatesql = "update stud_info set  name = '"+sname.Text+"',birthday = to_date('"+sb+"','yyyy-mm-dd'),gender = '"+sgender.Text+"',address = '"+saddress.Text+"',telcode = '"+stelcode.Text+"',zipcode = '"+szipcode.Text+"',mark = '"+smark.Text+"'where stud_id = '"+sid.Text+"'";
   if (bt != -1)
   {
    updatesql = "update stud_info set  name = '"+sname.Text+"',birthday = to_date('"+sb.Substring(0,bt)+"','yyyy-mm-dd'),gender = '"+sgender.Text+"',address = '"+saddress.Text+"',telcode = '"+stelcode.Text+"',zipcode = '"+szipcode.Text+"',mark = '"+smark.Text+"'where stud_id = '"+sid.Text+"'";
   }

   OracleConnection conn = new OracleConnection("server = neusoft; uid = student; password = student;");
   OracleCommand mycommand = new OracleCommand(updatesql,conn);
   try
   {
    conn.Open();
    
    
    try
    {
     /*-------执行修改-------*/
     mycommand.ExecuteNonQuery();
     MessageBox.Show("修改成功！");

     /*-------重新填充数据-------*/
     OracleConnection conn1 = new OracleConnection("server = neusoft; uid = student; password = student;");
     string sql = @"select * from stud_info";
     OracleDataAdapter da = new OracleDataAdapter(sql,conn1);
     DataSet ds = new DataSet();
     da.Fill(ds,"stud_info");
     dataGrid1.SetDataBinding (ds,"stud_info");
    }
    catch (Exception ex)
    {
     MessageBox.Show(ex.ToString());
    }
    finally
    {
     conn.Close();
    }

   }
   catch(Exception oExcept)
   {
    MessageBox.Show(oExcept.ToString());
   }
  }