获取DataGridview中某列的所有数据

/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dtSource">数据集</param>
/// <param name="filedName">列名</param>
/// <returns></returns>
public static List<T> GetColumnValues<T>(DataTable dtSource, string filedName)
{
return (from r in dtSource.AsEnumerable() select r.Field<T>(filedName)).ToList<T>();
}

调用

 string sql = "select sValueName,sTypeCode, sValueCode , sRemark from dbo.pbDataDictionary where sTypeCode = ‘TubeWeight‘ and bUsable = 1 order by iOrderNo";string connStr = "Data Source=.;Initial Catalog = test;Persist Security Info = True;User ID = zjp;Password =123 ;Connect Timeout=8;" SqlConnection Sqlconn = new SqlConnection(MainForm.connStr); SqlCommand cmd = new SqlCommand(sql, Sqlconn);Sqlconn.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sql, Sqlconn); DataTable dataTable = new DataTable(); da.Fill(dataTable);// List<string> idCode = new List<string>();// idCode = GetColumnValues<string>(dataTable, "sValueCode");//获取整列sValueCode的数据放到List中

 

相关文章