private
void
button1_Click(
object
sender, EventArgs e)
{
listView1.Items.Clear();
listView1.Columns.Clear();
SqlConnection con = new SqlConnection( " server=.;database=pubs;user id=sa;password=123 " );
con.Open();
DataSet dst = new DataSet();
SqlCommand cmd = new SqlCommand ( " select title_id,type from titles " ,con );
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(dst);
con.Close();
this .listView1.Columns.Add( " ID编号 " , 80 , HorizontalAlignment.Center);
this .listView1.Columns.Add( " 类型 " , 80 , HorizontalAlignment.Center); // 增加列标题
listView1.View = View.Details;
listView1.GridLines = true ; // 显示网格线。。
string [] str = new string [ 2 ];
foreach (DataRow row in dst.Tables[ 0 ].Rows)
{
str[ 0 ] = row[ " title_id " ].ToString();
str[ 1 ] = row[ " type " ].ToString();
ListViewItem item = new ListViewItem(str, 0 );
listView1.Items.Add(item);
}
}
{
listView1.Items.Clear();
listView1.Columns.Clear();
SqlConnection con = new SqlConnection( " server=.;database=pubs;user id=sa;password=123 " );
con.Open();
DataSet dst = new DataSet();
SqlCommand cmd = new SqlCommand ( " select title_id,type from titles " ,con );
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(dst);
con.Close();
this .listView1.Columns.Add( " ID编号 " , 80 , HorizontalAlignment.Center);
this .listView1.Columns.Add( " 类型 " , 80 , HorizontalAlignment.Center); // 增加列标题
listView1.View = View.Details;
listView1.GridLines = true ; // 显示网格线。。
string [] str = new string [ 2 ];
foreach (DataRow row in dst.Tables[ 0 ].Rows)
{
str[ 0 ] = row[ " title_id " ].ToString();
str[ 1 ] = row[ " type " ].ToString();
ListViewItem item = new ListViewItem(str, 0 );
listView1.Items.Add(item);
}
}