get user input and add to table

Marysm Khan

Hi,

I am new to C# so my question might seem pedestrian. I need to get Employee Info such as name, dob, phone number, deptid, and dept name from the user and add it to the table. my difficulty is saving the data to the table. I am able to ask the user for the information with Console.WriteLine then I added Console.ReadLine() , after that Department.Employee.Add(new Employee {FirstName=
" ", LastName=" ", DOB="", PhoneNumber="", DepartmentId="" , DeptName=" "}) ; HERE IS WHERE I AM HAVING PROBLEMS.

I am getting the error: "table Employee has no column named DepartmentId" When I check in SQLite Browser. I DO see the column named DepartmentId in Employee. I checked the spelling. So I don't understand where I am going wrong?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari4y ago
If you are sure, DepartmentId column exists in your Employee table then check datatype, I am pretty sure DepartmentId should be interegral value, so checnge your value like:
Employee {FirstName= "", LastName="", DOB="", PhoneNumber="", DepartmentId=1, DeptName=""});
Uttam Kumar4y ago
Can you share your code snippet?

It'll be rather easier understanding the issue you are facing.
Sachin Singh4y ago
Share your class structure. Make sure in your class there is property DepartmentId, i think it will be DeptId as you have named DeptName, just guessing.