Sharepoint 2010 获取一个列表的所有字段，并转换成SQL语句

  public static string GetListFieldSQLSelect(SPList list)
        {
            StringBuilder sqlSelect = new StringBuilder();
            sqlSelect.Append("select ");
            foreach (SPField _field in list.Fields)
            {
                if (!_field.Hidden && !_field.ReadOnlyField && _field.Type != SPFieldType.Attachments && _field.Type != SPFieldType.Computed)
                {
                    XmlDocument fieldSchemaXml = new XmlDocument();
                    fieldSchemaXml.LoadXml(_field.SchemaXml);
                    string colName = fieldSchemaXml.SelectSingleNode("Field").Attributes["ColName"].Value;

                    sqlSelect.AppendFormat("{0}{1} as {2},", "au.", colName, _field.InternalName);
                }
            }

            return sqlSelect.ToString();

        }

转载于:https://www.cnblogs.com/ahghy/archive/2011/06/07/2074128.html