如何从Sql数据库向日历控件提供源代码 [英] How to Give Source From Sql Database To Calendar Control

问题描述

如何从数据库向日历控件提供数据源...



我这样做但是出错了

How to Give Data source to Calendar control from Database...

im Doing this But Getting Error

"

Column '' does not belong to table Table.

"

DataSet EventDs = new DataSet();
        obj.OpenReturenDs("Select TXT_ACTIVITY_DESC as EventHeader ,DAT_START as EventStartDate,DAT_END as EventEndDate from T_ACTIVITY Where Month(DAT_START)=10 and DAT_END is not null", EventDs);
        if (EventDs.Tables[0].Rows.Count > 0)
        {
            Calendar1.EventStartDateColumnName = "EventStartDate";
            Calendar1.EventEndDateColumnName = "EventEndDate";

            Calendar1.EventHeaderColumnName = "EventHeader";
            
            Calendar1.EventSource = EventDs.Tables[0];
        }

推荐答案

请参阅：如何：在日历控件中显示数据库中的选定日期[msdn] [ ^ ]



问候..

See this: How to: Display Selected Dates from a Database in the Calendar Control [msdn][^]

Regards..

这篇关于如何从Sql数据库向日历控件提供源代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！