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