When I am trying to Load page of my clients web application, which has shared connection string, I am getting the below error
A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)...
I want to select rows from a table where Id is not equal to 4, How to achieve it using SQL query?
Something like in C# .Where(a=>a.Id != 4).ToList() ?
Or in SQL like Select * Where Id != 4?
Thanks
...One of my projects was working properly, and then I shifted it into another pc, now same code, throws the below error for some SQL queries.
SqlException: MSDTC on server is unavailable....
How should i display 1st 10 records, then next 10 records then next 10 records in sql (paging in SQL)?
And how should i display the same thing in view using see more link?
...