All Questions
683
questions
0
votes
0
answers
40
views
the DataGridViewComboBox is not filled in
I created a database and wrote functions that should take column names from tables and put them in DataGridViewComboBoxCells. However, after running the program, no errors came out, but all ...
0
votes
1
answer
110
views
Syntax error in FROM clause C# and MSAccess
I have a program that fetch data from database. I have two different databases (MSAccess and Oracle). I kept receiving "Syntax error in FROM clause" if I set the connection to MSAccess but ...
0
votes
1
answer
116
views
C# date time not match sql date [closed]
I try to develop a windows form program and I need to insert data. I need to insert today's date and time but when I try I get an error. I use access database. Where is my fault?
cmd = new ...
0
votes
1
answer
100
views
Cannot apply indexing with [] to an expression of type 'DataColumn' C#
this is my first time creating a post on here and so i may be a little new to the conventions here.
Basically, in my project (which is a c# form), I am trying to convert an excel spreadsheet into an ...
0
votes
1
answer
34
views
C# MS Access OleDb can't make write operations
I have a database in MS Access and I am trying to edit the table (db). SELECT works for me but edit operations like INSERT, SET and DELETE does not change anything.
I have this code below that deletes ...
0
votes
1
answer
79
views
No data exists for the row/colum when there is data
i have this code
public static PersonalData[] GetAllPersonalInfo(OleDbCommand cmd)
{
cmd.CommandText = "SELECT count(Id) FROM PersonalInfo";
int count = (int)...
0
votes
2
answers
108
views
SQL query ExecuteNonQuery(); is not working
What is wrong with this simple code? The second query " in //" which is the direct value works fine but the first query execution (rowsAffected) does return a value of 0.
try
{
using (...
1
vote
1
answer
88
views
How do I get a password hint from an Access Database
I'm currently making a C# winforms POS application, using an Microsft Access database (since its the only type of database I know how to use)
I need to get a password hint field, only knowing the ...
0
votes
1
answer
28
views
no value given for one or more required parameters. oledb c#
I have created a simple login (C# Windows Forms) with MS Access Database(2016), but when I tried to log in, in the username field if I enter uppercase or lowercase letters its given a successful login....
0
votes
2
answers
46
views
Oledb ExecuteNonQuery function is not inserting all data into database
I'm trying to insert values into an Access database with C#, but only some of the data is being inserted. All of the data types in the database and the C# code are correct.
This code below throws an ...
0
votes
1
answer
78
views
How do I read/write record in Access Database that has table relationships?
I am creating an Access Database, that has the following tables and field
TableMain TableCustomer Record in TableCustomer
ID Auto
fDate(Date/time) CID (Auto) ...
1
vote
1
answer
52
views
Update statement does nothing
When I enter a number in the ChbBeds_numericUpDown and click on the "Update" button, it says "Data Updated", but nothing changes in the database
private void ChbUp_button_Click(...
0
votes
0
answers
47
views
Missing operator in 3 table join statement [duplicate]
I am trying to join 3 tables in my MS Access database in C#. Whenever I run the code, i get an error saying "Missing Operator in query expression".
I have also just copied the SQL statement ...
1
vote
0
answers
41
views
C# Cannot modify an Access DataBase
I'm trying to modify an specific register on Access by C# but when I run the code, It doesn't modify anything, I have tried the same structure on adding resgisters or deleting and it works well, Help ...
1
vote
1
answer
97
views
How to check which primary key a record was assigned to in C#?
I'm using the OleDBConnectivity system to connect and use a Microsoft Access database.
I'm adding a record to the table in the database called "PayInfo", and the primary key is automatically ...