日历源代码,是网络上一个朋友的作品!我拿过来研究了下,写下我的读书笔记!
1.DB类:
public static OleDbConnection con()
{
return new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+System.Environment.CurrentDirectory+"//calender.mdb");
}
这里在调试的时候可以查询出:?System.Environment.CurrentDirectory
结果是:@"C:/Documents and Settings/李计刚.SHANGDA-18/桌面/日历源代码/bin/Debug"
2.IsNumeric()这个函数用来判断输入文字是否是数字!
private bool IsNumeric(string str)
{
if (str==null || str.Length==0)
return false;
foreach(char c in str)
{
if (!Char.IsNumber(c))
{
return false;
}
}
return true;
}
3.给日历控件中相应日期根据数据库加粗:
while(dr.Read())
{
this.monthCalendar1.AddBoldedDate(Convert.ToDateTime(dr["datetime"]).Date);
}
this.monthCalendar1.UpdateBoldedDates();
4.在日历里写入信息,比如说加粗
OleDbConnection conn=DB.con();
conn.Open();
OleDbCommand cmd=new OleDbCommand("insert into cal ([datetime],content,preday) values('"+this.monthCalendar1.SelectionStart.ToShortDateString()+"','"+this.textBox1.Text+"',#"+this.monthCalendar1.SelectionStart.AddDays(-Convert.ToInt32(this.textBox2.Text))+"#)",conn);
cmd.ExecuteNonQuery();
this.label1.Text="添加成功!"; this.monthCalendar1.AddBoldedDate(this.monthCalendar1.SelectionStart.Date);
this.monthCalendar1.UpdateBoldedDates();