111,039
社区成员
发帖
与我相关
我的任务
分享
private void ListViewBind()
{
Thread.Sleep(1000);
if ( this.InvokeRequired )
{
this.Invoke( new MethodInvoker( ListViewBind ) );
}
else
{
listView2.Items.Clear();
listView2.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.listView2.Columns.Add("调用接口", 80, HorizontalAlignment.Center);
this.listView2.Columns.Add("成功数", 80, HorizontalAlignment.Center);//增加列标题
this.listView2.Columns.Add("失败数",80,HorizontalAlignment.Center);
listView2.View = View.Details;
listView2.GridLines = true;//显示网格线。。
string[] str1 = new string[3];
foreach (DataRow row in dataset.Tables[0].Rows)
{
str1[0] = row["Interface"].ToString();
str1[1] = row["sucnum"].ToString();
str1[2] = row["failnum"].ToString();
ListViewItem item = new ListViewItem(str1, 0);
listView2.Items.Add(item);
}
}