tag:blogger.com,1999:blog-32772991721830486112024-03-14T20:26:15.627+05:30Web DevelopmentProgramming Codes in Asp.Net, C#, Visual Basic, Java Script, HTML, Ajax, Sql Server, Reporting for Developing Web Applications & WebSites in Microsoft Technologies .adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.comBlogger89125tag:blogger.com,1999:blog-3277299172183048611.post-73003063540583219022013-06-15T18:07:00.002+05:302013-06-15T18:07:30.986+05:30Complete Lifecycle of an ASP.Net page and controls<div dir="ltr" style="text-align: left;" trbidi="on">
<h1>
Complete Lifecycle of an ASP.Net page and controls</h1>
<br />Many people have blogged about the lifecycle of an ASP.Net Page or Master Page
but every time I need to find the complete lifecycle of a control it’s
not so easy. Today I wrote a couple of test pages to generate a
reference.<br />
The pages are very simple, I just overrode every method I could find
and wrote to the trace. For completeness when the method called its base
I wrapped it with “Start MethodName” and “End MethodName” (if you look
at the trace outputs below you will see why). I did this for the Master
Page (.master), Page (.aspx), User Control (.ascx) and Web Control
(.cs), the page structre was simple:<br />
<ul>
<li>Master Page
<ul>
<li>Page
<ul>
<li>User Control
</li>
<li>Web Control </li>
</ul>
</li>
</ul>
</li>
</ul>
For clarity I’ve split the produced trace into 5 individual reference sections:<br />
<h2 id="mp">
ASP.Net 2.0 Master Page Life Cycle</h2>
<ul class="mp">
<li class="alt">Start Construct()
</li>
<li>End Construct()
</li>
<li class="alt">Start FrameworkInitialize()
</li>
<li>End FrameworkInitialize()
</li>
<li class="alt">Start AddParsedSubObject(object obj)
<ul>
<li>CreateControlCollection()
</li>
<li class="alt">Start AddedControl(Control control, int index)
</li>
<li>End AddedControl(Control control, int index) </li>
</ul>
</li>
<li class="alt">End AddParsedSubObject(object obj)
</li>
<li>Start AddParsedSubObject(object obj)
<ul>
<li class="alt">Start AddedControl(Control control, int index)
</li>
<li>End AddedControl(Control control, int index) </li>
</ul>
</li>
<li class="alt">End AddParsedSubObject(object obj)
</li>
<li>Start AddParsedSubObject(object obj)
<ul>
<li class="alt">Start AddedControl(Control control, int index)
</li>
<li>End AddedControl(Control control, int index) </li>
</ul>
</li>
<li class="alt">End AddParsedSubObject(object obj)
</li>
<li>Start AddParsedSubObject(object obj)
<ul>
<li class="alt">Start AddedControl(Control control, int index)
</li>
<li>End AddedControl(Control control, int index) </li>
</ul>
</li>
<li class="alt">End AddParsedSubObject(object obj)
</li>
<li>Start AddParsedSubObject(object obj)
<ul>
<li class="alt">Start AddedControl(Control control, int index)
</li>
<li>End AddedControl(Control control, int index) </li>
</ul>
</li>
<li class="alt">End AddParsedSubObject(object obj)
</li>
<li>ResolveAdapter()
</li>
<li class="alt">Start OnInit(EventArgs e)
</li>
<li>End OnInit(EventArgs e)
</li>
<li class="alt">Start TrackViewState()
</li>
<li>End TrackViewState()
</li>
<li class="alt">Start OnLoad(EventArgs e)
<ul>
<li>Page_Load(object sender, EventArgs e) </li>
</ul>
</li>
<li class="alt">End OnLoad(EventArgs e)
</li>
<li>Start EnsureChildControls()
<ul>
<li class="alt">ResolveAdapter()
</li>
<li>Start CreateChildControls()
</li>
<li class="alt">End CreateChildControls() </li>
</ul>
</li>
<li>End EnsureChildControls()
</li>
<li class="alt">Start OnPreRender(EventArgs e)
</li>
<li>End OnPreRender(EventArgs e)
</li>
<li class="alt">SaveViewState()
</li>
<li>SaveViewState()
</li>
<li class="alt">HasControls()
</li>
<li>Start RenderControl(HtmlTextWriter writer)
<ul>
<li class="alt">Start Render(HtmlTextWriter writer)
<ul>
<li>Start RenderChildren(HtmlTextWriter writer)
</li>
<li class="alt">End RenderChildren(HtmlTextWriter writer) </li>
</ul>
</li>
<li>End Render(HtmlTextWriter writer) </li>
</ul>
</li>
<li class="alt">End RenderControl(HtmlTextWriter writer) </li>
</ul>
<h2 id="pg">
ASP.Net 2.0 Page Life Cycle</h2>
<ul class="pg">
<li class="alt">ResolveAdapter()
</li>
<li>DeterminePostBackMode()
</li>
<li class="alt">Begin PreInit
<ul>
<li>Start OnPreInit(EventArgs e)
</li>
<li class="alt">End OnPreInit(EventArgs e)
</li>
<li>HasControls()
</li>
<li class="alt">Start RemovedControl(Control control)
</li>
<li>End RemovedControl(Control control)
</li>
<li class="alt">ResolveAdapter()
</li>
<li>Start AddedControl(Control control, int index)
</li>
<li class="alt">End AddedControl(Control control, int index) </li>
</ul>
</li>
<li>End PreInit
</li>
<li class="alt">Begin Init
<ul>
<li>ResolveAdapter()
</li>
<li class="alt">Start OnInit(EventArgs e)
</li>
<li>End OnInit(EventArgs e)
</li>
<li class="alt">Start TrackViewState()
</li>
<li>End TrackViewState() </li>
</ul>
</li>
<li class="alt">End Init
</li>
<li>Begin InitComplete
<ul>
<li class="alt">Start OnInitComplete(EventArgs e)
</li>
<li>End OnInitComplete(EventArgs e) </li>
</ul>
</li>
<li class="alt">End InitComplete
</li>
<li>Begin PreLoad
<ul>
<li class="alt">Start OnPreLoad(EventArgs e)
</li>
<li>End OnPreLoad(EventArgs e) </li>
</ul>
</li>
<li class="alt">End PreLoad
</li>
<li>Begin Load
<ul>
<li class="alt">Start OnLoad(EventArgs e)
<ul>
<li>Page_Load(object sender, EventArgs e) </li>
</ul>
</li>
<li class="alt">End OnLoad(EventArgs e) </li>
</ul>
</li>
<li>End Load
</li>
<li class="alt">Begin LoadComplete
<ul>
<li>Start OnLoadComplete(EventArgs e)
</li>
<li class="alt">End OnLoadComplete(EventArgs e) </li>
</ul>
</li>
<li>End LoadComplete
</li>
<li class="alt">Begin PreRender
<ul>
<li>Start EnsureChildControls()
<ul>
<li class="alt">ResolveAdapter()
</li>
<li>Start CreateChildControls()
</li>
<li class="alt">End CreateChildControls() </li>
</ul>
</li>
<li>End EnsureChildControls()
</li>
<li class="alt">Start OnPreRender(EventArgs e)
</li>
<li>End OnPreRender(EventArgs e) </li>
</ul>
</li>
<li class="alt">End PreRender
</li>
<li>Begin PreRenderComplete
<ul>
<li class="alt">Start OnPreRenderComplete(EventArgs e)
</li>
<li>End OnPreRenderComplete(EventArgs e) </li>
</ul>
</li>
<li class="alt">End PreRenderComplete
</li>
<li>SaveViewState()
</li>
<li class="alt">Begin SaveState
<ul>
<li>SaveViewState()
</li>
<li class="alt">HasControls()
</li>
<li>Start SavePageStateToPersistenceMedium(object state)
<ul>
<li class="alt">ResolveAdapter() </li>
</ul>
</li>
<li>End SavePageStateToPersistenceMedium(object state) </li>
</ul>
</li>
<li class="alt">End SaveState
</li>
<li>Begin SaveStateComplete
<ul>
<li class="alt">Start OnSaveStateComplete(EventArgs e)
</li>
<li>End OnSaveStateComplete(EventArgs e) </li>
</ul>
</li>
<li class="alt">End SaveStateComplete
</li>
<li>Begin Render
<ul>
<li class="alt">CreateHtmlTextWriter(System.IO.TextWriter tw)
</li>
<li>Start RenderControl(HtmlTextWriter writer)
<ul>
<li class="alt">Start Render(HtmlTextWriter writer)
<ul>
<li>Start RenderChildren(HtmlTextWriter writer)
</li>
<li class="alt">End RenderChildren(HtmlTextWriter writer) </li>
</ul>
</li>
<li>End Render(HtmlTextWriter writer) </li>
</ul>
</li>
<li class="alt">End RenderControl(HtmlTextWriter writer) </li>
</ul>
</li>
<li>End Render
</li>
<li class="alt">CreateHtmlTextWriter(System.IO.TextWriter tw) </li>
</ul>
<h2 id="uc">
ASP.Net 2.0 User Control Life Cycle</h2>
<ul class="uc">
<li class="alt">Start Construct()
</li>
<li>End Construct()
</li>
<li class="alt">Start FrameworkInitialize()
</li>
<li>End FrameworkInitialize()
</li>
<li class="alt">ResolveAdapter()
</li>
<li>Start OnInit(EventArgs e)
</li>
<li class="alt">End OnInit(EventArgs e)
</li>
<li>Start TrackViewState()
</li>
<li class="alt">End TrackViewState()
</li>
<li>Start OnLoad(EventArgs e)
<ul>
<li class="alt">Page_Load(object sender, EventArgs e) </li>
</ul>
</li>
<li>End OnLoad(EventArgs e)
</li>
<li class="alt">Start EnsureChildControls()
<ul>
<li>ResolveAdapter()
</li>
<li class="alt">Start CreateChildControls()
</li>
<li>End CreateChildControls() </li>
</ul>
</li>
<li class="alt">End EnsureChildControls()
</li>
<li>Start OnPreRender(EventArgs e)
</li>
<li class="alt">End OnPreRender(EventArgs e)
</li>
<li>SaveViewState()
</li>
<li class="alt">SaveViewState()
</li>
<li>HasControls()
</li>
<li class="alt">Start RenderControl(HtmlTextWriter writer)
<ul>
<li>Start Render(HtmlTextWriter writer)
<ul>
<li class="alt">Start RenderChildren(HtmlTextWriter writer)
</li>
<li>End RenderChildren(HtmlTextWriter writer) </li>
</ul>
</li>
<li class="alt">End Render(HtmlTextWriter writer) </li>
</ul>
</li>
<li>End RenderControl(HtmlTextWriter writer) </li>
</ul>
<h2 id="cc">
ASP.Net 2.0 Web Control Life Cycle</h2>
<ul class="cc">
<li class="alt">Constructor Test()
</li>
<li>Start ApplyStyleSheetSkin(Page page)
</li>
<li class="alt">End ApplyStyleSheetSkin(Page page)
</li>
<li>ResolveAdapter()
</li>
<li class="alt">Start OnInit(EventArgs e)
</li>
<li>End OnInit(EventArgs e)
</li>
<li class="alt">Start TrackViewState()
</li>
<li>End TrackViewState()
</li>
<li class="alt">Start OnLoad(EventArgs e)
</li>
<li>End OnLoad(EventArgs e)
</li>
<li class="alt">Start EnsureChildControls()
<ul>
<li>ResolveAdapter()
</li>
<li class="alt">Start CreateChildControls()
</li>
<li>End CreateChildControls() </li>
</ul>
</li>
<li class="alt">End EnsureChildControls()
</li>
<li>Start OnPreRender(EventArgs e)
</li>
<li class="alt">End OnPreRender(EventArgs e)
</li>
<li>SaveViewState()
</li>
<li class="alt">SaveViewState()
</li>
<li>HasControls()
</li>
<li class="alt">Start RenderControl(HtmlTextWriter writer)
<ul>
<li>Start Render(HtmlTextWriter writer)
<ul>
<li class="alt">Start RenderBeginTag(HtmlTextWriter writer)
<ul>
<li>Start AddAttributesToRender(HtmlTextWriter writer)
</li>
<li class="alt">End AddAttributesToRender(HtmlTextWriter writer) </li>
</ul>
</li>
<li>End RenderBeginTag(HtmlTextWriter writer) </li>
</ul>
</li>
<li class="alt">Start RenderContents(HtmlTextWriter writer)
<ul>
<li>Start RenderChildren(HtmlTextWriter writer)
</li>
<li class="alt">End RenderChildren(HtmlTextWriter writer) </li>
</ul>
</li>
<li>End RenderContents(HtmlTextWriter writer)
</li>
<li class="alt">Start RenderEndTag(HtmlTextWriter writer)
</li>
<li>End RenderEndTag(HtmlTextWriter writer)
</li>
<li class="alt">End Render(HtmlTextWriter writer) </li>
</ul>
</li>
<li class="alt">End RenderControl(HtmlTextWriter writer) </li>
</ul>
<table border="0" cellpadding="0" cellspacing="0"><tbody>
<tr>
<th align="left" class="alt" colspan="2">
<h3 id="comp">
<b>Complete Trace</b></h3>
</th></tr>
<tr align="left" class="subhead">
<th>Category</th>
<th>Message</th></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">ResolveAdapter()</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">DeterminePostBackMode()</td></tr>
<tr>
<td>aspx.page</td>
<td>Begin PreInit</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start OnPreInit(EventArgs e)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End OnPreInit(EventArgs e)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start Construct()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End Construct()</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">HasControls()</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Start RemovedControl(Control control)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">End RemovedControl(Control control)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start FrameworkInitialize()</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End FrameworkInitialize()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start AddParsedSubObject(object obj)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">CreateControlCollection()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start AddedControl(Control control, int index)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End AddedControl(Control control, int index)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End AddParsedSubObject(object obj)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start AddParsedSubObject(object obj)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start AddedControl(Control control, int index)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">ResolveAdapter()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End AddedControl(Control control, int index)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End AddParsedSubObject(object obj)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start AddParsedSubObject(object obj)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start AddedControl(Control control, int index)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End AddedControl(Control control, int index)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End AddParsedSubObject(object obj)</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Start Construct()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">End Construct()</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Start FrameworkInitialize()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">End FrameworkInitialize()</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">Constructor Test()</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">Start ApplyStyleSheetSkin(Page page)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">End ApplyStyleSheetSkin(Page page)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start AddParsedSubObject(object obj)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start AddedControl(Control control, int index)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End AddedControl(Control control, int index)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End AddParsedSubObject(object obj)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start AddParsedSubObject(object obj)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start AddedControl(Control control, int index)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End AddedControl(Control control, int index)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End AddParsedSubObject(object obj)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start AddedControl(Control control, int index)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End AddedControl(Control control, int index)</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>End PreInit</td></tr>
<tr>
<td>aspx.page</td>
<td>Begin Init</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">ResolveAdapter()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">ResolveAdapter()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">ResolveAdapter()</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Start OnInit(EventArgs e)</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">End OnInit(EventArgs e)</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Start TrackViewState()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">End TrackViewState()</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">ResolveAdapter()</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">Start OnInit(EventArgs e)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">End OnInit(EventArgs e)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">Start TrackViewState()</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">End TrackViewState()</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start OnInit(EventArgs e)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End OnInit(EventArgs e)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start TrackViewState()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End TrackViewState()</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start OnInit(EventArgs e)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End OnInit(EventArgs e)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start TrackViewState()</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End TrackViewState()</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>End Init</td></tr>
<tr>
<td>aspx.page</td>
<td>Begin InitComplete</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start OnInitComplete(EventArgs e)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End OnInitComplete(EventArgs e)</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>End InitComplete</td></tr>
<tr>
<td>aspx.page</td>
<td>Begin PreLoad</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start OnPreLoad(EventArgs e)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End OnPreLoad(EventArgs e)</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>End PreLoad</td></tr>
<tr>
<td>aspx.page</td>
<td>Begin Load</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start OnLoad(EventArgs e)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Page_Load(object sender, EventArgs e)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">End OnLoad(EventArgs e)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start OnLoad(EventArgs e)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Page_Load(object sender, EventArgs e)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End OnLoad(EventArgs e)</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">Start OnLoad(EventArgs e)</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Page_Load(object sender, EventArgs e)</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">End OnLoad(EventArgs e)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">Start OnLoad(EventArgs e)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">End OnLoad(EventArgs e)</td></tr>
<tr>
<td>aspx.page</td>
<td>End Load</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>Begin LoadComplete</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Start OnLoadComplete(EventArgs e)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">End OnLoadComplete(EventArgs e)</td></tr>
<tr>
<td>aspx.page</td>
<td>End LoadComplete</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>Begin PreRender</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Start EnsureChildControls()</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">ResolveAdapter()</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Start CreateChildControls()</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">End CreateChildControls()</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End EnsureChildControls()</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start OnPreRender(EventArgs e)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End OnPreRender(EventArgs e)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start EnsureChildControls()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">ResolveAdapter()</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start CreateChildControls()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End CreateChildControls()</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End EnsureChildControls()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start OnPreRender(EventArgs e)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End OnPreRender(EventArgs e)</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Start EnsureChildControls()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">ResolveAdapter()</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Start CreateChildControls()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">End CreateChildControls()</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">End EnsureChildControls()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">Start OnPreRender(EventArgs e)</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">End OnPreRender(EventArgs e)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">Start EnsureChildControls()</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">ResolveAdapter()</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">Start CreateChildControls()</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">End CreateChildControls()</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">End EnsureChildControls()</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">Start OnPreRender(EventArgs e)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">End OnPreRender(EventArgs e)</td></tr>
<tr>
<td>aspx.page</td>
<td>End PreRender</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>Begin PreRenderComplete</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Start OnPreRenderComplete(EventArgs e)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">End OnPreRenderComplete(EventArgs e)</td></tr>
<tr>
<td>aspx.page</td>
<td>End PreRenderComplete</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">SaveViewState()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">SaveViewState()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">SaveViewState()</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">SaveViewState()</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>Begin SaveState</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">SaveViewState()</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">HasControls()</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">SaveViewState()</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">HasControls()</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">SaveViewState()</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">HasControls()</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">SaveViewState()</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">HasControls()</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Start SavePageStateToPersistenceMedium(object state)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">ResolveAdapter()</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End SavePageStateToPersistenceMedium(object state)</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>End SaveState</td></tr>
<tr>
<td>aspx.page</td>
<td>Begin SaveStateComplete</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start OnSaveStateComplete(EventArgs e)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End OnSaveStateComplete(EventArgs e)</td></tr>
<tr class="alt">
<td>aspx.page</td>
<td>End SaveStateComplete</td></tr>
<tr>
<td>aspx.page</td>
<td>Begin Render</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">CreateHtmlTextWriter(System.IO.TextWriter tw)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Start RenderControl(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">Start Render(HtmlTextWriter writer)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">Start RenderChildren(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start RenderControl(HtmlTextWriter writer)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">Start Render(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">Start RenderChildren(HtmlTextWriter writer)</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Start RenderControl(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">Start Render(HtmlTextWriter writer)</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">Start RenderChildren(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">End RenderChildren(HtmlTextWriter writer)</td></tr>
<tr>
<td class="uc">UserControl</td>
<td class="uc">End Render(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="uc">UserControl</td>
<td class="uc">End RenderControl(HtmlTextWriter writer)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">Start RenderControl(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">Start Render(HtmlTextWriter writer)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">Start RenderBeginTag(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">Start AddAttributesToRender(HtmlTextWriter writer)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">End AddAttributesToRender(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">End RenderBeginTag(HtmlTextWriter writer)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">Start RenderContents(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">Start RenderChildren(HtmlTextWriter writer)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">End RenderChildren(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">End RenderContents(HtmlTextWriter writer)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">Start RenderEndTag(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">End RenderEndTag(HtmlTextWriter writer)</td></tr>
<tr>
<td class="cc">CustomWebControl</td>
<td class="cc">End Render(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="cc">CustomWebControl</td>
<td class="cc">End RenderControl(HtmlTextWriter writer)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End RenderChildren(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="mp">MasterPage</td>
<td class="mp">End Render(HtmlTextWriter writer)</td></tr>
<tr>
<td class="mp">MasterPage</td>
<td class="mp">End RenderControl(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">End RenderChildren(HtmlTextWriter writer)</td></tr>
<tr>
<td class="pg">Page</td>
<td class="pg">End Render(HtmlTextWriter writer)</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">End RenderControl(HtmlTextWriter writer)</td></tr>
<tr>
<td>aspx.page</td>
<td>End Render</td></tr>
<tr class="alt">
<td class="pg">Page</td>
<td class="pg">CreateHtmlTextWriter(System.IO.TextWriter tw)</td><td class="pg"> </td><td class="pg"><a href="http://blogs.thesitedoctor.co.uk/tim/2006/06/30/Complete+Lifecycle+Of+An+ASPNet+Page+And+Controls.aspx" target="_blank">Ref.</a> </td></tr>
</tbody></table>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-24765624858518312402013-05-06T15:15:00.000+05:302013-05-06T15:17:24.995+05:30Add selected Rows into Datatable from DataSet<div dir="ltr" style="text-align: left;" trbidi="on">
<pre class="prettyprint linenums"> DataSet ds = new DataSet();
ds = (DataSet)Session["dsFocusArea"];
DataTable dt = ds.Tables[1].Clone();
foreach (DataRow row in ds.Tables[1].Select("unitid = " + TextBox1.Text + ""))
{
dt.Rows.Add(row.ItemArray);
}</pre>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0Gautam Buddh Nagar, Uttar Pradesh, India28.509729126769052 77.415161132812528.286493626769051 77.0924376328125 28.732964626769053 77.7378846328125tag:blogger.com,1999:blog-3277299172183048611.post-67931452872013974712013-03-12T14:41:00.001+05:302013-03-12T14:44:24.347+05:30Embedded Code and Inline Server Tags<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="pageTitle">
Embedded Code and Inline Server Tags</h2>
<span style="color: #009900; font-size: small;"><b>Introductions</b></span><br />
<div dir="ltr">
Hi, I hope it will be more
useful , so we will talk about something we need to use every day in
coding ,we will talk about "Embedded Code " using "In line Server Tags "
. Briefly it used to write server side code somewhere where it not
allowed directly . more developers use it in data binding controls .but
you can use it in many Places Like (Java Script , CSS , ASPX ) , and you
can use it with Routing ,ConnectionStrings , XMLQuery , AppSettings ,
Recourses Files or just writing server side code mixed with html. my be
you had seen it in the top of .aspx page .OK ! Let us begin .</div>
<div dir="ltr">
<a href="http://cid-c5b18a9758861597.office.live.com/self.aspx/My%20Bolgs/embedded%5E_Code.zip"><span style="color: blue;"><b>Download sample Code from Here </b></span></a></div>
<div dir="ltr">
<span style="color: #00cc00;"><b>What In line Server Code is ?</b></span></div>
<div dir="ltr">
inline server code enables you to embedded server side code
mixed with client script like javascript or mixed with aspx or with css
as we mentioned before. </div>
<div dir="ltr">
<span style="color: #00cc00;"><b>What Is In line Server Tags ? </b></span></div>
<div dir="ltr">
Look at this : </div>
<div dir="ltr">
<span style="background-color: #ccff99;"><span style="background-color: yellow;"><%</span> <span style="color: yellow;"> </span></span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
these tags what we talk about. It comes from ASP classic
style and it used in PHP and JSP too for the same reason "Writing Server
Side Code ".</div>
<div dir="ltr">
Note: you must know that we can't use it in code behind (Page.aspx.cs ) .</div>
<div dir="ltr">
<span style="color: #00cc00;"><b>inline Code and Page Life cycle :</b></span></div>
<div dir="ltr">
When the page call its Render Method after the
PreRenderComplete Event completed the compiler will Execute this Code
and embedded it into Render method which accept HtmlTextWriter as a
single parameter like the following :</div>
<div dir="ltr">
protected override void Render(HtmlTextWriter writer)<br />
{<br />
base.Render(writer);<br />
}</div>
<div dir="ltr">
Let us see the forms you may have seen:</div>
<div dir="ltr">
<b><span style="color: #00cc00;"> Page Directive </span></b></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Page Language="C#" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<b><span style="color: #00cc00;">Rendering Code</span></b></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span> Response.Write("Hello World!"); <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>= SayHello("Ahmed")<span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>: DateTime.Now.ToString() <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="color: #00cc00;"><b>Expression Syntax </b></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ ConnectionStrings:ConnStrFromWebConfig <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ AppSettings:ValueFromWebConfig <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ Resources:Resource, Arabic <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ RouteValue:year <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ YourExpressionPrefix : Any <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="color: #00cc00;"><b>Data Binding Syntax </b></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># Eval("Name") <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># Bind("Name") <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># XPath ("Name") <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<b><span style="color: #00cc00;">Comment Server </span></b></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>-- <asp:Label runat="server" Text="Label"></asp:Label>--<span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
Let us do it in details : </div>
<div dir="ltr">
<b><span style="color: #00cc00; font-size: small;"><span style="color: #009900;">Directive</span> </span></b></div>
<div dir="ltr">
We use directive to specify settings used by page and user
control Compiler . we use it to say hi complier this file is ......
.each directive can have number of attributes as you need.</div>
<div dir="ltr">
each directive start with @ . ASP.Net introduced number of Directive as following :<br />
<span style="color: #3333cc;"><span style="color: black;"><br /></span>@Page</span> : used on .aspx files only and you can use only one directive inside a file .<br />
<span style="background-color: yellow;"><br /><%</span>@ Page Language="C#" <span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Page Language="C#" CodeFile="Default2.aspx.cs" Inherits="Default2" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
Note that we are using <b>Codefile</b> to pass the file name of code behind and <b>inherits</b> to pass class Name.</div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@Control </span>: used only in .ascx files (user control)</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Control Language="C#" ClassName="WebUserControl" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@Import</span> : used for name space
declaration and only when we write code inside script tags,I mean that
if we use code behind we don't need it because we will use "Using
Directive" (C#) or " Imports " (VB.net)</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Import Namespace="System.Data" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@Assembly</span> : used to Links an Assembly(.DLL or .CS and .VB ) to that page and user control .</div>
<div dir="ltr">
DLL files like this </div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Assembly Name="CustomFile" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
(without .dll extension )</div>
<div dir="ltr">
Class files like this :</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Assembly src="Csharp.cs" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Assembly src="Csharp.vb" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
Note: we are using <b>Name</b> attribute with dll files and <b>src</b> with class files.</div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@Register</span> : used to register Controls (User Controls and Custom Server Controls) to page and user control.</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Register src="WebUserControl.ascx" tagname="WebUserControl" tagprefix="uc1" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
Note :we are using <b>Name</b> attribute when using assembly and using <b>src</b> when user control.</div>
<div dir="ltr">
<span style="color: blue;">@Implements</span> : used when we want to implement an Interface . and this Directive takes only one attribute "Interface" .</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Implements Interface="IWebParts" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@Reference</span> : used to indicate
that the source file of the page or user control should dynamically
compiled and linked to the current page .</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Reference Control ="~/WebUserControl.ascx" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Reference Page="~/Default2.aspx" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Reference VirtualPath ="anyfile.any" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@OutPutCache :</span> used when we need to put a page or user control in the cache.</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ OutputCache Duration ="900" VaryByParam ="none" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
Note: both attributes ( Duration and VarybyParam ) are required .</div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@Master</span> : used to decalre page as Master page.</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Master Language="C#" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@MasterType</span> : used to reference Master Page when we need to access master page through Master Property .</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ MasterType VirtualPath ="~/MasterPage.master" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: blue;">@PreviousPage</span> : used when need to access previous page through PreviousPage Property .</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ PreviousPageType VirtualPath ="~/Default4.aspx" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: #0000cc;">@Application</span> : used to declare the global application file .(global.asax)</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Application Language="C#" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: #0000cc;">@WebService</span> : used to declare the web service file .(.asmx)</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ WebService Language="C#" CodeBehind="~/App_Code/WebService.cs" Class="WebService" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: #0000cc;">@WebHandler</span>: used to declare the generic handler file (.ashx)</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ WebHandler Language="C#" Class="Handler" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: #0000cc;">@ServiceHost</span> : used by WCF (Windows Communication Foundation) .</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ ServiceHost Language="C#" Debug="true" Service="Service" CodeBehind="~/App_Code/Service.cs" <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
<span style="color: #009900; font-size: small;"><b>Rendering Code</b></span></div>
<div dir="ltr">
Render code tags like Response.write Method. Here an example : using for Looping </div>
<div dir="ltr">
<div></div>
<div dir="ltr">
<span style="background-color: yellow;"> <%</span> for(int i = 0 ; i <5; i++){ <span style="background-color: yellow;"> %></span></div>
<div dir="ltr">
Hello World ! <br /></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span> } <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
</div></div>
<div dir="ltr">
<b>output the following :</b></div>
<div dir="ltr">
Hello World ! </div>
<div dir="ltr">
Hello World ! </div>
<div dir="ltr">
Hello World ! </div>
<div dir="ltr">
Hello World ! </div>
<div dir="ltr">
Hello World !</div>
<div dir="ltr">
you can use it to execute a method but this time we use " =
" to get out of Response.write to an Expression and = is used to
resolve an expression and return its value to the block</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Page Language="C#" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<script runat="server"></div>
<div dir="ltr">
string message = "I Can Do it ";</div>
<div dir="ltr">
<br />
string SayHello(string name)<br />
{<br />
return "Hello " + name;<br />
} </div>
<div dir="ltr">
</script></div>
<div dir="ltr">
<html xmlns="http://www.w3.org/1999/xhtml"></div>
<div dir="ltr">
<head runat="server"></div>
<div dir="ltr">
<title>Test Page </title></div>
<div dir="ltr">
</head></div>
<div dir="ltr">
<body></div>
<div dir="ltr">
<form id="form1" runat="server"></div>
<div dir="ltr">
<div><br />
<span style="background-color: yellow;"> <%</span>= SayHello("Ahmed") <span style="background-color: yellow;">%></span> <br /><br />
<br /><br />
<span style="background-color: yellow;"> <%=</span>"Message variable = " + message <span style="background-color: yellow;">%></span> </div><br />
</form><br />
</body><br />
</html></div>
<div dir="ltr">
it will output string say "Hello Ahmed " and also gets the value of message variable .</div>
<div dir="ltr">
Note : this code blocks render nothing (no html controls ) .
try it yourself . browse this code in the browser and Right click to
View source .</div>
<div dir="ltr">
<a href="http://weblogs.asp.net/scottgu/archive/2010/04/06/new-lt-gt-syntax-for-html-encoding-output-in-asp-net-4-and-asp-net-mvc-2.aspx"><span style="color: blue;">Html Encoding output in ASP.Net 4</span></a></div>
<div dir="ltr">
It provides a concise way to automatically HTML encode content and then render it as output</div>
<div dir="ltr">
<span style="background-color: yellow;"> <%:</span>DateTime.Now.ToString () <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
You can learn more <a href="http://weblogs.asp.net/scottgu/archive/2010/04/06/new-lt-gt-syntax-for-html-encoding-output-in-asp-net-4-and-asp-net-mvc-2.aspx">here</a> :</div>
<div dir="ltr">
<b><span style="color: blue;">we can also use it to embedded Server Side code in Client Side Code (Java Script) </span></b></div>
<div dir="ltr">
what about calling Server side Method from Client Side Method . Let us do it :</div>
<div dir="ltr">
take a look at this code </div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>@ Page Language="C#" <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span><script runat="server"><br />
string SayHello(string name)<br />
{<br />
return "Hello " + name;<br />
} <br />
</script></div>
<div dir="ltr">
<html xmlns="http://www.w3.org/1999/xhtml"></div>
<div dir="ltr">
<head runat="server"><br />
<title>Test Page </title><br />
<script type="text/javascript" ><br />
function SayAny() {<br />
alert(' <span style="background-color: yellow;"><%</span>= SayHello("ahmed")<span style="background-color: yellow;"> %></span>');<br />
}<br />
</script><br />
</head><br />
<body><br />
<form id="form1" runat="server"><br />
<div><br />
<br /><br />
<input type="submit" onclick="SayAny()" value="Say Hello" /><br />
<br /><br />
</div><br />
</form><br />
</body><br />
</html></div>
<div dir="ltr">
it do what you expect : showing alert message .<br />
<br />
Sometimes we have a problem when passig control id to client side code like this </div>
<div dir="ltr">
var txt = document.getElementById("TextBox1");</div>
<div dir="ltr">
and this happened when we work with container like master
page or when we want to find control inside Data contorls Like
GridView ,DataList ,Repeater ,and so on. this happens because the
control has been changed to something like "container_ControlId". and to
solve this issue we can use server side blocks like the following :</div>
<div dir="ltr">
var txt = document.getElementById("<span style="background-color: yellow;"><%</span>=TextBox1.ClientID <span style="background-color: yellow;">%></span>");</div>
<div dir="ltr">
you can use alert message to display the value of this TextBox like this : </div>
<div dir="ltr">
alert(txt.value);</div>
<div dir="ltr">
<b><span style="color: #009900; font-size: small;">Expression Syntax :</span></b></div>
<div dir="ltr">
<b><span style="color: blue;">Get Connection String Section :</span></b></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ ConnectionStrings:ConnStrFromWebConfig <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
after we set connection strings in web.config file then we need to use data source controls ,Like the following :</div>
<div dir="ltr">
<b>Example </b></div>
<div dir="ltr">
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" <br />
SelectCommand="SELECT * FROM [Categories]"><br />
</asp:SqlDataSource></div>
<div dir="ltr">
Notice: connectionstring is the name of connection string section inside Web.Config Like following : </div>
<div dir="ltr">
Web.config :<br />
<connectionStrings><br />
<add name="ConnectionString" <br />
connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;<br />
Integrated Security=True;User Instance=True"<br />
providerName = "System.Data.SqlClient" /><br />
</connectionStrings></div>
<div dir="ltr">
<b><span style="color: blue;">Get AppSettings Section </span></b><br />
<span style="background-color: yellow;"><%</span>$ AppSettings:ValueFromWebConfig <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
after we set AppSettings section in web.config file you can call it using key name to return its value .<br />
<br />
<b>Web.config </b><br />
<br />
<appSettings><br />
<add key ="KeyName" value ="This Value Is Ahmed"/><br />
</appSettings></div>
<div dir="ltr">
<b>Default.aspx</b> </div>
<div dir="ltr">
<asp:Label Text="<span style="background-color: yellow;"><%</span>$ AppSettings :Keyname <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span>" runat="server" /></div>
<div dir="ltr">
<b><span style="color: blue;">Get a value from Global Resource File (.resx )</span></b></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ Resources:Resource, Arabic <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
Let us take an example switching between two Language (Arabic and English ).</div>
<ul>
<li>Create two files (Resource.resx , Resource.ar-eg.resx ) and put them in App_GlobalResources folder.</li>
<li>Define a key with name "Greeting" in both resource files.</li>
</ul>
<div dir="ltr">
<b>Note</b> : the "greeting" key will have two different value for Arabic and English .</div>
<ul>
<li>Create test page.aspx and drag a label control and drop down list control. so ,your aspx code will be like this : </li>
</ul>
<div dir="ltr">
<div><br />
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"><br />
<asp:ListItem Value="ar-eg">Arabic</asp:ListItem><br />
<asp:ListItem Value="en-us">English</asp:ListItem><br />
</asp:DropDownList><br />
<br /><br />
<br /><br />
<asp:Label ID="Label1" runat="server" Text="<%$ Resources:Resource, Greeting %>"> </asp:Label> <br />
</div></div>
<div dir="ltr">
<b>Note :</b></div>
<div dir="ltr">
- <b>Resources</b> >> Say " I am working with resource files ".</div>
<div dir="ltr">
- <b>Resource</b> >> say "I am the resource file name without extension".</div>
<div dir="ltr">
- <b>Greeting</b> >> say " I am the Key which my value will be displayed"</div>
<div dir="ltr">
now we have two values for "Arabic" and "English" we can
switch between them. what will happen if we select English or Arabic ?
ok, we need some code to change Language and Current Culture .let us go
to next step:</div>
<ul>
<li>We need to override IntializeCulture Method as following :</li>
</ul>
<div dir="ltr">
protected override void InitializeCulture()<br />
{<br />
if (Request["DropDownlist1"] != null)<br />
{<br />
string lang = Request["DropDownlist1"];<br />
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo(lang );<br />
Thread.CurrentThread.CurrentUICulture = System.Globalization.CultureInfo.CreateSpecificCulture(lang );<br />
}<br />
}</div>
<div dir="ltr">
Now you can select your Language from drop down list control and see that the related content will be displayed.</div>
<div dir="ltr">
<b><span style="color: blue;">Routing </span></b></div>
<div dir="ltr">
ASP.Net Routing is something about mapping URLs, Routing is
available in ASP.Net web forms and ASP.Net MVC.Since .net framework
3.5. to use routing you need to create static method that take a
parameter of RouteCollection data type inside global.asax file, then
call these method in Application_Start event .</div>
<div dir="ltr">
May you need more in Routing so here you can take a look </div>
<div dir="ltr">
<a href="http://msdn.microsoft.com/en-us/library/dd329551.aspx">http://msdn.microsoft.com/en-us/library/dd329551.aspx</a></div>
<div dir="ltr">
Ok , what we want to say is we can use Expression Syntax to set URLs Like this : </div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ RouteUrl:action=Edit , CategoryName=Cars<span style="background-color: yellow;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ RouteValue:year <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
You need to understand what action and categoryName means? To do this refer to The above Link .</div>
<div dir="ltr">
<b><span style="color: blue;">Exrpression Builder</span></b></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>$ YourExpressionPrefix : Any <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: white;">yes , you can create your Expression like mine : </span><span style="color: blue; font-family: Consolas; font-size: large;"><span style="color: blue; font-family: Consolas; font-size: large;"><span style="color: blue; font-family: Consolas; font-size: large;"><span style="font-size: xx-small;"><</span></span></span></span><span style="font-size: xx-small;"><span style="color: maroon; font-family: Consolas;"><span style="color: maroon; font-family: Consolas;"><span style="color: maroon; font-family: Consolas;">div</span></span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">></span></span></span></span><span style="font-size: xx-small;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"> <</span></span></span><span style="color: maroon; font-family: Consolas;"><span style="color: maroon; font-family: Consolas;"><span style="color: maroon; font-family: Consolas;">asp</span></span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">:</span></span></span><span style="color: maroon; font-family: Consolas;"><span style="color: maroon; font-family: Consolas;"><span style="color: maroon; font-family: Consolas;">Label</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: red; font-family: Consolas;"><span style="color: red; font-family: Consolas;"><span style="color: red; font-family: Consolas;">Text</span></span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">="</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"><%</span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">$</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> myCode:DateTime.Now %></span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: red; font-family: Consolas;"><span style="color: red; font-family: Consolas;"><span style="color: red; font-family: Consolas;">runat</span></span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">="server"</span></span></span><span style="font-family: Consolas;"><span style="font-family: Consolas;"> </span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">/></span></span></span></span><span style="font-size: xx-small;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"></</span></span></span><span style="color: maroon; font-family: Consolas;"><span style="color: maroon; font-family: Consolas;"><span style="color: maroon; font-family: Consolas;">div</span></span></span><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;">></span></span></span></span><span style="font-size: xx-small;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><span style="color: blue; font-family: Consolas;"><br />to learn more about Expression Builder <a href="http://weblogs.asp.net/infinitiesloop/archive/2006/08/09/The-CodeExpressionBuilder.aspx">Click Here</a></span></span></span></span></div>
<b><span style="color: #00cc00;">Data Binding Syntax </span></b><br />
<div dir="ltr">
<span style="background-color: yellow;"><%</span># Eval("Name") <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># Bind("Name")<span style="background-color: yellow;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># XPath ("Name") <span style="background-color: yellow;">%> </span></div>
<div dir="ltr">
We use embedded code in Data binding to set or get or in
Other words to read and write to a data source .we have Two methods for
working with Data base (Eval and Bind ) and one for working with XML
(XPath that stand of xml path ) .so , what is the different between Eval
and bind ? Eval method is One way that means it is for reading and Bind
method is Two way that means it is for Reading and writing .</div>
<div dir="ltr">
Example : using eval method in grid view to display Images .</div>
<div dir="ltr">
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"></div>
<div dir="ltr">
<Columns></div>
<div dir="ltr">
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" /></div>
<div dir="ltr">
<asp:TemplateField></div>
<div dir="ltr">
<ItemTemplate></div>
<div dir="ltr">
<asp:Image ID="Image2" runat="server" ImageUrl='<span style="background-color: yellow;"><%</span># Eval("Path") <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span>' Width="70" /></div>
<div dir="ltr">
</ItemTemplate></div>
<div dir="ltr">
</asp:TemplateField></div>
<div dir="ltr">
</Columns></div>
<div dir="ltr">
</asp:GridView></div>
<div dir="ltr">
In the above example we use eval method to get path field from data base and pass It to ImageUrl Property.</div>
<div dir="ltr">
try to use bind method in editing data. </div>
<div dir="ltr">
<b>XPath method: </b></div>
<div dir="ltr">
Use it when working with Xml, we can use it to select
element or attribute and get its value and it comes in many forms Like
this : </div>
<div dir="ltr">
Look at this file.xml. we use it to simplifies the following :</div>
<div dir="ltr">
<?xml version="1.0" encoding="utf-8" ?><br />
<Links><br />
<Link><br />
<name>Microsoft</name><br />
<Site>http://www.microsoft.com</Site><br />
</Link><br />
<Link><br />
<name id="10" >Asp.net</name><br />
<Site>http://www.asp.net</Site><br />
</Link><br />
<Link><br />
<name id="20" >MSDN</name><br />
<Site>http://www.msdn.com</Site><br />
</Link><br />
</Links> </div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># XPath ("Name") <span style="background-color: yellow;">%></span> </div>
<div dir="ltr">
get the value of the Name element .</div>
<div dir="ltr">
output here will be as following : Microsot ASP.Net MSDN </div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># XPath("name[@id]") <span style="background-color: yellow;">%></span> </div>
<div dir="ltr">
Get the value of the name element which take an attribute with name "Id"</div>
<div dir="ltr">
output here will be as following : ASP.Net MSDN </div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># XPath ("name[@id=\"10\"]") <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
Get the value of name element which take an attribute with name id that its value equal 10 .</div>
<div dir="ltr">
<br /></div>
<div dir="ltr">
output here will be as following : ASP.Net </div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># XPath("name/@id") <span style="background-color: yellow;">%></span></div>
<div dir="ltr">
Get the value of Every attribute which its name is 'id' that was defined in "name" element .</div>
<div dir="ltr">
output here will be as following : 10 20 </div>
<div dir="ltr">
Yes, it is give xml more funs .</div>
<div dir="ltr">
Note :</div>
<div dir="ltr">
When using your custom method as Binding Expression
Remember to call Databind Method . this question I meet it in Asp.Net
forums and that is my answer "call Databind method to that control "</div>
<div dir="ltr">
Example : Get Text from the result of custom method .</div>
<div dir="ltr">
<div></div>
<div dir="ltr">
<asp:Button ID="SomethingBtn" Text="<span style="background-color: yellow;"><%</span># ServerSideMethod() <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span>" runat="server" /></div>
<div dir="ltr">
</div></div>
<div dir="ltr">
So when we try to view it in browser the button wouldn't
display any text . because we need to call Data bind method for that
button Like this : </div>
<div dir="ltr">
protected void Page_Load(object sender, EventArgs e)</div>
<div dir="ltr">
{</div>
<div dir="ltr">
Somethingbtn.DataBind();</div>
<div dir="ltr">
}</div>
<div dir="ltr">
And finally I want to say that you can use all or one of them Like this :</div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># Eval("Id","~/default.aspx?id={0}") <span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># "Your Name Is :" + Eval("Name")<span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span># SayHello( Eval("Name").ToString () )<span style="background-color: #ccff99; color: yellow;"> </span><span style="background-color: yellow; color: black;">%></span></div>
<div dir="ltr">
And More ........... </div>
<div dir="ltr">
Last thing is Comment Server </div>
<div dir="ltr">
We can use it to put a comment where the comment is not allowed .</div>
<div dir="ltr">
Example :</div>
<div dir="ltr">
<div></div>
<div dir="ltr">
<span style="background-color: yellow;"><%</span>-- <asp:Button ID="Button2" runat="server" Text="Button" />-<span style="background-color: yellow;">-%></span></div>
<div dir="ltr">
</div></div>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-40760639938841521292013-03-12T11:12:00.000+05:302013-03-12T11:12:05.842+05:30Transpose Row into Column in SQL Server 2008<div dir="ltr" style="text-align: left;" trbidi="on">
private DataTable GenerateTransposedTable(DataTable inputTable)<br /> {<br /> DataTable outputTable = new DataTable();<br /><br /> // Add columns by looping rows<br /><br /> // Header row's first column is same as in inputTable<br /> outputTable.Columns.Add(inputTable.Columns[0].ColumnName.ToString());<br /><br /> // Header row's second column onwards, 'inputTable's first column taken<br /> foreach (DataRow inRow in inputTable.Rows)<br /> {<br /> string newColName = inRow[0].ToString();<br /> outputTable.Columns.Add(newColName);<br /> }<br /><br /> // Add rows by looping columns <br /> for (int rCount = 1; rCount <= inputTable.Columns.Count - 1; rCount++)<br /> {<br /> DataRow newRow = outputTable.NewRow();<br /><br /> // First column is inputTable's Header row's second column<br /> newRow[0] = inputTable.Columns[rCount].ColumnName.ToString();<br /> for (int cCount = 0; cCount <= inputTable.Rows.Count - 1; cCount++)<br /> {<br /> string colValue = inputTable.Rows[cCount][rCount].ToString();<br /> newRow[cCount + 1] = colValue;<br /> }<br /> outputTable.Rows.Add(newRow);<br /> }<br /><br /> return outputTable;<br /> }</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-24063147435287638442013-03-01T15:47:00.003+05:302013-03-01T15:47:36.372+05:30CRYSTAL REPORT DESIGN CONCEPT <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="fauxcolumn-outer fauxcolumn-center-outer">
<div class="cap-top">
</div>
<div class="fauxborder-left">
<div class="fauxcolumn-inner">
</div>
</div>
<div class="cap-bottom">
</div>
</div>
<div class="fauxcolumn-outer fauxcolumn-left-outer">
<div class="cap-top">
</div>
<div class="fauxborder-left">
<div class="fauxcolumn-inner">
</div>
</div>
<div class="cap-bottom">
</div>
</div>
<div class="fauxcolumn-outer fauxcolumn-right-outer">
<div class="cap-top">
</div>
<div class="fauxborder-left">
<div class="fauxcolumn-inner">
</div>
</div>
<div class="cap-bottom">
</div>
</div>
<h2 class="date-header">
<span></span></h2>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="5931556631645324093"></a>
<h3 class="post-title entry-title" itemprop="name">
CRYSTAL REPORT DESIGN CONCEPT
</h3>
<div class="post-header">
</div>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="312369"></a><span style="font-family: "Verdana","sans-serif";">This
section describes the basic concepts of report design and helps you
decide what information you want to include in your report.<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="338541"></a></span><br />
<div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<b><span style="color: red; font-family: "Verdana","sans-serif"; font-size: 18.0pt;">Basic report design</span></b></div>
<div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292855"></a><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 12.0pt;">The
purpose of this section is to suggest a structured approach to
preparing a Crystal report. This approach includes the following
elements:</span></div>
<ul type="disc">
<li class="MsoNormal" style="color: black; mso-list: l10 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292857"></a><span style="font-family: "Verdana","sans-serif"; font-size: 12.0pt;">Deciding on the content of the report. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292858"></a></span></li>
<li class="MsoNormal" style="color: black; mso-list: l10 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif"; font-size: 12.0pt;">Developing a prototype on paper. </span></li>
</ul>
<div class="MsoNormal" style="mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292863"></a><span style="color: black; font-family: "Verdana","sans-serif"; font-size: 12.0pt;">This section has been designed to provide a conceptual understanding of the reporting process</span></div>
<h4>
<span style="font-family: "Verdana","sans-serif"; font-style: normal;">What is the overall purpose of the report?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="293128"></a><span style="font-family: "Verdana","sans-serif";">Reports
are management tools. Their purpose is to help you quickly grasp the
essential elements and relationships found in raw data, to help you make
effective decisions. For a report to be effective, it has to present
the correct data in a logical way. If it presents the wrong data, or if
it presents the right data in a haphazard manner, the report may slow
the decision-making process or may even encourage incorrect decisions.</span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14543"></a><span style="font-family: "Verdana","sans-serif";">A
good starting place in the development of a report is to write out the
purpose of the report in a sentence or two. The purpose statement helps
you focus on your primary needs, and it gives the report both a starting
point and a goal. </span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="300436"></a><span style="font-family: "Verdana","sans-serif";">Here are some examples of purpose statements.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l2 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14544"></a><span style="font-family: "Verdana","sans-serif";">The
purpose of this report is to show monthly and year-to-date sales
by sales representatives, compare this year's numbers to last
year's, and flag representatives whose sales figures do not meet
company standards. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14545"></a></span></li>
<li class="MsoNormal" style="mso-list: l2 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">The
purpose of this report is to show sales activity for each item in
inventory, and to suggest reorder quantities based on that
activity. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14546"></a></span></li>
<li class="MsoNormal" style="mso-list: l2 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">The purpose of this report is to calculate bowling averages and handicaps for each member of the bowling league. </span></li>
</ul>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14547"></a><span style="font-family: "Verdana","sans-serif";">Defining the purpose of the report before you start is a critical step in the overall process.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291135"></a><span style="font-family: "Verdana","sans-serif"; font-style: normal;">Who is going to read the report?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14551"></a><span style="font-family: "Verdana","sans-serif";">A
single report is often used by many individuals. A detailed,
company-wide sales report, for example, may be used by sales
representatives, the regional sales manager, the national sales manager,
and the Chief Operating Officer (COO).</span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14552"></a><span style="font-family: "Verdana","sans-serif";">These individuals will be interested in different aspects of the report:</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l12 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14553"></a><span style="font-family: "Verdana","sans-serif";">A
sales representative will use the report to evaluate individual
sales performance and compare this performance to that of other
representatives in the region. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14554"></a></span></li>
<li class="MsoNormal" style="mso-list: l12 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">The
regional sales manager will use the report to evaluate regional
representatives and compare the region's performance to that of other
regions. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14555"></a></span></li>
<li class="MsoNormal" style="mso-list: l12 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">The
national sales manager will use the report to evaluate the
performance of regional managers and compare overall sales to the
current sales forecasts. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14556"></a></span></li>
<li class="MsoNormal" style="mso-list: l12 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">The
COO will use the report to evaluate the performance of the
Vice-President of Marketing and the sales department as a whole,
and to project such things as manufacturing needs and warehouse
locations. </span></li>
</ul>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="155718"></a><span style="font-family: "Verdana","sans-serif";">Since
each user of the report has different interests, it is important to
plan the report so it includes the information each user is looking for.</span><br />
<h3>
<span style="color: red; font-family: "Verdana","sans-serif";">Determining the layout of the report </span></h3>
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="297781"></a><span style="font-family: "Verdana","sans-serif";">What is the report title going to be?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291285"></a><span style="font-family: "Verdana","sans-serif";">Write
out a working title for the report. You may decide to change it later,
but at least you will have a title to use when creating the prototype
report.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291286"></a><span style="font-family: "Verdana","sans-serif";">What identifying information is needed in the header and footer?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291287"></a><span style="font-family: "Verdana","sans-serif";">You
may wish to include the print date, information on who prepared the
report, a block of text to describe the purpose of the report, the range
of data covered, or something similar. If you are going to include such
information, write it down so you can use it in preparing your
prototype.</span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291288"></a><span style="font-family: "Verdana","sans-serif";">The information can come from a variety of sources, depending on the kind of information you plan to use.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l0 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291290"></a><span style="font-family: "Verdana","sans-serif";">Information
on who prepared the report might be drawn from individual data
fields in the database table(s) used. If it is to be drawn from a
database table, what table? Or, what combination of tables? <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291291"></a></span></li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">A block of text can be created as a text object and placed anywhere on the report. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291571"></a></span></li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Crystal Reports can generate information such as the print date or page numbers. </span></li>
</ul>
<h3>
<span style="color: red; font-family: "Verdana","sans-serif";">Finding the data</span></h3>
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="19988"></a><span style="font-family: "Verdana","sans-serif";">What data do you want to use in the report?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="19989"></a><span style="font-family: "Verdana","sans-serif";">Do
you know the type of database you are reporting from? Will you be
reporting off a data file, SQL/ODBC, a Business View, or a Dictionary?</span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="297499"></a><span style="font-family: "Verdana","sans-serif";">If
you do not know, ask the database administrator in your organization
for help in setting up the database type and location of the data. For
more information, <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="297503"></a></span><br />
<span style="font-family: "Verdana","sans-serif";">Are
you familiar enough with the data to find the necessary information?
When looking for a Customer Contact name, can the field be found in a
database table?</span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="290990"></a><span style="font-family: "Verdana","sans-serif";">If not, your MIS professional, database administrator, or co-workers will have to help you become familiar with the data.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14584"></a><span style="font-family: "Verdana","sans-serif";">What specific data should appear in the body of the report?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14585"></a><span style="font-family: "Verdana","sans-serif";">The
body should contain all the data needed to fulfill the statement of
purpose you wrote for the report. It should also contain all of the data
needed by the various users that you have identified.</span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14589"></a><span style="font-family: "Verdana","sans-serif";">This
step requires you to look at the available database table(s). Crystal
Reports allows you to combine data from different databases when you
create reports, so you have a great deal of flexibility in your work.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l3 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14590"></a><span style="font-family: "Verdana","sans-serif";">Much
of the data in a typical report is taken directly from data
fields. Which data fields will be used, and where are they located?
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14591"></a></span></li>
<li class="MsoNormal" style="mso-list: l3 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Other data will be calculated based on data fields. Which data fields will be used in the calculations? <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14592"></a></span></li>
<li class="MsoNormal" style="mso-list: l3 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Still other data will be placed directly into the report using text objects (headings, notes, labels, and so on). </span></li>
</ul>
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291766"></a><span style="font-family: "Verdana","sans-serif";">Does the data exist or does it need to be calculated?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="155760"></a><span style="font-family: "Verdana","sans-serif";">Some
report information can be drawn directly from data fields (sales
information, for example); other information will have to be calculated
based on data field values (for example, sales commission, based on the
relationship of sales to quota). In your planning, it can be helpful to
segregate or flag data that needs to be calculated from that which can
be used directly.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14599"></a><span style="font-family: "Verdana","sans-serif";">What types of fields contain data?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="319322"></a><span style="font-family: "Verdana","sans-serif";">You
should take the time to get to know the data type for data fields that
will be used in your calculations. Since formula functions and operators
work with specific kinds of data, it is important to recognize the data
type you are working with, before you start any calculations. For
example, some functions require numeric data, while others work with
only string fields. For more information on specific functions and
operators, search for "Functions" and</span><em><span style="font-family: "Verdana","sans-serif";"> "</span></em><span style="font-family: "Verdana","sans-serif";">Operators," or for the function or operator by name in the Crystal Reports online help.</span><br />
<h4>
<span style="font-family: "Verdana","sans-serif";">Do you want the data organized into groups?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292287"></a><span style="font-family: "Verdana","sans-serif";">How?
By customer? By date? By hierarchy? Or by other criteria? Crystal
Reports provides several options for grouping data in a report. </span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292248"></a><span style="font-family: "Verdana","sans-serif";">Do you want the data sorted based on record or group values?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292254"></a><span style="font-family: "Verdana","sans-serif";">Crystal Reports gives you both alternatives.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="291817"></a><span style="font-family: "Verdana","sans-serif";">Do you want the report to contain only specific records or groups?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="25569"></a><span style="font-family: "Verdana","sans-serif";">Crystal
Reports gives you the opportunity to base a report on all records in a
given database, or on a limited set of records from the database.
Crystal Reports can be used to select records based on simple date
ranges or comparisons, or to create complex formulas to identify the
records to be included. Take a few minutes to determine the records
needed for the report and list the criteria to be used for selecting
those records. </span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14611"></a><span style="font-family: "Verdana","sans-serif";">Do you want to summarize the data?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292103"></a><span style="font-family: "Verdana","sans-serif";">Do
you want to total, average, count, or determine the maximum or minimum
value included in all the values in any column on the report?</span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="292133"></a><span style="font-family: "Verdana","sans-serif";">Crystal
Reports allows you to do this, and it also allows the grand total (or
the grand total average, grand total count, and so on) to be placed at
the bottom of the selected column.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14615"></a><span style="font-family: "Verdana","sans-serif";">What information should be flagged on the report?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14616"></a><span style="font-family: "Verdana","sans-serif";">You
may want to call attention to some data by flagging it on the report.
For example, non-moving inventory items are often flagged on inventory
reports so they can be given special attention. You might want to flag
each item that has shown no activity during the last month, during the
last three months, or during some other defined period. To flag
information, identify it and any conditions that will trigger the
flagging.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14619"></a><span style="font-family: "Verdana","sans-serif";">How do you want information flagged?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14620"></a><span style="font-family: "Verdana","sans-serif";">You
may want to flag items with an asterisk or some other symbol, or you
may want a word to appear as a flag. In any case, you should write out
flagging instructions so they are handy.</span><br />
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14624"></a><span style="font-family: "Verdana","sans-serif";">Crystal
Reports gives you the opportunity to underline report elements, and
change the font type, size, or color used for specific report items. It
allows you to put borders around items and to draw lines and boxes (to
break the report into sections), set off headings, and so on. All of
these formatting tools can be used to highlight key data on a report.</span><br />
<h3>
<span style="font-family: "Verdana","sans-serif";">Determining printing area characteristics</span></h3>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295882"></a><span style="font-family: "Verdana","sans-serif";">Each
report area has its own printing characteristics. It is important to
understand these characteristics because they affect when and how often
different report objects get printed.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295883"></a><span style="font-family: "Verdana","sans-serif";">In what order will the areas print on the report?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295884"></a><span style="font-family: "Verdana","sans-serif";">Areas
print in the order they appear on the Design tab (top to bottom). If
there is more than one section in an area, the sections print in the
order they appear. For example, if you have three Report Header
sections, all three of those sections will print, in order, before the
section(s) in the Page Header area begin to print.</span><br />
<h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295885"></a><span style="font-family: "Verdana","sans-serif";">How often do report objects print?</span></h4>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295886"></a><span style="font-family: "Verdana","sans-serif";">The
way objects print will determine how you design your report. This will
help you decide where to place charts, Cross-Tabs, and formulas to get
specific results.</span><br />
<h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295887"></a><span style="color: red; font-family: "Verdana","sans-serif";">Report Header</span></h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295888"></a><span style="font-family: "Verdana","sans-serif";">Objects placed in the Report Header area print once, at the beginning of the report.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l8 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295889"></a><span style="font-family: "Verdana","sans-serif";">Charts and Cross-Tabs placed in this area contain data for the entire report. </span></li>
</ul>
<div class="indent" style="margin-left: .5in;">
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="318714"></a><em><span style="font-family: "Verdana","sans-serif";">Note: </span></em><span style="font-family: "Verdana","sans-serif";">Both
charts and Cross-Tabs can filter report data by using a Group Sort; in
such cases, the data shown in the chart or Cross-Tab is a subset of the
data for the entire report.</span></div>
<ul type="disc">
<li class="MsoNormal" style="mso-list: l8 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295890"></a><span style="font-family: "Verdana","sans-serif";">Formulas placed in this area are evaluated once, at the beginning of the report. </span></li>
</ul>
<h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295891"></a><span style="color: red; font-family: "Verdana","sans-serif";">Page Header</span></h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295892"></a><span style="font-family: "Verdana","sans-serif";">Objects placed in the Page Header area print at the beginning of each new page.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l11 level1 lfo7; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295893"></a><span style="font-family: "Verdana","sans-serif";">Charts or Cross-Tabs cannot be placed in this section. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="312003"></a></span></li>
<li class="MsoNormal" style="mso-list: l11 level1 lfo7; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Formulas placed in this area are evaluated once per page, at the beginning of each new page. </span></li>
</ul>
<h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="312004"></a><span style="color: red; font-family: "Verdana","sans-serif";">Group Header</span></h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="312005"></a><span style="font-family: "Verdana","sans-serif";">Objects placed in the Group Header area print at the beginning of each new group.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l5 level1 lfo8; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295897"></a><span style="font-family: "Verdana","sans-serif";">Charts and Cross-Tabs placed in this area contain data just for the group. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295898"></a></span></li>
<li class="MsoNormal" style="mso-list: l5 level1 lfo8; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Formulas placed in this area are evaluated once for each group, at the beginning of the group. </span></li>
</ul>
<h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295899"></a><span style="color: red; font-family: "Verdana","sans-serif";">Details area</span></h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295900"></a><span style="font-family: "Verdana","sans-serif";">Objects placed in the Details area print with each new record.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l4 level1 lfo9; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295901"></a><span style="font-family: "Verdana","sans-serif";">Charts or Cross-Tabs cannot be placed in this area. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295902"></a></span></li>
<li class="MsoNormal" style="mso-list: l4 level1 lfo9; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Formulas placed in this area are evaluated once for each record. </span></li>
</ul>
<h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295903"></a><span style="color: red; font-family: "Verdana","sans-serif";">Group Footer</span></h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295904"></a><span style="font-family: "Verdana","sans-serif";">Objects placed in the Group Footer area print at the end of each group.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l6 level1 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295905"></a><span style="font-family: "Verdana","sans-serif";">Charts and Cross-Tabs placed in this area contain data just for the group. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295906"></a></span></li>
<li class="MsoNormal" style="mso-list: l6 level1 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Formulas placed in this area are evaluated once for each group, at the end of the group. </span></li>
</ul>
<h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295907"></a><span style="color: red; font-family: "Verdana","sans-serif";">Report Footer</span></h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295908"></a><span style="font-family: "Verdana","sans-serif";">Objects placed in the Report Footer area print once at the end of the report.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l1 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295909"></a><span style="font-family: "Verdana","sans-serif";">Charts and Cross-Tabs placed in this area contain data for the entire report. </span></li>
</ul>
<div class="indent" style="margin-left: .5in;">
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="318732"></a><em><span style="font-family: "Verdana","sans-serif";">Note: </span></em><span style="font-family: "Verdana","sans-serif";">Both
charts and Cross-Tabs can filter report data by using a Group Sort; in
such cases, the data shown in the chart or Cross-Tab is a subset of the
data for the entire report.</span></div>
<ul type="disc">
<li class="MsoNormal" style="mso-list: l1 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295910"></a><span style="font-family: "Verdana","sans-serif";">Formulas placed in this area are evaluated once, at the end of the report. </span></li>
</ul>
<h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295911"></a><span style="color: red; font-family: "Verdana","sans-serif";">Page Footer</span></h5>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295912"></a><span style="font-family: "Verdana","sans-serif";">Objects placed in the Page Footer area print at the bottom of each page.</span><br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l9 level1 lfo12; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295913"></a><span style="font-family: "Verdana","sans-serif";">Charts and Cross-Tabs cannot be placed in this area. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="295914"></a></span></li>
<li class="MsoNormal" style="mso-list: l9 level1 lfo12; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Formulas placed in this area are evaluated once per page, at the end of each new page. </span></li>
</ul>
<h2>
<span style="color: red; font-family: "Verdana","sans-serif";">Developing a prototype on paper</span></h2>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="63669"></a><span style="font-family: "Verdana","sans-serif";">While
a paper prototype is useful regardless of your level of expertise with
Crystal Reports, it is particularly valuable when you are first learning
the program. With the paper prototype in hand, you can put your full
effort into learning and using the commands, rather than into trying to
design and learn at the same time.</span><br />
<h6>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="31837"></a><span style="color: red; font-family: "Verdana","sans-serif";">To design a paper prototype</span></h6>
<ol start="1" type="1">
<li class="MsoNormal" style="mso-list: l7 level1 lfo13; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="31838"></a><span style="font-family: "Verdana","sans-serif";">Get the same size paper you will be using for the finished report. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14639"></a></span></li>
</ol>
<ol start="2" type="1">
<li class="MsoNormal" style="mso-list: l7 level1 lfo14; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Position the title and other descriptive header information, using boxes or lines to represent report elements. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14640"></a></span></li>
</ol>
<ol start="3" type="1">
<li class="MsoNormal" style="mso-list: l7 level1 lfo15; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Position the footer information. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14641"></a></span></li>
</ol>
<ol start="4" type="1">
<li class="MsoNormal" style="mso-list: l7 level1 lfo16; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Review the page layout for balance. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14642"></a></span></li>
</ol>
<ol start="5" type="1">
<li class="MsoNormal" style="mso-list: l7 level1 lfo17; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Look at the information you intend to include in the body of the report: </span></li>
<ul type="disc">
<li class="MsoNormal" style="mso-list: l7 level2 lfo17; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14643"></a><span style="font-family: "Verdana","sans-serif";">Count the number of fields being used and estimate the appropriate spacing between fields.<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14644"></a> </span></li>
<li class="MsoNormal" style="mso-list: l7 level2 lfo17; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Use rectangles to pencil in the fields within the estimated spacing.<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14645"></a> </span></li>
<li class="MsoNormal" style="mso-list: l7 level2 lfo17; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Change the spacing if you need to.<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14646"></a> </span></li>
<li class="MsoNormal" style="mso-list: l7 level2 lfo17; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Decide on a logical sequence for presenting the data in the body of the report.<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14647"></a> </span></li>
<li class="MsoNormal" style="mso-list: l7 level2 lfo17; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Label the fields to indicate that sequence.</span></li>
</ul>
</ol>
<ol start="6" type="1">
<li class="MsoNormal" style="mso-list: l7 level1 lfo18; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14648"></a><span style="font-family: "Verdana","sans-serif";">Use small boxes to indicate group values and totals. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14649"></a></span></li>
</ol>
<ol start="7" type="1">
<li class="MsoNormal" style="mso-list: l7 level1 lfo19; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Place random flags in the column where you want flags to appear. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14650"></a></span></li>
</ol>
<ol start="8" type="1">
<li class="MsoNormal" style="mso-list: l7 level1 lfo20; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Verdana","sans-serif";">Darken any elements you want highlighted to make them stand out from the rest of the prototype. <a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="14651"></a></span></li>
</ol>
<span style="font-family: "Verdana","sans-serif";">Review the finished product for layout and balance, and make changes as needed</span><br />
<h2 class="date-header">
<span><a href="http://ntssp.blogspot.in/2011/02/crystal-report-design-concept.html" target="_blank">ref:</a></span></h2>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-83928112294375973672013-01-31T11:43:00.004+05:302013-01-31T11:43:57.211+05:30Clear Items of a DropDownList using jQuery<div dir="ltr" style="text-align: left;" trbidi="on">
<pre class="code"><span style="color: blue;"><</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">DropDownList </span><span style="color: red;">ID</span><span style="color: blue;">="ddlPeople" </span><span style="color: red;">runat</span><span style="color: blue;">="server">
</</span><span style="color: #a31515;">asp</span><span style="color: blue;">:</span><span style="color: #a31515;">DropDownList</span><span style="color: blue;">></span></pre>
<pre class="code"><span style="color: blue;"> </span></pre>
<pre class="code"><span style="color: blue;">$(<span style="color: #a31515;">"select[id$=ddlPeople] > option"</span>).remove();</span></pre>
<pre class="code"><span style="color: blue;"> </span></pre>
<pre class="code"><span style="color: blue;"> </span></pre>
“>
option” matches all child elements. Because each item in the drop down
list is rendered as an <option> tag, you need to clear the child
<option> tags in order to clear the items in a drop down list.<br />
<br />
<a href="http://www.devcurry.com/2009/11/clear-items-of-dropdownlist-using.html" target="_blank">ref</a><br />
<pre class="code"><span style="color: blue;"> </span></pre>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-23015801422497285232013-01-17T11:49:00.000+05:302013-01-17T11:49:18.089+05:30Using parameterized SQL queries to help prevent SQL injection attack.<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="about" style="padding-top: 5px; width: 590px;">
<h4>
<span style="font-family: Verdana;"><span style="font-size: x-small;">Using parameterized SQL queries to help prevent SQL injection attack.</span></span></h4>
</div>
<div class="about" style="width: 590px;">
<div>
<span style="font-family: Verdana;">If
you are not new to web development in particular, it is quite likely
that you already know what a SQL injection is and how it poses threat to
your system security. This is more probable when you are adding strings
to SQL commands.</span></div>
<div>
</div>
<div>
</div>
<div>
</div>
<div>
<div>
<span style="color: purple; font-family: Courier New;">string sql = "SELECT * FROM tblUser WHERE Name = '" + txtName.Text +<br /> "' AND Password = '" + txtpassword.Text + "'";</span></div>
<div>
</div>
<div>
<div>
<span style="font-family: Verdana;">Well, the above statement looks fine but what a malicious user would now do is add condition such as </span></div>
<div>
</div>
<div>
<div>
<span style="font-family: Courier New;">' OR 3=3 --</span></div>
<div>
</div>
</div>
<div>
<div>
<span style="font-family: Verdana;">So that the actual SQL statement becomes </span></div>
<div>
</div>
<div>
</div>
</div>
</div>
</div>
<div>
<div>
<span style="color: purple; font-family: Courier New;">SELECT * FROM tblUser WHERE Name = '' OR 3=3 --' AND Password = ''</span></div>
<div>
</div>
</div>
<div>
<div>
<span style="font-family: Verdana;">The double dashes comment
out rest of the statement and the condition 3=3 is added. Since 3 is
always equal to 3 the query selects every row in the table thus giving
access to information which wouldn't be available otherwise. </span></div>
<div>
<span style="font-family: Verdana;"> </span></div>
<div>
<span style="font-family: Verdana;">However, parameterizing the SQL
statement would not only remove this vulnerability but also enhance
performance multifold. Parameterized SQL statements are in some ways
similar to stored procedures, so if you have worked with the latter, the
concept of parameterized query would be easier to understand. Further,
since the parts of the SQL statement are added as parameters, the same
code can be reused. </span></div>
<div>
<span style="font-family: Verdana;"> </span></div>
<div>
<span style="font-family: Verdana;">Now let us create a
parameterized SQL statement in ASP.NET. As usual, we would be required
to first create our connection and command objects. We would then add
parameters to it before it is executed. </span></div>
<div>
</div>
<div>
<span style="font-family: Verdana;">
<div>
<div>
<span style="color: navy; font-family: Courier New;">SqlConnection objCon = new SqlConnection(ConnectionString);<br />objCon.Open();<br />SqlCommand objCommand = new SqlCommand(<br /> "SELECT * FROM User WHERE Name = @Name AND Password = @Password",<br /> objConnection);<br />objCommand.Parameters.Add("@Name", txtName.Text);<br />objCommand.Parameters.Add("@Password", txtpassword.Text);<br />SqlDataReader objReader = objCommand.ExecuteReader();<br />if (objReader.Read())<br />{<br /> ----------<br /> -------- <br />---------<br />}</span></div>
<div>
<span style="color: navy; font-family: Courier New;"> </span></div>
<div>
<span style="color: navy; font-family: Courier New;"><a href="http://www.mindfiresolutions.com/How-to-use-parameterized-queries-in-ASPNet-174.php" target="_blank">Refrence</a> </span></div>
</div>
</span></div>
</div>
</div>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-14158836350418091002013-01-13T00:24:00.002+05:302013-01-13T00:24:35.377+05:30diffrence between Get and Post HTTP Methods<div dir="ltr" style="text-align: left;" trbidi="on">
<br />GET Method:<br /><br />1.All the name value pairs are submitted as a query string in URL.<br />It's not secured as it is visible in plain text format in the Location bar of the web browser.<br /><br />2.Length of the string is restricted.<br /><br /><br />3.If get method is used and if the page is refreshed it would not prompt before the request is submitted again.<br /><br />4.One can store the name value pairs as bookmark and directly be used while sharing with others - example search results.<br /><br /><br />POST Method:<br /><br />1. All the name value pairs are submitted in the Message Body of the request.<br /><br />2. Length of the string (amount of data submitted) is not restricted.<br /><br />3. Post Method is secured because Name-Value pairs cannot be seen in location bar of the web browser.<br /><br />4. If post method is used and if the page is refreshed it would prompt before the request is resubmitted.<br /><br />5. If the service associated with the processing of a form has side effects (for example, modification of a database or subscription to a service), the method should be POST.<br /><br />6. Data is submitted in the form as specified in enctype attribute of form tag and thus files can be used in FileUpload input box. </div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-74066066118980899152012-11-20T15:39:00.002+05:302013-01-08T17:18:04.102+05:30SQL Server error messages list 0 to 1000<meta name="google-translate-customization" content="328c4289700e2213-a5767f1fbd9bd28c-gf85230de79eb1b19-1d"></meta>
<div dir="ltr" style="text-align: left;" trbidi="on">
<style>
table.hovertable {
border-collapse: collapse;
border-color: #999999;
border-width: 1px;
color: #333333;
font-family: verdana,arial,sans-serif;
font-size: 11px;
}
table.hovertable th {
background-color: #C3DDE0;
border-color: #A9C6C9;
border-style: solid;
border-width: 1px;
padding: 8px;
}
table.hovertable tr {
background-color: #D4E3E5;
}
table.hovertable td {
border-color: #A9C6C9;
border-style: solid;
border-width: 1px;
padding: 8px;
}
</style>
<br />
<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="page_title">
SQL Server error messages list 0 to 1000</h2>
<h2 class="page_title">
</h2>
<table class="hovertable">
<tbody>
<tr>
<th>error </th>
<th>severity </th>
<th>description </th>
</tr>
<tr>
<td>21</td>
<td>20</td>
<td>Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.</td>
</tr>
<tr>
<td>101</td>
<td>15</td>
<td>Query not allowed in Waitfor.</td>
</tr>
<tr>
<td>102</td>
<td>15</td>
<td>Incorrect syntax near ‘%.*ls’.</td>
</tr>
<tr>
<td>103</td>
<td>15</td>
<td>The %S_MSG that starts with ‘%.*ls’ is too long. Maximum length is %d.</td>
</tr>
<tr>
<td>104</td>
<td>15</td>
<td>ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.</td>
</tr>
<tr>
<td>105</td>
<td>15</td>
<td>Unclosed quotation mark after the character string ‘%.*ls’.</td>
</tr>
<tr>
<td>106</td>
<td>16</td>
<td>Too many table names in the query. The maximum allowable is %d.</td>
</tr>
<tr>
<td>107</td>
<td>15</td>
<td>The column prefix ‘%.*ls’ does not match with a table name or alias name used in the query.</td>
</tr>
<tr>
<td>108</td>
<td>15</td>
<td>The ORDER BY position number %ld is out of range of the number of items in the select list.</td>
</tr>
<tr>
<td>109</td>
<td>15</td>
<td>There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.</td>
</tr>
<tr>
<td>110</td>
<td>15</td>
<td>There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.</td>
</tr>
<tr>
<td>111</td>
<td>15</td>
<td>‘%ls’ must be the first statement in a query batch.</td>
</tr>
<tr>
<td>112</td>
<td>15</td>
<td>Variables are not allowed in the %ls statement.</td>
</tr>
<tr>
<td>113</td>
<td>15</td>
<td>Missing end comment mark ‘*/’.</td>
</tr>
<tr>
<td>114</td>
<td>15</td>
<td>Browse mode is invalid for a statement that assigns values to a variable.</td>
</tr>
<tr>
<td>115</td>
<td>15</td>
<td>The FOR UPDATE clause is invalid for statements containing set operators.</td>
</tr>
<tr>
<td>116</td>
<td>15</td>
<td>Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.</td>
</tr>
<tr>
<td>117</td>
<td>15</td>
<td>The %S_MSG name ‘%.*ls’ contains more than the maximum number of prefixes. The maximum is %d.</td>
</tr>
<tr>
<td>119</td>
<td>15</td>
<td>Must pass parameter number %d and subsequent parameters as ‘@name = value’. After the form ‘@name = value’ has been used, all subsequent parameters must be passed in the form ‘@name = value’.</td>
</tr>
<tr>
<td>120</td>
<td>15</td>
<td>The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.</td>
</tr>
<tr>
<td>121</td>
<td>15</td>
<td>The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.</td>
</tr>
<tr>
<td>122</td>
<td>15</td>
<td>The %ls option is allowed only with %ls syntax.</td>
</tr>
<tr>
<td>123</td>
<td>15</td>
<td>Batch/procedure exceeds maximum length of %d characters.</td>
</tr>
<tr>
<td>124</td>
<td>15</td>
<td>CREATE PROCEDURE contains no statements.</td>
</tr>
<tr>
<td>125</td>
<td>15</td>
<td>Case expressions may only be nested to level %d.</td>
</tr>
<tr>
<td>126</td>
<td>15</td>
<td>Invalid pseudocolumn “%.*ls”.</td>
</tr>
<tr>
<td>127</td>
<td>15</td>
<td>A TOP N value may not be negative.</td>
</tr>
<tr>
<td>128</td>
<td>15</td>
<td>The name “%.*s” is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.</td>
</tr>
<tr>
<td>129</td>
<td>15</td>
<td>Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.</td>
</tr>
<tr>
<td>130</td>
<td>16</td>
<td>Cannot perform an aggregate function on an expression containing an aggregate or a subquery.</td>
</tr>
<tr>
<td>131</td>
<td>15</td>
<td>The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed for any data type (%d).</td>
</tr>
<tr>
<td>132</td>
<td>15</td>
<td>The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure.</td>
</tr>
<tr>
<td>133</td>
<td>15</td>
<td>A GOTO statement references the label ‘%.*ls’ but the label has not been declared.</td>
</tr>
<tr>
<td>134</td>
<td>15</td>
<td>The variable name ‘%.*ls’ has already been declared. Variable names must be unique within a query batch or stored procedure.</td>
</tr>
<tr>
<td>135</td>
<td>15</td>
<td>Cannot use a BREAK statement outside the scope of a WHILE statement.</td>
</tr>
<tr>
<td>136</td>
<td>15</td>
<td>Cannot use a CONTINUE statement outside the scope of a WHILE statement.</td>
</tr>
<tr>
<td>137</td>
<td>15</td>
<td>Must declare the scalar variable “%.*ls”.</td>
</tr>
<tr>
<td>138</td>
<td>15</td>
<td>Correlation clause in a subquery not permitted.</td>
</tr>
<tr>
<td>139</td>
<td>15</td>
<td>Cannot assign a default value to a local variable.</td>
</tr>
<tr>
<td>140</td>
<td>15</td>
<td>Can only use IF UPDATE within a CREATE TRIGGER statement.</td>
</tr>
<tr>
<td>141</td>
<td>15</td>
<td>A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.</td>
</tr>
<tr>
<td>142</td>
<td>15</td>
<td>Incorrect syntax for definition of the ‘%ls’ constraint.</td>
</tr>
<tr>
<td>143</td>
<td>15</td>
<td>A COMPUTE BY item was not found in the order by list. All expressions in the compute by list must also be present in the order by list.</td>
</tr>
<tr>
<td>144</td>
<td>15</td>
<td>Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.</td>
</tr>
<tr>
<td>145</td>
<td>15</td>
<td>ORDER BY items must appear in the select list if SELECT DISTINCT is specified.</td>
</tr>
<tr>
<td>146</td>
<td>15</td>
<td>Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.</td>
</tr>
<tr>
<td>147</td>
<td>15</td>
<td>An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.</td>
</tr>
<tr>
<td>148</td>
<td>15</td>
<td>Incorrect time syntax in time string ‘%.*ls’ used with WAITFOR.</td>
</tr>
<tr>
<td>149</td>
<td>15</td>
<td>Time value ‘%.*ls’ used with WAITFOR is not a valid value. Check date/time syntax.</td>
</tr>
<tr>
<td>150</td>
<td>15</td>
<td>Both terms of an outer join must contain columns.</td>
</tr>
<tr>
<td>151</td>
<td>15</td>
<td>‘%.*ls’ is an invalid money value.</td>
</tr>
<tr>
<td>152</td>
<td>15</td>
<td>The same large data placement option “%.*ls” has been specified twice.</td>
</tr>
<tr>
<td>153</td>
<td>15</td>
<td>Invalid usage of the option %.*ls in the %ls statement.</td>
</tr>
<tr>
<td>154</td>
<td>15</td>
<td>%S_MSG is not allowed in %S_MSG.</td>
</tr>
<tr>
<td>155</td>
<td>15</td>
<td>‘%.*ls’ is not a recognized %ls option.</td>
</tr>
<tr>
<td>156</td>
<td>15</td>
<td>Incorrect syntax near the keyword ‘%.*ls’.</td>
</tr>
<tr>
<td>157</td>
<td>15</td>
<td>An aggregate may not appear in the set list of an UPDATE statement.</td>
</tr>
<tr>
<td>158</td>
<td>15</td>
<td>An aggregate may not appear in the OUTPUT clause.</td>
</tr>
<tr>
<td>159</td>
<td>15</td>
<td>Must specify the table name and index name for the DROP INDEX statement.</td>
</tr>
<tr>
<td>160</td>
<td>15</td>
<td>Rule does not contain a variable.</td>
</tr>
<tr>
<td>161</td>
<td>15</td>
<td>Rule contains more than one variable.</td>
</tr>
<tr>
<td>162</td>
<td>15</td>
<td>Invalid expression in the TOP clause.</td>
</tr>
<tr>
<td>163</td>
<td>15</td>
<td>The compute by list does not match the order by list.</td>
</tr>
<tr>
<td>164</td>
<td>15</td>
<td>Each GROUP BY expression must contain at least one column that is not an outer reference.</td>
</tr>
<tr>
<td>165</td>
<td>16</td>
<td>Privilege %ls may not be granted or revoked.</td>
</tr>
<tr>
<td>166</td>
<td>15</td>
<td>‘%ls’ does not allow specifying the database name as a prefix to the object name.</td>
</tr>
<tr>
<td>167</td>
<td>15</td>
<td>Cannot create %S_MSG on a temporary object.</td>
</tr>
<tr>
<td>168</td>
<td>15</td>
<td>The floating point value ‘%.*ls’ is out of the range of computer representation (%d bytes).</td>
</tr>
<tr>
<td>169</td>
<td>15</td>
<td>A column has been specified more than once in the order by list. Columns in the order by list must be unique.</td>
</tr>
<tr>
<td>171</td>
<td>15</td>
<td>Browse mode cannot be used with INSERT, SELECT INTO, or UPDATE statements.</td>
</tr>
<tr>
<td>172</td>
<td>15</td>
<td>Cannot use HOLDLOCK in browse mode.</td>
</tr>
<tr>
<td>173</td>
<td>15</td>
<td>The definition for column ‘%.*ls’ must include a data type.</td>
</tr>
<tr>
<td>174</td>
<td>15</td>
<td>The %.*ls function requires %d argument(s).</td>
</tr>
<tr>
<td>175</td>
<td>15</td>
<td>An aggregate may not appear in a computed column expression or check constraint.</td>
</tr>
<tr>
<td>176</td>
<td>15</td>
<td>The FOR BROWSE clause is no longer supported in views. Set the database compatibility level to 80 or lower for this statement to be allowed.</td>
</tr>
<tr>
<td>177</td>
<td>15</td>
<td>The IDENTITY function can only be used when the SELECT statement has an INTO clause.</td>
</tr>
<tr>
<td>178</td>
<td>15</td>
<td>A RETURN statement with a return value cannot be used in this context.</td>
</tr>
<tr>
<td>179</td>
<td>15</td>
<td>Cannot use the OUTPUT option when passing a constant to a stored procedure.</td>
</tr>
<tr>
<td>180</td>
<td>15</td>
<td>There are too many parameters in this %ls statement. The maximum number is %d.</td>
</tr>
<tr>
<td>181</td>
<td>15</td>
<td>Cannot use the OUTPUT option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.</td>
</tr>
<tr>
<td>182</td>
<td>15</td>
<td>Table and column names must be supplied for the READTEXT or WRITETEXT utility.</td>
</tr>
<tr>
<td>183</td>
<td>15</td>
<td>The scale (%d) for column ‘%.*ls’ must be within the range %d to %d.</td>
</tr>
<tr>
<td>184</td>
<td>16</td>
<td>DEFAULT cannot be specified more than once for filegroups of the same content type.</td>
</tr>
<tr>
<td>185</td>
<td>15</td>
<td>Data stream is invalid for WRITETEXT statement in bulk form.</td>
</tr>
<tr>
<td>186</td>
<td>15</td>
<td>Data stream missing from WRITETEXT statement.</td>
</tr>
<tr>
<td>187</td>
<td>16</td>
<td>The valid range for MAX_QUEUE_READERS is 0 to 32767.</td>
</tr>
<tr>
<td>188</td>
<td>15</td>
<td>Cannot specify a log file in a CREATE DATABASE statement without also specifying at least one data file.</td>
</tr>
<tr>
<td>189</td>
<td>15</td>
<td>The %ls function requires %d to %d arguments.</td>
</tr>
<tr>
<td>190</td>
<td>15</td>
<td>An invalid date or time was specified in the statement.</td>
</tr>
<tr>
<td>191</td>
<td>15</td>
<td>Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.</td>
</tr>
<tr>
<td>192</td>
<td>16</td>
<td>The scale must be less than or equal to the precision.</td>
</tr>
<tr>
<td>193</td>
<td>15</td>
<td>The object or column name starting with ‘%.*ls’ is too long. The maximum length is %d characters.</td>
</tr>
<tr>
<td>194</td>
<td>15</td>
<td>A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.</td>
</tr>
<tr>
<td>195</td>
<td>15</td>
<td>‘%.*ls’ is not a recognized %S_MSG.</td>
</tr>
<tr>
<td>196</td>
<td>15</td>
<td>SELECT INTO must be the first query in a statement containing a UNION, INTERSECT or EXCEPT operator.</td>
</tr>
<tr>
<td>197</td>
<td>15</td>
<td>EXECUTE cannot be used as a source when inserting into a table variable.</td>
</tr>
<tr>
<td>198</td>
<td>15</td>
<td>Browse mode is invalid for statements containing a UNION, INTERSECT or EXCEPT operator.</td>
</tr>
<tr>
<td>199</td>
<td>15</td>
<td>An INSERT statement cannot contain a SELECT statement that assigns values to a variable.</td>
</tr>
<tr>
<td>201</td>
<td>16</td>
<td>Procedure or function ‘%.*ls’ expects parameter ‘%.*ls’, which was not supplied.</td>
</tr>
<tr>
<td>202</td>
<td>16</td>
<td>Invalid type ‘%s’ for WAITFOR. Supported data types are CHAR/VARCHAR, NCHAR/NVARCHAR, and DATETIME. WAITFOR DELAY supports the INT and SMALLINT data types.</td>
</tr>
<tr>
<td>203</td>
<td>16</td>
<td>The name ‘%.*ls’ is not a valid identifier.</td>
</tr>
<tr>
<td>204</td>
<td>20</td>
<td>Normalization error in node %ls.</td>
</tr>
<tr>
<td>205</td>
<td>16</td>
<td>All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.</td>
</tr>
<tr>
<td>206</td>
<td>16</td>
<td>Operand type clash: %ls is incompatible with %ls</td>
</tr>
<tr>
<td>207</td>
<td>16</td>
<td>Invalid column name ‘%.*ls’.</td>
</tr>
<tr>
<td>208</td>
<td>16</td>
<td>Invalid object name ‘%.*ls’.</td>
</tr>
<tr>
<td>209</td>
<td>16</td>
<td>Ambiguous column name ‘%.*ls’.</td>
</tr>
<tr>
<td>210</td>
<td>16</td>
<td>Conversion failed when converting datetime from binary/varbinary string.</td>
</tr>
<tr>
<td>211</td>
<td>23</td>
<td>Possible schema corruption. Run DBCC CHECKCATALOG.</td>
</tr>
<tr>
<td>212</td>
<td>16</td>
<td>Expression result length exceeds the maximum. %d max, %d found.</td>
</tr>
<tr>
<td>213</td>
<td>16</td>
<td>Column name or number of supplied values does not match table definition.</td>
</tr>
<tr>
<td>214</td>
<td>16</td>
<td>Procedure expects parameter ‘%ls’ of type ‘%ls’.</td>
</tr>
<tr>
<td>215</td>
<td>16</td>
<td>Parameters supplied for object ‘%.*ls’ which is not a function. If the parameters are intended as a table hint, a WITH keyword is required.</td>
</tr>
<tr>
<td>216</td>
<td>16</td>
<td>Parameters were not supplied for the function ‘%.*ls’.</td>
</tr>
<tr>
<td>217</td>
<td>16</td>
<td>Maximum stored procedure, function, trigger, or view nesting level exceeded (limit %d).</td>
</tr>
<tr>
<td>218</td>
<td>16</td>
<td>Could not find the type ‘%.*ls’. Either it does not exist or you do not have the necessary permission.</td>
</tr>
<tr>
<td>219</td>
<td>16</td>
<td>The type ‘%.*ls’ already exists, or you do not have permission to create it.</td>
</tr>
<tr>
<td>220</td>
<td>16</td>
<td>Arithmetic overflow error for data type %ls, value = %ld.</td>
</tr>
<tr>
<td>221</td>
<td>10</td>
<td>FIPS Warning: Implicit conversion from %ls to %ls.</td>
</tr>
<tr>
<td>222</td>
<td>16</td>
<td>The base type “%.*ls” is not a valid base type for the alias data type.</td>
</tr>
<tr>
<td>223</td>
<td>11</td>
<td>Object ID %ld specified as a default for table ID %ld, column ID %d is missing or not of type default.</td>
</tr>
<tr>
<td>224</td>
<td>11</td>
<td>Object ID %ld specified as a rule for table ID %ld, column ID %d is missing or not of type default.</td>
</tr>
<tr>
<td>225</td>
<td>16</td>
<td>The parameters supplied for the %ls “%.*ls” are not valid.</td>
</tr>
<tr>
<td>226</td>
<td>16</td>
<td>%ls statement not allowed within multi-statement transaction.</td>
</tr>
<tr>
<td>227</td>
<td>15</td>
<td>“%.*ls” is not a valid function, property, or field.</td>
</tr>
<tr>
<td>228</td>
<td>15</td>
<td>Method ‘%.*ls’ of type ‘%.*ls’ in assembly ‘%.*ls’ does not return any value.</td>
</tr>
<tr>
<td>229</td>
<td>14</td>
<td>The %ls permission was denied on the object ‘%.*ls’, database ‘%.*ls’, schema ‘%.*ls’.</td>
</tr>
<tr>
<td>230</td>
<td>14</td>
<td>The %ls permission was denied on the column ‘%.*ls’ of the object ‘%.*ls”, database ‘%.*ls’, schema ‘%.*ls’.</td>
</tr>
<tr>
<td>231</td>
<td>11</td>
<td>No such default. ID = %ld, database ID = %d.</td>
</tr>
<tr>
<td>232</td>
<td>16</td>
<td>Arithmetic overflow error for type %ls, value = %f.</td>
</tr>
<tr>
<td>233</td>
<td>16</td>
<td>The column ‘%.*ls’ in table ‘%.*ls’ cannot be null.</td>
</tr>
<tr>
<td>234</td>
<td>16</td>
<td>There is insufficient result space to convert a money value to %ls.</td>
</tr>
<tr>
<td>235</td>
<td>16</td>
<td>Cannot convert a char value to money. The char value has incorrect syntax.</td>
</tr>
<tr>
<td>236</td>
<td>16</td>
<td>The conversion from char data type to money resulted in a money overflow error.</td>
</tr>
<tr>
<td>237</td>
<td>16</td>
<td>There is insufficient result space to convert a money value to %ls.</td>
</tr>
<tr>
<td>239</td>
<td>16</td>
<td>Duplicate common table expression name ‘%.*ls’ was specified.</td>
</tr>
<tr>
<td>240</td>
<td>16</td>
<td>Types don’t match between the anchor and the recursive part in column “%.*ls” of recursive query “%.*ls”.</td>
</tr>
<tr>
<td>241</td>
<td>16</td>
<td>Conversion failed when converting date and/or time from character string.</td>
</tr>
<tr>
<td>242</td>
<td>16</td>
<td>The conversion of a %ls data type to a %ls data type resulted in an out-of-range value.</td>
</tr>
<tr>
<td>243</td>
<td>16</td>
<td>Type %.*ls is not a defined system type.</td>
</tr>
<tr>
<td>244</td>
<td>16</td>
<td>The conversion of the %ls value ‘%.*ls’ overflowed an %hs column. Use a larger integer column.</td>
</tr>
<tr>
<td>245</td>
<td>16</td>
<td>Conversion failed when converting the %ls value ‘%.*ls’ to data type %ls.</td>
</tr>
<tr>
<td>246</td>
<td>16</td>
<td>No anchor member was specified for recursive query “%.*ls”.</td>
</tr>
<tr>
<td>247</td>
<td>16</td>
<td>An anchor member was found in the recursive part of recursive query “%.*ls”.</td>
</tr>
<tr>
<td>248</td>
<td>16</td>
<td>The conversion of the %ls value ‘%.*ls’ overflowed an int column.</td>
</tr>
<tr>
<td>249</td>
<td>16</td>
<td>The type “%ls” is not comparable. It cannot be used in the %ls clause.</td>
</tr>
<tr>
<td>251</td>
<td>16</td>
<td>Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded.</td>
</tr>
<tr>
<td>252</td>
<td>16</td>
<td>Recursive common table expression ‘%.*ls’ does not contain a top-level UNION ALL operator.</td>
</tr>
<tr>
<td>253</td>
<td>16</td>
<td>Recursive member of a common table expression ‘%.*ls’ has multiple recursive references.</td>
</tr>
<tr>
<td>254</td>
<td>16</td>
<td>Prefixed columns are not allowed in the column list of a PIVOT operator.</td>
</tr>
<tr>
<td>255</td>
<td>16</td>
<td>Pseudocolumns are not allowed in the column list of a PIVOT operator.</td>
</tr>
<tr>
<td>256</td>
<td>16</td>
<td>The data type %ls is invalid for the %ls function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.</td>
</tr>
<tr>
<td>257</td>
<td>16</td>
<td>Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.</td>
</tr>
<tr>
<td>258</td>
<td>15</td>
<td>Cannot call methods on %ls.</td>
</tr>
<tr>
<td>259</td>
<td>16</td>
<td>Ad hoc updates to system catalogs are not allowed.</td>
</tr>
<tr>
<td>260</td>
<td>16</td>
<td>Disallowed implicit conversion from data type %ls to data type %ls, table ‘%.*ls’, column ‘%.*ls’. Use the CONVERT function to run this query.</td>
</tr>
<tr>
<td>261</td>
<td>16</td>
<td>‘%.*ls’ is not a recognized function.</td>
</tr>
<tr>
<td>262</td>
<td>16</td>
<td>%ls permission denied in database ‘%.*ls’.</td>
</tr>
<tr>
<td>263</td>
<td>16</td>
<td>Must specify table to select from.</td>
</tr>
<tr>
<td>264</td>
<td>16</td>
<td>The column name ‘%.*ls’ is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a vi</td>
</tr>
<tr>
<td>265</td>
<td>16</td>
<td>The column name “%.*ls” specified in the %ls operator conflicts with the existing column name in the %ls argument.</td>
</tr>
<tr>
<td>266</td>
<td>16</td>
<td>Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld.</td>
</tr>
<tr>
<td>267</td>
<td>16</td>
<td>Object ‘%.*ls’ cannot be found.</td>
</tr>
<tr>
<td>268</td>
<td>16</td>
<td>Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.</td>
</tr>
<tr>
<td>270</td>
<td>16</td>
<td>Object ‘%.*ls’ cannot be modified.</td>
</tr>
<tr>
<td>271</td>
<td>16</td>
<td>The column “%.*ls” cannot be modified because it is either a computed column or is the result of a UNION operator.</td>
</tr>
<tr>
<td>272</td>
<td>16</td>
<td>Cannot update a timestamp column.</td>
</tr>
<tr>
<td>273</td>
<td>16</td>
<td>Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.</td>
</tr>
<tr>
<td>275</td>
<td>16</td>
<td>Prefixes are not allowed in value or pivot columns of an UNPIVOT operator.</td>
</tr>
<tr>
<td>276</td>
<td>16</td>
<td>Pseudocolumns are not allowed as value or pivot columns of an UNPIVOT operator.</td>
</tr>
<tr>
<td>277</td>
<td>16</td>
<td>The column “%.*ls” is specified multiple times in the column list of the UNPIVOT operator.</td>
</tr>
<tr>
<td>278</td>
<td>16</td>
<td>The text, ntext, and image data types cannot be used in a GROUP BY clause.</td>
</tr>
<tr>
<td>279</td>
<td>16</td>
<td>The text, ntext, and image data types are invalid in this subquery or aggregate expression.</td>
</tr>
<tr>
<td>280</td>
<td>16</td>
<td>Only base table columns are allowed in the TEXTPTR function.</td>
</tr>
<tr>
<td>281</td>
<td>16</td>
<td>%d is not a valid style number when converting from %ls to a character string.</td>
</tr>
<tr>
<td>282</td>
<td>10</td>
<td>The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.</td>
</tr>
<tr>
<td>283</td>
<td>16</td>
<td>READTEXT cannot be used on inserted or deleted tables within an INSTEAD OF trigger.</td>
</tr>
<tr>
<td>284</td>
<td>16</td>
<td>Rules cannot be bound to text, ntext, or image data types.</td>
</tr>
<tr>
<td>285</td>
<td>16</td>
<td>The READTEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views or functions.</td>
</tr>
<tr>
<td>286</td>
<td>16</td>
<td>The logical tables INSERTED and DELETED cannot be updated.</td>
</tr>
<tr>
<td>287</td>
<td>16</td>
<td>The %ls statement is not allowed within a trigger.</td>
</tr>
<tr>
<td>288</td>
<td>16</td>
<td>The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.</td>
</tr>
<tr>
<td>290</td>
<td>16</td>
<td>Invalid EXECUTE statement using object “%ls”, method “%ls”.</td>
</tr>
<tr>
<td>291</td>
<td>16</td>
<td>CAST or CONVERT: invalid attributes specified for type ‘%.*ls’</td>
</tr>
<tr>
<td>292</td>
<td>16</td>
<td>There is insufficient result space to convert a smallmoney value to %ls.</td>
</tr>
<tr>
<td>293</td>
<td>16</td>
<td>Cannot convert char value to smallmoney. The char value has incorrect syntax.</td>
</tr>
<tr>
<td>294</td>
<td>16</td>
<td>The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.</td>
</tr>
<tr>
<td>295</td>
<td>16</td>
<td>Conversion failed when converting character string to smalldatetime data type.</td>
</tr>
<tr>
<td>297</td>
<td>16</td>
<td>The user does not have permission to perform this action.</td>
</tr>
<tr>
<td>300</td>
<td>14</td>
<td>%ls permission was denied on object ‘%.*ls’, database ‘%.*ls’.</td>
</tr>
<tr>
<td>301</td>
<td>16</td>
<td>Query contains an outer-join request that is not permitted.</td>
</tr>
<tr>
<td>302</td>
<td>16</td>
<td>The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type ‘uniqueidentifier’ in a CREATE TABLE or ALTER TABLE statement. It cannot be combined with other operators to form a complex scalar expression.</td>
</tr>
<tr>
<td>303</td>
<td>16</td>
<td>The table ‘%.*ls’ is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause.</td>
</tr>
<tr>
<td>304</td>
<td>16</td>
<td>‘%d’ is out of range for index option ‘%.*ls’. See sp_configure option ‘%ls’ for valid values.</td>
</tr>
<tr>
<td>305</td>
<td>16</td>
<td>The XML data type cannot be compared or sorted, except when using the IS NULL operator.</td>
</tr>
<tr>
<td>306</td>
<td>16</td>
<td>The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.</td>
</tr>
<tr>
<td>307</td>
<td>16</td>
<td>Index ID %d on table ‘%.*ls’ (specified in the FROM clause) does not exist.</td>
</tr>
<tr>
<td>308</td>
<td>16</td>
<td>Index ‘%.*ls’ on table ‘%.*ls’ (specified in the FROM clause) does not exist.</td>
</tr>
<tr>
<td>309</td>
<td>16</td>
<td>Cannot use index “%.*ls” on table “%.*ls” in a hint. XML indexes are not allowed in hints.</td>
</tr>
<tr>
<td>310</td>
<td>15</td>
<td>The value %d specified for the MAXRECURSION option exceeds the allowed maximum of %d.</td>
</tr>
<tr>
<td>311</td>
<td>16</td>
<td>Cannot use text, ntext, or image columns in the ‘inserted’ and ‘deleted’ tables.</td>
</tr>
<tr>
<td>312</td>
<td>16</td>
<td>Cannot reference text, ntext, or image columns in a filter stored procedure.</td>
</tr>
<tr>
<td>313</td>
<td>16</td>
<td>An insufficient number of arguments were supplied for the procedure or function %.*ls.</td>
</tr>
<tr>
<td>314</td>
<td>16</td>
<td>Cannot use GROUP BY ALL with the special tables INSERTED or DELETED.</td>
</tr>
<tr>
<td>315</td>
<td>16</td>
<td>Index “%.*ls” on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online.</td>
</tr>
<tr>
<td>316</td>
<td>16</td>
<td>The index ID %d on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online.</td>
</tr>
<tr>
<td>317</td>
<td>16</td>
<td>Table-valued function ‘%.*ls’ cannot have a column alias.</td>
</tr>
<tr>
<td>318</td>
<td>16</td>
<td>The table (and its columns) returned by a table-valued method need to be aliased.</td>
</tr>
<tr>
<td>319</td>
<td>16</td>
<td>Incorrect syntax near the keyword ‘with’. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.</td>
</tr>
<tr>
<td>320</td>
<td>16</td>
<td>The compile-time variable value for ‘%.*ls’ in the OPTIMIZE FOR clause must be a literal.</td>
</tr>
<tr>
<td>321</td>
<td>15</td>
<td>“%.*ls” is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.</td>
</tr>
<tr>
<td>322</td>
<td>15</td>
<td>The variable “%.*ls” is specified in the OPTIMIZE FOR clause, but is not used in the query.</td>
</tr>
<tr>
<td>323</td>
<td>16</td>
<td>The ‘COMPUTE’ clause is not allowed in a statement containing an INTERSECT or EXCEPT operator.</td>
</tr>
<tr>
<td>324</td>
<td>15</td>
<td>The ‘ALL’ version of the %.*ls operator is not supported.</td>
</tr>
<tr>
<td>325</td>
<td>15</td>
<td>Incorrect syntax near ‘%.*ls’. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.</td>
</tr>
<tr>
<td>326</td>
<td>16</td>
<td>Multi-part identifier ‘%.*ls’ is ambiguous. Both columns ‘%.*ls’ and ‘%.*ls’ exist.</td>
</tr>
<tr>
<td>327</td>
<td>16</td>
<td>Function call ‘%.*ls’ is ambiguous: both a user-defined function and a method call with this name exist.</td>
</tr>
<tr>
<td>328</td>
<td>16</td>
<td>A cursor plan could not be generated for the given statement because the textptr() function was used on a LOB column from one of the base tables.</td>
</tr>
<tr>
<td>329</td>
<td>16</td>
<td>Each GROUP BY expression must contain at least one column reference.</td>
</tr>
<tr>
<td>330</td>
<td>15</td>
<td>The target ‘%.*ls’ of the OUTPUT INTO clause cannot be a view or common table expression.</td>
</tr>
<tr>
<td>331</td>
<td>15</td>
<td>The target table ‘%.*ls’ of the OUTPUT INTO clause cannot have any enabled triggers.</td>
</tr>
<tr>
<td>332</td>
<td>15</td>
<td>The target table ‘%.*ls’ of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint ‘%ls’.</td>
</tr>
<tr>
<td>333</td>
<td>15</td>
<td>The target table ‘%.*ls’ of the OUTPUT INTO clause cannot have any enabled check constraints or any enabled rules. Found check constraint or rule ‘%ls’.</td>
</tr>
<tr>
<td>334</td>
<td>15</td>
<td>The target table ‘%.*ls’ of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.</td>
</tr>
<tr>
<td>335</td>
<td>16</td>
<td>Function call cannot be used to match a target table in the FROM clause of a DELETE or UPDATE statement. Use function name ‘%.*ls’ without parameters instead.</td>
</tr>
<tr>
<td>336</td>
<td>15</td>
<td>Incorrect syntax near ‘%.*ls’. If this is intended to be a common table expression, you need to explicitly terminate the previous statement with a semi-colon.</td>
</tr>
<tr>
<td>337</td>
<td>10</td>
<td>Warning: the floating point value ‘%.*ls’ is too small. It will be interpreted as 0.</td>
</tr>
<tr>
<td>338</td>
<td>16</td>
<td>READEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views, remote tables, and inserted or deleted tables inside triggers.</td>
</tr>
<tr>
<td>339</td>
<td>16</td>
<td>DEFAULT or NULL are not allowed as explicit identity values.</td>
</tr>
<tr>
<td>340</td>
<td>16</td>
<td>Cannot create the trigger “%.*ls” on view “%.*ls”. AFTER triggers cannot be created on views.</td>
</tr>
<tr>
<td>341</td>
<td>16</td>
<td>Replication filter procedures may not contain columns of large object, large value, XML or CLR type.</td>
</tr>
<tr>
<td>342</td>
<td>16</td>
<td>Column “%.*ls” is not allowed in this context, and the user-defined function or aggregate “%.*ls” could not be found.</td>
</tr>
<tr>
<td>343</td>
<td>15</td>
<td>Unknown object type ‘%.*ls’ used in a CREATE, DROP, or ALTER statement.</td>
</tr>
<tr>
<td>344</td>
<td>16</td>
<td>Remote function reference ‘%.*ls’ is not allowed, and the column name ‘%.*ls’ could not be found or is ambiguous.</td>
</tr>
<tr>
<td>345</td>
<td>16</td>
<td>Function ‘%.*ls’ is not allowed in the OUTPUT clause, because it performs user or system data access, or is assumed to perform this access. A function is assumed by default to perform data access if it is not schemabound.</td>
</tr>
<tr>
<td>346</td>
<td>15</td>
<td>The parameter “%.*ls” can not be declared READONLY since it is not a table-valued parameter.</td>
</tr>
<tr>
<td>347</td>
<td>16</td>
<td>The table-valued parameter “%.*ls” cannot be declared as an OUTPUT parameter.</td>
</tr>
<tr>
<td>348</td>
<td>16</td>
<td>The table variable “%.*ls” can not be passed to a stored procedure with the OUTPUT option.</td>
</tr>
<tr>
<td>349</td>
<td>16</td>
<td>The procedure “%.*ls” has no parameter named “%.*ls”.</td>
</tr>
<tr>
<td>350</td>
<td>16</td>
<td>The column “%.*ls” does not have a valid data type. A column cannot be of a user-defined table type.</td>
</tr>
<tr>
<td>351</td>
<td>16</td>
<td>Column, parameter, or variable %.*ls. : Cannot find data type %.*ls.</td>
</tr>
<tr>
<td>352</td>
<td>15</td>
<td>The table-valued parameter “%.*ls” must be declared with the READONLY option.</td>
</tr>
<tr>
<td>353</td>
<td>16</td>
<td>Function ‘%.*ls’ is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. This is because the function performs user or system data access, or is assumed to perform this access. By default, a f</td>
</tr>
<tr>
<td>354</td>
<td>16</td>
<td>The target ‘%.*ls’ of the INSERT statement cannot be a view or common table expression when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.</td>
</tr>
<tr>
<td>355</td>
<td>16</td>
<td>The target table ‘%.*ls’ of the INSERT statement cannot have any enabled triggers when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.</td>
</tr>
<tr>
<td>356</td>
<td>16</td>
<td>The target table ‘%.*ls’ of the INSERT statement cannot be on either side of a (primary key, foreign key) relationship when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found reference constraint ‘%ls’.</td>
</tr>
<tr>
<td>357</td>
<td>16</td>
<td>The target table ‘%.*ls’ of the INSERT statement cannot have any enabled rules when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found rule ‘%ls’.</td>
</tr>
<tr>
<td>358</td>
<td>16</td>
<td>The target table ‘%.*ls’ of the MERGE statement cannot have any enabled rules. Found rule ‘%ls’.</td>
</tr>
<tr>
<td>359</td>
<td>16</td>
<td>The target ‘%.*ls’ of an OUTPUT INTO clause has an index with the ignore_dup_key option and cannot be used when an OUTPUT clause is also used.</td>
</tr>
<tr>
<td>360</td>
<td>16</td>
<td>The target column list of an INSERT, UPDATE, or MERGE statement cannot contain both a sparse column and the column set that contains the sparse column. Rewrite the statement to include either the sparse column or the column set, but not both.</td>
</tr>
<tr>
<td>361</td>
<td>16</td>
<td>The number of target columns that are specified in an INSERT, UPDATE, or MERGE statement exceeds the maximum of %d. This total number includes identity, timestamp, and columns that have default values. To correct this error, change the query to target a s</td>
</tr>
<tr>
<td>362</td>
<td>16</td>
<td>The query processor could not produce a query plan because the name ‘%.*ls’ in the FORCESEEK hint on table or view ‘%.*ls’ did not match the key column names of the index ‘%.*ls’.</td>
</tr>
<tr>
<td>363</td>
<td>16</td>
<td>The query processor could not produce a query plan because the FORCESEEK hint on table or view ‘%.*ls’ cannot be used with the %S_MSG specified by index ‘%.*ls’.</td>
</tr>
<tr>
<td>364</td>
<td>16</td>
<td>The query processor could not produce a query plan because the FORCESEEK hint on view ‘%.*ls’ is used without a NOEXPAND hint. Resubmit the query with the NOEXPAND hint or remove the FORCESEEK hint on the view.</td>
</tr>
<tr>
<td>365</td>
<td>16</td>
<td>The query processor could not produce a query plan because the FORCESEEK hint on table or view ‘%.*ls’ specified more seek columns than the number of key columns in index ‘%.*ls’. </td>
</tr>
<tr>
<td>401</td>
<td>16</td>
<td>Unimplemented statement or expression %ls.</td>
</tr>
<tr>
<td>402</td>
<td>16</td>
<td>The data types %s and %s are incompatible in the %s operator.</td>
</tr>
<tr>
<td>403</td>
<td>16</td>
<td>Invalid operator for data type. Operator equals %ls, type equals %ls.</td>
</tr>
<tr>
<td>404</td>
<td>16</td>
<td>The column reference “inserted.%.*ls” is not allowed because it refers to a base table that is not being modified in this statement.</td>
</tr>
<tr>
<td>405</td>
<td>16</td>
<td>A remote table cannot be used as a DML target in a statement which includes an OUTPUT clause or a nested DML statement.</td>
</tr>
<tr>
<td>406</td>
<td>16</td>
<td>%ls cannot be used in the PIVOT operator because it is not invariant to NULLs.</td>
</tr>
<tr>
<td>407</td>
<td>16</td>
<td>Internal error. The string routine in file %hs, line %d failed with HRESULT 0x%x.</td>
</tr>
<tr>
<td>408</td>
<td>16</td>
<td>A constant expression was encountered in the ORDER BY list, position %i.</td>
</tr>
<tr>
<td>411</td>
<td>16</td>
<td>COMPUTE clause #%d, aggregate expression #%d is not in the select list.</td>
</tr>
<tr>
<td>412</td>
<td>16</td>
<td>The column “%.*ls” is not updatable because it is derived or constant.</td>
</tr>
<tr>
<td>413</td>
<td>16</td>
<td>Correlated parameters or sub-queries are not supported by the inline function “%.*ls”.</td>
</tr>
<tr>
<td>414</td>
<td>16</td>
<td>UPDATE is not allowed because the statement updates view “%.*ls” which participates in a join and has an INSTEAD OF UPDATE trigger.</td>
</tr>
<tr>
<td>415</td>
<td>16</td>
<td>DELETE is not allowed because the statement updates view “%.*ls” which participates in a join and has an INSTEAD OF DELETE trigger.</td>
</tr>
<tr>
<td>416</td>
<td>16</td>
<td>The service queue “%.*ls” cannot be directly updated.</td>
</tr>
<tr>
<td>417</td>
<td>16</td>
<td>TOP is not allowed in an UPDATE or DELETE statement against a partitioned view.</td>
</tr>
<tr>
<td>418</td>
<td>16</td>
<td>Objects exposing CLR type columns are not allowed in distributed queries. Use a pass-through query to access the remote object ‘%.*ls’.</td>
</tr>
<tr>
<td>421</td>
<td>16</td>
<td>The %ls data type cannot be selected as DISTINCT because it is not comparable.</td>
</tr>
<tr>
<td>422</td>
<td>16</td>
<td>Common table expression defined but not used.</td>
</tr>
<tr>
<td>423</td>
<td>16</td>
<td>Xml data type methods are not supported in check constraints. Create a scalar user-defined function to wrap the method invocation. The error occurred at table “%.*ls”.</td>
</tr>
<tr>
<td>424</td>
<td>16</td>
<td>Xml data type methods are not supported in computed column definitions of table variables and return tables of table-valued functions. The error occurred at column “%.*ls”, table “%.*ls”, in the %ls statement.</td>
</tr>
<tr>
<td>425</td>
<td>16</td>
<td>Data type %ls of receiving variable is not equal to the data type %ls of column ‘%.*ls’.</td>
</tr>
<tr>
<td>426</td>
<td>16</td>
<td>The length %d of the receiving variable is less than the length %d of the column ‘%.*ls’.</td>
</tr>
<tr>
<td>427</td>
<td>20</td>
<td>Could not load the definition for constraint ID %d in database ID %d. Run DBCC CHECKCATALOG to verify the integrity of the database.</td>
</tr>
<tr>
<td>428</td>
<td>16</td>
<td>Insert bulk cannot be used in a multi-statement batch.</td>
</tr>
<tr>
<td>432</td>
<td>16</td>
<td>Xml data type methods are not supported in check constraints anymore. Please drop the constraint or create a scalar user-defined function to wrap the method invocation. The error occurred at table “%.*ls”.</td>
</tr>
<tr>
<td>434</td>
<td>16</td>
<td>Function ‘%ls’ is not allowed in the OUTPUT clause.</td>
</tr>
<tr>
<td>435</td>
<td>16</td>
<td>Xml data type methods are not supported in computed column definitions. Create a scalar user-defined function to wrap the method invocation. The error occurred at column “%.*ls”, table “%.*ls”, in the %ls statement.</td>
</tr>
<tr>
<td>438</td>
<td>16</td>
<td>Xml data type methods are not allowed in rules. The error occurred at table “%.*ls”.</td>
</tr>
<tr>
<td>440</td>
<td>16</td>
<td>Internal query compilation error. The stack overflow could not be handled.</td>
</tr>
<tr>
<td>441</td>
<td>16</td>
<td>Cannot use the ‘%ls’ function on a remote data source.</td>
</tr>
<tr>
<td>442</td>
<td>16</td>
<td>The NEST argument must be a column reference. Expressions are not allowed.</td>
</tr>
<tr>
<td>443</td>
<td>16</td>
<td>Invalid use of a side-effecting operator ‘%s’ within a function.</td>
</tr>
<tr>
<td>444</td>
<td>16</td>
<td>Select statements included within a function cannot return data to a client.</td>
</tr>
<tr>
<td>445</td>
<td>16</td>
<td>COLLATE clause cannot be used on expressions containing a COLLATE clause.</td>
</tr>
<tr>
<td>446</td>
<td>16</td>
<td>Cannot resolve collation conflict for %ls operation.</td>
</tr>
<tr>
<td>447</td>
<td>16</td>
<td>Expression type %ls is invalid for COLLATE clause.</td>
</tr>
<tr>
<td>448</td>
<td>16</td>
<td>Invalid collation ‘%.*ls’.</td>
</tr>
<tr>
<td>449</td>
<td>16</td>
<td>Collation conflict caused by collate clauses with different collation ‘%.*ls’ and ‘%.*ls’.</td>
</tr>
<tr>
<td>450</td>
<td>16</td>
<td>Code page translations are not supported for the text data type. From: %d To: %d.</td>
</tr>
<tr>
<td>451</td>
<td>16</td>
<td>Cannot resolve collation conflict for column %d in %ls statement.</td>
</tr>
<tr>
<td>452</td>
<td>16</td>
<td>COLLATE clause cannot be used on user-defined data types.</td>
</tr>
<tr>
<td>453</td>
<td>16</td>
<td>Collation ‘%.*ls’ is supported on Unicode data types only and cannot be set at the database or server level.</td>
</tr>
<tr>
<td>454</td>
<td>16</td>
<td>The UNNEST argument must be a nested table column.</td>
</tr>
<tr>
<td>455</td>
<td>16</td>
<td>The last statement included within a function must be a return statement.</td>
</tr>
<tr>
<td>456</td>
<td>16</td>
<td>Implicit conversion of %ls value to %ls cannot be performed because the resulting collation is unresolved due to collation conflict.</td>
</tr>
<tr>
<td>457</td>
<td>16</td>
<td>Implicit conversion of %ls value to %ls cannot be performed because the collation of the value is unresolved due to a collation conflict.</td>
</tr>
<tr>
<td>458</td>
<td>16</td>
<td>Cannot create the SELECT INTO target table “%.*ls” because the xml column “%.*ls” is typed with a schema collection “%.*ls” from database “%.*ls”. Xml columns cannot refer to schemata across databases.</td>
</tr>
<tr>
<td>459</td>
<td>16</td>
<td>Collation ‘%.*ls’ is supported on Unicode data types only and cannot be applied to char, varchar or text data types.</td>
</tr>
<tr>
<td>460</td>
<td>16</td>
<td>DISTINCT operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.</td>
</tr>
<tr>
<td>461</td>
<td>16</td>
<td>TOP operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.</td>
</tr>
<tr>
<td>462</td>
<td>16</td>
<td>Outer join is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.</td>
</tr>
<tr>
<td>463</td>
<td>16</td>
<td>Functions with parameters are not allowed in the recursive part of a recursive common table expression ‘%.*ls’.</td>
</tr>
<tr>
<td>464</td>
<td>16</td>
<td>Functions with side effects are not allowed in the recursive part of a recursive common table expression ‘%.*ls’.</td>
</tr>
<tr>
<td>465</td>
<td>16</td>
<td>Recursive references are not allowed in subqueries.</td>
</tr>
<tr>
<td>466</td>
<td>16</td>
<td>UNION operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.</td>
</tr>
<tr>
<td>467</td>
<td>16</td>
<td>GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression ‘%.*ls’.</td>
</tr>
<tr>
<td>468</td>
<td>16</td>
<td>Cannot resolve the collation conflict between “%.*ls” and “%.*ls” in the %ls operation.</td>
</tr>
<tr>
<td>469</td>
<td>16</td>
<td>An explicit column list must be specified for target table ‘%.*ls’ when table hint KEEPIDENTITY is used and the table contains an identity column.</td>
</tr>
<tr>
<td>470</td>
<td>16</td>
<td>The synonym “%.*ls” referenced synonym “%.*ls”. Synonym chaining is not allowed.</td>
</tr>
<tr>
<td>471</td>
<td>16</td>
<td>Only one of the three options, SINGLE_BLOB, SINGLE_CLOB or SINGLE_NCLOB, can be specified.</td>
</tr>
<tr>
<td>472</td>
<td>16</td>
<td>Either a format file or one of the three options SINGLE_BLOB, SINGLE_CLOB, or SINGLE_NCLOB must be specified.</td>
</tr>
<tr>
<td>473</td>
<td>16</td>
<td>The incorrect value “%.*ls” is supplied in the PIVOT operator.</td>
</tr>
<tr>
<td>474</td>
<td>16</td>
<td>Unable to load the computed column definitions for table “%.*ls”.</td>
</tr>
<tr>
<td>475</td>
<td>16</td>
<td>Invalid SAMPLE clause. Only table names in the FROM clause of SELECT, UPDATE, and DELETE queries may be sampled.</td>
</tr>
<tr>
<td>476</td>
<td>16</td>
<td>Invalid PERCENT tablesample size “%f” for table “%.*ls”. The PERCENT tablesample size must be between 0 and 100.</td>
</tr>
<tr>
<td>477</td>
<td>16</td>
<td>Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be an integer.</td>
</tr>
<tr>
<td>478</td>
<td>16</td>
<td>The TABLESAMPLE clause cannot be used in a view definition or inline table function definition.</td>
</tr>
<tr>
<td>479</td>
<td>16</td>
<td>Invalid ROWS value or REPEATABLE seed “%I64d” in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be greater than 0.</td>
</tr>
<tr>
<td>480</td>
<td>16</td>
<td>The TABLESAMPLE clause cannot be used with the table function “%.*ls”.</td>
</tr>
<tr>
<td>481</td>
<td>16</td>
<td>The TABLESAMPLE clause cannot be used with the linked server table “%.*ls”.</td>
</tr>
<tr>
<td>482</td>
<td>16</td>
<td>Non-constant or invalid expression is in the TABLESAMPLE or the REPEATABLE clause.</td>
</tr>
<tr>
<td>483</td>
<td>16</td>
<td>The OUTPUT clause cannot be used in an INSERT…EXEC statement.</td>
</tr>
<tr>
<td>484</td>
<td>16</td>
<td>Cannot declare more than %d local variables.</td>
</tr>
<tr>
<td>485</td>
<td>16</td>
<td>Views and inline functions cannot return xml columns that are typed with a schema collection registered in a database other than current. Column “%.*ls” is typed with the schema collection “%.*ls”, which is registered in database “%.*ls”.</td>
</tr>
<tr>
<td>486</td>
<td>16</td>
<td>“%.*ls” does not allow specifying a schema name as a prefix to the assembly name.</td>
</tr>
<tr>
<td>487</td>
<td>16</td>
<td>An invalid option was specified for the statement “%.*ls”.</td>
</tr>
<tr>
<td>488</td>
<td>16</td>
<td>%s columns must be comparable. The type of column “%.*ls” is “%s”, which is not comparable.</td>
</tr>
<tr>
<td>489</td>
<td>16</td>
<td>The OUTPUT clause cannot be specified because the target view “%.*ls” is a partitioned view.</td>
</tr>
<tr>
<td>490</td>
<td>16</td>
<td>The resync functionality is temporarily disabled.</td>
</tr>
<tr>
<td>491</td>
<td>16</td>
<td>A correlation name must be specified for the bulk rowset in the from clause.</td>
</tr>
<tr>
<td>492</td>
<td>16</td>
<td>Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name “%.*ls” is a duplicate.</td>
</tr>
<tr>
<td>493</td>
<td>16</td>
<td>The column ‘%.*ls’ that was returned from the nodes() method cannot be used directly. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.</td>
</tr>
<tr>
<td>494</td>
<td>16</td>
<td>The TABLESAMPLE clause can only be used with local tables.</td>
</tr>
<tr>
<td>495</td>
<td>16</td>
<td>The return table column “%.*ls” is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata.</td>
</tr>
<tr>
<td>496</td>
<td>16</td>
<td>The parameter “%.*ls” is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata.</td>
</tr>
<tr>
<td>497</td>
<td>16</td>
<td>Variables are not allowed in the TABLESAMPLE or REPEATABLE clauses.</td>
</tr>
<tr>
<td>498</td>
<td>16</td>
<td>Invalid value in the TABLESAMPLE or the REPEATABLE clause.</td>
</tr>
<tr>
<td>499</td>
<td>16</td>
<td>Invalid parameter for the getchecksum function.</td>
</tr>
<tr>
<td>500</td>
<td>16</td>
<td>Trying to pass a table-valued parameter with %d column(s) where the corresponding user-defined table type requires %d column(s).</td>
</tr>
<tr>
<td>505</td>
<td>16</td>
<td>The current user account was invoked with SETUSER or SP_SETAPPROLE. Changing databases is not allowed.</td>
</tr>
<tr>
<td>506</td>
<td>16</td>
<td>The invalid escape character “%.*ls” was specified in a %ls predicate.</td>
</tr>
<tr>
<td>507</td>
<td>16</td>
<td>Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.</td>
</tr>
<tr>
<td>509</td>
<td>11</td>
<td>User name ‘%.*ls’ not found.</td>
</tr>
<tr>
<td>510</td>
<td>16</td>
<td>Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.</td>
</tr>
<tr>
<td>511</td>
<td>16</td>
<td>Cannot create a row of size %d which is greater than the allowable maximum row size of %d.</td>
</tr>
<tr>
<td>512</td>
<td>16</td>
<td>Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.</td>
</tr>
<tr>
<td>513</td>
<td>16</td>
<td>A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database ‘%.*ls’, table ‘%.*ls’, column ‘%.*ls’.</td>
</tr>
<tr>
<td>515</td>
<td>16</td>
<td>Cannot insert the value NULL into column ‘%.*ls’, table ‘%.*ls’; column does not allow nulls. %ls fails.</td>
</tr>
<tr>
<td>517</td>
<td>16</td>
<td>Adding a value to a ‘%ls’ column caused an overflow.</td>
</tr>
<tr>
<td>518</td>
<td>16</td>
<td>Cannot convert data type %ls to %ls.</td>
</tr>
<tr>
<td>522</td>
<td>16</td>
<td>The WAITFOR thread was evicted.</td>
</tr>
<tr>
<td>523</td>
<td>16</td>
<td>A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active.</td>
</tr>
<tr>
<td>524</td>
<td>16</td>
<td>A trigger returned a resultset and the server option ‘disallow results from triggers’ is true.</td>
</tr>
<tr>
<td>525</td>
<td>16</td>
<td>The column that was returned from the nodes() method cannot be converted to the data type %ls. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.</td>
</tr>
<tr>
<td>526</td>
<td>16</td>
<td>%ls of XML types constrained by different XML schema collections and/or DOCUMENT/CONTENT option is not allowed. Use the CONVERT function to run this query.</td>
</tr>
<tr>
<td>527</td>
<td>16</td>
<td>Implicit conversion between XML types constrained by different XML schema collections is not allowed. Use the CONVERT function to run this query.</td>
</tr>
<tr>
<td>529</td>
<td>16</td>
<td>Explicit conversion from data type %ls to %ls is not allowed.</td>
</tr>
<tr>
<td>530</td>
<td>16</td>
<td>The statement terminated. The maximum recursion %d has been exhausted before statement completion.</td>
</tr>
<tr>
<td>531</td>
<td>10</td>
<td>Cannot set NOCOUNT to OFF inside the trigger execution because the server option “disallow_results_from_triggers” is true or we are inside LOGON trigger execution.</td>
</tr>
<tr>
<td>532</td>
<td>16</td>
<td>The timestamp (changed to %S_TS) shows that the row has been updated by another user.</td>
</tr>
<tr>
<td>533</td>
<td>10</td>
<td>Cannot set XACT ABORT to OFF inside the trigger execution unless the database compatibility is 90.</td>
</tr>
<tr>
<td>534</td>
<td>16</td>
<td>‘%.*ls’ failed because it is not supported in the edition of this SQL Server instance ‘%.*ls’. See books online for more details on feature support in different SQL Server editions.</td>
</tr>
<tr>
<td>535</td>
<td>16</td>
<td>The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.</td>
</tr>
<tr>
<td>536</td>
<td>16</td>
<td>Invalid length parameter passed to the %ls function.</td>
</tr>
<tr>
<td>537</td>
<td>16</td>
<td>Invalid length parameter passed to the LEFT or SUBSTRING function.</td>
</tr>
<tr>
<td>539</td>
<td>16</td>
<td>Schema changed after the target table was created. Rerun the Select Into query.</td>
</tr>
<tr>
<td>540</td>
<td>16</td>
<td>There is insufficient system memory to run RAISERROR.</td>
</tr>
<tr>
<td>541</td>
<td>16</td>
<td>There is not enough stack to execute the statement</td>
</tr>
<tr>
<td>542</td>
<td>16</td>
<td>An invalid datetime value was encountered. Value exceeds the year 9999.</td>
</tr>
<tr>
<td>543</td>
<td>16</td>
<td>Creation of a return table failed for the table valued function ‘%.*ls’.</td>
</tr>
<tr>
<td>544</td>
<td>16</td>
<td>Cannot insert explicit value for identity column in table ‘%.*ls’ when IDENTITY_INSERT is set to OFF.</td>
</tr>
<tr>
<td>545</td>
<td>16</td>
<td>Explicit value must be specified for identity column in table ‘%.*ls’ either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.</td>
</tr>
<tr>
<td>547</td>
<td>16</td>
<td>The %ls statement conflicted with the %ls constraint “%.*ls”. The conflict occurred in database “%.*ls”, table “%.*ls”%ls%.*ls%ls.</td>
</tr>
<tr>
<td>548</td>
<td>16</td>
<td>The insert failed. It conflicted with an identity range check constraint in database ‘%.*ls’, replicated table ‘%.*ls’%ls%.*ls%ls. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_a</td>
</tr>
<tr>
<td>549</td>
<td>16</td>
<td>The collation ‘%.*ls’ of receiving variable is not equal to the collation ‘%.*ls’ of column ‘%.*ls’.</td>
</tr>
<tr>
<td>550</td>
<td>16</td>
<td>The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.</td>
</tr>
<tr>
<td>552</td>
<td>16</td>
<td>CryptoAPI function ‘%ls’ failed. Error 0x%x: %ls</td>
</tr>
<tr>
<td>555</td>
<td>16</td>
<td>User-defined functions are not yet enabled.</td>
</tr>
<tr>
<td>556</td>
<td>16</td>
<td>INSERT EXEC failed because the stored procedure altered the schema of the target table.</td>
</tr>
<tr>
<td>557</td>
<td>16</td>
<td>Only functions and some extended stored procedures can be executed from within a function.</td>
</tr>
<tr>
<td>558</td>
<td>16</td>
<td>Remote function calls are not allowed within a function.</td>
</tr>
<tr>
<td>561</td>
<td>16</td>
<td>Failed to access file ‘%.*ls’</td>
</tr>
<tr>
<td>562</td>
<td>16</td>
<td>Failed to access file ‘%.*ls’. Files can be accessed only through shares</td>
</tr>
<tr>
<td>563</td>
<td>14</td>
<td>The transaction for the INSERT EXEC statement has been rolled back. The INSERT EXEC operation will be terminated.</td>
</tr>
<tr>
<td>564</td>
<td>16</td>
<td>Attempted to create a record with a fixed length of ‘%d’. Maximum allowable fixed length is ‘%d’.</td>
</tr>
<tr>
<td>565</td>
<td>18</td>
<td>A stack overflow occurred in the server while compiling the query. Please simplify the query.</td>
</tr>
<tr>
<td>566</td>
<td>21</td>
<td>An error occurred while writing an audit trace. SQL Server is shutting down. Check and correct error conditions such as insufficient disk space, and then restart SQL Server. If the problem persists, disable auditing by starting the server at the command p</td>
</tr>
<tr>
<td>567</td>
<td>16</td>
<td>File ‘%.*ls’ either does not exist or is not a recognizable trace file. Or there was an error opening the file.</td>
</tr>
<tr>
<td>568</td>
<td>16</td>
<td>Encountered an error or an unexpected end of trace file ‘%.*ls’.</td>
</tr>
<tr>
<td>569</td>
<td>16</td>
<td>The handle that was passed to %ls was invalid.</td>
</tr>
<tr>
<td>570</td>
<td>15</td>
<td>INSTEAD OF triggers do not support direct recursion. The trigger execution failed.</td>
</tr>
<tr>
<td>571</td>
<td>16</td>
<td>The specified attribute value for %ls is invalid.</td>
</tr>
<tr>
<td>572</td>
<td>16</td>
<td>Invalid regular expression “%.*ls” near the offset %d.</td>
</tr>
<tr>
<td>573</td>
<td>16</td>
<td>Evaluation of the regular expression is too complex: ‘%.*ls’.</td>
</tr>
<tr>
<td>574</td>
<td>16</td>
<td>%ls statement cannot be used inside a user transaction.</td>
</tr>
<tr>
<td>575</td>
<td>16</td>
<td>A LOGON trigger returned a resultset. Modify the LOGON trigger to not return resultsets.</td>
</tr>
<tr>
<td>576</td>
<td>16</td>
<td>Cannot create a row that has sparse data of size %d which is greater than the allowable maximum sparse data size of %d.</td>
</tr>
<tr>
<td>577</td>
<td>16</td>
<td>The value provided for the timeout is not valid. Timeout must be a valid integer between 0 and 2147483647.</td>
</tr>
<tr>
<td>578</td>
<td>16</td>
<td>Insert Exec not allowed in WAITFOR queries.</td>
</tr>
<tr>
<td>579</td>
<td>16</td>
<td>Can not execute WAITFOR query with snapshot isolation level.</td>
</tr>
<tr>
<td>582</td>
<td>16</td>
<td>Offset is greater than the length of the column to be updated in write.</td>
</tr>
<tr>
<td>583</td>
<td>16</td>
<td>Negative offset or length in write.</td>
</tr>
<tr>
<td>584</td>
<td>16</td>
<td>Select Into not allowed in WAITFOR queries.</td>
</tr>
<tr>
<td>585</td>
<td>16</td>
<td>Changing database context is not allowed when populating the resource database.</td>
</tr>
<tr>
<td>587</td>
<td>16</td>
<td>An invalid delayed CLR type fetch token is provided.</td>
</tr>
<tr>
<td>588</td>
<td>16</td>
<td>Multiple tasks within the session are using the same delayed CLR type fetch token at the same time.</td>
</tr>
<tr>
<td>589</td>
<td>16</td>
<td>This statement has attempted to access data whose access is restricted by the assembly.</td>
</tr>
<tr>
<td>590</td>
<td>16</td>
<td>RPC was aborted without execution.</td>
</tr>
<tr>
<td>591</td>
<td>16</td>
<td>%ls: The formal parameter “%ls” was defined as OUTPUT, but the actual parameter was not declared as OUTPUT.</td>
</tr>
<tr>
<td>592</td>
<td>16</td>
<td>Cannot find %S_MSG ID %d in database ID %d.</td>
</tr>
<tr>
<td>593</td>
<td>10</td>
<td>fn_trace_gettable: XML conversion of trace data for event 165 failed.</td>
</tr>
<tr>
<td>594</td>
<td>10</td>
<td>fn_trace_gettable: XML conversion of trace data is not supported in fiber mode.</td>
</tr>
<tr>
<td>595</td>
<td>16</td>
<td>Bulk Insert with another outstanding result set should be run with XACT_ABORT on.</td>
</tr>
<tr>
<td>596</td>
<td>16</td>
<td>Cannot continue the execution because the session is in the kill state.</td>
</tr>
<tr>
<td>597</td>
<td>16</td>
<td>The execution of in-proc data access is being terminated due to errors in the User Datagram Protocol (UDP).</td>
</tr>
<tr>
<td>598</td>
<td>16</td>
<td>An error occurred while executing CREATE/ALTER DB. Please look at the previous error for more information.</td>
</tr>
<tr>
<td>599</td>
<td>16</td>
<td>%.*ls: The length of the result exceeds the length limit (2GB) of the target large type.</td>
</tr>
<tr>
<td>601</td>
<td>12</td>
<td>Could not continue scan with NOLOCK due to data movement.</td>
</tr>
<tr>
<td>602</td>
<td>21</td>
<td>Could not find an entry for table or index with partition ID %I64d in database %d. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB.</td>
</tr>
<tr>
<td>603</td>
<td>21</td>
<td>Could not find an entry for table or index with object ID %d (partition ID %I64d) in database %d. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHE</td>
</tr>
<tr>
<td>605</td>
<td>21</td>
<td>Attempt to fetch logical page %S_PGID in database %d failed. It belongs to allocation unit %I64d not to %I64d.</td>
</tr>
<tr>
<td>606</td>
<td>21</td>
<td>Metadata inconsistency. Filegroup id %ld specified for table ‘%.*ls’ does not exist. Run DBCC CHECKDB or CHECKCATALOG.</td>
</tr>
<tr>
<td>608</td>
<td>16</td>
<td>No catalog entry found for partition ID %I64d in database %d. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.</td>
</tr>
<tr>
<td>609</td>
<td>16</td>
<td>BTree is not empty when waking up on RowsetBulk.</td>
</tr>
<tr>
<td>610</td>
<td>16</td>
<td>Invalid header value from a page. Run DBCC CHECKDB to check for a data corruption.</td>
</tr>
<tr>
<td>611</td>
<td>16</td>
<td>Cannot insert or update a row because total variable column size, including overhead, is %d bytes more than the limit.</td>
</tr>
<tr>
<td>613</td>
<td>21</td>
<td>Could not find an entry for worktable rowset with partition ID %I64d in database %d. </td>
</tr>
<tr>
<td>615</td>
<td>21</td>
<td>Could not find database ID %d, name ‘%.*ls’. The database may be offline. Wait a few minutes and try again.</td>
</tr>
<tr>
<td>617</td>
<td>20</td>
<td>Descriptor for object ID %ld in database ID %d not found in the hash table during attempt to unhash it. A work table is missing an entry. Rerun the query. If a cursor is involved, close and reopen the cursor.</td>
</tr>
<tr>
<td>622</td>
<td>16</td>
<td>The filegroup “%.*ls” has no files assigned to it. Tables, indexes, text columns, ntext columns, and image columns cannot be populated on this filegroup until a file is added.</td>
</tr>
<tr>
<td>627</td>
<td>16</td>
<td>Cannot use SAVE TRANSACTION within a distributed transaction.</td>
</tr>
<tr>
<td>628</td>
<td>16</td>
<td>Cannot issue SAVE TRANSACTION when there is no active transaction.</td>
</tr>
<tr>
<td>650</td>
<td>16</td>
<td>You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.</td>
</tr>
<tr>
<td>651</td>
<td>16</td>
<td>Cannot use the %ls granularity hint on the table “%.*ls” because locking at the specified granularity is inhibited.</td>
</tr>
<tr>
<td>652</td>
<td>16</td>
<td>The index “%.*ls” for table “%.*ls” (RowsetId %I64d) resides on a read-only filegroup (“%.*ls”), which cannot be modified.</td>
</tr>
<tr>
<td>656</td>
<td>10</td>
<td>The partitioning function ‘%.*ls’ creates %d partitions, which prevents removal of increased partitions support.</td>
</tr>
<tr>
<td>657</td>
<td>16</td>
<td>Could not disable support for increased partitions in database ‘%.*ls’ because %S_MSG.</td>
</tr>
<tr>
<td>658</td>
<td>16</td>
<td>Could not enable support for increased partitions in database ‘%.*ls’ because %S_MSG.</td>
</tr>
<tr>
<td>666</td>
<td>16</td>
<td>The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID %I64d. Dropping and re-creating the index may resolve this; otherwise, use another clustering key.</td>
</tr>
<tr>
<td>667</td>
<td>16</td>
<td>The index “%.*ls” for table “%.*ls” (RowsetId %I64d) resides on a filegroup (“%.*ls”) that cannot be accessed because it is offline, is being restored, or is defunct.</td>
</tr>
<tr>
<td>669</td>
<td>22</td>
<td>The row object is inconsistent. Please rerun the query.</td>
</tr>
<tr>
<td>670</td>
<td>16</td>
<td>Large object (LOB) data for table “%.*ls” resides on an offline filegroup (“%.*ls”) that cannot be accessed.</td>
</tr>
<tr>
<td>671</td>
<td>16</td>
<td>Large object (LOB) data for table “%.*ls” resides on a read-only filegroup (“%.*ls”), which cannot be modified.</td>
</tr>
<tr>
<td>672</td>
<td>10</td>
<td>Failed to queue cleanup packets for orphaned rowsets in database “%.*ls”. Some disk space may be wasted. Cleanup will be attempted again on database restart.</td>
</tr>
<tr>
<td>674</td>
<td>10</td>
<td>Exception occurred in destructor of RowsetNewSS 0x%p. This error may indicate a problem related to releasing pre-allocated disk blocks used during bulk-insert operations. Restart the server to resolve this problem.</td>
</tr>
<tr>
<td>675</td>
<td>10</td>
<td>Worktable with partition ID %I64d was dropped successfully after repeated attempts.</td>
</tr>
<tr>
<td>676</td>
<td>10</td>
<td>Error occurred while attempting to drop worktable with partition ID %I64d.</td>
</tr>
<tr>
<td>677</td>
<td>10</td>
<td>Unable to drop worktable with partition ID %I64d after repeated attempts. Worktable is marked for deferred drop. This is an informational message only. No user action is required.</td>
</tr>
<tr>
<td>678</td>
<td>10</td>
<td>Active rowset for partition ID %I64d found at the end of the batch. This error may indicate incorrect exception handling. Use the current activity window in SQL Server Management Studio or the Transact-SQL KILL statement to terminate the server process id</td>
</tr>
<tr>
<td>679</td>
<td>16</td>
<td>One of the partitions of index ‘%.*ls’ for table ‘%.*ls’(partition ID %I64d) resides on a filegroup (“%.*ls”) that cannot be accessed because it is offline, restoring, or defunct. This may limit the query result.</td>
</tr>
<tr>
<td>680</td>
<td>10</td>
<td>Error [%d, %d, %d] occurred while attempting to drop allocation unit ID %I64d belonging to worktable with partition ID %I64d.</td>
</tr>
<tr>
<td>681</td>
<td>16</td>
<td>Attempting to set a non-NULL-able column’s value to NULL.</td>
</tr>
<tr>
<td>682</td>
<td>16</td>
<td>Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.</td>
</tr>
<tr>
<td>683</td>
<td>22</td>
<td>An internal error occurred while trying to convert between variable-length and fixed-length decimal formats. Run DBCC CHECKDB to check for any database corruption.</td>
</tr>
<tr>
<td>684</td>
<td>22</td>
<td>An internal error occurred while attempting to convert between compressed and uncompressed storage formats. Run DBCC CHECKDB to check for any corruption.</td>
</tr>
<tr>
<td>685</td>
<td>22</td>
<td>An internal error occurred while attempting to retrieve a backpointer for a heap forwarded record.</td>
</tr>
<tr>
<td>686</td>
<td>16</td>
<td>Cannot compress a nchar or nvarchar column that has an odd number of bytes.</td>
</tr>
<tr>
<td>701</td>
<td>19</td>
<td>There is insufficient system memory in resource pool ‘%ls’ to run this query.</td>
</tr>
<tr>
<td>708</td>
<td>10</td>
<td>Server is running low on virtual address space or machine is running low on virtual memory. Reserved memory used %d times since startup. Cancel query and re-run, decrease server load, or cancel other applications.</td>
</tr>
<tr>
<td>801</td>
<td>20</td>
<td>A buffer was encountered with an unexpected status of 0x%x.</td>
</tr>
<tr>
<td>802</td>
<td>17</td>
<td>There is insufficient memory available in the buffer pool.</td>
</tr>
<tr>
<td>803</td>
<td>10</td>
<td>simulated failure (DEBUG only)</td>
</tr>
<tr>
<td>805</td>
<td>10</td>
<td>restore pending</td>
</tr>
<tr>
<td>806</td>
<td>10</td>
<td>audit failure (a page read from disk failed to pass basic integrity checks)</td>
</tr>
<tr>
<td>807</td>
<td>10</td>
<td>(no disk or the wrong disk is in the drive)</td>
</tr>
<tr>
<td>808</td>
<td>10</td>
<td>insufficient bytes transferred</td>
</tr>
<tr>
<td>821</td>
<td>20</td>
<td>Could not unhash buffer at 0x%p with a buffer page number of %S_PGID and database ID %d with HASHED status set. The buffer was not found. %S_PAGE. Contact Technical Support.</td>
</tr>
<tr>
<td>822</td>
<td>21</td>
<td>Could not start I/O operation for request %S_BLKIOPTR. Contact Technical Support.</td>
</tr>
<tr>
<td>823</td>
<td>24</td>
<td>The operating system returned error %ls to SQL Server during a %S_MSG at offset %#016I64x in file ‘%ls’. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threa</td>
</tr>
<tr>
<td>824</td>
<td>24</td>
<td>SQL Server detected a logical consistency-based I/O error: %ls. It occurred during a %S_MSG of page %S_PGID in database ID %d at offset %#016I64x in file ‘%ls’. Additional messages in the SQL Server error log or system event log may provide more detail. </td>
</tr>
<tr>
<td>825</td>
<td>10</td>
<td>A read of the file ‘%ls’ at offset %#016I64x succeeded after failing %d time(s) with error: %ls. Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be co</td>
</tr>
<tr>
<td>826</td>
<td>10</td>
<td>incorrect pageid (expected %d:%d; actual %d:%d)</td>
</tr>
<tr>
<td>829</td>
<td>21</td>
<td>Database ID %d, Page %S_PGID is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.</td>
</tr>
<tr>
<td>830</td>
<td>10</td>
<td>stale page (a page read returned a log sequence number (LSN) (%u:%u:%u) that is older than the last one that was written (%u:%u:%u))</td>
</tr>
<tr>
<td>831</td>
<td>20</td>
<td>Unable to deallocate a kept page.</td>
</tr>
<tr>
<td>832</td>
<td>24</td>
<td>A page that should have been constant has changed (expected checksum: %08x, actual checksum: %08x, database %d, file ‘%ls’, page %S_PGID). This usually indicates a memory failure or other hardware or OS corruption.</td>
</tr>
<tr>
<td>833</td>
<td>10</td>
<td>SQL Server has encountered %d occurrence(s) of I/O requests taking longer than %d seconds to complete on file [%ls] in database [%ls] (%d). The OS file handle is 0x%p. The offset of the latest long I/O is: %#016I64x</td>
</tr>
<tr>
<td>844</td>
<td>10</td>
<td>Time out occurred while waiting for buffer latch — type %d, bp %p, page %d:%d, stat %#x, database id: %d, allocation unit id: %I64d%ls, task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Continuing to wait.</td>
</tr>
<tr>
<td>845</td>
<td>17</td>
<td>Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.</td>
</tr>
<tr>
<td>846</td>
<td>10</td>
<td>A time-out occurred while waiting for buffer latch — type %d, bp %p, page %d:%d, stat %#x, database id: %d, allocation unit Id: %I64d%ls, task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Not continuing to wait.</td>
</tr>
<tr>
<td>847</td>
<td>10</td>
<td>Timeout occurred while waiting for latch: class ‘%ls’, id %p, type %d, Task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Continuing to wait.</td>
</tr>
<tr>
<td>848</td>
<td>10</td>
<td>Using large pages for buffer pool.</td>
</tr>
<tr>
<td>849</td>
<td>10</td>
<td>Using locked pages for buffer pool.</td>
</tr>
<tr>
<td>850</td>
<td>10</td>
<td>%I64u MB of large page memory allocated.</td>
</tr>
<tr>
<td>851</td>
<td>10</td>
<td>the page is in an OFFLINE file which cannot be read</td>
</tr>
<tr>
<td>902</td>
<td>16</td>
<td>To change the %ls, the database must be in state in which a checkpoint can be executed.</td>
</tr>
<tr>
<td>904</td>
<td>16</td>
<td>Database %ld cannot be autostarted during server shutdown or startup.</td>
</tr>
<tr>
<td>905</td>
<td>21</td>
<td>Database ‘%.*ls’ cannot be started in this edition of SQL Server because it contains a partition function ‘%.*ls’. Only Enterprise edition of SQL Server supports partitioning.</td>
</tr>
<tr>
<td>907</td>
<td>16</td>
<td>The database “%ls” has inconsistent database or file metadata.</td>
</tr>
<tr>
<td>908</td>
<td>10</td>
<td>Filegroup %ls in database %ls is unavailable because it is %ls. Restore or alter the filegroup to be available.</td>
</tr>
<tr>
<td>909</td>
<td>21</td>
<td>Database ‘%.*ls’ cannot be started in this edition of SQL Server because part or all of object ‘%.*ls’ is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterpris</td>
</tr>
<tr>
<td>910</td>
<td>10</td>
<td>Database ‘%.*ls’ is upgrading script ‘%.*ls’ from level %d to level %d.</td>
</tr>
<tr>
<td>911</td>
<td>16</td>
<td>Database ‘%.*ls’ does not exist. Make sure that the name is entered correctly.</td>
</tr>
<tr>
<td>912</td>
<td>21</td>
<td>Script level upgrade for database ‘%.*ls’ failed because upgrade step ‘%.*ls’ encountered error %d, state %d, severity %d. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error </td>
</tr>
<tr>
<td>913</td>
<td>22</td>
<td>Could not find database ID %d. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occ</td>
</tr>
<tr>
<td>914</td>
<td>21</td>
<td>Script level upgrade for database ‘%.*ls’ failed because upgrade step ‘%.*ls’ was aborted before completion. If the abort happened during upgrade of the ‘master’ database, it will prevent the entire SQL Server instance from starting. Examine the previous</td>
</tr>
<tr>
<td>915</td>
<td>21</td>
<td>Unable to obtain the current script level for database ‘%.*ls’. If the error happened during startup of the ‘master’ database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the approp</td>
</tr>
<tr>
<td>916</td>
<td>14</td>
<td>The server principal “%.*ls” is not able to access the database “%.*ls” under the current security context.</td>
</tr>
<tr>
<td>917</td>
<td>21</td>
<td>An upgrade script batch failed to execute for database ‘%.*ls’ due to compilation error. Check the previous error message for the line which caused compilation to fail.</td>
</tr>
<tr>
<td>918</td>
<td>21</td>
<td>Failed to load the engine script metadata from script DLL ‘%.*ls’. The error code reported by Windows was %d. This is a serious error condition, which usually indicates a corrupt or incomplete installation. Repairing the SQL Server instance may help resol</td>
</tr>
<tr>
<td>919</td>
<td>10</td>
<td>User ‘%.*ls’ is changing database script level entry %d to a value of %d.</td>
</tr>
<tr>
<td>920</td>
<td>20</td>
<td>Only members of the sysadmin role can modify the database script level.</td>
</tr>
<tr>
<td>921</td>
<td>14</td>
<td>Database ‘%.*ls’ has not been recovered yet. Wait and try again.</td>
</tr>
<tr>
<td>922</td>
<td>14</td>
<td>Database ‘%.*ls’ is being recovered. Waiting until recovery is finished.</td>
</tr>
<tr>
<td>923</td>
<td>14</td>
<td>Database ‘%.*ls’ is in restricted mode. Only the database owner and members of the dbcreator and sysadmin roles can access it.</td>
</tr>
<tr>
<td>924</td>
<td>14</td>
<td>Database ‘%.*ls’ is already open and can only have one user at a time.</td>
</tr>
<tr>
<td>925</td>
<td>19</td>
<td>Maximum number of databases used for each query has been exceeded. The maximum allowed is %d.</td>
</tr>
<tr>
<td>926</td>
<td>14</td>
<td>Database ‘%.*ls’ cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.</td>
</tr>
<tr>
<td>927</td>
<td>14</td>
<td>Database ‘%.*ls’ cannot be opened. It is in the middle of a restore.</td>
</tr>
<tr>
<td>928</td>
<td>20</td>
<td>During upgrade, database raised exception %d, severity %d, state %d, address %p. Use the exception number to determine the cause.</td>
</tr>
<tr>
<td>929</td>
<td>20</td>
<td>Unable to close a database that is not currently open. The application should reconnect and try again. If this action does not correct the problem, contact your primary support provider.</td>
</tr>
<tr>
<td>930</td>
<td>21</td>
<td>Attempting to reference recovery unit %d in database ‘%ls’ which does not exist. Contact Technical Support.</td>
</tr>
<tr>
<td>931</td>
<td>21</td>
<td>Attempting to reference database fragment %d in database ‘%ls’ which does not exist. Contact Technical Support.</td>
</tr>
<tr>
<td>932</td>
<td>21</td>
<td>SQL Server cannot load database ‘%.*ls’ because change tracking is enabled. The currently installed edition of SQL Server does not support change tracking. Either disable change tracking in the database by using a supported edition of SQL Server, or upgra</td>
</tr>
<tr>
<td>933</td>
<td>21</td>
<td>Database ‘%.*ls’ cannot be started because some of the database functionality is not available in the current edition of SQL Server.</td>
</tr>
<tr>
<td>934</td>
<td>21</td>
<td>SQL Server cannot load database ‘%.*ls’ because Change Data Capture is enabled. The currently installed edition of SQL Server does not support Change Data Capture. Either disable Change Data Capture in the database by using a supported edition of SQL Serv</td>
</tr>
<tr>
<td>935</td>
<td>21</td>
<td>The script level for ‘%.*ls’ in database ‘%.*ls’ cannot be downgraded from %d to %d, which is supported by this server. This usually implies that a future database was attached and the downgrade path is not supported by the current installation. Install </td>
</tr>
<tr>
<td>942</td>
<td>14</td>
<td>Database ‘%.*ls’ cannot be opened because it is offline.</td>
</tr>
<tr>
<td>943</td>
<td>14</td>
<td>Database ‘%.*ls’ cannot be opened because its version (%d) is later than the current server version (%d).</td>
</tr>
<tr>
<td>944</td>
<td>10</td>
<td>Converting database ‘%.*ls’ from version %d to the current version %d.</td>
</tr>
<tr>
<td>945</td>
<td>16</td>
<td>Database ‘%.*ls’ cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.</td>
</tr>
<tr>
<td>946</td>
<td>14</td>
<td>Cannot open database ‘%.*ls’ version %d. Upgrade the database to the latest version.</td>
</tr>
<tr>
<td>947</td>
<td>16</td>
<td>Error while closing database ‘%.*ls’. Check for previous additional errors and retry the operation.</td>
</tr>
<tr>
<td>948</td>
<td>20</td>
<td>The database ‘%.*ls’ cannot be opened because it is version %d. This server supports version %d and earlier. A downgrade path is not supported.</td>
</tr>
<tr>
<td>949</td>
<td>16</td>
<td>tempdb is skipped. You cannot run a query that requires tempdb</td>
</tr>
<tr>
<td>950</td>
<td>20</td>
<td>Database ‘%.*ls’ cannot be upgraded because its non-release version (%d) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.</td>
</tr>
<tr>
<td>951</td>
<td>10</td>
<td>Database ‘%.*ls’ running the upgrade step from version %d to version %d.</td>
</tr>
<tr>
<td>952</td>
<td>16</td>
<td>Database ‘%.*ls’ is in transition. Try the statement later.</td>
</tr>
<tr>
<td>954</td>
<td>14</td>
<td>The database “%.*ls” cannot be opened. It is acting as a mirror database.</td>
</tr>
<tr>
<td>955</td>
<td>14</td>
<td>Database %.*ls is enabled for Database Mirroring, but the database lacks quorum: the database cannot be opened. Check the partner and witness connections if configured.</td>
</tr>
<tr>
<td>956</td>
<td>14</td>
<td>Database %.*ls is enabled for Database Mirroring, but has not yet synchronized with its partner. Try the operation again later.</td>
</tr>
<tr>
<td>957</td>
<td>17</td>
<td>Database ‘%.*ls’ is enabled for Database Mirroring, The name of the database may not be changed.</td>
</tr>
<tr>
<td>958</td>
<td>10</td>
<td>The resource database build version is %.*ls. This is an informational message only. No user action is required.</td>
</tr>
<tr>
<td>959</td>
<td>20</td>
<td>The resource database version is %d and this server supports version %d. Restore the correct version or reinstall SQL Server.</td>
</tr>
<tr>
<td>960</td>
<td>10</td>
<td>Warning: User “sys” (principal_id = %d) in database “%.*ls” has been renamed to “%.*ls”. “sys” is a reserved user or schema name in this version of SQL Server.</td>
</tr>
<tr>
<td>961</td>
<td>10</td>
<td>Warning: Index “%.*ls” (index_id = %d) on object ID %d in database “%.*ls” was renamed to “%.*ls” because its name is a duplicate of another index on the same object.</td>
</tr>
<tr>
<td>962</td>
<td>10</td>
<td>Warning: Primary key or Unique constraint “%.*ls” (object_id = %d) in database “%.*ls” was renamed to “%.*ls” because its index was renamed.</td>
</tr>
<tr>
<td>963</td>
<td>10</td>
<td>Warning: Database “%.*ls” was marked suspect because of actions taken during upgrade. See errorlog or eventlog for more information. Use ALTER DATABASE to bring the database online. The database will come online in restricted_user state.</td>
</tr>
<tr>
<td>964</td>
<td>10</td>
<td>Warning: System user ‘%.*ls’ was found missing from database ‘%.*ls’ and has been restored. This user is required for SQL Server operation.</td>
</tr>
<tr>
<td>965</td>
<td>10</td>
<td>Warning: A column nullability inconsistency was detected in the metadata of index “%.*ls” (index_id = %d) on object ID %d in database “%.*ls”. The index may be corrupt. Run DBCC CHECKTABLE to verify consistency.</td>
</tr>
<tr>
<td>966</td>
<td>10</td>
<td>Warning: Assembly “%.*ls” in database “%.*ls” has been renamed to “%.*ls” because the name of the assembly conflicts with a system assembly in this version of SQL Server.</td>
</tr>
<tr>
<td>967</td>
<td>10</td>
<td>Warning: The index “%.*ls” on “%.*ls”.”%.*ls” is disabled because the XML data bound to it may contain negative values for xs:date and xs:dateTime which are not longer supported.</td>
</tr>
<tr>
<td>968</td>
<td>10</td>
<td>Warning: The XML facet on type “%.*ls” in schema collection “%.*ls” is updated from “%.*ls” to “%.*ls” because Sql Server does not support negative years inside values of type xs:date or xs:dateTime.</td>
</tr>
<tr>
<td>969</td>
<td>10</td>
<td>Warning: The default or fixed value on XML element or attribute “%.*ls” in schema collection “%.*ls” is updated from “%.*ls” to “%.*ls” because Sql Server does not support negative years inside values of type xs:date or xs:dateTime.</td>
</tr>
<tr>
<td>970</td>
<td>10</td>
<td>Warning: The XML instances in the XML column “%.*ls.%.*ls.%.*ls” may contain negative simple type values of type xs:date or xs:dateTime. It will be impossible to run XQuery or build a primary XML index on these XML instances.</td>
</tr>
<tr>
<td>971</td>
<td>10</td>
<td>The resource database has been detected in two different locations. Attaching the resource database in the same directory as sqlservr.exe at ‘%.*ls’ instead of the currently attached resource database at ‘%.*ls’.</td>
</tr>
<tr>
<td>972</td>
<td>17</td>
<td>Could not use database ‘%d’ during procedure execution.</td>
</tr>
</tbody></table>
</div>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-47762788818595610432012-11-06T12:26:00.001+05:302013-01-08T17:21:56.599+05:30Connection strings for SQL Server 2008<meta name="google-translate-customization" content="328c4289700e2213-a5767f1fbd9bd28c-gf85230de79eb1b19-1d"></meta>
<div dir="ltr" style="text-align: left;" trbidi="on">
<h2>
.NET Framework Data Provider for SQL Server</h2>
<span class="cs_pi_label">Type</span>:
<span class="cs_pi_value">.NET Framework Class Library</span>
<span class="cs_pi_label">Usage</span>:
<span class="cs_pi_value">System.Data.SqlClient.SqlConnection</span>
<span class="cs_pi_label">Manufacturer: </span>
<span class="cs_pi_value">Microsoft</span><br />
<br />
<br />
<h3>
Standard Security</h3>
<div class="cs_ctc">
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" title="Copy to clipboard"> </a></div>
<div class="cs_csbox" id="cs1">
<span class="cs_k">Server</span>=<span class="cs_v">myServerAddress</span>;<span class="cs_k">Database</span>=<span class="cs_v">myDataBase</span>;<span class="cs_k">User Id</span>=<span class="cs_v">myUsername</span>;<span class="cs_k">Password</span>=<span class="cs_v">myPassword</span>;</div>
<div class="cs_bi">
</div>
<div class="cs_after">
</div>
<h3>
Trusted Connection</h3>
<div class="cs_ctc">
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" title="Copy to clipboard"> </a></div>
<div class="cs_csbox" id="cs2">
<span class="cs_k">Server</span>=<span class="cs_v">myServerAddress</span>;<span class="cs_k">Database</span>=<span class="cs_v">myDataBase</span>;<span class="cs_k">Trusted_Connection</span>=<span class="cs_v">True</span>;</div>
<div class="cs_bi">
</div>
<div class="cs_after">
</div>
<h3>
Connection to a SQL Server instance </h3>
The <em>server/instance</em> name syntax used in the <em>server</em> option is the same for all SQL Server connection strings.<br />
<div class="cs_ctc">
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" title="Copy to clipboard"> </a></div>
<div class="cs_csbox" id="cs3">
<span class="cs_k">Server</span>=<span class="cs_v">myServerName\myInstanceName</span>;<span class="cs_k">Database</span>=<span class="cs_v">myDataBase</span>;<span class="cs_k">User Id</span>=<span class="cs_v">myUsername</span>;<br /><span class="cs_k">Password</span>=<span class="cs_v">myPassword</span>;</div>
<div class="cs_csbox" id="cs3">
</div>
<div class="cs_csbox" id="cs3">
</div>
<div class="cs_csbox" id="cs3">
<h3>
Connect via an IP address</h3>
<div class="cs_ctc">
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" title="Copy to clipboard"> </a></div>
<div class="cs_csbox" id="cs5">
<span class="cs_k">Data Source</span>=<span class="cs_v">190.190.200.100,1433</span>;<span class="cs_k">Network Library</span>=<span class="cs_v">DBMSSOCN</span>;<span class="cs_k">Initial Catalog</span>=<span class="cs_v">myDataBase</span>;<br /><span class="cs_k">User ID</span>=<span class="cs_v">myUsername</span>;<span class="cs_k">Password</span>=<span class="cs_v">myPassword</span>;</div>
<div class="cs_csbox" id="cs5">
</div>
<cite>note:- DBMSSOCN=TCP/IP</cite> is how to use TCP/IP
instead of Named Pipes. At the end of the Data Source is the port to
use. 1433 is the default port for SQL Server. </div>
<div class="cs_csbox" id="cs3">
<br /></div>
<div class="cs_csbox" id="cs3">
<br /></div>
<div class="cs_csbox" id="cs3">
<br /></div>
<div class="cs_csbox" id="cs3">
<a href="http://www.connectionstrings.com/sql-server-2008" target="_blank">Refrence</a></div>
<br />
<br />
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-74255983548605654752012-10-09T17:01:00.000+05:302013-01-08T17:22:08.071+05:30CustomValidator example in asp.net<meta name="google-translate-customization" content="328c4289700e2213-a5767f1fbd9bd28c-gf85230de79eb1b19-1d"></meta>
<div dir="ltr" style="text-align: left;" trbidi="on">
In this example, we will simply check the length of the string in the
TextBox. This is a very basic and that useful example, only made to show
you how you may use the CustomValidator.<br />
<br />
<pre class="prettyprint linenums">Custom text:
<asp:textbox id="txtCustom" runat="server">
<asp:customvalidator controltovalidate="txtCustom" errormessage="The text must be exactly 8 characters long!" id="cusCustom" onservervalidate="cusCustom_ServerValidate" runat="server">
</asp:customvalidator></asp:textbox>
</pre>
<br />
<br />
As you can see, it's pretty simple. The only unknown property is the <i>onservervalidate</i>
event. It's used to reference a method from CodeBehind which will
handle the validation. Switch to our CodeBehind file and add the
following method:<br />
<br />
<pre class="prettyprint linenums">protected void cusCustom_ServerValidate(object sender, ServerValidateEventArgs e)
{
if(e.Value.Length == 8)
e.IsValid = true;
else
e.IsValid = false;
}</pre>
This is very simple. The validator basically works by setting the
e.IsValid boolean value to either true or false. Here we check the
e.Value, which is the string of the control being validated, for it's
length. If it's exactly 8 characters long, we return true, otherwise we
return false.
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-32833179923847829512012-10-09T15:03:00.002+05:302013-01-08T17:22:19.044+05:30IDM fake key serial number block problem?<meta name="google-translate-customization" content="328c4289700e2213-a5767f1fbd9bd28c-gf85230de79eb1b19-1d"></meta><div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: black; font-size: x-small;">Solutioin;-</span><br />
<span style="color: black; font-size: x-small;"> </span><br />
<span style="color: black; font-size: x-small;">1. Exit IDM from the taskbar before entering the serial.<br />
2. Disconnect active connections to the internet.<br />
3. Then go to the directory C:\Windows\system32\drivers\etc and locate the file 'hosts'<br />
4. Open the "hosts" file with "notepad".<br />
5. on the last line enter the following address as shown and save. <br />
<br />
127.0.0.1 <a href="http://www.internetdownloadmanager.com/" target="_blank">www.internetdownloadmanager.com</a></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0YQfMtBtaxgQACCtpGa7mAUUnDjORycfw_1viNyfkcNyeLsCnEvAUdWrqN8rYn26Fyp32WXlpDnGZcG4939y7lag-E8lle4T6DN1stPAHPwEMVOuvQnDzPoJHYyOLlw24EfdVQ1WKG9Y/s1600/idm.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0YQfMtBtaxgQACCtpGa7mAUUnDjORycfw_1viNyfkcNyeLsCnEvAUdWrqN8rYn26Fyp32WXlpDnGZcG4939y7lag-E8lle4T6DN1stPAHPwEMVOuvQnDzPoJHYyOLlw24EfdVQ1WKG9Y/s320/idm.JPG" width="320" /></a></div>
<br />
<br />
<span style="color: black; font-size: x-small;">6. Now, again enter the "fake serial" and wait for few seconds.<br />
7. your IDM is registered again.</span><span style="color: black; font-size: x-small;"> </span></div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-24083447066637716262012-10-04T17:45:00.002+05:302012-10-04T17:49:01.312+05:30Create Procedure in Sql Server Step by Step<div dir="ltr" style="text-align: left;" trbidi="on">
create new demo database
<br />
<pre class="prettyprint linenums">CREATE DATABASE demo
</pre>
use demo Database
<br />
<pre class="prettyprint linenums">USE demo</pre>
create new table
<br />
<pre class="prettyprint linenums">CREATE TABLE demoTest
(
id INT,
NAME VARCHAR(30),
ADDR VARCHAR(50)
)
</pre>
create Procedure for inserting data into demoTest Table.
<br />
<pre class="prettyprint linenums">CREATE PROC ins_DemoTest
@id INT,@name VARCHAR(30),@addr VARCHAR(30)
AS
BEGIN
INSERT INTO demoTest
(
id,
NAME,
ADDR
)
VALUES
(
@id,
@name,
@addr
)
END</pre>
execute procedure<br />
<pre class="prettyprint linenums">EXEC ins_DemoTest 1,'Aditya','New Delhi'
EXEC ins_DemoTest 2,'Abhishek','Lucknow'
EXEC ins_DemoTest 3,'Akhilesh','Greater Noida'
EXEC ins_DemoTest 4,'Abhi','Noida'</pre>
select data from Table
<br />
<pre class="prettyprint linenums">SELECT * FROM demoTest
id NAME ADDR
1 Aditya New Delhi
2 Abhishek Lucknow
3 Akhilesh Greater Noida
4 Abhi Noida
</pre>
<br /></div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-21698713958089786412012-10-04T17:02:00.001+05:302012-10-04T17:02:30.367+05:30Parameterized Sql Query in Asp.net<div dir="ltr" style="text-align: left;" trbidi="on">
<pre class="prettyprint">Dim ds As DataSet = New DataSet()
Dim param As SqlParameter = New SqlParameter("@user_code", SqlDbType.VarChar, 4)
param.Value = Convert.ToString("0016")
Const sqlstr As String = "select sectors.sector_code,sector_name from user_sectors inner join sectors on user_sectors.sector_code = sectors.sector_code where user_code = @user_code and sectors.sector_code not in ('z')"
Dim da As SqlDataAdapter = New SqlDataAdapter(sqlstr, _con)
da.SelectCommand.Parameters.Add(param)
da.Fill(ds)
ddl.DataValueField = "sector_code"
ddl.DataTextField = "sector_name"
ddl.DataSource = ds.Tables(0)
ddl.DataBind()
</pre>
<br /></div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-11017386079565371082012-10-04T16:17:00.002+05:302012-10-04T16:17:47.477+05:30About Me <div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-Q2h5g8LlVoM/UBI3p8P-jTI/AAAAAAAAAG4/MmqEsgaZEYY/s1600/26072012615%255B1%255D.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://1.bp.blogspot.com/-Q2h5g8LlVoM/UBI3p8P-jTI/AAAAAAAAAG4/MmqEsgaZEYY/s320/26072012615%255B1%255D.jpg" width="318" /></a></div>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i> </i></h2>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i>Aditya Pratap Singh</i></h2>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i><span style="font-size: x-small;">Programmer : CyberQ India Counsalting Pvt. Ltd.</span></i></h2>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i><span style="font-size: x-small;">Qualification : MCA (UPTU-2011)</span></i></h2>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i><span style="font-size: x-small;">Exp : 1.6 yrs</span></i></h2>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i><span style="font-size: x-small;">Mo. : 9911690423</span></i></h2>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i><span style="font-size: x-small;">Email: adityapratapsingh002@gmail.com</span></i></h2>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i><span style="font-size: x-small;">Working Area: C#,VB,Asp.net,SqlServer,JavaScript,JQuery </span></i></h2>
<h2 style="color: #444444; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i><span style="font-size: x-small;"> </span></i></h2>
<h2 style="color: magenta; font-family: Georgia,"Times New Roman",serif; text-align: left;">
<i> </i></h2>
<br />
<br /></div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-68236486107737029652012-09-25T12:55:00.001+05:302012-10-04T17:16:14.647+05:30Find selected item from radiobutton list using javascript<div dir="ltr" style="text-align: left;" trbidi="on">
ASP.NET renders a table and a bunch of other mark-up around the actual radio inputs <br />
<br /><pre class="prettyprint linenums" >
var list = document.getElementById("rdbdesc"); <br />
var inputs = list.getElementsByTagName("input"); <br />
var selected; <br />
for (var i = 0; i < inputs.length; i++) <br />
{ <br />
if (inputs[i].checked) { <br />
selected = inputs[i]; <br />
break; <br />
} <br />
} <br />
if (selected) <br />
{<br />
<br />
alert(selected.value); <br />
<br />
}<br />
</pre></div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-47026968911046316142012-09-25T11:20:00.001+05:302012-09-25T11:20:33.559+05:30Difference Between the HAVING and WHERE Clauses in a SQL<div dir="ltr" style="text-align: left;" trbidi="on">
Difference Between the HAVING and WHERE Clauses in a SQL<br /><ol>
<li> The <span class="pf">WHERE</span> clause specifies the criteria which individual records must meet to be selcted by a query. It can be used without the <span class="pf">GROUP BY</span> clause. The <span class="pf">HAVING</span> clause cannot be used without the <span class="pf">GROUP BY</span> clause. </li>
<li> The <span class="pf">WHERE</span> clause selects rows <em>before</em> grouping. The <span class="pf">HAVING</span> clause selects rows <em>after</em> grouping.</li>
<li> The <span class="pf">WHERE</span> clause <em>cannot</em> contain aggregate functions. The <span class="pf">HAVING</span> clause <em>can</em> contain aggregate functions. <a href="http://www.devx.com/DevX/Tip/21295" target="_blank">source</a><span style="font-family: Times,"Times New Roman",serif;"></span><br /><h2>
Using the code
</h2>
<pre><div class="sql" style="background: #f0f0f0;">
<div style="background: #F0F0FF; border-bottom: dotted; border-color: #A5A5A5; border-width: 1px; color: #a23f27; font-family: tahoma; line-height: 15px;">
Code</div>
<ol>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">SELECT</span> cusnum<span style="color: #66cc66;">,</span> lstnam<span style="color: #66cc66;">,</span> init</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">FROM</span> Test</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">WHERE</span> state <span style="color: #993333; font-weight: bold;">IN</span> <span style="color: #66cc66;">(</span><span style="color: red;">'CA'</span><span style="color: #66cc66;">,</span> <span style="color: red;">'LA'</span><span style="color: #66cc66;">)</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
CUSNUM LSTNAM INIT BALDUE</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #66cc66;">======</span> <span style="color: #66cc66;">============</span> <span style="color: #66cc66;">====</span> <span style="color: #66cc66;">========</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #cc66cc;">938472</span> John G K <span style="color: #cc66cc;">37.00</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #cc66cc;">938485</span> Mark J A <span style="color: #cc66cc;">3987.50</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #cc66cc;">593029</span> Lily E D <span style="color: #cc66cc;">25.00</span></div>
</li>
</ol>
</div>
</pre>
Suppose I want the total amount due from customers by state. In that
case, I would need to use the GROUP BY clause to build an aggregate
query.
<pre><div class="sql" style="background: #f0f0f0;">
<div style="background: #F0F0FF; border-bottom: dotted; border-color: #A5A5A5; border-width: 1px; color: #a23f27; font-family: tahoma; line-height: 15px;">
Code</div>
<ol>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">SELECT</span> state<span style="color: #66cc66;">,</span>SUM<span style="color: #66cc66;">(</span>baldue<span style="color: #66cc66;">)</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">FROM</span> Test</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">GROUP</span> <span style="color: #993333; font-weight: bold;">BY</span> state</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">ORDER</span> <span style="color: #993333; font-weight: bold;">BY</span> state</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
State Sum<span style="color: #66cc66;">(</span>Baldue<span style="color: #66cc66;">)</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #66cc66;">=====</span> <span style="color: #66cc66;">===========</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
CA <span style="color: #cc66cc;">250.00</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
CO <span style="color: #cc66cc;">58.75</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
GA <span style="color: #cc66cc;">3987.50</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
MN <span style="color: #cc66cc;">510.00</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
NY <span style="color: #cc66cc;">589.50</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
TX <span style="color: #cc66cc;">62.00</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
VT <span style="color: #cc66cc;">439.00</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
WY <span style="color: #66cc66;">.</span><span style="color: #cc66cc;">00</span></div>
</li>
</ol>
</div>
</pre>
Using Having
<pre><div class="sql" style="background: #f0f0f0;">
<div style="background: #F0F0FF; border-bottom: dotted; border-color: #A5A5A5; border-width: 1px; color: #a23f27; font-family: tahoma; line-height: 15px;">
Code</div>
<ol>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">SELECT</span> state<span style="color: #66cc66;">,</span>SUM<span style="color: #66cc66;">(</span>baldue<span style="color: #66cc66;">)</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">FROM</span> Test</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">GROUP</span> <span style="color: #993333; font-weight: bold;">BY</span> state</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #993333; font-weight: bold;">HAVING</span> SUM<span style="color: #66cc66;">(</span>baldue<span style="color: #66cc66;">)</span> <span style="color: #66cc66;">></span> <span style="color: #cc66cc;">250</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
</div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
State Sum<span style="color: #66cc66;">(</span>Baldue<span style="color: #66cc66;">)</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
<span style="color: #66cc66;">=====</span> <span style="color: #66cc66;">===========</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
GA <span style="color: #cc66cc;">3987.50</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
MN <span style="color: #cc66cc;">510.00</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
NY <span style="color: #cc66cc;">589.50</span></div>
</li>
<li style="background: #fcfcfc;"><div style="font-family: 'Courier New', Courier, monospace; font-style: normal; font-weight: normal;">
VT <span style="color: #cc66cc;">439.00</span></div>
</li>
</ol>
</div>
</pre>
<h2>
<br /></h2>
<br /><br /></li>
</ol>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-57204228547927194742012-09-24T14:03:00.000+05:302012-09-24T14:03:02.041+05:30Get All Running Instances of Sql Server<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="text-align: left;">
Que:- Get All Running Instances of Sql Server?<br /><br />Sol:-</h2>
<div style="color: #3d85c6; text-align: left;">
Step 1. add Com refrence to sqlserver dmo.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
sqldmo.dll can be found at<br />"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQLDMO.DLL"</div>
<div style="text-align: left;">
<br /></div>
<div style="color: #3d85c6; text-align: left;">
Step 2.add this code in page_load event </div>
<div style="text-align: left;">
<br />protected void Page_Load(object sender, EventArgs e)<br /> {<br /> NameList sqlservers = new SQLDMO.Application().ListAvailableSQLServers();<br /> <br /> foreach (string sql in sqlservers )<br /> {<br /> Response.Write(sql +"<br/>");<br /> }<br /> }<br /></div>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-85305144236411299782012-09-24T12:14:00.002+05:302012-09-24T12:14:29.053+05:30Access an asp.net website using IP Address in an LAN Network <div dir="ltr" style="text-align: left;" trbidi="on">
step 1:<br /><br /> Click on Start--> Run-->type in textbox 'Inetmgr', to open IIS .<br /><br />step 2:<br /><br /> click on Websites-->Default Websites --> YourWebApplicationName<br /><br /> browse through your application virtual directory.<br /><br />step 3.<br /> right click on WebApplication and select PROPERTIES.<br /><br /> click on 'Directory Security' Tab<br /><br />step 4.<br /><br /> In 'Anonymous Access and Authentication Control' click on EDIT .<br /><br />step 5.<br /><br /> Check the checkbox 'Anonymous Access' and uncheck remaining all<br /> (except Allow IIS to control password, Let it be checked)<br /><br />step 6. <br /><br /> Click Ok. again OK.<br /><br />Step 7.<br /><br /> now open control panel-->Windows Firewall<br /><br />step 8.<br /><br /> click on Exceptions Tab.<br /><br />step 9.<br /><br /> Click on Add Port. Enter Name: IIS and Port Number : 80 Click Ok.again <br /> Click OK.<br /><br />step 10.<br /><br /> now open IE and enter your system IP : http://192.168.X.X/</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-90004611891475079412012-09-21T15:07:00.000+05:302012-09-21T15:07:27.120+05:30Check given Year is Leap year or Not in Sql Server?<div dir="ltr" style="text-align: left;" trbidi="on">
create function dbo.fn_IsLeapYear (@year int)<br />returns bit<br />as<br />begin<br /> return(select case datepart(mm, dateadd(dd, 1, cast((cast(@year as varchar(4)) + '0228') as datetime)))<br /> when 2 then 1<br /> else 0<br /> end)<br />end<br />go<br /><br /><br /></div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-30948089225266477972012-09-21T15:04:00.002+05:302012-09-21T15:04:36.646+05:30Get Paging Data from Sql Server<div dir="ltr" style="text-align: left;" trbidi="on">
Why Custom Paging?<br />Custom paging allows you to get limited number
records from a large database table that saves processing time of your
database server as well as your application server and makes your
application scalable, efficient and fast.<br />
<br />In this article, I
am going to explain how to create a stored procedure in SQL Server 2005
that allows you to pass startRowIndex and pageSize as a parameter and
return you the number of records starting from that row index to the
page size specified. It was possible in the SQL Server 2000 too but it
was not as easy as in SQL Server 2005 is.<br />
<br />
<pre><span style="color: green; font-size: 85%;">-- EXEC LoadPagedArticles 10, 5</span><span style="color: blue; font-size: 85%;">CREATE</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">PROCEDURE</span><span style="font-size: 85%;"> LoadPagedArticles </span><br />
<span style="color: green; font-size: 85%;">-- Add the parameters for the stored procedure here</span><br />
<span style="font-size: 85%;">@startRowIndex </span><span style="color: blue; font-size: 85%;">int</span><span style="color: grey; font-size: 85%;">,</span><br />
<span style="font-size: 85%;">@pageSize </span><span style="color: blue; font-size: 85%;">int</span><br />
<span style="color: blue; font-size: 85%;">AS</span><br />
<span style="color: blue; font-size: 85%;">BEGIN</span><br />
<span style="color: green; font-size: 85%;">-- SET NOCOUNT ON added to prevent extra result sets from</span><br />
<span style="color: green; font-size: 85%;">-- interfering with SELECT statements.</span><br />
<span style="color: blue; font-size: 85%;">SET</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">NOCOUNT</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">ON</span><span style="color: grey; font-size: 85%;">;</span><br />
<span style="color: grey; font-size: 85%;"><span style="color: green; font-size: 85%;">-- increase the startRowIndex by 1 to avoid returning the last record again</span></span><span style="font-size: 85%;">
</span><span style="color: blue; font-size: 85%;">SET</span><span style="font-size: 85%;"> @startRowIndex </span><span style="color: grey; font-size: 85%;">=</span><span style="font-size: 85%;"> @startRowIndex </span><span style="color: grey; font-size: 85%;">+</span><span style="font-size: 85%;"> 1 </span><br />
<span style="color: blue; font-size: 85%;"> BEGIN</span><br />
<span style="color: blue; font-size: 85%;"> SELECT</span><span style="font-size: 85%;"> </span><span style="color: grey; font-size: 85%;">*</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">FROM</span><span style="font-size: 85%;"> </span><span style="color: grey; font-size: 85%;">(</span><br />
<span style="color: blue; font-size: 85%;"> Select</span><span style="font-size: 85%;"> </span><span style="color: grey; font-size: 85%;">*,</span><span style="font-size: 85%;"> </span><br />
<span style="color: magenta; font-size: 85%;"> ROW_NUMBER</span><span style="color: grey; font-size: 85%;">()</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">OVER</span><span style="font-size: 85%;"> </span><span style="color: grey; font-size: 85%;">(</span><span style="color: blue; font-size: 85%;">ORDER</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">BY</span><span style="font-size: 85%;"> registration_no </span><span style="color: blue; font-size: 85%;">ASC</span><span style="color: grey; font-size: 85%;">)</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">as</span><span style="font-size: 85%;"> RowNum</span><br />
<span style="color: blue; font-size: 85%;"> FROM</span><span style="font-size: 85%;"> grievance</span><br />
<span style="color: grey; font-size: 85%;"> )</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">as</span><span style="font-size: 85%;"> grievance</span><br />
<span style="color: blue; font-size: 85%;"> WHERE</span><span style="font-size: 85%;"> RowNum </span><span style="color: grey; font-size: 85%;">BETWEEN</span><span style="font-size: 85%;"> @startRowIndex </span><span style="color: grey; font-size: 85%;">AND</span><span style="font-size: 85%;"> </span><span style="color: grey; font-size: 85%;">(</span><span style="font-size: 85%;">@startRowIndex </span><span style="color: grey; font-size: 85%;">+</span><span style="font-size: 85%;"> @pageSize</span><span style="color: grey; font-size: 85%;">)</span><span style="font-size: 85%;"> </span><span style="color: grey; font-size: 85%;">-</span><span style="font-size: 85%;"> 1</span><br />
<span style="color: blue; font-size: 85%;"> ORDER</span><span style="font-size: 85%;"> </span><span style="color: blue; font-size: 85%;">BY</span><span style="font-size: 85%;"> registration_no </span><span style="color: blue; font-size: 85%;">ASC</span><br />
<span style="color: blue; font-size: 85%;"> END</span><br />
<span style="color: blue; font-size: 85%;">END</span><br />
<span style="font-size: 85%;">GO
</span></pre>
<h2 style="text-align: left;">
Run It:-</h2>
<pre style="text-align: left;"><span style="font-size: 85%;">exec LoadPagedArticles 6,5
<br />
</span></pre>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-65922772632798762752012-09-21T14:51:00.000+05:302012-09-21T14:51:03.009+05:30Get Comma Delimited List in Sql Server<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 style="font-family: Arial,Helvetica,sans-serif; text-align: left;">
<b style="color: #93c47d;">How Get Comma Delimited List in Sql Server?</b></h2>
<h2 style="font-family: Arial,Helvetica,sans-serif; text-align: left;">
<b style="color: #93c47d;">Solution:- </b></h2>
<h2 style="font-family: Arial,Helvetica,sans-serif; text-align: left;">
</h2>
<div style="font-family: "Courier New",Courier,monospace; text-align: left;">
DECLARE @state_name nvarchar(100)<br />SELECT @state_name = COALESCE(@state_name,'') + COALESCE(state_name,'') + ',' FROM states <br />WHERE state_name IS NOT NULL<br />SET @state_name = SUBSTRING(@state_name,0,LEN(RTRIM(@state_name)))<br />--use for print list </div>
<div style="font-family: "Courier New",Courier,monospace; text-align: left;">
PRINT @state_name</div>
<h2 style="font-family: Arial,Helvetica,sans-serif; text-align: left;">
<b style="color: #93c47d;">Example:-</b></h2>
<div style="font-family: "Courier New",Courier,monospace; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVIabCmmKdKlE0fZAAMmPR10rtHKtvOiRA4MhURC-ow2MMyVAR8tCEXLMdCstN_e1KQ8LpDuY_NFjaOFoh22xY31ldsutVxu2nG8K90oJYCKl4zNPoFpz0gp2icr82hhityhR-RbvUGu8/s1600/sqltemp.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="73" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVIabCmmKdKlE0fZAAMmPR10rtHKtvOiRA4MhURC-ow2MMyVAR8tCEXLMdCstN_e1KQ8LpDuY_NFjaOFoh22xY31ldsutVxu2nG8K90oJYCKl4zNPoFpz0gp2icr82hhityhR-RbvUGu8/s320/sqltemp.JPG" width="320" /></a></div>
<h2 style="font-family: Arial,Helvetica,sans-serif; text-align: left;">
<b style="color: #93c47d;"><br /> </b></h2>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-64343615591774282362012-09-21T14:36:00.000+05:302012-09-21T14:36:10.231+05:30Search within Database in any Table<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 class="post-title entry-title">
<a href="http://sqlservercodebook.blogspot.in/2008/11/how-to-search-entire-database.html">How To search entire database?</a></h3>
<h3 class="post-title entry-title">
<span style="font-family: Verdana; font-size: x-small;">here is how you run it:<br /><br />
<span style="color: grey; font-family: verdana; font-size: x-small;">--To search all columns of all tables in Pubs database for the keyword "Computer"</span>
<br />
<span style="color: blue; font-family: verdana; font-size: x-small;">EXEC SearchAllTables 'Computer'<br />GO</span>
<br /><br />
Here is the complete stored procedure code:
</span></h3>
<pre><span style="font-family: Verdana; font-size: x-small;"><span style="color: blue; font-family: verdana; font-size: xx-small;">
CREATE PROC SearchAllTables
(
@SearchStr nvarchar(100)
)
AS
BEGIN
<span style="color: grey; font-family: verdana; font-size: xx-small;">
-- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.
-- Purpose: To search all columns of all tables for a given search string
-- Written by: Narayana Vyas Kondreddi
-- Site: http://vyaskn.tripod.com
-- Tested on: SQL Server 7.0 and SQL Server 2000
-- Date modified: 28th July 2002 22:50 GMT
</span>
CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))
SET NOCOUNT ON
DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')
WHILE @TableName IS NOT NULL
BEGIN
SET @ColumnName = ''
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY(
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
), 'IsMSShipped'
) = 0
)
WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
BEGIN
SET @ColumnName =
(
SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
AND TABLE_NAME = PARSENAME(@TableName, 1)
AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
AND QUOTENAME(COLUMN_NAME) > @ColumnName
)
IF @ColumnName IS NOT NULL
BEGIN
INSERT INTO #Results
EXEC
(
'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)
FROM ' + @TableName + ' (NOLOCK) ' +
' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
)
END
END
END
SELECT ColumnName, ColumnValue FROM #Results
END
</span> </span></pre>
<pre><span style="font-family: Verdana; font-size: x-small;"> </span></pre>
<pre><span style="font-family: Verdana; font-size: x-small;"><a href="http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm" target="_blank">Ref:-</a> </span></pre>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-87109387412144414982012-09-18T16:52:00.000+05:302012-09-24T16:12:49.991+05:30JQuery Toggle Example<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Toggling using J Query to Show/Hide Div <br />
<br />
Steps.-<br />
1. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.js"></script><br />
add this line in your code for j Query Library.<br />
2.<br />
<input type="submit" id="xyz" value="Check Toggle" ><br />
<br />
<div id="dv1" style="color:#ff1493;"><br />
a journey over toggle function in jquery. <br/><br />
This is a demo. <br/><br />
in this demo dive section is toggle on button click event in different type of animation.<br />
</div><br />
<script src ="jquery.js"></script><br />
<br />
<script><br />
$('#xyz').click( function aditya()<br />
{<br />
$('#dv1').slideToggle().delay(1000);<br />
}<br />
)<br />
<br />
</script><br />
<br />
see Video<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div id="dv1" style="border: medium solid green; display: none;">
this is div for showing example using j query.
it will hide and show as per click on button.
</div>
<input id="xyz" onclick="call()" style="display: none;" type="submit" value="Toggle" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.js"></script>
<script>
function call()
{
$('#dv1').toggle();
}
</div>
</script>
<embed height="800" pluginspage=" http://www.macromedia.com/go/getflashplayer" src="https://6e6feb40-a-62cb3a1a-s-sites.googlegroups.com/site/adityapratapsingh002/toggle.swf?attachauth=ANoY7cpTpizTXvwT5ImuKrApOI4L7kLmETcbNr84lfiCVzujQLfMtzXi5AlMeTdRBWyeEtFRwogOnNPURCB342WrLES8IuV17-x0idARcl1ctuPAiWyM9-t10VqYe5PdmqTwedlE8qTq3Atwf6DAAxQuHWRcK3o1inAH4CPLCD2LD_1Nb3JeY39pNTuQKLH-mf2n5RJgWl8FX3vVUBqpgcDH-I9k_3Vsqw%3D%3D&attredirects=0" type="application/x-shockwave-flash" width="600"></embed>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0tag:blogger.com,1999:blog-3277299172183048611.post-88471919908988552032012-09-17T14:52:00.000+05:302012-09-17T14:52:25.375+05:30Visual Studio 2010 Shortcuts<div dir="ltr" style="text-align: left;" trbidi="on">
<h1>
Visual Studio 2010 Shortcuts <span class="user_token" id="2947d08f2c325b386557"></span></h1>
<div class="page_info_options">
<br /></div>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="link_1"></a>
<table cellspacing="0" class="category main">
<tbody>
<tr><th colspan="2"><span class="plus_minus main"></span>1. Manage Visual Studio</th></tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">s</span></td>
<td><span class="kbd">S</span>ave current file</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">s</span></td>
<td><span class="kbd">S</span>ave all files</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">n</span></td>
<td>Create <span class="kbd">n</span>ew project</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">o</span></td>
<td><span class="kbd">O</span>pen file</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">o</span></td>
<td><span class="kbd">O</span>pen project</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">a</span></td>
<td><span class="kbd">A</span>dd item to project</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Esc</span></td>
<td>Close menu or dialog</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">p</span></td>
<td><span class="kbd">P</span>rint</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">Alt</span>+<span class="kbd">Enter</span></td>
<td>Toggle full screen mode</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">f4</span></td>
<td>Close current tab</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">f6</span>/<span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">f6</span></td>
<td>Go to next / go to previous window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Tab</span>, then <span class="kbd">Arrow keys</span></td>
<td>Press and hold <span class="kbd">Ctrl</span>+<span class="kbd">Tab</span>, then using <span class="kbd">arrow keys</span> gives a small task manager with all open files and views</td>
</tr>
</tbody></table>
<div class="goto_top">
<br /></div>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="link_2"></a>
<table cellspacing="0" class="category main">
<tbody>
<tr><th colspan="2"><span class="plus_minus main"></span>2. Bookmarks</th></tr>
<tr><td class="supplemental" colspan="2">For keystrokes with two keys such as <span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">k</span>, keep holding the <span class="kbd">Ctrl</span> key until releasing the last key.</td></tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">k</span></td>
<td>Toogle boo<span class="kbd">k</span>mark</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">n</span></td>
<td>Goto <span class="kbd">n</span>ext bookmark</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">p</span></td>
<td>Goto <span class="kbd">p</span>revious bookmark</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">k</span>+<span class="kbd">n</span></td>
<td>Goto <span class="kbd">n</span>ext bookmark in folder</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">k</span>+<span class="kbd">p</span></td>
<td>Goto <span class="kbd">p</span>revious bookmark in folder</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">w</span></td>
<td>Put focus on bookmark <span class="kbd">w</span>indow</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Esc</span></td>
<td>Leave bookmark window and focus on editor</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">h</span></td>
<td>Toggle code s<span class="kbd">h</span>ortcut at current line*</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span> + <span class="kbd">K</span> + <span class="kbd">L</span></td>
<td>Clear all bookmarks</td>
</tr>
<tr><td class="supplemental" colspan="2">*if somebody figures out additional shortut keys on how to use code shortcuts, please edit this page and add.</td></tr>
</tbody></table>
<div class="goto_top">
<br /></div>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="link_3"></a>
<table cellspacing="0" class="category main">
<tbody>
<tr><th colspan="2"><span class="plus_minus main"></span>3. Code Editor</th></tr>
</tbody></table>
<div class="subcategories">
<table cellspacing="0" class="category sub">
<tbody>
<tr><th colspan="2"><span class="plus_minus sub"></span>Find, Replace, and Goto</th></tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">f</span></td>
<td><span class="kbd">F</span>ind and replace dialog box</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">f3</span>/<span class="kbd">Shift</span>+<span class="kbd">f3</span></td>
<td>Find next / find previous</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">h</span></td>
<td>Display Replace options on the quick tab</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">f12</span></td>
<td>Find all references for selected symbol</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">f</span></td>
<td>Find in files</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Alt</span>+<span class="kbd">F3</span>, <span class="kbd">s</span></td>
<td>Stop current find in files operation</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">F3</span>/<span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">f3</span></td>
<td>Find next / find previous in selected text</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Alt</span>+<span class="kbd">F12</span></td>
<td>Find symbol</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">d</span></td>
<td>Put cursor in fin<span class="kbd">d</span>/command box of the toolbar. Use <span class="kbd">ctrl</span>+<span class="kbd">/</span> in Visual C#</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">i</span>/<span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">i</span></td>
<td><span class="kbd">I</span>ncremental search / reverse incremental search</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">Alt</span>+<span class="kbd">f12</span></td>
<td>Quick find symbol</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">,</span></td>
<td>Display Navigate-To dialog box</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">g</span></td>
<td><span class="kbd">G</span>oto line number</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">]</span></td>
<td>Go to matching brace in source file</td>
</tr>
</tbody></table>
<table cellspacing="0" class="category sub">
<tbody>
<tr><th colspan="2"><span class="plus_minus sub"></span> </th></tr>
</tbody></table>
<table cellspacing="0" class="category sub"><tbody>
<tr><th colspan="2">Undo, Redo, Copy, Paste</th></tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">x</span>, Ctrl+<span class="kbd">x</span>, Ctrl+<span class="kbd">v</span></td>
<td>Cut, copy, paste</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">v</span></td>
<td>Pastes an item from the Clipboard ring</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">z</span></td>
<td>Undo</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">y</span></td>
<td>Redo (or <span class="kbd">Shift</span>+<span class="kbd">Alt</span>+<span class="kbd">Backspace</span>, or <span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">Z</span>)</td>
</tr>
</tbody></table>
<table cellspacing="0" class="category sub">
<tbody>
<tr><th colspan="2"><span class="plus_minus sub"></span> </th></tr>
</tbody></table>
<table cellspacing="0" class="category sub"><tbody>
<tr><th colspan="2">Select Text</th></tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">Arrow Keys</span></td>
<td>Extend selection one character/one line</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">End</span>/ <span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">Home</span></td>
<td>Extend selection to end / to beginning of document</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">]</span></td>
<td>Extend selection to nexst brace</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">End</span>/ <span class="kbd">Shift</span>+<span class="kbd">Home</span></td>
<td>Extend selection to end / to beginning of line</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">Page Down</span>/ <span class="kbd">Shift</span>+<span class="kbd">Page Up</span></td>
<td>Extends selection down one page / up one page</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">w</span></td>
<td>Select current <span class="kbd">w</span>ord</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Esc</span></td>
<td>Cancel Selection</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">Page Down</span>/ <span class="kbd">Page Up</span></td>
<td>Moves cursor and extend selection to the last line / first line in view.</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">Arrow right</span>/ <span class="kbd">arrow left</span></td>
<td>Extend selection one word to the right / one word to the left</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">a</span></td>
<td>Select <span class="kbd">A</span>ll</td>
</tr>
</tbody></table>
</div>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="link_4"></a>
<table cellspacing="0" class="category main">
<tbody>
<tr><th colspan="2"><span class="plus_minus main"></span> </th></tr>
</tbody></table>
<table cellspacing="0" class="category main"><tbody>
<tr><th colspan="2">4. Coding</th></tr>
</tbody></table>
<div class="subcategories" style="display: block;">
<table cellspacing="0" class="category sub">
<tbody>
<tr><th colspan="2"><span class="plus_minus sub"></span>Collapse Items</th></tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">m</span>+<span class="kbd">m</span></td>
<td>Collapse / un-collapse current preset area (e.g. method)</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">m</span>+<span class="kbd">h</span></td>
<td>Collpase / <span class="kbd">h</span>ide current selection</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">m</span>+<span class="kbd">o</span></td>
<td>Collapse declaration bodies</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">m</span>+<span class="kbd">a</span></td>
<td>Collapse <span class="kbd">a</span>ll</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">m</span>+<span class="kbd">x</span></td>
<td>Uncollapse all</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">m</span>, <span class="kbd">ctrl</span>+<span class="kbd">t</span></td>
<td>Collapse H<span class="kbd">t</span>ml tag</td>
</tr>
</tbody></table>
<table cellspacing="0" class="category sub">
<tbody>
<tr><th colspan="2"><span class="plus_minus sub"></span>Edit Code</th></tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">l</span></td>
<td>De<span class="kbd">l</span>ete current line or selection of lines to and add to clipboard</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">l</span></td>
<td>De<span class="kbd">l</span>ete current line or selection of lines</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Delete</span></td>
<td>Delete word to right of cursor</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Backspace</span></td>
<td>Delete word to left of cursor</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Enter</span></td>
<td>Enter blank line above cursor</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">Enter</span></td>
<td>Enter blank line below cursor</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">u</span></td>
<td>Make <span class="kbd">u</span>ppercase</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">u</span></td>
<td>Make lowercase (reverse <span class="kbd">u</span>percase)</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">c</span></td>
<td><span class="kbd">C</span>omment selected text</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">u</span></td>
<td><span class="kbd">U</span>ncomment selected text</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">\</span></td>
<td>Remove white space and tabs in selection or around current cursor position</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">d</span></td>
<td>Format document to code formatting settings</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">f</span></td>
<td>Format selection to code formatting settings</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">space</span></td>
<td>Display parameter required for selected method</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">8</span></td>
<td>Visualize <span class="kbd">w</span>hitespace (or press <span class="kbd">Ctrl</span>+<span class="kbd">r</span>, then <span class="kbd">Ctrl</span>+<span class="kbd">w</span>)</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">d</span></td>
<td>Format document to code formatting settings</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">f</span></td>
<td>Format selection to code formatting settings</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">t</span></td>
<td><span class="kbd">T</span>ranspose word to right of cursor; makes b=a out of a=b if cursor was in front of a</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">t</span></td>
<td><span class="kbd">T</span>ranspose character left and right of cursor; cursor between ab would make ba</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">Alt</span>+<span class="kbd">t</span></td>
<td><span class="kbd">T</span>ranspose line: Move line below cursor up and current line down.</td>
</tr>
</tbody></table>
<table cellspacing="0" class="category sub">
<tbody>
<tr><th colspan="2"><span class="plus_minus sub"></span>IntelliSense and Code Helper</th></tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Space</span></td>
<td>Autocomplete word from completion list (or <span class="kbd">alt</span>+<span class="kbd">right arrow</span>)</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">Space</span></td>
<td>Show parameter info</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">f12</span></td>
<td>Display symbol definition</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">f12</span></td>
<td>Display symbol declaration</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">j</span></td>
<td>Open IntelliSense completion list</td>
</tr>
</tbody></table>
</div>
<div class="goto_top" style="display: block;">
<br /></div>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="link_5"></a>
<table cellspacing="0" class="category main">
<tbody>
<tr><th colspan="2"><span class="plus_minus main"></span>5. Build and Debug</th></tr>
<tr>
<td class="shortcut"><span class="kbd">f7</span></td>
<td>Build solution (or <span class="kbd">Ctrl</span>+<span class="kbd">shift</span>+<span class="kbd">b</span>)</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Alt</span>+<span class="kbd">f7</span></td>
<td>Rebuild solution</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+break</td>
<td>Cancel build process</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">\</span>+<span class="kbd">e</span></td>
<td>Show <span class="kbd">e</span>rror list</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">f9</span></td>
<td>Toggle breakpoint</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">b</span></td>
<td>Insert new function <span class="kbd">b</span>reakpoint</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">f5</span></td>
<td>Start debugging</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">f11</span></td>
<td>Debug / step into</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">f10</span></td>
<td>Debug / step over</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">f11</span></td>
<td>Debug / step out</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">f10</span></td>
<td>Debug / run to cursor</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Alt</span>+<span class="kbd">q</span></td>
<td>Show <span class="kbd">Q</span>uickwatch window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">f10</span></td>
<td>Set current statement to be the next executed</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Alt</span>+<span class="kbd">*</span> (on numeric keyboard)</td>
<td>Show nexst statement</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Alt</span>+<span class="kbd">e</span></td>
<td>Show <span class="kbd">E</span>xception dialog box</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">f11</span></td>
<td>Toggle between disassembly and user code view</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">f5</span></td>
<td>Stop Debugging</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">f5</span></td>
<td>Bypass debugger</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Alt</span>+<span class="kbd">p</span></td>
<td>Show attach to <span class="kbd">p</span>rocess window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Alt</span>+break</td>
<td>Break all executing threads</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td>
</tr>
</tbody></table>
<a href="http://www.blogger.com/blogger.g?blogID=3277299172183048611" name="link_6"></a>
<table cellspacing="0" class="category main">
<tbody>
<tr><th colspan="2"><span class="plus_minus main"></span> </th></tr>
</tbody></table>
<table cellspacing="0" class="category main"><tbody>
<tr><th colspan="2">6. Tool Windows</th></tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">/</span></td>
<td> Put cursor in the find/command box in toolbar</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">b</span></td>
<td> Open code snippet manager window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Alt</span>+<span class="kbd">f11</span></td>
<td> Open macro IDE window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">k</span>+<span class="kbd">w</span></td>
<td> Open bookmark window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Alt</span>+<span class="kbd">k</span></td>
<td> Open call hierarchy window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">c</span></td>
<td> Open <span class="kbd">c</span>lass view window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Alt</span>+<span class="kbd">a</span></td>
<td> Open Command window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">o</span></td>
<td> Open <span class="kbd">O</span>utput window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">e</span></td>
<td> Open R<span class="kbd">e</span>source view window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">s</span></td>
<td> Open <span class="kbd">S</span>erver explorer window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Ctrl</span>+<span class="kbd">Shift</span>+<span class="kbd">l</span></td>
<td> Open So<span class="kbd">l</span>ution explorer window</td>
</tr>
<tr>
<td class="shortcut"><span class="kbd">Shift</span>+<span class="kbd">Esc</span></td>
<td> Close Find & Replace Window</td>
</tr>
</tbody></table>
</div>
adihttp://www.blogger.com/profile/02564994916358661777noreply@blogger.com0