All Questions
81 questions
0
votes
2
answers
65
views
I want to find distinct values from a column in an Access (accdb) database table
I want to select all the rows in a database table where the values in FileSize are unique.
I am using .NET, OleDB, and SQL against an Access database:
ID FileName FileSize
------------------------
...
- 57
0
votes
1
answer
107
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
1
answer
550
views
How do I write data from access tables to excel
I am looping through a table called _TF_Tables which contains the names of all tables within the database for which an Excel workbook needs to be created and filled with data from that table.
The ...
- 822
-2
votes
1
answer
112
views
I want to update the Value of a row if it already exist in table
I want to update the value of Qty if the product name is already in the table.
{
connection.Open();
OleDbCommand command = new OleDbCommand();
...
0
votes
0
answers
96
views
Null error on AutoIncrement ID Column when inserting (using MDB linked to MySQL)
I created an MDB database and linked the tables to MySQL.
When I try to insert I get the following error:
„FotoID” cannot be null
Stack Trace Error:
Source: System.Data Stack Trace:
...
0
votes
0
answers
179
views
C# MS Access Database Update with Dynamic Column Name
I am trying to push data into a column where the name is a variable.
From the code below:
label1.Text is the dynamic column of the DB database (it is a string)
ComboBox1.Text is the data that I ...
0
votes
2
answers
95
views
How do I use BETWEEN and AND in Access SQL to filter on a date range?
I am using an Access database that has table Visits with field VisitDate whose values are stored as a strings (e.g. 01/21/2020). I need to extract all records using VisitDate fields values between 1/...
1
vote
2
answers
1k
views
Inserting Null into a database with C#
I'm pretty new to C# and am struggling with the following query.
I'm trying to insert values into a database, but it won't accept null as a value. I need to differentiate between 0 and nothing in ...
-1
votes
1
answer
62
views
I have problem with the parameters in a query in dataset
I have a .NET program with a dataset to an access/a sql DB.
I wrote a query and used 2 parameters, but I got an error:
Error in WHERE clause near '@'.
Unable to parse query text.
My query is:
...
user11568901
1
vote
0
answers
45
views
MS Access - missing operator in query expression [duplicate]
I'm developing a .Net Platform app running against an Access Database. The query is failing with the error:
"Syntax error (missing operator) in query expression
'Repairs.CustomerId = Customer....
- 33
0
votes
1
answer
426
views
Get a Value from a SqlDataSource object's SelectCommand, then use the value in an If Statement
So I need to get the value from from the Query - in the AS TrueOrFalse field.
I'm confused on how I should go about doing that.
In basic thought/wording: I need to see if there exists a value in ...
- 15
-1
votes
1
answer
100
views
Retrieving info from a database in C# with SQL commands
I'm currently trying to make a book manager in C#. I'm using a .ACCDB Database to store data about the books.
First I retrieve the bookIDs that belong to a specific series with:
sql.CommandText = "...
- 33
0
votes
5
answers
76
views
(SQL) Select and return all from more than 2 tables that have a common field where a specific value is present in all tables
As above, I would like the result to be one row of all the columns from each table where the value was met. The common field in all tables is the primary key. Any type of UNION does not work as the ...
1
vote
2
answers
3k
views
How to rename MS Access table with relationships using SQL?
I'm connecting to an MS Access database from an external .Net application. I need to use SQL in order to upgrade the schema of the database. Part of the upgrade requires renaming a table that is part ...
- 453
-1
votes
1
answer
79
views
No value given for one or more required parameters. System.Data.OleDb.OleDbException:
I am getting this error while running my aspx file when I click o Button2 after selecting start and end date and value from dropdown list.
The website was working normally but now it is throwing this ...
- 41