protected void Button1_Click(object sender, EventArgs e)
{
sqlstr = "select * from department where departmentid='" + DropDownList1.SelectedValue.ToString() + "'";
SqlDataAdapter cmd = new SqlDataAdapter(sqlstr, sms_conn);
//创建填充 DataSet.
DataSet ds = new DataSet();
cmd.Fill(ds, "TD1");
RepeaterD.DataSource = ds.Tables["TD1"];
RepeaterD.DataBind();
}
private void SMS_BindRepeater()
{
sqlstr = "select * from department";
SqlDataAdapter cmd = new SqlDataAdapter(sqlstr, sms_conn);
//创建填充 DataSet.
DataSet ds = new DataSet();
cmd.Fill(ds, "TD1");
RepeaterD.DataSource = ds.Tables["TD1"];
RepeaterD.DataBind();
ds.Clear();
ds.Dispose();
}