how we write insert query in msacess using in c# with windows application
Insert into LendersInformation(AccountNo,UserName,Gender,DOB,Age,MobileNo,TelephoneNo,Address,Date,WorkingStatus) values (100,'gfhgfh','Female','11/9/2000','9','456456456','454643456','gfhgfhfgh','11/4/2009','gfhgfhgfhfghfgh')
the above statment is wrong what is correct plz send correct answer
|
| Author: Ali Mahran 04 Nov 2009 | Member Level: Bronze | Rating:  Points: 2 |
Insert into LendersInformation(AccountNo,UserName,Gender,DOB,Age,MobileNo,TelephoneNo,Address,Date,WorkingStatus) values (100,'gfhgfh','Female','11/9/2000','9','456456456','454643456','gfhgfhfgh','11/4/2009','gfhgfhgfhfghfgh');
u must put semi colon in ur code
or
sure ur Fields names in DB is the same names in Code
|
| Author: Dharmaraj 04 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Hi,
Just put ; at the end of the statement
Regards,
Dharma
Editor,Mentor,MVM
Try and fail but don't fail and try
Me and DNS
|