Hello, I'm doing a windows form project, in this project, when I subtract the entry date from the end date, I reflect the result to a column named remaining usage. What I want in the database is that this remaining usage decreases by 1 every 24 hours
I have a very simple query
Select * from Employees
where company = 'Company A'
order by firstName
I want to run this query to run automatically on a daily basis and save the results in excel. Is their any way I can achieve this purpose?
I tried using SQL server jobs but the output excel file...
See code below:
public ActionResult<List<string>> FetchConfig([FromBody] FetchConfigDto fetchConfigDto)
List<string> myResult = new List<string>();
_logger.Debug("getting config from database");
I am new bee to programin world, i know fundamentals of C#, i trying to build a web app on asp.net
But i have a question, i want to get information from multi sql server that are about 50 db.
how can i get this info to my app?
i will use Grid Vew, but i am confuse how i will merge...
I work on SQL Server 2014 and my issue occurred after displaying Feature Name and Feature Value separated by $.
When executing the query below after adding Feature Name and Feature Value with stuff it became very slow.
How to enhance it?
Before adding the two stuff statements it took 28...
I need your help PLEASE .
I developed a desktop application ( c# ; .NETFramework 4.7.2 ) with Visual studio2019 & SqlServer2017 ; and I tried to deploy it but it doesn't work in another laptop .
I get the error message :
************* Débogage JIT **************
Pour activer le débogage...
Hello, im currently getting to grips with ASP.NET Core and I've ended up having an issue with one of my functions within my UsersController class.
public class UsersController : ControllerBase
private readonly IDBConnection _isqlConnection;
I want to ask if there is any possibility to retain the Auto Increment Primary Key Numbers after deleting a record. For Example there are 5 records save in a table if I delete a tuple ID 3 by clicking on a delete button from a datagridview it shows the ID sequence retained as 1,2,3,4 instead of...
Initially I was concatenating my SQL queries, i was then informed that it would be best to use parameterized queries to prevent SQL Injection. I've now done that and everything works fine, however when posting on a forum yesterday about one of my queries not working properly, a person told me...
I would like to read all of the values from the column name "seatNo" and store those values within a list. I've done most of the code but i have absolutely no idea how to actually store the values
Here is what i have so far:
private List<string> seatNumbers = new List<string>()...
I have a sign in method, which stores the details of a user based on the password and email that they enter. Within this method i call a function which stores those details inside of a list.
My question is how would i be able to access those individual values? I want to be able to access just...
When signing up data will be stored within two tables. customerLogin and customer.
The code for this is shown below, it works the way i want it to, inserting the correct details into both tables.
string query_1 = "Insert into customer (firstName...
I'm trying to execute the following query, but its throwing an exception "Must declare the scalar variable \@dateFrom\ "." Does anyone maybe know why this is occurring? the dataType for dateOfDeparture is date. when i was using concatenation i was providing the format of the date...
When the user logs in they will be taken to a dashboard where they can select different options. one of them being "Account details". within this user control I've set up text boxes which will be filled with the users details once they double click on the row within the DataGridView .
When the user double clicks on one of the bookings within the grid view, i would like to transfer the Id to a text box in a separate user control. Any ideas of how could I achieve this? Thankyou
private void availableBookings_CellDoubleClick(object sender, DataGridViewCellEventArgs e)...
I have a method which is storing values in database and after that it is print invoice. I'm printing a form for invoice printing. I want to make sure that if it's saving it should print. Otherwise rollback all chanages. Following is syntex of the method.
im having a problem converting from datetime c# to datetime sql server using odbc and time c# to time(7) sql server this is my code:
command.CommandText = "INSERT INTO pointer (Nom_employe, Date_Heure , Matin, Midi, apresmidi, Soir) VALUES ( ? ,? , ? , ?, ?, ?);";
I am trying to learn database management system that exists in my company. I am new to this. So there are things that I have understood so far. I want to know what I understood is correct or not. So there is this Database which when I checked in Visual studio is of type Microsoft Sql...