62,074
社区成员
发帖
与我相关
我的任务
分享
public static List<Register> suiji()
{
List<Register> result = new List<Register> ();
string sql = "select top 19 * from Register order by NEWID()";
try
{
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AppConnectionString, CommandType.Text, sql, null);
Register rea;
while (reader.Read())
{
rea = new Register(reader);
result.Add(rea);
}
else
{
reader.Close();
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
return result;
}
public static Register suiji()
{
string sql = "select top 19 * from Register order by NEWID()";
try
{
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AppConnectionString, CommandType.Text, sql, null);
if (reader.Read())
{
Register rea = new Register(reader);
return rea;
}
else
{
reader.Close();
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return null;
}
}
select top 19 *,NEWID() [newID] into #table from [User] order by [newID]
select * from #table
select top 19 *,NEWID() [newID] into #table from [User] order by [newID]
select * from #table
select top 19 * from Users order by NEWID()