oracleÖÐͨ¹ýʱ¼ä²éѯÄÚÈݵÄÎÊÌâ - Oracle / ¿ª·¢

ÏÂÃæÊÇ.netÉϵĴúÂë
  private void button1_Click(object sender, EventArgs e)
  {
  DateTime GivenDay = DateTime.Parse(SelectDay.Text.Trim());
  Fill_dayview(GivenDay);
  }

  //ÓÃÓÚÉú³ÉÈÕÊÓͼ
  private int Fill_dayview(DateTime GivenDay)
  {
  //Éú³ÉÒ»¸öеÄDataSet
  DataSet DS_DayView = new DataSet();
  MySchedule DaySchedule = new MySchedule();
  if (!DaySchedule.GetScheduleByGivenDay(ref myConn, ref DS_DayView, ref GivenDay))
  return -1;
  int nScheduleCount = DS_DayView.Tables["ScheduleList"].Rows.Count;
  dg_dayview.DataSource = DS_DayView.Tables["ScheduleList"].DefaultView;
  return 0;
  }


ÏÂÃæÊÇoracleµÄ´úÂ룺
CREATE OR REPLACE PROCEDURE GetScheduleGivenDay (GivenDay date)
as
task_title task.title%type;
task_detail task.detail%type;
task_begintime task.begintime%type;
task_notifytime task.notifytime%type;
task_neednotify task.neednotify%type;
task_finished task.finished%type;
tasktype_typetitle tasktype.typetitle%type;
priority_title priority.prioritytitle%type;
begin
select
  task.title,
  task.detail,
  task.