private void button3_Click(object sender, EventArgs e) { SqliHelper.UpdateData("table1", new string[] { "Name = 'aaa'" }, "EMAIL='修改@.com'", "CODE='修改'"); List <List <string> > List = SqliHelper.ReadData("table1", new string[] { "Name", "CODE" }, " ORDER BY ASC LIMIT 1 OFFSET 0", "Name like 'aaa'"); if (List.Count > 0) { textBox1.Text = List[0][0]; textBox2.Text = List[0][1]; } }
private void button3_Click(object sender, EventArgs e) { SqliHelper.UpdateData("table1", "Name", "aaa", "EMAIL='修改@.com'", "CODE='修改'"); List <string> List = SqliHelper.ReadMultiData("table1", new string[] { "Name", "CODE" }, "Name like 'aaa'"); if (List.Count > 0) { textBox1.Text = List[0]; textBox2.Text = List[1]; textBox3.Text = List[2]; } }