private void Update_Click(object sender, RoutedEventArgs e)
{
sql = "select * from uoption where opt_id = ?";
OdbcCommand cmd;
DataTable dr = OdbcTool.ExecuteDataTable(sql, out cmd, "900002");
dr.Rows[0]["note"] = "csj1";
int rtn = OdbcTool.UpdateDataTable(dr, cmd);
MessageBox.Show(rtn.ToString());
}
public static void testODBCDataSet()
{
String sql = "select * from uoption where opt_id = ?";
OdbcCommand cmd;
DataTable table = OdbcTool.ExecuteDataTable(sql, out cmd, "900002");
table.Rows[0][3] = table.Rows[0][3].ToString() + "c";
int rtn = OdbcTool.UpdateDataTable(table, cmd);
Console.WriteLine(rtn.ToString());
}