C# and SQL Server 2005

See more:

SQL-Server-2005

C#

SQL-Server

Hello,

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.

My Code

private void LoadAppointments()
        {
            var conn = new SqlConnection(ConnectionString);
            var adapter = new SqlDataAdapter("LoadAppointment", conn);
            var ds = new DataSet();
            adapter.Fill(ds);
            schedulerStorage1.Appointments.DataSource = ds.Tables[0];
        }

My SQL 2005 Stored Procedure

USE [Scheduler]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[LoadAppointment]
AS
SELECT * FROM [Scheduler].[dbo].[tblAppointments]
GO

Any help regarding this would be appreciated a lot!! Thanks in advance