我有一个数据库表有一个phoneNumber字段,现在我现对其中的为空的记录更新为随机的数字但是每条都不一样.:string mysql2 = "Select phoneNumber From [User] WHERE phoneNumber is NULL";
try
{
DataSet ds2 = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, mysql2, null);
if (ds2.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
string aa =randomNumber()//该方法返回一个随机数字串.
String mysql3= "UPDATE [User] SET phoneNumber='" + aa + "'WHERE phoneNumber is NULL"; //这样子明显的有错误可是不知道怎样写,请帮忙看下. DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, mysql3, null);
}
}
}
try
{
DataSet ds2 = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, mysql2, null);
if (ds2.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
string aa =randomNumber()//该方法返回一个随机数字串.
String mysql3= "UPDATE [User] SET phoneNumber='" + aa + "'WHERE phoneNumber is NULL"; //这样子明显的有错误可是不知道怎样写,请帮忙看下. DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, mysql3, null);
}
}
}
WHERE 前面没空格!
try
{
DataSet ds2 = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, mysql2, null);
if (ds2.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
string aa =randomNumber()//该方法返回一个随机数字串.
String mysql3= "UPDATE [User] SET phoneNumber='" + aa + "'WHERE id = ds2.Tables[0].Row[i][0].toString();
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, mysql3, null);
}
}
}
String mysql3= "UPDATE [User] SET phoneNumber='" + aa + "' WHERE [标识字段]='"+ds2.Tables[0].Rows[i]["标识字段"]+"'"
string mysql2 = "Select phoneNumber From [User] WHERE phoneNumber is NULL";
try
{
DataSet ds2 = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, mysql2, null);
if (ds2.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
string aa =randomNumber()//该方法返回一个随机数字串.
String mysql3= "UPDATE [User] SET phoneNumber='" + aa + "'WHERE phoneNumber=(SELECT top 1 phoneNumber FROM [User] WHERE phoneNumber is NULL)"; //这样子明显的有错误可是不知道怎样写,请帮忙看下.
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnectionString, CommandType.Text, mysql3, null);
}
}
}
string mysql2 = "Select ID,phoneNumber From [User] WHERE phoneNumber is NULL";
string mysql3= "update user set phoneNumber = '"+aa+"' where [id] = '" + ds.Tables[0].Rows[i]["ID"].ToString() + "'";