LINQ to ListControl

using System.Data;
using System.Data.SqlClient;
using System.Linq;

绑定 ListControl 的数据源:
try
{
    SqlCommand cmd = new SqlCommand("CommandText", SqlConnection);
    cmd.CommandType = CommandType.StoredProcedure;
    if (SqlConnection.State == ConnectionState.Closed)
        SqlConnection.Open();
    using (SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
    {
        int name = sdr.GetOrdinal("Name");
        var query = from record in sdr.Cast<System.Data.Common.DbDataRecord>()
                    let ID = record.GetString(0) // let: 范围变量 record 只调用一次 GetString()。
                    let Name = record.GetString(name)
                    orderby ID ascending
                    select new { ID, Name };
        var list = query.ToList();
        list.Insert(0, new { ID = "", Name = "" });
        ListControl.Sorted = false; // 绑定数据时，禁用排序。
        ListControl.ValueMember = "ID"; // 绑定数据之前赋值。
        ListControl.DataSource = list.AsReadOnly();
        //ListControl.Items.AddRange(list.ToArray());
        ListControl.DisplayMember = "Name";
    }
}
catch
{
    if (SqlConnection.State == ConnectionState.Open)
        SqlConnection.Close();
}

try
{
    SqlCommand cmd = SqlConnection.CreateCommand();
    cmd.CommandText = string.Format("select {0}ID as ID, {0}Name as Name from {0} order by ID asc", TableName);
    if (SqlConnection.State == ConnectionState.Closed)
        SqlConnection.Open();
    using (SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
    {
        ListControl.ValueMember = "ID"; // 绑定数据之前赋值。
        ListControl.DataSource = sdr.Cast<System.Data.Common.DbDataRecord>().ToList();
        ListControl.DisplayMember = "Name";
    }
}
catch
{
    if (SqlConnection.State == ConnectionState.Open)
        SqlConnection.Close();
}