System.Data.SQLite.SQLiteException: 'SQL logic error no such table: Employee'
Open
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 18.4k
- Forks
- 3.7k
- Avg merge
- 5h 8m
- Merged PRs (30d)
- 1
Description

private void setConnection()
{
sql_con = new SQLiteConnection("Data Source = DBEmployeeManagement.db;Version = 3; New = False;Compress=True");
}
private void ExecuteQuery(string txtQuery)
{
setConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = txtQuery;
sql_cmd.ExecuteNonQuery();
sql_con.Close();
}
private void LoadData()
{
setConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
string CommandText = "SELECT * FROM Employee Profile ";
DB = new SQLiteDataAdapter(CommandText, sql_con); \\this starts the error
DS.Reset(); \\
DB.Fill(DS);\\
DT = DS.Tables[0];
dataGridEmp.DataSource = DT;
cbGender.DataSource = DT;
string CommandText1 = "SELECT * FROM Department Profile";
DB1 = new SQLiteDataAdapter(CommandText1, sql_con);
DS1.Reset();
DB1.Fill(DS1);
DT1 = DS1.Tables[0];
dataGridDept.DataSource = DT1;
cbDept.DataSource = DT1;
string CommandText2 = "SELECT * FROM Job Profile";
DB2 = new SQLiteDataAdapter(CommandText2, sql_con);
DS2.Reset();
DB2.Fill(DS2);
DT2 = DS2.Tables[0];
dataGridJob.DataSource = DT2;
cbJob.DataSource = DT2;
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No Dapper file, test, or repository entry point is identified; the report only shows external C# SQLite code and a missing-table error. First verify whether the problem is reproducible in Dapper, then identify a repository-level failure and test before defining what done means.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sqlite
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 10/100