I Created setup file in Visual Studio 2015 but not run software after installation

[Sohel Jaman]

I create a phone book project. It work fine on visual studio 2015. It has a sqlite database (phonebookDB.sqlite3). I created setup\ installer for my desktop and it install on PC. It had been install and created shortcut icon when i click shortcut icon, it not run and it is not showing any error. I tryed to run to open as administrator but it not run when i create setup file without sqlite code it run fine on windows. i have used visual studio installer to make setup file.

My code...

<add name="connect" connectionString="Data Source=.\phoonbookDB.sqlite3; Version=3; New=False; Compress=True;"/>

            string s = ConfigurationManager.ConnectionStrings["connect"].ConnectionString;

            try
            {
                string query = "Select * From phoonbooklist order by Id DESC";
                using(cmd = new SQLiteCommand(query, con))
                {
                    con.Open();
                    using (SQLiteDataReader result = cmd.ExecuteReader())
                    {
                        if (result.HasRows)
                        {
                            dataGridView.Rows.Clear();
                            while (result.Read())
                            {
                                int n = dataGridView.Rows.Add();
                                dataGridView.Rows[n].Cells[0].Value = result[0].ToString();
                                dataGridView.Rows[n].Cells[1].Value = result[1].ToString();
                                dataGridView.Rows[n].Cells[2].Value = result[2].ToString();
                                dataGridView.Rows[n].Cells[3].Value = result[3].ToString();
                                dataGridView.Rows[n].Cells[4].Value = result[4].ToString();
                                dataGridView.Rows[n].Cells[5].Value = result[5].ToString();
                            }
                        }
                        con.Close();
                    }
                }
            }
            catch
            {

            }

        private void saveBtn_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(fnametext.Text) && string.IsNullOrEmpty(mnumbertext.Text))
            {
                MessageBox.Show("Fill Name and Mobile Number Field!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                fnametext.Focus();
            }
            else
            {
                con.Open();
                str = "select count(*) from phoonbooklist where Mnumber = @Mnumber";
                cmd = new SQLiteCommand(str, con);
                cmd.Parameters.AddWithValue("@Mnumber", mnumbertext.Text.Trim());
                int count = Convert.ToInt32(cmd.ExecuteScalar());
                con.Close();

                if (count > 0)
                {
                    MessageBox.Show(mnumbertext.Text + " This mobile number alrady existed!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    con.Open();
                    str = "Insert Into phoonbooklist (Fname, Mnumber, Email, City, Country) Values ('" + fnametext.Text + "', '" + int.Parse(mnumbertext.Text) + "', '" + emailtext.Text + "', '" + citytext.Text + "', '" + countrytext.Text + "')";
                    cmd = new SQLiteCommand(str, con);
                    cmd.ExecuteNonQuery();
                    con.Close();
                    LoadData();
                    cleardata();
                    MessageBox.Show("Data Insert successfully!!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }

[Bob Winter]

although I don't know anything about the topic I just clicked on it out of curiosity what's it about
unfortunately it's one of those posts hard to read - especially on mobile devices with small screens:

a) coderanch supports the BBCode standard - which one part of it is the code-tag
it also supports common languages like java, c/++ and even c# - this makes it way easier to read code as it gets formatted properly and also syntax highlightet - a moderator may correct it this time for you
b) although images often do help in situations were "it's useful to see what you see", but I don't see it helps on your topic as you just show us some IDE stuff but the issue you described happens outside of the IDE
c) "it does not work" is not a very helpful way of describing the issue - it often helps better if you describe what you expect to happen, what does actually happen, and maybe post some error log you get

as for the issue itself:
do you have any debug-log in your programm? have you tried it running from the commandline instead of double-click on the short cut? does your installer make sure the privileges are set correctly or to place specific files in specific places? does your code has any fail-fast lines in it where it just exists the programm in case if anything fails?

from what I see: you have an empty catch-block:

try
{
	//code
}
catch
{
	//empty?!
}

I can only say from java: never ever do this - what you'Re doing here is you hide any error message that could be printed to log - in java there's Throwable.printStackTrace - in C# it seem to be this:

catch (Exception ex)
{
    Console.WriteLine(ex.StackTrace);
}

this way you'll get at least a log output why it failed (I predict some privilege issue here)

//edit - fixed code tag

[Stephan van Hulst]

Welcome to CodeRanch, Sohel Jaman!

I added code tags to your post so that it is more easily to read. Next time, please add them yourself like [code]this[/code], and use the "Preview" button to see if everything looks nice before you submit your post.

You're likely not getting an error message because you're silently catching exceptions. NEVER have an empty catch block.

You're mixing presentation code with database access code. You shouldn't be accessing databases directly from your event handlers. Instead, create a class that encapsulates your database operations, and when an exception is thrown, wrap the exceptions in more appropriate ones, which you can then handle in your event handlers:

namespace Phonebook
{
    using System;

    internal sealed class Contact
    {
        internal Contact(string fullName, string mobilePhoneNumber, string emailAddress, string city, string country)
        {
            FullName          = fullName          ?.Trim() ?? throw new ArgumentNullException(nameof(fullName));
            MobilePhoneNumber = mobilePhoneNumber ?.Trim() ?? throw new ArgumentNullException(nameof(mobilePhoneNumber));
            EmailAddress      = emailAddress      ?.Trim() ?? throw new ArgumentNullException(nameof(emailAddress));
            City              = city              ?.Trim() ?? throw new ArgumentNullException(nameof(city));
            Country           = country           ?.Trim() ?? throw new ArgumentNullException(nameof(country));
        }

        internal string FullName { get; }

        internal string MobilePhoneNumber { get; }

        internal string EmailAddress { get; }

        internal string City { get; }

        internal string Country { get; }
    }
}

namespace Phonebook.Repositories
{
	using System.Collections.Generic;

	internal interface IContactRepository
	{
		IEnumerable<Contact> GetAllContacts();

		void AddContact(Contact contact);
	}
}

namespace Phonebook.Repositories.SQLite
{
	using System;
	using System.Collections.Generic;
	using System.Data;
	using System.Data.SQLite;

	internal sealed class SQLiteContactRepository : IContactRepository
	{
		private const string TableName = "phonebooklist";

		private const string FullNameColumnName = "Fname";

		private const string MobilePhoneNumberColumnName = "Mnumber";

		private const string EmailAddressColumnName = "Email";

		private const string CityColumnName = "City";

		private const string CountryColumnName = "Country";

		private static readonly string SelectAllContactsCommandText =
			$"SELECT [rowid], [{FullNameColumnName}], [{MobilePhoneNumberColumnName}], [{EmailAddressColumnName}], [{CityColumnName}], [{CountryColumnName}] " +
			$"FROM [{TableName}]";

		private static readonly string InsertContactCommandText =
			$"INSERT INTO [{TableName}] ([{FullNameColumnName}], [{MobilePhoneNumberColumnName}], [{EmailAddressColumnName}], [{CityColumnName}], [{CountryColumnName}]) " +
			$"VALUES (@FullName, @MobilePhoneNumber, @EmailAddress, @City, @Country)";

		internal SQLiteContactRepository(string connectionString)
		{
			ConnectionString = connectionString ?? throw new ArgumentNullException(nameof(connectionString));
		}

		private string ConnectionString { get; }

		public IEnumerable<Contact> GetAllContacts()
		{
			using (var adapter = new SQLiteDataAdapter(SelectAllContactsCommandText, ConnectionString))
			using (var dataSet = new DataSet())
			{
				adapter.Fill(dataSet, TableName);

				return
					from contact in dataSet.Tables[TableName].AsEnumerable()
					select new Contact(
						fullName:          contact.Field<string>(FullNameColumnName),
						mobilePhoneNumber: contact.Field<string>(MobilePhoneNumberColumnName),
						emailAddress:      contact.Field<string>(EmailAddressColumnName),
						city:              contact.Field<string>(CityColumnName),
						country:           contact.Field<string>(CountryColumnName)
					);
			}
		}

		public void AddContact(Contact contact)
		{
			using (var connection = new SQLiteConnection(ConnectionString))
			using (var adapter = new SQLiteDataAdapter(SelectAllContactsCommandText, connection)
			{
				InsertCommand = new SQLiteCommand(InsertContactCommandText, connection)
				{
					Parameters = {
						new SQLiteParameter("@FullName",          DbType.String, FullNameColumnName),
						new SQLiteParameter("@MobilePhoneNumber", DbType.String, MobilePhoneNumberColumnName),
						new SQLiteParameter("@EmailAddress",      DbType.String, EmailAddressColumnName),
						new SQLiteParameter("@City",              DbType.String, CityColumnName),
						new SQLiteParameter("@Country",           DbType.String, CountryColumnName),
					},
				},
			})
			using (var dataSet = new DataSet())
			{
				adapter.Fill(dataSet, TableName);

				var table = dataSet.Tables[TableName];
				var row = table.NewRow();

				row.SetField(FullNameColumnName,          contact.FullName);
				row.SetField(MobilePhoneNumberColumnName, contact.MobilePhoneNumber);
				row.SetField(EmailAddressColumnName,      contact.EmailAddress);
				row.SetField(CityColumnName,              contact.City);
				row.SetField(CountryColumnName,           contact.Country);

				table.Rows.Add(row);

				try
				{
					adapter.Update(table);
				}
				catch (SQLiteException ex) when (IsConstraintError(ex))
				{
					throw new RepositoryConstraintFailedException("A repository constraint failed.", ex);
				}
				catch (SQLiteException ex)
				{
					throw new RepositoryException("An exception occurred while adding a contact to the repository.", ex);
				}
			}
		}

		private static bool IsConstraintError(SQLiteException ex)
		{
			var primaryErrorCode = (SQLiteErrorCode) (ex.ErrorCode & 0xff);
			return primaryErrorCode == SQLiteErrorCode.Constraint;
		}
	}
}

Your form can then look something like this:

namespace Phonebook.Forms
{
	using System;
	using System.Configuration;
	using System.Windows.Forms;

	using Phonebook.Repositories;
	using Phonebook.Repositories.SQLite;

	internal sealed partial class PhonebookForm : Form
	{
		private const string ConnectionStringName = "connect";

		internal PhonebookForm()
		{
			InitializeComponent();
		}

		private string ConnectionString { get; } = ConfigurationManager.ConnectionStrings[ConnectionStringName].ConnectionString;

		private void AddContactToGrid(Contact contact)
		{
			contactsGridView.Rows.Add(
				contact.FullName,
				contact.MobilePhoneNumber,
				contact.EmailAddress,
				contact.City,
				contact.Country
			);
		}

		private void HandlePhonebookFormLoading(object sender, EventArgs e)
		{
			var repository = new SQLiteContactRepository(ConnectionString);

			contactsGridView.Rows.Clear();
			foreach (var contact in repository.GetAllContacts())
			{
				AddContactToGrid(contact);
			}
		}

		private void HandleAddContactButtonClicked(object sender, EventArgs e)
		{
			var repository = new SQLiteContactRepository(ConnectionString);

			var contact = new Contact(
				         fullNameTextBox.Text,
				mobilePhoneNumberTextBox.Text,
				     emailAddressTextBox.Text,
				             cityTextBox.Text,
				          countryTextBox.Text
			);

			try
			{
				repository.AddContact(contact);
				AddContactToGrid(contact);
			}
			catch (RepositoryConstraintFailedException)
			{
				MessageBox.Show(
					owner:   this,
					text:    "The mobile phone number or e-mail address is already in use.",
					caption: "Couldn't add new contact",
					buttons: MessageBoxButtons.OK,
					icon:    MessageBoxIcon.Warning
				);
			}
		}
	}
}