All Questions
732
questions
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
0
answers
28
views
Command "Update-database" not connecting to SQL server [duplicate]
When I try to use the “Update-database” command, I always end up with this problem:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was ...
1
vote
1
answer
69
views
Retrieving Courses Taught by a Teacher using C# and MySQL
I am working on a C# application that interacts with a MySQL database to retrieve information about teachers and the courses they teach. I have a teachers table containing information about teachers ...
2
votes
1
answer
1k
views
Unable to add stored procedures to EDMX file in VS 2022
I am wondering if anyone can recommend a possible solution or something I have not tried to help me solve the following problem.
Issue:
I am unable to add stored procedures to a EDMX file using the ...
0
votes
1
answer
83
views
Checking Build Errors to be included in a solution build so that if there is any error in sql file the build fails
I have a c# project which is a console application , it uses DbUp for running the scripts to a sql server db , Is there a way to stop the build process if there is any syntax issue in .sql file
I ...
0
votes
1
answer
1k
views
Get Current User in a Blazor server app without using AuthenticationStateProvider
so i just started to learn about blazor and i am trying to make an dating app, in that app i have a page that creates profile but the thing is i cant get it to read the logged in user id by it self
...
0
votes
1
answer
81
views
The underlying provider failed on Open. - Login failed for user Domain\MachinName$
I have a application which worked fine for many years, but after updating windows server it stopped working. The application (visual studio , SQL Server Database)is formed from two parts, 1) ...
-1
votes
1
answer
44
views
How to manually set a data on a datagridview column between 2 dates?
enter image description here
i have this datagridview that has 2 date columns named : "SOA RECIEVED" and "DATE PAID". What i wanted to do is to compute the difference and show the ...
0
votes
0
answers
74
views
C#, DevExpress and SQL multiple database table access problem
So pretty much I've started developing for a small company on a abandoned project they started like 2 years ago and I've hit a big roadblock. The app means to manage a lot of parameters and data of ...
0
votes
0
answers
164
views
LINQ in SQL Server database project C# Visual Studio 2022
I created a SQL Server database project. In this project, I have some classes where I use LINQ. Simple syntax LINQ is working properly - for example:
var p = AreasList.Where(c => c.AreaId == (int)...
0
votes
0
answers
54
views
How would you properly use System.Data.SqlClient to populate data with a query that contains a DateTime?
The purpose of this application is for the user to select a specific seat on a specific day for a football game. The purpose of this specific part of this application is to populate the drop-down ...
-1
votes
1
answer
253
views
how to convert from a datetime picker in DevExpress in C# to DateTime only date without time
I need the result as
01/05/1998
not
01/05/1998 07:35PM
I tried
(Convert.ToDateTime(DateTime.Parse(dtpCUST_BD.EditValue.ToString()).ToShortDateString())
0
votes
1
answer
299
views
String was not recognized as a valid TimeSpan. Error in C# inserting time to SQL database
I'm using this code to insert time into a SQL database:
TimeSpan.Parse(string.Format(DateTime.Now.ToShortTimeString(), "hh:Mi"))
I tried to change the syntax of time "hh:mm:ss" ...
1
vote
1
answer
541
views
I have a problem with SQL Server connection string [duplicate]
When I run the api from Visual Studio without a debug, I always get an error when I enter the values I want in swagger.io.
System.InvalidOperationException: The ConnectionString property has not ...
1
vote
1
answer
151
views
How to bind the results of one combobox to another combobox in Visual Studio (C#/SQL)
I am creating an interface to display car owners and their respective cars (think, a pretend DMV).
I have a combobox bound to the database that autopopulates a few text fields (first name, last name,...