Having trouble stepping into a stored procedure Visual studio (get canceled by user)

This error can be solved by adding your logged in user account as sysadmin user in SQL server .

How to assign value to asp.net literal or Label using JavaScript?

For an asp.net Label you can assign value using the innerText property
document.getElementById ('<%=Label.ClientID %>').innerText='Hellow World';

For an asp.net Literal you can assign value using the innerHTML property
document.getElementById ('<%=Label.ClientID %>').innerHTML=' Hellow World ';

How to add comments in my CSS (style sheet)?

CSS Commenting is very simple as any other language. Your comments should be in between /* and */. Here is an example of how to have comments
 /* this is a comment*/

How to open a popup from a hyperlink?

<a href="http://jquery.com/" target="_blank">new window</a>

Showing Updateprogress in a model window using Ajax modal popup extender

The below code will help you you to show an Ajax update progress in a Modal popup extender like the screen shot below.

The below code assumes the current page is under a master page.

Source code

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" Title="Untitled Page" %> <%@ Register assembly="System.Web.Ajax" namespace="System.Web.UI" tagprefix="asp" %> <%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> <style> .bg { background-color:Gray; filter:alpha(opacity=70); opacity:0.7; </style> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <asp:AjaxScriptManager ID="AjaxScriptManager1" runat="server"> </asp:AjaxScriptManager> <script runat="server"> protected void Button1_Click1(object sender, EventArgs e) { System.Threading.Thread.Sleep(2000); Label1.Text = DateTime.Now.ToString(); } </script> <asp:Button ID="Button1" runat="server" onclick="Button1_Click1" Text="Get date" /> <asp:Panel runat="server" ID="panel"> <img alt="" src="loading.gif" style="width: 130px; height: 60px" /> </asp:Panel> <asp:ModalPopupExtender ID="panel_ModalPopupExtender" runat="server" DynamicServicePath="" Enabled="True" PopupControlID="panel" TargetControlID="panel" BackgroundCssClass="bg"> </asp:ModalPopupExtender> <br /> <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional"> <contenttemplate> <asp:Label ID="Label1" runat="server" Text="Date:"></asp:Label> </ContentTemplate> <triggers> <asp:AsyncPostBackTrigger ControlID="Button1" /> </Triggers> </asp:UpdatePanel> <script language="javascript" type="text/javascript"> Sys.Net.WebRequestManager.add_invokingRequest(Laodpopup); Sys.Net.WebRequestManager.add_completedRequest(unLaodpopup); function Laodpopup(sender, args) { $find('<%=panel_ModalPopupExtender.ClientID %>').show(); } function unLaodpopup(sender, args) { $find('<%=panel_ModalPopupExtender.ClientID %>').hide(); } function pageUnload() { Sys.Net.WebRequestManager.remove_invokingRequest(Laodpopup); Sys.Net.WebRequestManager.remove_completedRequest(unLaodpopup); } </script> </asp:Content>

Why UpdateProgress Not Showing?

In the following scenarios, the UpdateProgress control will not display automatically:

The UpdateProgress control is associated with a specific update panel, but the asynchronous postback results from a control that is not inside that update panel.

The UpdateProgress control is not associated with any UpdatePanel control, and the asynchronous postback does not result from a control that is not inside an UpdatePanel and is not a trigger. For example, the update is performed in code.

For making the ajax update progress to be working in the above senarion, follow as descibed below.

Underneath the "asp:ScriptManager" element, add the following script:
<script language="javascript" type="text/javascript"> <!-- var prm = Sys.WebForms.PageRequestManager.getInstance(); prm.add_initializeRequest(InitializeRequest); prm.add_endRequest(EndRequest); var postBackElement; function InitializeRequest(sender, args) { if (prm.get_isInAsyncPostBack()) { args.set_cancel(true); } postBackElement = args.get_postBackElement(); if (postBackElement.id == 'Button1') { $get('UpdateProgress1').style.display = 'block'; } } function EndRequest(sender, args) { if (postBackElement.id == 'Button1') { $get('UpdateProgress1').style.display = 'none'; } } // --> </script>
Replace 'UpdateProgress1' with your Udateprogressbar id and replace 'Button1' with your trigering control id.


More info can be found at
http://www.asp.net/AJAX/Documentation/Live/tutorials/ProgrammingUpdateProgress.aspx

Can view in SQL server 2005 be updated,inserted or deleted

Updatable Views
You can modify the data of an underlying base table through a view, as long as the following conditions are true:

Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table.
The columns being modified in the view must directly reference the underlying data in the table columns. The columns cannot be derived in any other way, such as through the following:
An aggregate function: AVG, COUNT, SUM, MIN, MAX, GROUPING, STDEV, STDEVP, VAR, and VARP.
A computation. The column cannot be computed from an expression that uses other columns. Columns that are formed by using the set operators UNION, UNION ALL, CROSSJOIN, EXCEPT, and INTERSECT amount to a computation and are also not updatable.
The columns being modified are not affected by GROUP BY, HAVING, or DISTINCT clauses.
TOP is not used anywhere in the select_statement of the view together with the WITH CHECK OPTION clause.
The previous restrictions apply to any subqueries in the FROM clause of the view, just as they apply to the view itself. Generally, the Database Engine must be able to unambiguously trace modifications from the view definition to one base table. For more information, see Modifying Data Through a View.

If the previous restrictions prevent you from modifying data directly through a view, consider the following options:

INSTEAD OF Triggers
INSTEAD OF triggers can be created on a view to make a view updatable. The INSTEAD OF trigger is executed instead of the data modification statement on which the trigger is defined. This trigger lets the user specify the set of actions that must happen to process the data modification statement. Therefore, if an INSTEAD OF trigger exists for a view on a specific data modification statement (INSERT, UPDATE, or DELETE), the corresponding view is updatable through that statement. For more information about INSTEAD OF triggers, see Designing INSTEAD OF Triggers.
Partitioned Views
If the view is a partitioned view, the view is updatable, subject to certain restrictions. When it is needed, the Database Engine distinguishes local partitioned views as the views in which all participating tables and the view are on the same instance of SQL Server, and distributed partitioned views as the views in which at least one of the tables in the view resides on a different or remote server.
For more information about partitioned views, see Creating Partitioned Views.