//小弟这两天才入职,要写一个简单的日程安排,之前一直用的sqlserver,最近才接触orcale,大致要实现,打开日历加载每天的日程,然后点击日期实现添加修改
//目前遇到的问题是,从数据库中读出来的字段怎么添加到calendar控件中去,然后点击跳转后如何添加
//大致思路有了,但是写了大半天还没写出来,如果有类似demo的能不能发给我参考一下
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
//定义连接数据库的字符串
string constring = "Data Source=192.168.27.122/orcl;User ID=cale;Password=cale;Unicode=True";
//进行连接
OracleConnection conn = new OracleConnection(constring);
conn.Open();//打开指定的连接
OracleCommand com = conn.CreateCommand();
//执行的Sql语句
string date = "2016-04-1";
com.CommandText = "SELECT PLAN_CONTENT FROM CALE WHERE PLAN_DATE = To_Date('" + date + "','YYYY-MM-DD');";
OracleDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Label1.Text =reader.GetString(0);
}
reader.Close();
conn.Close();
}
protected void Calendar1_SelectionChanged(object sender, DayRenderEventArgs e)
{
CalendarDay d = ((DayRenderEventArgs)e).Day;
string id = d.ToString();
Response.Write("<script>window.open('addItem.aspx?id=" + id + "')</script>");
}