我想检索插入数据的最后一条记录。我研究并了解到我必须使用SELECT LAST_INSERT_ID((。我已经尝试过但没有工作。所以我在下面提供了我的代码
//Inserting into Student Table
string query = "INSERT INTO student(name) Values('" + txtboxname.Text + "' )";
// query= "SELECT LAST_INSERT_ID()";
// query += " SELECT SCOPE_IDENTITY()";
//Inserting into course table
string query1 = "INSERT INTO course(title) Values('" + txttitle.Text + "')";
// query1 = " SELECT LAST_INSERT_ID()";
//Execute Insert Statement queries
MySqlCommand command = new MySqlCommand(query, con);
command.ExecuteNonQuery();
command = new MySqlCommand(query1, con);
command.ExecuteNonQuery();
//Close and dispose off connections
command.Dispose();
con.Close();
预览页面
string query1 = "SELECT (name) FROM student WHERE ID = id";
string query2 = "SELECT (title) FROM course WHERE ID = id";
MySqlCommand command = new MySqlCommand(query1, con);
lblname.Text = command.ExecuteScalar().ToString();
command = new MySqlCommand(query2, con);
lbltitle.Text = command.ExecuteScalar().ToString();
con.Close();
如果您已将表 ID 设置为自动递增,请从表中查找最大 ID,据我所知,如果它有效,这将是您的最后一次插入。
在您的代码中,更改如下,
线路号: 3 query="set @std_id=last_insert_id();"
线路号:7 query1="set @title_id=last_insert_id();"
预览页面:
string query1 = "SELECT (name) FROM student WHERE ID = query";
string query2 = "SELECT (title) FROM course WHERE ID = query1";