超时不有响影啊,看看IIS架高正不正确
解决方案 »
- 求助 C# 应用程序 使用皮肤的时候出现问题了,不报错,但是皮肤没有效果,新建一个项目一样的代码操作又可以!
- 合作开发仿真软件(车间生产流程)
- winform中如何配置数据源?
- 求一正则表达式,简单,但我不会
- 简单的存储过程问题
- 关于Control的keydown事件,很是让老夫郁闷?
- 请问在commandtext写t-sql语句的问题
- C#中响应linkLabel的点击事件
- 问个改变大小界面很卡的问题,文本框内容很多
- sorry cant type chinese now : plz help !! how can i get a row count of SqlDatareader that's got by SqlCommand.ExecuteReader ?
- 如何在一个WEBFORM中调用另一个WEBFORM中的函数?
- c#和vc.net ,asp.net,vb.net关系?
public void InsertUsers()
{
this.connString();
SqlParameter[] parms={};
for(int i=0;i<aryServerConn.Count;i++)
{
aryUsers.Clear();
aryRoles.Clear();
string curServerConn=Convert.ToString(aryServerConn[i]);
using(SqlDataReader rdr = DataBase.ExecuteReader(curServerConn,CommandType.Text,SQL_SELECT_USERID,parms))
{
while(rdr.Read())
{
aryUsers.Add(rdr["strAccountID"]);
aryRoles.Add(rdr["strUserID"]);
} MessageBox.Show(Convert.ToString(aryRoles.Count)); using (SqlConnection conn=new SqlConnection(DataBase.CONN_STRING))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
for(int j=0;j<aryUsers.Count;j++)
{
//MessageBox.Show(Convert.ToString(aryRoles[0]));
string SQL_SELECT_USER="select * from everuser where strClientID='" + aryUsers[j] + "'";
using (SqlDataReader rdrUsers = DataBase.ExecuteReader(DataBase.CONN_STRING,CommandType.Text,SQL_SELECT_USER,parms))
{
if (rdrUsers.Read())
{
}
else
{
string SQL_INSERT_EVERUSER="insert into everuser (strClientID,strPasswd,strSocNo) values ('" + aryUsers[j] + "','111222333','')";
string SQL_INSERT_CLIENT="Insert into client (strClientID,strName,strEmail) values ('" + aryUsers[j] + "','请修改','[email protected]')";
string SQL_INSERT_CLIENTMORE="Insert into clientMore (strClientID) values ('"+ aryUsers[j] +"')";
DataBase.ExecuteNonQuery(trans,CommandType.Text,SQL_INSERT_EVERUSER,parms);
DataBase.ExecuteNonQuery(trans,CommandType.Text,SQL_INSERT_CLIENT,parms);
DataBase.ExecuteNonQuery(trans,CommandType.Text,SQL_INSERT_CLIENTMORE,parms);
} //插入Ever_UserID信息
int strServerID=i+1;
string SQL_INSERT_EVER_USERID="insert into ever_userid (strClientID,strUserID,ServerID) values ('" + aryUsers[j] + "','" + aryRoles[j] + "','" + strServerID + "')";
DataBase.ExecuteNonQuery(trans,CommandType.Text,SQL_INSERT_EVER_USERID,parms); int strZoneID=i+2;
//插入zoneinfo信息
string SQL_INSERT_ZONEINFO="Insert into ZoneInfo_0" + strZoneID + " (strClientID,strUserID,ZoneNumber,SiteCode,end_x,end_y) values ('" + aryUsers[j] + "','" + aryRoles[j] + "','0','1000','20','214')";
DataBase.ExecuteNonQuery(trans,CommandType.Text,SQL_INSERT_ZONEINFO,parms);
}
}
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
}
}
我在执行如上程序时出现错误的。