I know the update did not go through because the table has a trigger on the field called updatedate, which updates this field to current datetime when a change occurs, and there were no rows in the database with the time I had performed an update. Thanks.

But like GuyThiebaut mentioned, since the update query errored out, the connection would be lost and hence as good as rollback.

Creating the backup table every time an update is executed does not make sense. The database has all these tables _bak and begins to get messy real soon.

Nope I did not issue a commit. Usually have it commented and if all goes well, highlight the commit and execute it! Thanks a bunch!

This question is more for my future understanding. Do I have to issue a rollback statement, or since the update is part of begin tran, and since the update failed nothing would update or would it result in a partial update? Thanks.

Hello All, I am performing an update statement. About 100,000 rows. Just before my update statement I had, "begin tran". There was an issue with the update statement, and errored out. Do I have to issue a "rollback" statement to make sure there is not a partial update or does using begin tran make sure a partial update does not occur? Thanking you!

Hi, I have a panel which is not visible to begin with. this panel had a static text, and a dropdownlist which is loaded dynamically. On Postback, when the dropdownlist keeps disappearing, but i can still see the static question. On viewing in the firebug, the visibility for this dropdown is set to hidden. I keep setting it to visible but the dropdown does not show. any ideas?????

Null value is returned.

Actually both settings are defined in the web.config file, but under different sections. I am not using the app.config file in my other project.

In the web.config file, if I use the then I am able to access this setting in my other C# project using, with no issues:

Int32.Parse(ConfigurationManager.AppSettings["QId"]);

But if it is defined in the part of web.config, when I try to access it in my other C# project:

Int32.Parse(System.Web.Configuration.WebConfigurationManager.AppSettings["QId"])

a null value is returned. Is my syntax incorrect?

Hello All, Our main 2012 VS solution has 16 projects. One of the project is a web site, which a web.config file defined. I want to access this website's web.config file's applicationSettings value in another project. I added the System.Configuration to this class. And using below trying to access the value of the settings. Since this setting is defined as a string, converting it to an int. The value for the setting QuesId is 2 in the web.config file. The code complies with no errors, but when i execute and browse the code, the value is null. any ideas??

Int32.Parse(ConfigurationManager.AppSettings["QuesId"]);

Hello all, I ran the trace file and then analysed this data in the Anaylser in SQL Server 2008. I have a table consisting of 2 million rows, and the analyser recommended 15 indexes. I am fairly new to this company and was not sure how to go about this. Is there some other way to figure which index would be really required? I have a field which is the Primary Key, a datetime field, a unique identified field. Thank you!

Hi All, I solved this issue by addressing these two items:\ 1. Regarding the first error, need to remove the following tags in the csproj file

0
blah\blah\blah
4.0

2. Regarding the IIS error, I had to do this:

True change to False

I have another URL in place, and dont really use the localhost, my website has a defined another url in IIS, like http://mydev.ee.com. But i am still using IIS, how does this still work? many thanks,

Hi, We have all our code base in team foundation server. All of a sudden i am getting this error message, related to getting the latest files from TFS. It is not able to able to load the main web site project, resulting in this error message. I have VS2012. I had no issues in past opening the solution, it is just the past week that i am having a problem. But my fellow developers have VS2010.

Visual Studio needs to make non-functional changes to this project in order to enable the project to open in this version and Visual Studio 2010 SP1 without impacting project behavior.

I am not able to reload the main project, comes up with

error : The Web Application Project Emerson is configured to use IIS. The Web server 'http://localhost/' could not be found.

I am at my wits end trying to research this issue. Any thoughts? anything i missed? Much much appreciated!

Hello all, I added a new dynamicdata\custompage aspx page to the existing Data Scaffolding project. I want to remove the existing "delete" option in the gridview, and hence need to create a custompage to accomplish this. How to make sure the default page is reading this newly created page? I rebuilt the solution. but every time I try to access this page, it comes back with a page not found message. Am i missing something? Thank you!

Hello All, I have an ASP.Net label error message set at the top of the page. And for some reason MaintainScrollPositionOnPostback = false is not working. I would like the page to scroll back to top, so users can see this error message. It does not scroll to the top, and maintains its existing position, leaving the user to keep clicking submit button. I have tried this: Specified on the code behind of asp.net user control: Page.MaintainScrollPositionOnPostBack = false; It does not scroll back to top of the page, as i would like it to so the user can read the message at the top of the page. am I missing anything? Thanks!

Hi All, I am trying to debug a data issue, where in a query is reporting incorrect data. Upon looking at the query having about 15 tables joined in the query, there is one join where it is specified as RIGHT OUTER JOIN but does not have a table it joins to. I am researching an existing query, written by someone else with no documentation. I tried to add one join at a time to debug this issue, but the query fails when i try to add the RIGHT OUTER JOIN with no table to join on specified. I really don't know how the original query is working. any ideas/inputs much appreciated!! Thanks!

This is the syntax, to be placed with in the body of email: var createdate = '<%=hdnCreateDate.Value%>';

Thank you for your response. The job runs at 3am just for that reason, so we don't have resource issues. It has crashed 3 times the past few months, but our seniors want this matter researched since it is a new bug in their test environment. They don't want this bug to migrate to production environment. I got this error message of the log file, and it is defined with single hash, #.

Hi Everyone! All of a sudden we are seeing the above error message, in one of our automated jobs. This job runs at 3am everyday. This error occurs on random days, not on a regular basis. There is not much out on this particular error. The temp table is defined in a stored procedure. Thanks!!!