listview mysql查询_ListView显示数据库数据并实现查询、修改、更新

【实例简介】

ListView显示数据库SQL数据并实现查询、修改、更新，list中显示图片等功能

【实例截图】

【核心代码】

private void BtnModfy_Click(object sender, EventArgs e)

{

SqlConnection connection;

string strUpdate = "Update tb_02 set Approp='" txtPrice.Text.Trim() "' where ID='" txtID.Text.Trim() "'";

using (connection = new SqlConnection("server=.;pwd=test;user=sa;database=db_02"))

{

connection.Open();

SqlCommand command = new SqlCommand(strUpdate, connection);

if (command.ExecuteNonQuery() > 0)

{

MessageBox.Show(string.Format("编码为:{0}的产品价格已经更新为{1}", txtID.Text.Trim(), txtPrice.Text.Trim()));

}

}

ListViewDisplayDate(listView1);

}

//查询按钮代码

private void BtnSearch_Click(object sender, EventArgs e)

{

ListViewDisplayDate(listView1);

}

//删除按钮代码

private void BtnDelete_Click(object sender, EventArgs e)

{

SqlConnection connection;

string strUpdate = "Delete from tb_02 where ID='" txtID.Text.Trim() "'";

using (connection = new SqlConnection("server=.;pwd=test;user=sa;database=db_02"))

{

connection.Open();

SqlCommand command = new SqlCommand(strUpdate, connection);

if (command.ExecuteNonQuery() > 0)

{

MessageBox.Show(string.Format("编码为:{0}的产品价格已删除", txtID.Text.Trim()));

}

}

ListViewDisplayDate(listView1);

}