sql-server Archives - Page 8 of 19

Waiting for localhost, forever!

August 31, 2022 by Magenaut

I have a gridview on my homepage with a view and an edit link that use query strings to display table data in read-only and editable pages, respectively. I get no error messages from my code, it’s simple enough that it doesn’t seem to be missing anything, but when I try to debug or view in browser, I get the permanent pinwheel on my status bar and the message “waiting for localhost”. What am I missing? Does anyone out there have some experience with this particular issue? I’m using C# and ASP.NET in visual studios with sql server 2008.

DB Connection string in Web.config to use attached .mdf database won’t work

August 31, 2022 by Magenaut

The file neodb.mdf is in my App_Data folder and I can browse the database in the server explorer in visual studio, using built in SQLEXPRESS:

What could be good ways to deploy ASP.Net Web Applications?

August 30, 2022 by Magenaut

We currently deploy web applications by creating a database and running SQL scripts through query analyzer. Then we copy the output from “publish website” and set up that website in IIS.

How to automatically delete records in sql server after a certain amount of time

August 30, 2022 by Magenaut

I have set up temporary user accounts on my sql database where the user names, passwords and date added of my websites users are stored. I was initially going to have these records delete programmatically but now im wondering if sql server 2008 has a built in function that allows records to be auto-deleted after … Read more

Occasionally Getting SqlException: Timeout expired

August 30, 2022 by Magenaut

I have application running on my server. The problem with this application is that daily I am getting nearly 10-20, System.Data.SqlClient.SqlException Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding only one of my SP. Here is my SP,

Return multiple datasets from sql server stored procedure

August 30, 2022 by Magenaut

I need to return through Web Api a Base64 XML output based upon calling a stored procedures which runs 5 different queries.

Get Return Value from Stored procedure in asp.net

August 30, 2022 by Magenaut

i have a stored procedure

Access Denied when inserting file into Sql Server 2012 FileTable using File.CreateFile in ASP.NET website

August 30, 2022 by Magenaut

I have an ASP.NET website.
I want to upload a file to the website and save it into a FileTable in SqlServer 2012.

Since there is no Sqlserver array parameter, what’s the best way to proceed?

August 30, 2022 by Magenaut

I need to create multiple records in sqlserver, each with the same value in column A, but with a unique value in column B. I have the values for column B in an array.

Multiplicity constraint violated Entity framework 5

August 30, 2022 by Magenaut

Hello i have 3 classes Person, UserProfile(it inherits Person) and Results, a Person can have one or more results, when i try to add i a result to a person a i get the error mentioned in the title, my classes are bellow. Any help would be appreciated.