参数byte[] VbyteFile
objCmd.CommandText="insert into PersonDoc (Docdetail,DocSize,DocMIME,) values (?,?,?,?,?)";
objCmd.Parameters.Add(new OleDbParameter("@Docdetail",OleDbType.VarBinary));
objCmd.Parameters.Add(new OleDbParameter("@DocSize",OleDbType.VarChar,20));
objCmd.Parameters.Add(new OleDbParameter("@DocMIME",OleDbType.VarChar,50));
objCmd.Parameters["@Docdetail"].Value=VbyteFile;
objCmd.Parameters["@DocSize"].Value=文件尺寸;
objCmd.Parameters["@DocMIME"].Value=文件MIME;
以上是c#自己改一下
objCmd.CommandText="insert into PersonDoc (Docdetail,DocSize,DocMIME,) values (?,?,?,?,?)";
objCmd.Parameters.Add(new OleDbParameter("@Docdetail",OleDbType.VarBinary));
objCmd.Parameters.Add(new OleDbParameter("@DocSize",OleDbType.VarChar,20));
objCmd.Parameters.Add(new OleDbParameter("@DocMIME",OleDbType.VarChar,50));
objCmd.Parameters["@Docdetail"].Value=VbyteFile;
objCmd.Parameters["@DocSize"].Value=文件尺寸;
objCmd.Parameters["@DocMIME"].Value=文件MIME;
以上是c#自己改一下
ITcontent 是字节数组
strsql = "insert into 题库表 (题型,题目) values('" & Tstyle & "',"&itcontent &")"
用Parameter参数集的方法