Comments by Member 10943256

Member 10943256 7-Jul-20 8:44am View

Perfect! Thank you

Member 10943256 13-Dec-19 9:54am View

Thanks for the explaination.
Regarding to the first paragraph in your comment, can u please tell what should i do to solve it?

Member 10943256 13-Dec-19 4:13am View

@OriginalGriff: Thanks for helping again.
i did what you mentioned, and now it works again like before.i mean when i made a setup file and installed it, with double clicking on shortcut, nothing will happend!
Could you please tell what i missed?
Thanks.

1)My code in App.config is like below:

<configuration>
<startup>
<supportedruntime version="v4.0" sku=".NETFramework,Version=v4.6.1">

<connectionstrings>

<add name="connection_string" providername="System.Data.sqlclient" connectionstring="Data Source=C:\\Users\\MYUSER\\Desktop\\simpleDatabase8 SQLite - Copy\\simpleDatabase7\\bin\\Debug\\sqliteDB.db3;Version=3">

2) And i wrote like it in my Form:
static string conn_string = System.Configuration.ConfigurationManager.ConnectionStrings["connection_string"].ConnectionString;
public static SQLiteConnection con = new SQLiteConnection(conn_string);

Member 10943256 12-Dec-19 11:35am View

Thanks Richard and also thanks @OriginalGriff.
i added the SQLite into sql connection but the connection String is still the same as address of the file location. but if i understood correctly, you meant i should change it(not to be in C/desktop...), yes?
2) and still it doesnt work after i installed it.(like before. i just click on shortcut and nothing happend)

Member 10943256 12-Dec-19 10:51am View

Thanks. i edited it.
about solving my main problem to run the software after installing, could you please guide me more?
I dont know how should i find the address of my configuration file to fix the problem.

Member 10943256 12-Dec-19 10:30am View

in this case, i wrote like it :)
Is it correct? Thanks
int i = 0;
i = cmd.ExecuteNonQuery();
if (i > 0)
{

MessageBox.Show("Inserted");
DisplayData();
}
else
{
MessageBox.Show("Not Inserted");
}
con.Close();

Member 10943256 12-Dec-19 9:53am View

Thanks for explanation.
About last sentece, i didn't get your point. could you please tell me what is address point2...?

Member 10943256 12-Dec-19 9:34am View

it get values from the textfileds and save them in two columns in database with the same name!

Member 10943256 12-Dec-19 9:31am View

Richard your answer was not correct!
As i mentioned in my question, if you run this from visual studio it works well and all data would be saved in database correctly. i don't know why you wrote this code will not run for weeks.....

Member 10943256 12-Dec-19 8:53am View

Dear Richard,
Thanks for your comment.
from my side, i think i wrote all relevant information, but if i missed sth or there is any vague part in my explanation, please tell me then i will write/add that.

Member 10943256 12-Dec-19 6:06am View

Sorry why you use "We" instead of "I" ?!
i have a problem and i wrote my question with complete information there. i even send the complete source file from my problem and i asked kindly for help. If anyone knows and helps, i will really appreciate it!
But you, if you don't want to help or you don't know the answer please dont write anything!

Member 10943256 12-Dec-19 5:43am View

i guess, i should add the database physically to my visual studio first, then i can see Configuration file, ?

Member 10943256 12-Dec-19 5:40am View

I thought you saw my windows application!
i uploaded it on google drive and shared it above the text :"What I have tried:"
https://drive.google.com/file/d/1XV0GtTODcVJQW1gyI6xvZXUWQ1JvS7ua/view?usp=sharing

Member 10943256 12-Dec-19 5:01am View

Thanks for your good information.
about the first tip, what is the address of my configuration file?
i could't find it.
Thanks

Comments by Member 10943256 (Top 14 by date)