sql查询tips



1、select * from C_ServiceProject order by CAST(ServiceProjectID AS INT) ASC

//将字符型的ID转化为INT型进行排序；

2、1方法在LINQ中的实现

            var ServiceProject = (from sp in ac.ServiceProject select sp.ServiceProjectName+","+sp.ServiceProjectID).ToList();
            ServiceProject.Sort();
            string[] arrays1 = new string[25];
            for(int j=0;j<25;j++)
            {
               
                string []aa=ServiceProject[j].Split(',');
                int index = Convert.ToInt32(aa[1]);
                arrays1[index-1] = ServiceProject[j].ToString();
            }