windows application

Question

hi how to insert the date in ms access.date format like(dd/mm/yyyy). by using this Format(# + paydate + #'dd/MM/yyyy') tblFeePayment PaymentDate 07/10/2013 07/11/2013 07/12/2013 13/07/2013 14/07/2013 15/07/2013 but i need to insert all dates like dd/mm/yyyy. Please help me.....

Vulpes · Answer

Judging by the error I gather that paymentDate is in fact a string variable whereas we'd all been assuming it was a DateTime variable. If that's the case and the string is already in dd/MM/yyyy format then all you need to put in the query for that field is: # + paymentDate + # However if it's in MM/dd/yyyy format you'll need to do something like this: DateTime dt = DateTime.ParseExact(paymentDate MM/dd/yyyy null); and then use the following in the query: # + dt.ToString(dd/MM/yyyy) + #

Iftikar Hussain · Answer

like that only you are looking for..right? Regards Iftikar

prathyusha · Answer

hi current date like 15/07/2013 and i'm using windows applications

Iftikar Hussain · Answer

please check with current date. it should come like 15/07/2013. Are you using windows application? Regards Iftikar

prathyusha · Answer

hi i = ts.DataManipulate(insert into tblFeePayment(AdmissionNumberPaymentDateAmountPaidBalanceFeeDescriptionFeeStatusAcademicYearIdAdmissionFeeAnnualFeeLibraryFeeSportsFeeOthersMonthlyFeeAmountwordsTermFee) values(' + admnumber + '# + String.Format({0:dd/MM/yyyy} paydate) + # + amountpaid +  + balance + ' + remarks + ' + feestatus +  + academicyearid +  + admf +  + annualfee +  + libfee +  + sportfee +  + miscfee +  + monfee + ' + amt + ' + test1 + )); 07/10/2013 output like this only please help me

Iftikar Hussain · Answer

Hi Use like this # + String.Format({0: dd/MM/yyyy } paymentDate ) + # Regards Iftikar

prathyusha · Answer

hi public int InsertStudentFee(string admnumber string paydate int amountpaid int balance string remarks int feestatus int academicyearid int admf int annualfee int libfee int sportfee int miscfee int monfee string amt int test1) { int i = 0; Transaction ts = new Transaction(); i = ts.DataManipulate(insert into tblFeePayment(AdmissionNumberPaymentDateAmountPaidBalanceFeeDescriptionFeeStatusAcademicYearIdAdmissionFeeAnnualFeeLibraryFeeSportsFeeOthersMonthlyFeeAmountwordsTermFee) values(' + admnumber + '# + paydate.ToString(dd/MM/yyyy) + # + amountpaid +  + balance + ' + remarks + ' + feestatus +  + academicyearid +  + admf +  + annualfee +  + libfee +  + sportfee +  + miscfee +  + monfee + ' + amt + ' + test1 + )); return i; } by using above query in windows application(forms) this eror will be displayed Error19The best overloaded method match for 'string.ToString(System.IFormatProvider)' has some invalid argumentsC:\Users\dev02.QGNDOR\Desktop\QGS_School\BussinessLogic\BL_Student.cs563264BussinessLogic Error20Argument '1': cannot convert from 'string' to 'System.IFormatProvider'C:\Users\dev02.QGNDOR\Desktop\QGS_School\BussinessLogic\BL_Student.cs563281BussinessLogic please help me it's important to me.

Vulpes · Answer

Try it like this: i = ts.DataManipulate(insert into tblFeePayment(AdmissionNumberPaymentDateAmountPaidBalanceFeeDescriptionFeeStatusAcademicYearIdAdmissionFeeAnnualFeeLibraryFeeSportsFeeOthersMonthlyFeeAmountwordsTermFee) values(' + admnumber + ' # + paymentDate.ToString(dd/MM/yyyy) + # + amountpaid +  + balance + ' + remarks + ' + feestatus +  + academicyearid +  + admf +  + annualfee +  + libfee +  + sportfee +  + miscfee +  + monfee + ' + amt + ' + test1 + ));

prathyusha · Answer

hi my query like this in windows application i = ts.DataManipulate(insert into tblFeePayment(AdmissionNumberPaymentDateAmountPaidBalanceFeeDescriptionFeeStatusAcademicYearIdAdmissionFeeAnnualFeeLibraryFeeSportsFeeOthersMonthlyFeeAmountwordsTermFee) values(' + admnumber + 'Format(# + paydate + #'dd/MM/yyyy') + amountpaid +  + balance + ' + remarks + ' + feestatus +  + academicyearid +  + admf +  + annualfee +  + libfee +  + sportfee +  + miscfee +  + monfee + ' + amt + ' + test1 + )); please help me

Vulpes · Answer

Try: # + paymentDate.ToString(dd/MM/yyyy) + #

Sanjeeb Lenka · Answer

check this link it may help you http://allenbrowne.com/ser-36.html