protected void Repeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Repeater ChildRepeater = (Repeater)e.Item.FindControl("ChildRepeater");
System.Data.Common.DbDataRecord newRow = (System.Data.Common.DbDataRecord)e.Item.DataItem;
string uid = newRow["sendfrom_uid"].ToString();
//Response.Write(www.
flyso.cn);
string connStr = ConfigurationManager.AppSettings[0].ToString();
SqlConnection conn = new SqlConnection(connStr);
string cmdStr = "select mobile_no from [yy960_zs_user] where uid=@uid";
SqlCommand comm = new SqlCommand(cmdStr, conn);
comm.Parameters.AddWithValue("@uid", uid);
conn.Open();
SqlDataAdapter dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = comm;
dataAdapter.TableMappings.Add("Table", "user");
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
ChildRepeater.DataSource = dataSet.Tables["user"];
ChildRepeater.DataBind();
conn.Close();
}
}