本文是用listview显示需要更新的数据库文件,一些ddl和dml文件。
其中用到了listview的绑定。
private void AddDateTableRow(DataTable table, string title, string msg)
{DataRow row = table.NewRow();
row["标题"] = title;
row["执行信息"] = msg;
table.Rows.Add(row);
this.dataGridView1.DataSource = table;
this.dataGridView1.Refresh();
}
protected override void OnLoad(EventArgs e)
{
string currentddl="";
string currentdml="";
string lasteddl="";
string lastedml="";
currentddl = ServerGlobal.dict["CURRENTDDLVER"].ToString();
currentdml = ServerGlobal.dict["CURRENTDMLVER"].ToString();
lasteddl = ServerGlobal.dbDict["LastestDDLVer"].ToString();
lastedml = ServerGlobal.dbDict["LastestDMLVer"].ToString();
base.OnLoad(e);
CreateViewItemMethodTow();
this.textBox1.Text = currentddl;
this.textBox2.Text = lasteddl;
this.textBox3.Text = currentdml;
this.textBox4.Text = lastedml;
this.button2.Enabled = false;
}
//加载listview
public void CreateViewItemMethodTow()
{
this.listView1.View = View.Details;
this.listView1.BeginUpdate();
this.listView1.Columns.Add("文件名");
this.listView1.Columns.Add("大小");
this.listView1.Columns.Add("創建日期");
path = Application.StartupPath + @"\DBUpdate";
DirectoryInfo dir = new DirectoryInfo(path);
DirectoryInfo[] dirs = dir.GetDirectories();
FileInfo[] finfo = dir.GetFiles("*.ddlsql");
FileInfo[] finfo1 = dir.GetFiles("*.dmlsql");
ListViewItem lviItem;
ListViewItem.ListViewSubItem lviSubItem;
foreach (DirectoryInfo di in dirs)
{