SoFunction
Updated on 2025-03-07

Get the ID of newly added records in Access version


/// <summary>
/// Add new article
/// </summary>
/// <param name="ArticleTitle"></param>
/// <param name="Author"></param>
/// <param name="ArticleFrom"></param>
/// <param name="Creator"></param>
/// <param name="ModifyBy"></param>
/// <param name="Content"></param>
/// <param name="ChannelID"></param>
/// <param name="IsOnTop"></param>
/// <param name="IsCommend"></param>
/// <param name="IsCheck"></param>
/// <param name="Keyword"></param>
/// <param name="ArticleIntroduction"></param>
/// <returns>Added new article ID</returns>
public int AddArticle(string ArticleTitle,
string Author,
string ArticleFrom,
int Creator,
int ModifyBy,
string Content,
int ChannelID,
bool IsOnTop,
bool IsCommend,
bool IsCheck,
string Keyword,
string ArticleIntroduction)
{
int ArticleID =-1;
//Format HTML tag
ArticleTitle=(ArticleTitle);
Author=(Author);
Keyword=(Keyword);

OleDbConnection OleCon=new OleDbConnection();
OleDbCommand OleCmd=new OleDbCommand();
=;
=OleCon;
="AddArticle";
//Get the next ID number
ArticleID= ("ArticleID","Article",);
("ArticleID",ArticleID);
("ArticleTitle",ArticleTitle);
("Author",Author);
("ArticleFrom",ArticleFrom);
("Creator",Creator);
("ModifyBy",ModifyBy);
("Content",Content);
("ChannelID",ChannelID);
("IsOnTop",IsOnTop);
("IsCommend",IsCommend);
("IsCheck",IsCheck);
("Keyword",Keyword);
//2004-2-2 Add introduction attributes to the article Jiang Yong
("ArticleIntroduction",ArticleIntroduction);
//implement
(OleCmd);
return ArticleID;
}