Why does EditItemTemplate data changes?
-
Hello Experts, There are some date columns in my data grid. The data in a date column is like below: "01/11/2010" But when I press the update button on the gridview then the edititemtemplate directly converts the data as: "01/00/2010" What is the problem??..Please help...
-
Hello Experts, There are some date columns in my data grid. The data in a date column is like below: "01/11/2010" But when I press the update button on the gridview then the edititemtemplate directly converts the data as: "01/00/2010" What is the problem??..Please help...
from where this value come 01/11/2010 wat code u use for it..
-
from where this value come 01/11/2010 wat code u use for it..
I havent used it.. The update code of the gridview is like below.There is no mistake... UPDATE [CP_MASTER] SET [ORDERNUMBER] = @ORDERNUMBER, [NEWRPT] = @NEWRPT, [UNICLODEL] = CAST(@UNICLODEL as smalldatetime), [SUPPLDEL] = @SUPPLDEL, [CUSTOMER] = @CUSTOMER, [DEPARTMENT] = @DEPARTMENT, [SUPPLIER] = @SUPPLIER, [LINE] = @LINE, [COLORS] = @COLORS, [QTY] = @QTY, [NOTES] = @NOTES, [RATIO] = @RATIO, [WC] = @WC, [KIMBALL] = @KIMBALL, [LAPDIPSENT] = @LAPDIPSENT, [LAPDIPAPPRV] = @LAPDIPAPPRV, [WASH] = @WASH, [WASHTYPE] = @WASHTYPE, [PRINTX] = @PRINTX, [PRINTAPPRV] = @PRINTAPPRV, [EMB] = @EMB, [EMBAPPRV] = @EMBAPPRV, [BULKFABRICARRV] = @BULKFABRICARRV, [FITSENT] = @FITSENT, [FITAPPRV] = @FITAPPRV, [SIZESETSENT] = @SIZESETSENT, [SIZESETAPPRV] = @SIZESETAPPRV, [SEALERSENT] = @SEALERSENT, [SEALERAPPRV] = @SEALERAPPRV, [BULKFABRICTEST] = @BULKFABRICTEST, [GARMENTTEST] = @GARMENTTEST, [CUTDATE] = @CUTDATE, [SEWING] = @SEWING, [MIDINSPECTION] = @MIDINSPECTION, [PRODSENT] = @PRODSENT, [PRODAPPRV] = @PRODAPPRV, [INSPECTIONDATE] = @INSPECTIONDATE, [STATUS] = @STATUS WHERE [ORDERDATE] = @ORDERDATE AND [ONUNICLO] = @ONUNICLO AND [STYLE] = @STYLE AND [MERCH] = @MERCH