Recently
research on datatable bind with database. Those programmers are
brilliant to create binding method.
Let’s
see how to use it.
database structure:
CREATE TABLE testdecimal (
`c1` decimal(10,8) DEFAULT NULL,
`c2` decimal(10,8) DEFAULT NULL,
`id` double NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
insert some data to test
code look like this:
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = "server=testbed-pc;user id=root;password=123;Database=test;charset=utf8;";
try
{
MySqlDataAdapter
da = new MySqlDataAdapter();
da.SelectCommand = new MySqlCommand("select * from testdecimal where c1 =10",
conn);
MySqlCommandBuilder
cb = new MySqlCommandBuilder(da);
da.Fill(testdecimal);
while
(i < testdecimal.Rows.Count)
{
testdecimal.Rows[i]["c2"] = 2 + i ;
i++;
}
da.Update(testdecimal);
}
catch
(Exception er)
{
MessageBox.Show(er.ToString());
conn.Close();
}
finally
{
conn.Close();
}
when execute, all rows with c1 =10 updated! database update successfully! fast and convenient way!