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