问题描述
- 将数据库项目表中的项目随机并均匀分配给数据库表中的管理员,求大神指导一下!!!!!!
-
将数据库项目表中的项目随机并均匀分配给数据库表中的管理员,项目数目和管理员数目个数是不定的,只能从数据库中读取,下面不知道怎么写了????
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"]); }
}
解决方案
读出来两个数字,做除法就行了吧,没人几个就确定了啊。然后随机分配数字就行了
时间: 2024-07-31 13:17:12