windows application

prathyusha

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.....

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
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") + "#"
0
Iftikar Hussain13y ago
like that only you are looking for..right?

Regards,
Iftikar
0
prathyusha13y ago
hi

current date like 15/07/2013 and i'm using windows applications
0
Iftikar Hussain13y ago
please check with current date. it should come like 15/07/2013. Are you using windows application?

Regards,
Iftikar
0
prathyusha13y ago
hi

i = ts.DataManipulate("insert into tblFeePayment(AdmissionNumber,PaymentDate,AmountPaid,Balance,FeeDescription,FeeStatus,AcademicYearId,AdmissionFee,AnnualFee,LibraryFee,SportsFee,Others,MonthlyFee,Amountwords,TermFee) 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
0
Iftikar Hussain13y ago
Hi,
Use like this

"#" + String.Format("{0:dd/MM/yyyy}", paymentDate) + "#"

Regards,
Iftikar
0
prathyusha13y ago
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(AdmissionNumber,PaymentDate,AmountPaid,Balance,FeeDescription,FeeStatus,AcademicYearId,AdmissionFee,AnnualFee,LibraryFee,SportsFee,Others,MonthlyFee,Amountwords,TermFee) 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.
0
Vulpes13y ago
Try it like this:

i = ts.DataManipulate("insert into
tblFeePayment(AdmissionNumber,PaymentDate,AmountPaid,Balance,FeeDescription,FeeStatus,AcademicYearId,AdmissionFee,AnnualFee,LibraryFee,SportsFee,Others,MonthlyFee,Amountwords,TermFee)
values('" + admnumber + "', #" + paymentDate.ToString("dd/MM/yyyy") + "#," + amountpaid + "," + balance + ",'" + remarks + "'," + feestatus + "," + academicyearid + "," + admf + "," + annualfee + "," + libfee + "," + sportfee + "," + miscfee + "," + monfee + ",'" + amt + "'," + test1 + ")");
0
prathyusha13y ago
hi
my query like this in windows application

i = ts.DataManipulate("insert into
tblFeePayment(AdmissionNumber,PaymentDate,AmountPaid,Balance,FeeDescription,FeeStatus,AcademicYearId,AdmissionFee,AnnualFee,LibraryFee,SportsFee,Others,MonthlyFee,Amountwords,TermFee)
values('" + admnumber + "',Format(#" + paydate + "#,'dd/MM/yyyy')," + amountpaid + "," + balance + ",'" + remarks + "'," + feestatus + "," + academicyearid + "," + admf + "," + annualfee + "," + libfee + "," + sportfee + "," + miscfee + "," + monfee + ",'" + amt + "'," + test1 + ")");

please help me
0
Vulpes13y ago
Try:

"#" + paymentDate.ToString("dd/MM/yyyy") + "#"
0
Sanjeeb Lenka13y ago
check this link it may help you

http://allenbrowne.com/ser-36.html
0