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();
}