62,046
社区成员
发帖
与我相关
我的任务
分享
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.DataConStr, CommandType.Text, sql, parameters);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (Int32.Parse(ds.Tables[0].Rows[i][4].ToString()) > 1)
{
for (int j = 0; j < Int32.Parse(ds.Tables[0].Rows[i][4].ToString())-1; j++)
{
//ds.Tables[0].Rows.Add();
ds.Tables[0].Rows.InsertAt(ds.Tables[0].Rows[i], 0);
}
}
}
return ds;
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.DataConStr, CommandType.Text, sql, parameters);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (Int32.Parse(ds.Tables[0].Rows[i][4].ToString()) > 1)
{
for (int j = 0; j < Int32.Parse(ds.Tables[0].Rows[i][4].ToString())-1; j++)
{
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
foreach(DataColumn dc in dt.Columns)
{
dr[dc.ColumnName] = dt.Rows[i][dc.ColumnName].ToString();
}
ds.Tables[0].Rows.InsertAt(dr, 0);
}
}
}
return ds;