C#使用自动增量获取插入ID
发布时间:2020-12-15 03:56:09 所属栏目:百科 来源:网络整理
导读:我正在使用此方法在表中插入一行: MySqlConnection connect = new MySqlConnection(connectionStringMySql); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = connect; cmd.Connection.Open(); string commandLine = @"INSERT INTO Wanted (clien
我正在使用此方法在表中插入一行:
MySqlConnection connect = new MySqlConnection(connectionStringMySql); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = connect; cmd.Connection.Open(); string commandLine = @"INSERT INTO Wanted (clientid,userid,startdate,enddate) VALUES" + "(@clientid,@userid,@startdate,@enddate);"; cmd.CommandText = commandLine; cmd.Parameters.AddWithValue("@clientid",userId); cmd.Parameters.AddWithValue("@userid",""); cmd.Parameters.AddWithValue("@startdate",start); cmd.Parameters.AddWithValue("@enddate",end); cmd.ExecuteNonQuery(); cmd.Connection.Close(); 我还有id列有自动增量. 解决方法
您可以访问MySqlCommand LastInsertedId属性.
cmd.ExecuteNonQuery(); long id = cmd.LastInsertedId; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |