winfrom增加
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new
SqlConnection("server=.;database=mydb;user=sa;pwd=123");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into fruit values(@ids,@name,@price,@source,@stack,@numbers,@image)";
cmd.Parameters.Add("@ids",txtids.Text);
cmd.Parameters.Add("@name", txtname.Text);
cmd.Parameters.Add("@price", txtprice.Text);
cmd.Parameters.Add("@source", txtsource.Text);
cmd.Parameters.Add("@stack", txtstack.Text);
cmd.Parameters.Add("@numbers", txtnumbers.Text);
cmd.Parameters.Add("@image", txtimage.Text);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
winfrom 查询
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new
SqlConnection("server=.;database=mydb;user=sa;pwd=123");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select *from fruit where name like '%"+textBox1.Text.Trim()+"%' or ids like '%"+textBox1.Text.Trim()+"%'";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
listView1.Items.Clear();
while (dr.Read())
{
ListViewItem lvt = new ListViewItem();
lvt.Text = dr["ids"].ToString();//第一列
lvt.SubItems.Add(dr["name"].ToString());
lvt.SubItems.Add(dr["price"].ToString());
lvt.SubItems.Add(dr["source"].ToString());
lvt.SubItems.Add(dr["stack"].ToString());
lvt.SubItems.Add(dr["numbers"].ToString());
lvt.SubItems.Add(dr["image"].ToString());
listView1.Items.Add(lvt);
}
conn.Close();
}
winfrom 删除:
private void button2_Click(object sender, EventArgs e)
{
//selecteditems存着选中项的集合
if (listView1.SelectedItems.Count > 0)
{
foreach (ListViewItem lvt in listView1.SelectedItems)
{
//连接数据库,根据编号删除数据
SqlConnection conn = new
SqlConnection("server=.;database=mydb;user=sa;pwd=123");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "delete from fruit where ids=@ids";
cmd.Parameters.Clear();
cmd.Parameters.Add("@ids",lvt.Text);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
winfrom 修改
private void button1_Click(object sender, EventArgs e)
{
FruitData data = new FruitData();
data.Ids = txtids.Text;
data.Name = txtname.Text;
data.Price = decimal.Parse(txtprice.Text);
data.Source = txtsource.Text;
data.Stack = txtstack.Text;
data.Image = txtimage.Text;
data.Numbers = int.Parse(txtnumbers.Text);
new FruitDA().Update(data);
}