I am currently building a Web Application Project in Visual Studio 2010 and, until recently, have not needed to use the scaffolded code for Memberships, Users and Roles etc that are stored in the ASPNETDB.mdf database file. I have been running the project on the Visual Studio Web Server, IIS Express (from Visual studio) and also IIS7.5 without a problem.
When i am trying to run my website (with aspx) this problem comes up:
I’ve got a Repeater and its SqlDatasource nested inside a Gridview TemplatedField.
The Repeater’s datasource SelectCommand is set using the FormatString of an Eval from the Gridview.
The SelectCommand has a WHERE clause which is to compare a string.
Because I have already used the single and double quotes, I am having trouble delimiting the string in the SQL WHERE clause.
I am using multiview index to insert the news details. In the first view the user can enter details of news which is then inserted into db on clicking the next button
the second view gives a user to add images of that news (only 3 images allowed) ,
i am having a SQL Procedure that always returns “PRINT” Command and i want to extract the output of this “PRINT” Command i.e the procedure in C# how can i do that ? here is the PROCEDURE
I am getting exception: “Specific cast is not valid”, here is the code
I am using a TRY CATCH block in a stored procedure where I have two INSERT instructions.
I am trying to execute stored procedure from bcontext.Database.SqlQuery using EF5.
I was wondering how I can pass either an ArrayList, List<int> or StringBuilder comma delimited list to a stored procedure such that I find a list of IDs using IN():
I’m trying to insert order details into my DB, and it keeps saying: