0
votes
0answers
20 views
Passing Sql Server data to a view through JsonResult
I'm currently trying to get my data from a sql server db to display in a table on my page using jTable, but every time I do, I get a popup saying "An error occurred while communicating to the server."
...
2
votes
3answers
48 views
ASP.NET MVC 4 - Using Linq to read databse once & use multiple times
I am using Linq to create 4 object collections:
var Restaurants = db.Places.Where(p => p.Tags.Any(t => t.Name == "Restaurant")).ToList();
var Bars = db.Places.Where(p => p.Tags.Any(t => ...
0
votes
1answer
60 views
ASP.NET MVC 4 Code First - Best Practice: Always set maxlength for strings? (SQL Server 2012 efficiency)
When I developed applications Database First, I would always set limits (the likely maximum required) on varchar or nvarchar fields as this reduced SQL Server page size - and was generally seen as ...
0
votes
0answers
40 views
+50
“Error: Cannot Initialize OLE” When I try to run a SPA?
I'm trying to run the standard ASP.NET MVC 4 Single Page Application, but when I try to run it (Ctrl + F5), I get the following error message:
Unable to launch the IIS Express Web server.
...
1
vote
2answers
31 views
EF and datetime in SQL Server 2005
I am testing an application on server with SQL Server 2005 and I am getting the following error (the application runs fine with SQL Server 2008 R2 and 2012 versions).
There is no store type ...
0
votes
1answer
42 views
How would you use a sql server stored procedure that requires 2 parameters to produce a view in MVC 4
I have the following stored procedure in sql server 2008 r2
ALTER PROCEDURE [dbo].[cusGenDenialReport](@StartDate VARCHAR(11), @EndDate VARCHAR(11))
AS
BEGIN
SELECT ...
-2
votes
0answers
58 views
Dynamic Data,Pivot Records, with running totals Using Linq C# [closed]
i have a requirement to show report of target achieved by members for a campaign.
campaign has a set duration and i have to show data in report by month
This isn't the actual example, but it's ...
1
vote
1answer
32 views
User Defined Fields Structure
I am currently building a system which will need to implement user defined fields.
I currently have the following EAV 'like' structure. The 'Person' table acts as a master table.
Person Table
...
0
votes
1answer
35 views
How to add one item to different tables?
How can I add the same object same "truck" to another table?
[HttpPost]
public ActionResult TruckAdd(TruckList truck)
{
truck.DateAdded = DateTime.Now;
db.truckList.Add(truck);
...
0
votes
1answer
79 views
Import Excel into SQL Server with ASP.NET MVC in a list so it will easy
I have a table where I have fields
public class Exceldate
{
public virtual int Id { get; set; }
public virtual string Name { get; set; }
}
I have a SQL Server 2008 table Exceldate... and I ...
6
votes
6answers
229 views
+250
Is it ever a good idea to have a record in a reference table in your database that represent “all other records”?
I have an asp.net-mvc website with a SQL Server backend. I am simplifying my situation to highlight and isolate the issue. I have 3 tables in the DB
Article table (id, name, content)
Location table ...
0
votes
0answers
22 views
Having trouble loading my data into jTable in mvc 4 [duplicate]
I recently asked a similar question without solving my issue, and further research on my end hasn't solved my problem, so I thought I'd reask my question. I'm trying out jTable for the first time and ...
0
votes
0answers
105 views
Entity Framework LINQ joining 5 tables on multiple columns (impossible?!)
Please see image:
I am trying to create a LINQ query that combines 5 different tables on 1 to 3 different columns. I am basically taking the examples of 2 tables and repeating the join sections for ...
-1
votes
0answers
19 views
NH SaveOrUpdate(newObject) generating or jumping to a wrong Id in the database
Am having an issues with Nhibernate after persisting a new object. It was generating the correct Id of newly stored objects in the database but suddenly jumped from the correct value to thousands ...
1
vote
1answer
36 views
Displaying content stored in database(SQL Server) on MVC view
I have following stored on database
<iframe width="420" height="315" src="http://www.youtube.com/embed/mqSQvoinDE4"
frameborder="0" allowfullscreen></iframe>
When I try to display it ...
