c# ʹÓÃParameters·½Ê½¸üÐÂAccessÊý¾Ý¿â

×ö¸ö´úÂëÊÕ¼¯µÄС³ÌÐò¡£¶ÔAccessÊý¾Ý¿âCRUDʱ£¬U²»Õý³£

²»Ì«»á±í´ï£¬ÏÈ¿´´úÂë°É

²åÈë·½·¨

C# code:


string sql = "Insert Into DataInfo(title,context,typeId,createTime)"+
" Values(@title,@context,@typeId,@createTime)";
OleDbParameter[] ps ={
new OleDbParameter("@title",dataInfo.Title),
//...
};
return DBHelper.ExecuteCommand(sql, ps);



¿ÉÒÔÕýÈ·Ö´ÐÐ

¸üз½·¨1

C# code:


string sql = "Update DataInfo Set title=@title,context=@context,"+
"typeId=@typeId,createTime=@createTime Where id=@id ";
OleDbParameter[] ps ={
new OleDbParameter("@id",dataInfo.Id),
//...
};
return DBHelper.ExecuteCommand(sql, ps);



²»ÄÜÕýÈ·Ö´ÐÐ


¸üз½·¨2

C# code:


string sql = "Update DataInfo Set title='" + dataInfo.Title +