ASP.net button text to wrap to second line

Some times we have more matter to write on Asp.net Button and the button becomes longer in width.. if we make its width small then text will be truncated (complete text will not be visible). so to do this here is solution:Lets say you want to write following line on page in this way: Submit here if you are an Engineerto write text in above format in asp button write it in below format:Submit here if...

Read More

Multiple Active Result Sets (MARS) in SQL Server 2005

MARS is newly added future in SQL 2005. In earlier version from sql2005 user are not allowed to run more than one SQL batch on an open connection at the same time but sql2005 allows the user to run more than one SQL batch on an open connection at the same time. private void MARS_Off(){ SqlConnection conn = new SqlConnection("Server=serverName; Database=adventureworks;Trusted_Connection=yes;"); string sql1 = "SELECT...

Read More

Common Table Expressions in SQL Server (2005/2008)

Using Common Table ExpressionsA common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times...

Read More

Inline & Code Behind code in Asp.net

Inline & Codebehind CodeInline Code is mixing client and serverside code on the same page like HTMLandJavaScript. So precompilation is no need.CodeBehind .aspx separately only for serverside code. So it provides good performance than inline code. Why because CodeBehind needs to be compile in advance.Article Author: Rajesh Role...

Read More

Check all Checkbox of HTML Table Using JQuery

Lets we have a HTML Table and we have checkbox in every row and we have a checkbox in Table Header.. now we want that when we click on checkbox of table header then all checkbox of table should be checked/unchecked according checked state of checkbox in table header.. using JQueryeg:< %@ Page Language="C#" AutoEventWireup="true" CodeFile="chkall.aspx.cs" Inherits="chkall" % >< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML...

Read More