public void freshen() { string sql = "select * from Storage order by S_ID"; dtInfo = DBHLper.GetTable(sql); dataGridView1.DataSource = dtInfo; InitDataSet(); this.label3.Text = "第" + pageCurrent + "页" + "共" + pageCount + "页" + "共" + nMax + "条"; dataGridView1.AllowUserToAddRows = false; }
//修改 //private void button2_Click(object sender, EventArgs e) //{ // string PhysicalPath = this.textBox1.Text; // string StorageName = this.textBox2.Text; // string sqlstr = string.Format("update Storage set PhysicalPath='{0}' " + // ",StorageName='{1}' where S_ID={2}", PhysicalPath, StorageName,dgid); // int num= DBHLper.GetExecuteNonQuery(sqlstr); // if (num>0) // { // MessageBox.Show("修改成功!"); // } // textBox1.Text = string.Empty; // textBox2.Text = string.Empty; // freshen(); //} //查询 private void bn_c_Click(object sender, EventArgs e) { string url = this.tb_url.Text; string strsql = string.Format("select * from Storage where PhysicalPath like '%{0}%' order by S_ID", url); dtInfo = DBHLper.GetTable(strsql); //dtInfo.Compute("PhysicalPath", url); dataGridView1.DataSource = dtInfo; InitDataSet(); this.label3.Text = "第" + pageCurrent + "页" + "共" + pageCount + "页" + "共" + nMax + "条"; dataGridView1.AllowUserToAddRows = false; }