Search results for query: *

  1. Kostakis45

    Resolved Shortcut

    I figured out the problem. The tutorial i followed seems to be incomplete. I had to include more assembly files to setup. Now everything works fine. Thank you all for your help.
  2. Kostakis45

    Resolved Shortcut

    To my exe file.I noticed that when i try to run that executable it creates my db file but nothing else.
  3. Kostakis45

    Resolved Shortcut

    Hello Everyone.Following this turtorial video to create a setup wizard for my program I stumbled upon a problem.Though I managed to make setup wizard when I try to run the main program through the created shortcut it won't run. When i run the installation wizard it doesn't seem to installing the...
  4. Kostakis45

    Resolved SQLite Delete data don't work

    Thank you guys for the help and suggestions.I'll keep it in mind.
  5. Kostakis45

    Resolved SQLite Delete data don't work

    I found my problem.I was forgeting to close the SqliteDataReader in my search methods.Thanks everyone for the help.
  6. Kostakis45

    Resolved SQLite Delete data don't work

    I have put together all your suggestions so far except the ideally part wich I don't think i understand clearly but I'm assuming you are talking about return value?Also I fixed all my classes so that the connection could close everytime after executing.And i put my conections into a using...
  7. Kostakis45

    Resolved SQLite Delete data don't work

    no but i can open it in dbBroswer
  8. Kostakis45

    Resolved SQLite Delete data don't work

    If i recall correctly i think for this project i used .Net Framework 4.8 and i downloaded this Nugget package. Also to your previous suggestions: I have only windows firewall and the database file is not only read.
  9. Kostakis45

    Resolved SQLite Delete data don't work

    ok.its logical.like i mentioned before the locked error occurs when the program is in freeze mode and after some time passed while the debugging is still running.The locked error occurs in the cmd.ExecuteNonQuery line.I'm at a loss.
  10. Kostakis45

    Resolved SQLite Delete data don't work

    Any example or reference to read?I now know these two methods.Won't hurt to learn another one.And aplly it to my code as you suggested.Thanks.
  11. Kostakis45

    Resolved SQLite Delete data don't work

    You just said something worth to search for.I'll look for not closed conection through my code.Give me some minutes.
  12. Kostakis45

    Resolved SQLite Delete data don't work

    When someone speaks about single quotes i know those (' ') and double quotes those (" ").Now that we cleared that please read my reply post #8 and you'll understand better my position.
  13. Kostakis45

    Resolved SQLite Delete data don't work

    For your first paragraph.I don't know any other way to pass a user_input value into sqlite command as val=user_input value.Also i convert the val to integer so I think it should work.If there's another way to pass the val to sqlite command please give me a reference. For your second...
  14. Kostakis45

    Resolved SQLite Delete data don't work

    After some time it's saying database is locked,but it's not related.I made a new db and it's the same.My guess is tha for some reason it's not reading the user input in this line cmd.CommandText = "DELETE FROM Description WHERE Mould_Code = '"+ val +"'"; How else i can write this code?
  15. Kostakis45

    Resolved SQLite Delete data don't work

    So I fixed my references.It's like this now. using System; using System.Data.SQLite; using System.Windows.Forms; namespace Παράμετροι_Μηχανών { class Delete_Record { string connection = @"URI=file:" + Application.StartupPath + "\\Injection_Settings.db"; public static...
  16. Kostakis45

    Resolved SQLite Delete data don't work

    I was hoping to get errors but it only freezes.
  17. Kostakis45

    Resolved SQLite Delete data don't work

    1st Answer:I don't really mind of SQL hacking as this is a personal project wich is not going to be in any server. 2nd Answer: Strangely my Search method works fine. It gets a string user input and returns an integer from db. 3d Answer:I tried to do this Delete_Record.Search_Box.Text = Search...
  18. Kostakis45

    Resolved SQLite Delete data don't work

    I can delete easy from dbBroswer.Not from my program. I just tried to print the value of pa.Search_Box.Text and guess what. IT'S EMPTY even though I'm referencing to it.My next guess is that i might messed up the order of my code somewhere.
Back
Top Bottom