1 stringstrSQL =2 "INSERT INTO Gongcheng (GCSY,GCBH,GCBHOLD,GCMC,GCKCJD,GCJSDW,GCSJDW,GCKCDW,GCSGDW,GCDD,GCX,GCY,GCBG,GCQSLC, Gcjslc,gczxdh,gczxlc,gczxlx,gczxsm,gcyx,gczbz,gcblc,gcbz,pzfa,bz,gcsj,dtable,zgsw,dzjl,dzld,jcms,jqbs,fgch,tlx , cdlb,yhzs,gcmm,tzbh,kgrq,wgrq,version,gczbx,gcgcx) VALUES (@GCSY, @GCBH, @GCBHOLD, @GCMC, @GCKCJD, @GCJSDW, @GCSJDW, @ GCKCDW, @GCSGDW, @GCDD, @GCX, @GCY, @GCBG, @GCQSLC, @GCJSLC, @GCZXDH, @GCZXLC, @GCZXLX, @GCZXSM, @GCYX, @GCZBZ, @GCBLC, @GCBZ , @PZFA, @BZ, @GCSJ, @DTABLE, @ZGSW, @DZJL, @DZLD, @JCMS, @JQBS, @FGCH, @TLX, @CDLB, @YHZS, @GCMM, @TZBH, @KGRQ, @WGRQ, @VERSION , @GCZBX, @GCGCX)";3OleDbCommand cmd =NewOleDbCommand (strSQL, con);4Cmd. Parameters.addwithvalue ("@GCSY", datarow["Gcsy"]);5Cmd. Parameters.addwithvalue ("@GCBH", datarow["GCBH"]);6Cmd. Parameters.addwithvalue ("@GCBHOLD", datarow["Gcbhold"]);7Cmd. Parameters.addwithvalue ("@GCMC", datarow["GCMC"]);8Cmd. Parameters.addwithvalue ("@GCKCJD", datarow["Gckcjd"]);9Cmd. Parameters.addwithvalue ("@GCJSDW", datarow["Gcjsdw"]);TenCmd. Parameters.addwithvalue ("@GCSJDW", datarow["GCSJDW"]); OneCmd. Parameters.addwithvalue ("@GCKCDW", datarow["GCKCDW"]); ACmd. Parameters.addwithvalue ("@GCSGDW", datarow["GCSGDW"]); -Cmd. Parameters.addwithvalue ("@GCDD", datarow["GCDD"]); -Cmd. Parameters.addwithvalue ("@GCX", (Object) datarow["GCX"] ??DBNull.Value); theCmd. Parameters.addwithvalue ("@GCY", (Object) datarow["Gcy"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@GCBG", (Object) datarow["GCBG"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@GCQSLC", (Object) datarow["GCQSLC"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@GCJSLC", (Object) datarow["GCJSLC"] ??DBNull.Value); +Cmd. Parameters.addwithvalue ("@GCZXDH", (Object) datarow["GCZXDH"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@GCZXLC", (Object) datarow["GCZXLC"] ??DBNull.Value); +Cmd. Parameters.addwithvalue ("@GCZXLX", datarow["GCZXLX"]); ACmd. Parameters.addwithvalue ("@GCZXSM", datarow["Gczxsm"]); atCmd. Parameters.addwithvalue ("@GCYX", (Object) datarow["gcyx"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@GCZBZ", (Object) datarow["GCZBZ"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@GCBLC", (Object) datarow["GCBLC"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@GCBZ", (Object) datarow["GCBZ"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@PZFA", (Object) datarow["PZFA"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@BZ", datarow["BZ"]); inCmd. Parameters.addwithvalue ("@GCSJ", (Object) datarow["GCSJ"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@DTABLE", datarow["dtable"]); toCmd. Parameters.addwithvalue ("@ZGSW", (Object) datarow["ZGSW"] ??DBNull.Value); +Cmd. Parameters.addwithvalue ("@DZJL", (Object) datarow["DZJL"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@DZLD", (Object) datarow["Dzld"] ??DBNull.Value); theCmd. Parameters.addwithvalue ("@JCMS", (Object) datarow["JCMS"] ??DBNull.Value); *Cmd. Parameters.addwithvalue ("@JQBS", (Object) datarow["Jqbs"] ??DBNull.Value); $Cmd. Parameters.addwithvalue ("@FGCH", (Object) datarow["FGCH"] ??DBNull.Value);Panax NotoginsengCmd. Parameters.addwithvalue ("@TLX", (Object) datarow["TLX"] ??DBNull.Value); -Cmd. Parameters.addwithvalue ("@CDLB", (Object) datarow["CDLB"] ??DBNull.Value); theCmd. Parameters.addwithvalue ("@YHZS", (Object) datarow["Yhzs"] ??DBNull.Value); +Cmd. Parameters.addwithvalue ("@GCMM", datarow["GCMM"]); ACmd. Parameters.addwithvalue ("@TZBH", datarow["TZBH"]); theCmd. Parameters.addwithvalue ("@KGRQ", datarow["KGRQ"]); +Cmd. Parameters.addwithvalue ("@WGRQ", datarow["WGRQ"]); -Cmd. Parameters.addwithvalue ("@VERSION", datarow["VERSION"]); $Cmd. Parameters.addwithvalue ("@GCZBX", datarow["GCZBX"]); $Cmd. Parameters.addwithvalue ("@GCGCX", datarow["gcgcx"]); -Cmd. ExecuteNonQuery ();
Solution for importing DataTable data into MS ACCESS database with null number Type field