I've published my first web app and changed the connection string and membership however I'm having an issue trying to connect and run the update stored procedures. I can retrieve data without any problems. The stored procedures work fine on my local machine but not after it's been published.
[code]....
How to update two tables in a single update query.
View 6 RepliesThe users of my webapplication are validated using database connection. This requires each user is a sql server database user. While logging their validity is checking by trying to create a connection using userid and password entered by the user. If connection opens successfully, it is a valid user. I also have a page in application to change the password, where sp_password is used to updated database password.
string connectionString = ConfigurationManager.AppSettings["DBServerName"];
//try to create a new connection dynamically using user id and password
connectionString = connectionString + User ID=" + userId + ";Password=" + password;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
}
The problem is after i change password, and logout and try to login, i am able to login using old passwd also. The line of code which creates and open connection succeeds with both old and new password. If i stop and run the application again this works.
I have select query like this :
[Code]....
I have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.
If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?
Here is the sqldatasource config code: <asp:SqlDataSource ID="SqlDataSource1" runat="server"
View 1 Repliesi want to update the data of a database through a gridview update button
how can i attach a dataconvertion like this
[Code]....
[code]....
Im trying to update my DB(DataBase) by using SQL UPDATE query ,but its not updating in the dataBase i receive confirmation(in testLabel) that one row is affected(dataReader = query.ExecuteReader(); return numbers of rows affected)...
I have given a HTML editortext control on a page,which generates HTML (i have to store it in my DB,that page is only for Admin) ,on pressing Update button , im receving in my testLabel that one row is affected(which shows DB is updated succesfully) but when i check my DB its in old state,it is not updating...
Here is my Event handler of Update Button which have to make updates in DB:
[Code]....
[Code]....
What's wrong with the following code?
[Code]....
After the SubmitChanges call, the Text field in data2 wasn't changed. According to the NerdDinner sample, I supposedly can just write to my data object and then call SubmitChanges.
I have an update / insert statements. If the user selects the checkbox IsPrestigeFeatured, I want that row to be set to 1 and I want all other rows to be set to 0. E.g. so there is only one row which is "Is prestige Featured"
My update statement:
ALTER PROCEDURE dbo.Update_Property
@propertyId int,
@propertyTypeId int,
@Name ntext,
@Price int,
@DescriptionResultsExcerpt text,
@Description ntext,
@Characteristics ntext,
@IsRenovation int,
@IsCharacter int,
@IsPrestige int,
@IsHomepageFeatured int,
@IsPrestigeFeatured int,
@CityId int,
@DepartmentId int,
@CommuneId int
As
UPDATE Property
SET Name = @Name, PropertyTypeID = @propertyTypeId, Price = @Price,
DescriptionResultsExcerpt = @DescriptionResultsExcerpt,
Description = @Description, Characteristics = @Characteristics,
IsRenovation = @IsRenovation, IsCharacter = @IsCharacter,
IsPrestige = @IsPrestige, IsHomepageFeatured = @IsHomepageFeatured,
IsPrestigeFeatured = @IsPrestigeFeatured, CityId = @CityId,
DepartmentId = @DepartmentId, CommuneId = @CommuneId
FROM Property
WHERE (PropertyID = @PropertyID)
From the last few days I am struggling with the error
"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."
I hav created an asp.net web application with membership shcema. It works fine an my developement machine but when I published it on my web server.
I am having problems with the following update query that is part of an SQL Datasource. This query was automatically generated by VS2008 and I have formatted it so that it is easier to read.
UPDATE tblowner
SET altownerid = @AltOwnerID,
name = @Name,
address = @Address,
phyadd = @PhyAdd,
phone = @Phone,
fax = @Fax,
cellphone = @CellPhone,
email = @Email,
COMMENT = @Comment,
attention = @Attention,
contact = @Contact,
ownerdesc = @OwnerDesc,
taxid = @TaxID,
financialcontact = @FinancialContact,
fyenddate = @FYEndDate,
firstname = @FirstName,
lastname = @LastName,
stampinit = @StampInit,
stampdate = @StampDate,
zipid = @ZIPID,
[ZIP+4] = @N'@[ZIP+4]'
WHERE ( ownerid = @original_OwnerID )
Everything works but the [ZIP+4] field which does not update. I believe that VS2008 added the square brackets around the field name because of the plus character that it contains. If I change the ZIP+4 variable name to [ZIP+4] = @ZIP4 it still does not work. This brings up another question, I have never understood where these update queries are getting their data from.
I wrote my first app in VB 2010 ASP/SQL. Runs perfectly in VS environment.
I then publish it to 2008 Server using Windows Authentication. The only App Pool it will start in is ASP.NET 4.0 Integrated....Classic will not work.
Starts out OK and then when the program tries to access SQL I get the following:
[Code]....
HTTP Error 500.24 - Internal Server Error An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.
[Code]....
I am trying to publish a 13Mb database on a remote shared SQL server and I keep getting an error:
TITLE: SqlPubWiz
------------------------------
An error occured while trying to publish the following script:IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetEvent]') AND type in (N'P', N'PC'))BEGIN
EXEC dbo.sp_executesql @statement = N' [code]...
I'm trying to publish a site which uses an ajax uploader control which has an extra licence file that must be in the bin folder. Now if i publish my site this file is not published to the server and so i have to manually copy the file every thime to the server. My publishing setting is set to 'Only files needed to run this application'. If I change this to 'All files in the project folder' then it works but what is the point in that? I'm using Visual Studio 2010 Ultimate. (Note that i am a little new to publishing websites etc).
View 4 RepliesHow do I exclude Web.config from server when publishing website (not web application project) in Visual Studio 2005 I can see information how to add setting to the Web.Config but in this instance the Web.config is fine on the servers; so I do not want the problem of introducing possible faulty Web.config to a live environment.
View 1 RepliesI am currently working on a project and I am hosting it on my IIS to test it every so often but now i have an issue:
When i run in debug mode with this connection string:
Data Source=.;AttachDbFilename=c:New folderdbname.mdf;Database=dbname;Trusted_Connection=Yes;
everything works fine and i can access the database but once its published onto my iis it doesnt find the database?
In my Visual Studio 2008 web site, I created a new folder named Reporting. Then one of my web pages creates an xml file in this new folder when the user clicks a button. The user then clicks another button and the xml file displays in the browser. This all works fine on my development PC. But if I publish this web site to my production server, it does not work. I get an error when I click the first button to create my xml file. The error reads: Could not find part of the path 'c:windowssystem32inetsrvReportingabc.xml' What must I do so that this works on my development PC and also my production server?
View 7 Repliesi published an application on windows server 2008 and IIS 7 i am facing a problem when user are trying to access the server or the web application in address they put ip address of the server /application a pop up screen asking for username and password problem IIS on windows server 2008 ..the server is configured it s making me crazy it s asking users for username and password
View 3 RepliesAfter I successfully installed Database Publishing Wizard [URL], I use it to connect to my local database server using SSMS 10.0 to generate a .sql file but I'm getting this error "This SQL Server version (10.0) is not supported."
Is there any updated version of DPW 1.1 that supports SQL Server 2008?
I'm getting the following error when using the Database Publishing wizard to script a SQL Server Express database for deployment. I have googled for hours unsuccessfully. Anyone had this isssue or know how to solve it?
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
After months of work I thought I had finished with my web application using VS2008 with CSSFriendly menu. On publishing, the menu did not work and I got all sorts of errors. Deleting CSSFriendlyAdapters.browser in App_Browsers folder improved the layout but the menu was not rendered with css even though the html source shows thet are linked. On desperation, I changed the target Framework from 3.5 to 2.0 and then back to 3.5 with no avail.
View 5 RepliesCreated a new virtual directory on my web sit in IIS 6.. set proper settings and wild card extensions... published via file system from dev environment to the server but i get a page cannot be found 404 error when browsing the site...
View 4 RepliesI have created a web app using Visual Studio 2008 Express Edition and have come to the point where I need to publish the site onto my server (which is running window server 2008). I found that the publish function is not limited in the express edition, so published the app to a local file and FTP'd the contents across to my server. I then setup a website through the servers IIS manage and pointed it to the folder containing the FTP'd files.
My question is, how do I run the app? Do I need to point to a specific file?
I have tried to view a number of the files in browser directly from the IIS but keep getting the same standard connection error i.e. "Internet Explorer cannot display the webpage"
I have never used IIS Manager before and I can't find a resource which gives me a step by step guide to setting up a new site which has been created by Visual Studio 2008 Express Edition, are there any config changes needed.
How to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
