//判断重复
decimal alli = 0;
for (int i = 0; i < sqlds.Tables[0].Rows.Count; i++)
{
string tempitem = sqlds.Tables[0].Rows[i][0].ToString();
DataRow[] rows;
rows = sqlds.Tables[0].Select("SNumber='" + tempitem + "'");
if (rows.Length > 1)
{
alli = alli + 1;
Response.Write("重复号:" + tempitem + "<br>");
sqlds.Tables[0].Rows[i].Delete();
}
}
Response.Write("重复数:" + alli + "<br>");
decimal alli = 0;
for (int i = 0; i < sqlds.Tables[0].Rows.Count; i++)
{
string tempitem = sqlds.Tables[0].Rows[i][0].ToString();
DataRow[] rows;
rows = sqlds.Tables[0].Select("SNumber='" + tempitem + "'");
if (rows.Length > 1)
{
alli = alli + 1;
Response.Write("重复号:" + tempitem + "<br>");
sqlds.Tables[0].Rows[i].Delete();
}
}
Response.Write("重复数:" + alli + "<br>");