各位高人,前辈,大家好,小弟有个疑问请教。
最近学习网上的一个开源日历控件jquery-weekcalendar,发现里面的Event是写死的,代码如下:function getEventData() {
var year = new Date().getFullYear();
var month = new Date().getMonth();
var day = new Date().getDate();
return {
events : [
{
"id":1,
"start": new Date(year, month, day, 12),
"end": new Date(year, month, day, 13, 30),
"title":"Lunch with Mike"
},
{
"id":2,
"start": new Date(year, month, day, 14),
"end": new Date(year, month, day, 14, 45),
"title":"Dev Meeting"
},
{
"id":3,
"start": new Date(year, month, day + 1, 17),
"end": new Date(year, month, day + 1, 17, 45),
"title":"Hair cut"
},
{
"id":4,
"start": new Date(year, month, day - 1, 8),
"end": new Date(year, month, day - 1, 9, 30),
"title":"Team breakfast"
},
{
"id":5,
"start": new Date(year, month, day + 1, 14),
"end": new Date(year, month, day + 1, 15),
"title":"Product showcase"
},
{
"id":6,
"start": new Date(year, month, day, 10),
"end": new Date(year, month, day, 11),
"title":"I'm read-only",
readOnly : true
} ]
};
}请问如果想从DB中抓资料,并且存入这个events : []数组,应该怎么做呢?
DB是SQLServer
最近学习网上的一个开源日历控件jquery-weekcalendar,发现里面的Event是写死的,代码如下:function getEventData() {
var year = new Date().getFullYear();
var month = new Date().getMonth();
var day = new Date().getDate();
return {
events : [
{
"id":1,
"start": new Date(year, month, day, 12),
"end": new Date(year, month, day, 13, 30),
"title":"Lunch with Mike"
},
{
"id":2,
"start": new Date(year, month, day, 14),
"end": new Date(year, month, day, 14, 45),
"title":"Dev Meeting"
},
{
"id":3,
"start": new Date(year, month, day + 1, 17),
"end": new Date(year, month, day + 1, 17, 45),
"title":"Hair cut"
},
{
"id":4,
"start": new Date(year, month, day - 1, 8),
"end": new Date(year, month, day - 1, 9, 30),
"title":"Team breakfast"
},
{
"id":5,
"start": new Date(year, month, day + 1, 14),
"end": new Date(year, month, day + 1, 15),
"title":"Product showcase"
},
{
"id":6,
"start": new Date(year, month, day, 10),
"end": new Date(year, month, day, 11),
"title":"I'm read-only",
readOnly : true
} ]
};
}请问如果想从DB中抓资料,并且存入这个events : []数组,应该怎么做呢?
DB是SQLServer
再用Json定义这个数组,可是不知道怎么实现呢,请大家帮帮忙,我是新手,刚上班不久啊。
1.用Ajax从后台动态抓
2.或者页面加载时,动态生成的JSON数据,getEventData返回这个JSON
一看这个,难道是想让人连基本的数据库连接串、取数据SQL都写出来吗?
to theforever 因为之前没有概念,以为是要在Js里面查询DB
感谢大家,刚刚写了一些代码拿出来晒晒,还请指正啊,错误很多呢function getEventData() {
$.ajax({
type: "GET",
url: "../Index.aspx",
data: "mod=GetEventData",
success: function(data) {
if(data!=null)
{
data.toString();
return {
for (i = 0; i <data.count; i++)
{
events : [
{
"id": data[i].id,
"start": data[i].start.getFullYear().toString(), data[i].start.getMonth().toString(), data[i].start.getDay().toString(), data[i].start.getHours().toString(),data[i].start.getMinutes().toString()),
"end": data[i].start.getFullYear().toString(), data[i].start.getMonth().toString(), data[i].start.getDay().toString(), data[i].start.getHours().toString(),data[i].start.getMinutes().toString()),
"title":data[i].title
}
]
}
};
}
}
});
}后台protected void GetEventData()
{
SCHEDULEBLL SCHEDULEBLL = new SCHEDULEBLL();
DataSet ds = new DataSet();
ds=SCHEDULEBLL.GetList("");//返回DateSet
//SCHEDULEBLL.GetModelList("");//返回List<>
Response.Write(ds);
}感恩!