本文共 1084 字,大约阅读时间需要 3 分钟。
string
sql =
"SELECT * FROM MyTable"
;
MySqlDataAdapter adapter =
new
MySqlDataAdapter(sql, connection_);
DataTable dataTable =
new
DataTable();
adapter.Fill(dataTable);
dataGridViewMariaDB.DataSource = dataTable;
int
id = DateTime.Now.Second;
string
username = DateTime.Now.ToShortDateString();
string
password = Guid.NewGuid().ToString();
string
sql =
string
.Format(
"INSERT INTO MyTable (`id`,`username`,`password`) VALUES({0},'{1}','{2}');"
, id, username, password);
MySqlCommand command =
new
MySqlCommand(sql, connection_);
int
affectLines = command.ExecuteNonQuery();
转载地址:http://auymf.baihongyu.com/