All Questions
970
questions
0
votes
0
answers
133
views
using ajax with asp.net core mvc .NET 8 in visual studio 2022
I have a view that shows information from a sql tabel that I inserted in to a local DataTable I want to create a button that filters what is shown with ajax
this is the loop where the information from ...
1
vote
2
answers
180
views
Trying to Insert Bulk record into the database at once using C# and MS SQL User-Defined Table type
I have written below C# code and SQL code; I got scenario to insert multiple records in database at once, so I tried below method, but it is not working from my MVC C# but when I fire query manually ...
0
votes
1
answer
94
views
C# MVC Function that calls stored procedure but it always returns empty
I'm currently working on a function that calls a stored procedure that for some reason will always return empty for me. This stored procedure works when I run it manually inside SMSS, but for some ...
0
votes
1
answer
84
views
ASP.NET MVC code-first authentication page, can not upload files
I created an ASP.NET MVC project with authentication and I want to add a new field to register page for uploading an user image. The problem is when I save the new account, the image column is empty.
...
0
votes
1
answer
26
views
Partial view having switches called multiple times
I have a main view where I am calling a partial view
<div id="Company_EmployeeSMSNotification_Container" class="emp-notif-containers" style="...
0
votes
0
answers
28
views
An unhandled exception occurred while processing the request. How to cast object of type system.double to system.single? [duplicate]
I have encountered this error when I try to create new product. When I click the create button, this is what it shows.
This is my table in my database.
Although the data I entered when I was trying ...
-2
votes
1
answer
81
views
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_User_Table_UserTypeTable" [duplicate]
please help me with error.
I'm doing a project at school
I'm building a web but when I nbut when I do login and use stored sql I get this error enter image description here.
Can you help me solve this ...
0
votes
0
answers
39
views
Switching Schemas Programatically in ASP.NET MVC [duplicate]
I am building a web app using asp.net mvc. My database is SQL server I have a schema for each of my clients and I need the same tables for each of the clients. What I want to achieve is show the data ...
0
votes
1
answer
211
views
ASP.NET MVC controller execute raw SQL queries - ToList objects are null
I want to use some raw SQL queries in my ASP.NET MVC controller. My queries are much more complicated than the example shown, but they has the same problems.
The objects are empty!
TableName
| Id | ...
0
votes
0
answers
60
views
How to post foreign key that’s passed from another action controller as a primary key? (ADO.NET ASP.NET MVC)
I have tables:
Shipment (ssuid, sCompanyName, sFName, sMName, sLName, sAddress1, sAddress2, sCity, sState, sPostalCode, sCountry)
Packages (ppuid, psuid, pTrackingNumber)
where psuid is a foreign ...
0
votes
1
answer
97
views
How do I pass foreign key to View page? (ADO.NET)
I have 3 SQL tables for my web application.
Shipment(ssuid, sCompanyName, sFName, sMName, sLName, sAddress1, sAddress2, sCity, sState, sPostalCode, sCountry)
Packages(ppuid, psuid, pTrackingNumber)
...
0
votes
1
answer
78
views
How to query type (int?) for any matches of type IQueryable<int>?
I have an IQueryable<int> set of data that I am using as my "match". I want to find any "Source" were the UnitID matches any of the "Units" (any of the integers).
...
0
votes
0
answers
39
views
How to pause the process in MVC and resume when user select YES and should be aborted for NO
My application is in MVC, and database SQL. In our scenario user upload an excel file which may contain more than 100,000 records. The file is converted into data table and than uploaded to the ...
0
votes
0
answers
68
views
Is it possible to add trigger and function in asp.net?
tables for item and purchase
I have created two tables and the apps CRUD works. Now, I want to make something that when I add a new purchase record, the associated item's ItemNum will be subtracted ...
0
votes
1
answer
800
views
Using LinQ to access multiple tables. What is the correct way to join these tables with LinQ to be the same as SQL Query?
I am trying to access all the tables in the data warehouse that I created for an experimental project using Lin-Q and I just don't seem to understand how to access every table regarding the data ...