Tag: asp.net

add sql WHERE statement to select new ID:s in database (asp / sql)

I’m trying to update a website where there’s new ID’s for different damage groups. All the new ID’s start after ID 139. In SQL the statement to get the new groups are simply: However, I want to implement the same statement in my ASP code and in the method that fetches the current damage groups. Here’s the current method for

Convert html foreach loop data to webgrid using asp.net mvc

asp.net asp.net-mvc-4 c# entity-framework sql

Below html table is filling using two loop condition, and same i want using two loop conditions to fill Webgrid I have tried to fill one field in web grid by using below code. when I am click debugging mode after code line complete on this line the following error is showing. Answer The exceptions you’ve included in your question

How to connect sql Database with ado.net in Asp.Net Core Mvc 5.0?

ado.net asp.net asp.net-mvc c# sql

I can not find where am i missing. my code like this ; users.cs : } usersAccessLayer.cs ; appsettings.json And finally i got this error; An unhandled exception occurred while processing the request. NullReferenceException: Object reference not set to an instance of an object. Adonet_Sql.Models.users..ctor() in users.cs, line 14 Adonet_Sql.Models.users..ctor() in users.cs bla bla. Answer ConfigurationManager.ConnectionStrings[“DefaultConnection”].ConnectionString; is for .net Core

How do I query SQL for the latest record based on latest Date and Time OR Date_Time columns?

asp.net c# mysql sql

Situation: SerialNumber has duplicate rows and I need to select the latest records and get what is the Status value (either it PASS or FAIL does not matter). SerialNumber must be check based on the previous StationNumber. Example: I want to get the Status value of the latest record SerialNumber 197601234512345 in Station 2, so value StationNumber = @Station in

ASP / SQL: Filepath as clickable link

asp.net sql visual-studio

I have a database file that looks like the following: When I put this in a SQL Datasource (Visual Studio), the file should be clickable text or image. Now it’s just plain text. What I currently have is: But this links to link instead of the content of the sql. Thanks Answer Remember, code behind can use full file system

POST HTTP request that sends SQL data to a site [closed]

asp.net http httprequest post sql

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question Would there be a way to create a POST HTTP request that sends SQL data to a site and then a GET request to show

Increasing the number of ids in the TextBox by one

asp.net c# devexpress sql

I have a table in my Sql Server and I have a value in this table. Table name = veriler Values name= Project ID int(PRIMARY KEY) I’m doing project automation for electrical engineer’s project. If engineer click the new project button. My program redirect to the Genel.aspx page. When the new project is opened, I want my id number to