Hello,
I don't find information how to view events in DayPilotScheduler.
I want that every resources I can view its appointments.
My code in function Load:
SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnAttiva"].ConnectionString;
cnn.Open();

StrSql = "select ClCodice, rtrim(ClNome) + ' ' + rtrim(ClCognome) as 'nomerisorsa' " +
"from " + CodApplicazione + "UtenteLogin inner join " + CodApplicazione + "UtenteAgenzia on UlCodice = UaCodice " +
"and UaAgenziaFiliale = '" + CodAgenzia + "' and UaAgenziaContatto = '" + CodAgenzia + "' " +
"and UaCodiceFiliale = '" + Session["CodFilialeUtente"].ToString() + "' and UlCodiceCpuser <> '20' " +
"inner join " + CodApplicazione + "Contatto on ClAgenzia = UaAgenziaContatto and ClCodice = UaCodiceContatto";


SqlCommand cmd = new SqlCommand(StrSql, cnn);
SqlDataReader sdr = cmd.ExecuteReader();

DayPilotScheduler1.Resources.Clear();

while (sdr.Read())
{
DayPilotScheduler1.Resources.Add(new Resource(Convert.ToString(sdr["nomerisorsa"]), Convert.ToString(sdr["ClCodice"])));
}

sdr.Close();
cnn.Close();

My code for datatable:

protected DataTable getData
{
get
{
SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnAttiva"].ConnectionString;
cnn.Open();

//leggere gli appuntamenti e salvare in un dataset
string StrSql = "Select ClCodice, rtrim(ClNome) + ' ' + rtrim(ClCognome) as 'nomerisorsa', plagenzia + '/' + plcodice as 'key', rtrim(TpDescrizione) as tag, rtrim(TpDescrizione) + ' - ' + rtrim(PlLuogo) as subject," +
"dateadd(minute ,cast(right(PlOraInizio,2) as int),dateadd(Hour, cast(left(PlOraInizio,2) as int), PlData)) as start, " +
"dateadd(minute ,cast(right(PlOraFine,2) as int),dateadd(Hour, cast(left(PlOraFine,2) as int), PlData)) as 'end', PlNote as nota, rtrim(PlLuogo) as luogo From vst_" + CodApplicazione + "_Planner Where " +
"PlAgenzia = '" + CodAgenzia + "' And PlFiliale = '" + Session["CodFilialeUtente"].ToString() + "'";

// query
SqlDataAdapter query = new SqlDataAdapter(StrSql, cnn);

// creo il dataset
DataSet querydataset = new DataSet();
query.Fill(querydataset);

cnn.Close();

//resistuisco la tabella con i dati
return querydataset.Tables[0];
}

}

in the page aspx:

<DayPilot:DayPilotScheduler ID="DayPilotScheduler1" runat="server" TimeFormat="Clock24Hours"
DataValueField="key" DataTextField="subject" DataEndField="end" DataTagFields="tag" DataStartField="start" DataSource="<%# getData %>" DataResourceField="nomerisorsa" CellDuration="15" DurationBarColor="#666666" CellGroupBy="Hour">

</DayPilot:DayPilotScheduler>

I see the resorces, but I don't see their appointment.
what I mistake?
Thanks