You are really struggling with these basic concepts aren't you. Get a book and work through ALL the examples it will be ultimately quicker that repeatedly asking the same questions in a support forum. As answered the other day. object oResult = (cmd_BranchExposureFactor.ExecuteScalar(); Now you can look at the content of oResult in your debugger to give you an idea what it contains. As Garth said it is probably a string, empy or null. Now you can deal with it! Never underestimate the power of human stupidity RAH

karthiksruby@123 wrote: Your issue What issue is it that you are referring to? I am not having any issues connecting to any database.

zebra88 wrote: what is the problem ? Dunno. Does "error" mean that it throws an exception that the access database cannot be found? If yes, then there's an error in your connectionstring. If no, does "error" mean that it displays the message "the record is not here"? Further, a "select" statement is a query. One would use the ExecuteReader method to read the dataset. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

ok i make a class and i have there the following code: public DataTable findrefyear(string dateref) { try { //Set the access command string string query_insert = "INSERT INTO Questionnaires_Table (BranchName,Factor,Region,Branch_ID,[Current_Date],No_Employees," + "No_Cashdesk,UrbanArea,TouristArea,RuralArea,GreenLinearArea,CentralStreets,EscapeBack,Collonization," + "TimeDelay,PatrolPolice,Visibility,SafeBoxRisk,StaffAccess,KeyboardActiviation,ConnectionKSC,GSMCommunicator,SystemAlarmRisk," + "InstalledSKKT,CheckSKKT,CheckDesk,CheckEntrance,SKKTRisk,RenovatedStore,MetalCashDrawers,ExtensionCash,Limits," + "CashDrawers,CasherRisk,WarningAlert,SecurityWarningDelay,WarningRisk,BothSideDoors," + "DoorsSound,ExitRisk,EmergencyCase,RobberyCase,DescriptionForm,SeminarRobbery,EducationRisk,ReferenceYear) " + "SELECT BranchName,Factor,Region,Branch_ID,Current_Date,No_Employees," + "No_Cashdesk,UrbanArea,TouristArea,RuralArea,GreenLinearArea,CentralStreets,EscapeBack,Collonization," + "TimeDelay,PatrolPolice,Visibility,(TimeDelay+PatrolPolice+Visibility)/3,StaffAccess,KeyboardActiviation,ConnectionKSC,GSMCommunicator,(StaffAccess+KeyboardActiviation+ConnectionKSC+GSMCommunicator)/4," + "InstalledSKKT,CheckSKKT,CheckDesk,CheckEntrance,(InstalledSKKT+CheckSKKT)/2,RenovatedStore,MetalCashDrawers,ExtensionCash,Limits," + "CashDrawers,(CheckDesk+CheckEntrance+RenovatedStore+MetalCashDrawers+ExtensionCash+Limits+CashDrawers)/7," + "WarningAlert,SecurityWarningDelay,(WarningAlert+SecurityWarningDelay)/2,BothSideDoors," + "DoorsSound,(BothSideDoors+DoorsSound)/2," + "EmergencyCase,RobberyCase,DescriptionForm,SeminarRobbery,(EmergencyCase+RobberyCase+DescriptionForm+SeminarRobbery)/4,ReferenceYear " + "FROM [MS Access;DAT

It all depends on what your query is actually returning: it is very possible that your line: string rfyear = ((string)cmd_year.ExecuteScalar()); Will not work, but throw an InvalidCastException because the data coming back can't be cast to a string - it may work if you change it to: string rfyear = cmd_year.ExecuteScalar().ToString(); But...I wouldn't recommend it as there is a very good chance that you will get a string containing the name of the type of the value returned. What does your query return when it works and when it fails? The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)

i think that i have all the files as i have the same project in 2 versions 32bit compiled and 64 bit and the 64 bit version is ok.

for the use that i want it i just make none the cancel button property that has the logout_click button :) so i use only the command application.exit(); and when i press button logout and in messagebox NO then it stay in the form that i am at the same time

i have added the methods in program.cs but haven't saw something different from before.. is there any other way to implement setup for my c# project so that working for all laptops without any problems with access 2010 database?

Hi Thanks all for your help. I found the problem rely on your advice. I changed the target platform from configuration manager to x64 bit and the problem solved. thank you again!!

You probably do want to create a service. Here is an article: A Windows Service Application[^]

Using Dock and Anchor properties will help you out. For more information, go through, Manage WinForm controls using the Anchor and Dock properties[^]. WP Apps - Color Search | Arctic | XKCD | Sound Meter | Speed Dial

zebra88 wrote: this database will be used from my c# project that MS Access requires that the OS must have file level access to the database file. So if you want 3 people (three different computers running the client app) to use it then all three of those must have the file viewable via Explorer.

zebra88 wrote: Error 27 File 'log4net.dll' targeting 'AMD64' is not compatible with the project's target platform 'x86' C:\Users\user\Documents\Visual Studio 2010\Projects\WindowsFormsApplication3\Insurance Management Setup\Insurance Management Setup\Insurance Management Setup.vdproj Insurance Management Setup Why this is happening is described in the error message: you are trying to deploy the AMD (AMD64) targeted dll against a Generic x86 (x86) application. zebra88 wrote: What is the solution ?? Personally, I'd start by downloading the Log4Net Source and building alongside the app so it always builds against the same version as the app. You could also get the generic version of the dll and deploy that, but as you require 32-bit deployment as well it might get messy. As for 32/64 bit deployment, the simplest thing to do is to set up both 32 and 64 bit versions of your build configuration and swapping to produce 32 and 64-bit versions of your MSIs. You could also consider two installer projects for each, but it depends on your circumstances. If you want a single installer where the user chooses which version as part of the installation process, then that is beyond my ken I'm afraid. “Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed” “One of the greatest problems of our time is that many are schooled but few are educated” Sir Thomas More (1478 – 1535)

One options would be to allow setting a "from/start" date, and a number of months as a regular integer parameter, e.g. from a textfield or combo box. Then in your C# code create a date range as: public DateTime CalculateEndDateOfRange(DateTime startdate, uint months) { DateTime endtime = startdate.AddMonths(months); return endtime; } Check as similar question here... http://stackoverflow.com/questions/4454271/date-range-in-days-c[^]

No worries! :) /ravi My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

you are most welcome!

good for you! Nice to hear it works. V. (MQOTD Rules and previous Solutions )

Get a good book; the code to write/read to/from a database is more complex than hooking an event to a control. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]