将数据库项目表中的项目随机并均匀分配给数据库表中的管理员，项目数目和管理员数目个数是不定的，只能从数据库中读取，下面不知道怎么写了？？？？
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;
public partial class 申报管理页面 : System.Web.UI.Page
{
private string connectstring = ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection sqlconn = new SqlConnection(connectstring);
string cmdText = "SELECT * FROM dbo.项目申报内容 ";
string cmdText2 = "SELECT * FROM dbo.管理员";
//string cmdText3 = "SELECT top 4 cxmname FROM dbo.项目申报内容 ORDER BY newid() ";
SqlCommand command = new SqlCommand(cmdText, sqlconn);
SqlCommand command2 = new SqlCommand(cmdText2, sqlconn);
SqlCommand command3 = new SqlCommand(cmdText3, sqlconn);
try
{
//打开连接
sqlconn.Open();
int i = 0;
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
i++;
}
Response.Write(i);
dr.Close();
int j = 0;
SqlDataReader dr2 = command2.ExecuteReader();
while (dr2.Read())
{
j++;
}
Response.Write(j);
dr2.Close();
SqlDataReader dr3 = command3.ExecuteReader();
// while (dr3.Read())
// {
// Response.Write(dr3["cxmname"].ToString());
// }
//dr3.Close();
//for (int k = 0; k < i % j; k++)
//{
//}
}
catch (SqlException sqlex)
{
//显示错误信息
Response.Write(sqlex.Message + "<br>");
}
finally
{
//关闭数据连接
sqlconn.Close();
}// xmname.Text = Convert.ToString(Session["ID"]);
}
}
读出来两个数字，做除法就行了吧，没人几个就确定了啊。然后随机分配数字就行了