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.
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...
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...
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.
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.
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.
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...
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?
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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.