DayPilot Forums

Can anyone help me with the code for databinding. I tried myself but not working

What do you want to do?

You got to add to the daypilotschedular the following attributes

DataValueField="YourID field" DataResourceField="your resource ID field"
DataStartField=""From field" DataEndField="date to field" dataTextfield="what shows in the event cell"

plus DataSourceID="your data source i

Is there any place I can get the entire code to insert the data into a database?

You should take a look at the DemoSQL directory, especially DemoSQL/Default.aspx.cs. You will find a sample TimeRangeSelected handler there:

    protected void DayPilotCalendar1_TimeRangeSelected(object sender, 
       TimeRangeSelectedEventArgs e)
    {

        using (SqlConnection con 
          = new SqlConnection(ConfigurationManager.ConnectionStrings["daypilot"].ConnectionString))
        {
            con.Open();

            SqlCommand cmd = new SqlCommand("INSERT INTO [event] (eventstart, eventend, name, allday) VALUES (@start, @end, @name, 0)", con);
            cmd.Parameters.AddWithValue("start", e.Start);
            cmd.Parameters.AddWithValue("end", e.End);
            cmd.Parameters.AddWithValue("name", "New event");
            cmd.ExecuteNonQuery();

        }

        DayPilotCalendar1.DataBind();
        DayPilotCalendar1.Update();

    }

This demonstrates how to do it for DayPilotCalendar, but DayPilotScheduler works the same way.