62,047
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("FID");
dt.Columns.Add("MID");
string[] strIDs = new string[] { "1", "2", "张4" };
for (int i = 0; i < strIDs.Length; i++)
{
Select(dt, strIDs[i], 0);
}
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
}
private void Select(DataTable dt, string id, int c)
{
if (id == null || id == "")
{
return;
}
DataSet ds = SqlHelper.ExecuteDataset(CONNECTION_STRING, CommandType.Text, "select ID,FID,MID from tba where ID='" + id + "'");
//判断是否存在
if (ds.Tables[0].Rows.Count == 1)
{
string strID = ConvertToString(ds.Tables[0].Rows[0]["ID"]);
string strFID = ConvertToString(ds.Tables[0].Rows[0]["FID"]);
string strMID = ConvertToString(ds.Tables[0].Rows[0]["MID"]);
DataRow row = dt.NewRow();
row["ID"] = strID;
row["FID"] = strFID;
row["MID"] = strMID;
dt.Rows.Add(row);
if (strFID != "" && strMID != "")
{
c++;
if (c < 4)
{
Select(dt, strFID, c);
Select(dt, strMID, c);
}
c = 0;
}
else if (strFID != "")
{
c++;
if (c < 4)
{
Select(dt, strFID, c);
}
c = 0;
}
else if (strMID != "")
{
c++;
if (c < 4)
{
Select(dt, strMID, c);
}
c = 0;
}
else
{
return;
}
}
}
private string ConvertToString(object obj)
{
if (obj == DBNull.Value)
return "";
else
return ConvertToString(obj.ToString());
}
private string ConvertToString(string obj)
{
return obj.ToString();
}