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;
}