private void btncx_Click(object sender, EventArgs e)
{
// 清除数据
lvwshow.Items.Clear();
SqlDataReader dr = TvBLL.TvDimBLL(txttvname.Text.Trim());
if (dr.HasRows)
{
while (dr.Read())
{
string tvname = dr[0].ToString();
string jmname = dr[1].ToString();
string time = dr[2].ToString();
ListViewItem itemc = new ListViewItem(tvname);
itemc.SubItems.Add(jmname);
itemc.SubItems.Add(time);
lvwshow.Items.Add(itemc);
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
lvwshow.View = View.Details;
lvwshow.Columns.Add("频道名称");
lvwshow.Columns.Add("节目名称");
lvwshow.Columns.Add("时间");
SqlDataReader dr = TvBLL.TvShowBLL();
if (dr.HasRows)
{
while (dr.Read())
{
string tvname = dr[0].ToString();
string jmname = dr[1].ToString();
string time = dr[2].ToString();
ListViewItem itemc = new ListViewItem(tvname);
itemc.SubItems.Add(jmname);
itemc.SubItems.Add(time);
lvwshow.Items.Add(itemc);
}
}
}
