Task: Application to create and Load Appointments to a Scheduler Control
So far, I have created appointments and saved them into my SQL 2005 Database.
Then, I retrieve them using a Stored Procedure as shown below.
I use my C# code (as shown below) to load data to the "Datasource" property.
Now, my task is to convert the "ds.Tables" to a "List" and need some help in doing this.
private void LoadAppointments()
var conn = new SqlConnection(ConnectionString);
var adapter = new SqlDataAdapter("LoadAppointment", conn);
var ds = new DataSet();
schedulerStorage1.Appointments.DataSource = ds.Tables;
My SQL 2005 Stored Procedure
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER PROCEDURE [dbo].[LoadAppointment]
SELECT * FROM [Scheduler].[dbo].[tblAppointments]
Any help regarding this would be appreciated a lot!! Thanks in advance