#region 连接数据库.

        private string _strConn = @"Data Source=.\SQLExpress;Initial Catalog=DB_Person;Integrated Security=True";   //连接字符串.

        private LinqProcessSalaryDataContext _linq; //linq连接对象.

        #endregion



_linq = new LinqProcessSalaryDataContext(_strConn);

            var allMember = from member in _linq.批次确认公示人员信息表_xls_s

                            where member.工资 > 0

                            select new {

                                序号 = member.序号,

                                主管单位 = member.主管单位,

                                职位编码 = member.职位编码,

                                姓名 = member.姓名,

                                性别 = member.性别,

                                出生年月 = member.出生年月,

                                毕业院校_工作单位 = member.毕业院校_工作单位,

                                工资 = member.工资

                            };