SQL Tutorial - C# Populate ComboBox Dropdown DataSet Stored Procedure

Here is the C# snippet to populate a ComboBox called iOwner

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;


private void LoadUsers()
{

string connectionString = null;
SqlConnection connection;
SqlDataAdapter adapter;
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();

connectionString = "Data Source=.;Initial Catalog=ContractManagement;Integrated Security=True";
connection = new SqlConnection(connectionString);

connection.Open();
cmd.Connection = connection;

//Load user list
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.uspListAllUsers";
adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
iOwnerID.DataSource = ds.Tables[0].DefaultView;
iOwnerID.DisplayMember = "FullName";
iOwnerID.ValueMember = "EMail";
cmd.Parameters.Clear();

connection.Close();
connection.Dispose();

}

Here is the SQL Stored Procedure

CREATE PROCEDURE [dbo].[uspListAllUsers]
AS
SET NOCOUNT ON
SELECT UserID,
FirstName,
Surname,
EMail,
Surname + ', ' + FirstName as FullName
FROM dbo.Users
ORDER BY Surname