62,074
社区成员
发帖
与我相关
我的任务
分享
create table Test
( number int)
declare @i int
set @i=1
while(@i<=500)
begin
if(@i<>3 and @i<>4 and @i <>6 and @i<>7 and @i<>9)
begin
insert into Test values(@i)
end
set @i=@i+1
end
declare @max int
declare @j int
select @max=MAX(number) from Test
set @j =1
create table Temp(t int)
while(@j<=@max)
begin
if(not exists(select 1 from Test where number=@j))
begin
insert into Temp values(@j)
end
set @j=@j+1
end
select * from Temp
drop table Temp
drop table Test
protected void Page_Load(object sender, EventArgs e)
{
int Min = 0;
int Max = 500;
int count = 200;
List<int> randarray = GetRandomArray(count, Min, Max).ToList();
randarray.Sort();
Response.Write("生成的" + "<br/>");
randarray.ForEach(I => Response.Write(I.ToString() + "<br/>"));
List<int> arrayToLenght = new List<int>();
for (int i = 0; i < count; i++)
{
arrayToLenght.Add(i);
}
Response.Write("---------------------------------------------------");
arrayToLenght.Except(randarray).ToList().ForEach(I => Response.Write(I.ToString() + "<br/>"));
}
public int[] GetRandomArray(int Number, int minNum, int maxNum)
{
int j;
int[] b = new int[Number];
Random r = new Random();
for (j = 0; j < Number; j++)
{
int i = r.Next(minNum, maxNum);
int num = 0;
for (int k = 0; k < j; k++)
{
if (b[k] == i)
{
num = num + 1;
}
}
if (num == 0)
{
b[j] = i;
}
else
{
j = j - 1;
}
}
return b;
}