Shravanti's Blog

JQUERY TIPS

2013-04-30T13:00:00.001+05:30

As a follower of JQuery, I would like to share some of the Jquery tips which I use in day to day coding. Hope you find it useful.

1. To hide or show an element.

$("#EmailTextBox").hide();

$("#NameLabel").show();

2. To set an alternative background color of a HTML table.

$("#Table tbody tr:even").css("background-color", "#F7F7F7");

$("#Table tbody tr:odd").css("background-color", "#F0F0F0");

3. To disable or enable an element.

$("#DropDownList").attr("disabled", "disabled");

$("#DropDownList").removeAttr("disabled");

4. To check the SelectedIndex of a dropdownlist

var selectedIndex = $("DropDownList").prop("selectedIndex");

if (selectedIndex == 1) {

//Write code

}

(ASP.NET) PreviousPage Property

2012-06-05T10:05:00.000+05:30

The PreviousPage property can be used when we want to pass values between two aspx pages.

This property is useful when you do not want to use Server.Transfer to access value from previous page.

Consider an example, where we want to pass a label value from one page to another page.

Steps to do:

Main Page

Place a label and a button control.
Assign the label value to “Previous” and PostBackUrl of button control to Next page.
In the code behind, create a property and return the label value.

Next Page

1. Declare PreviousPageType directive in the aspx page.

2. Place a label control in the Next Page.

3. In the Page_Load, if the page is not postback, and if the previouspage is not null, then assign the property from previouspage to the label.

Main Page

.aspx

<body>

<div>

<asp:Label ID="Value" runat="server" Text="Previous"></asp:Label>

<asp:Button ID="Button1" runat="server" Text="Button" PostBackUrl="~/Next.aspx" />

</div>

</form>

</body>

.aspx.cs

public string Property

{

get

{

return this.Value.Text;

}

Next Page

.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Next.aspx.cs" Inherits="Next" %>

<%@ PreviousPageType VirtualPath="~/Main.aspx" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

</div>

</form>

</body>

</html>

.aspx.cs

protected void Page_Load(object sender, EventArgs e)

{

if (!this.Page.IsPostBack)

{

if (PreviousPage != null)

{

this.Label1.Text = (this.PreviousPage as Main).Property;

}

(SQL SERVER) To find the row count of all tables in a database

2012-05-11T14:51:00.001+05:30

Execute the below query to find the table names and the row count of the corresponding tables in a database.

SELECT

sysobjects.Name

, sysindexes.Rows

FROM

sysobjects

INNER JOIN sysindexes

ON sysobjects.id = sysindexes.id

WHERE

type = 'U'

AND sysindexes.IndId < 2

ORDER BY

sysobjects.name

The row count of a particular table can be found by executing

exec sp_spaceused 'tablename'

ROTATE IMAGE IN ASP.NET

2012-04-16T18:29:00.000+05:30

The image can be rotated in a desired degree using the Namespace System.Drawing in C#. The method that will be used is RotateFlip which has various rotatefliptypes from 90, 180, 270, none. In the below example, I have used the 90 degree rotation. The rotated image will be stored in the same path with the same name using the Save method.

In aspx page,

<asp:ImageButton ID="ImageButton" runat="server" ImageUrl="~/images/boat_nature.jpg" Width="300px" Height="300px" /><br /><br />

<asp:Button ID="RotateButton" runat="server" Text="Rotate" onclick="Button1_Click" />

In aspx.cs page

protected void Button1_Click(object sender, EventArgs e)

{

// get the full path of image url

string path = Server.MapPath(ImageButton.ImageUrl);

// create image from the image url

System.Drawing.Image img = System.Drawing.Image.FromFile(path);

// rotate Image 90' Degree

img.RotateFlip(RotateFlipType.Rotate90FlipXY);

// save it to its actual path

img.Save(path);

// release Image File

img.Dispose();

// Set Image Control Attribute property to new image(but its old path)

ImageButton.Attributes.Add("ImageUrl", path);

}

FILE UPLOAD IN ASP.NET USING C#

2012-04-16T12:21:00.000+05:30

The file upload can be performed easily using File upload control in ASP.NET. First include a file upload control, a button, a label to display the upload status and another label to display the uploaded details in the aspx page. Perform the upload operation in the onclick event of the upload button. Validate the file before uploading it in the specified folder. First, check whether the control has the file and check the content length if the file is selected. We need not use the ASP.NET validators to validate the file. Instead I have included labels to display the validated messages. After the file is uploaded, the uploaded details will be displayed in the label as shown in the below example.

In aspx page,

<tr>

<td >

<asp:Label ID="UploadLabel" runat="server" Text="Choose a File:" />

</td>

</tr>

<tr>

<td>

<asp:FileUpload ID="Upload" runat="server" />

</td>

</tr>

<tr>

<td>

<asp:Button ID="UploadButton" runat="server" Text="Upload" Width="200px"

onclick="UploadButton_Click" />

</td>

</tr>

<tr>

<td>

<asp:Label ID="StatusLabel" runat="server" ForeColor="DarkGreen" />

<asp:Label ID="DetailsLabel" runat="server" ForeColor="DarkGreen" Visible="false"/>

</td>

</tr>

</table>

In aspx.cs page

protected void UploadButton_Click(object sender, EventArgs e)

{

if (Upload.HasFile)

{

try

{

//Check the file size

if (Upload.PostedFile.ContentLength > 0)

{

//path to which file should be stored

string filename = Server.MapPath("~/uploads/" + Upload.FileName);

Upload.SaveAs(filename);

StatusLabel.Text = "File uploaded successfully!!";

// Display the uploaded file's details

DetailsLabel.Visible = true;

DetailsLabel.Text = string.Format(

@"Uploaded file: {0}<br />

File size (in bytes): {1:N0}<br />

Content-type: {2}",

Upload.FileName,

Upload.FileBytes.Length,

Upload.PostedFile.ContentType);

}

else

{

DetailsLabel.Visible = false;

StatusLabel.Text = "File could not be uploaded.";

}

catch (Exception ex)

{

DetailsLabel.Visible = false;

StatusLabel.Text = "File could not be uploaded. Error Message: " + ex.Message;

}

else

{

StatusLabel.Text = "Please select a file to upload";

}

SEND AN EMAIL WITH ATTACHMENT USING C#

2012-04-12T17:33:00.000+05:30

I have described an example to send an email using ASP.NET in C# and using GMAIL as a port.The Namespaces to be used are System.Net.Mail and System.IO. The code is written in the way that the attachment is stored in a folder temporarily before sending it and will be deleted afterwards.

In ASPX Page,

<tr>

<td>

<asp:TextBox ID="ToTextBox" runat="server" Width="400px"></asp:TextBox>

</td>

</tr>

<tr>

</tr>

<tr>

<td>Subject</td>

</tr>

<tr>

<td>Attachments</td>

<td>

<asp:FileUpload ID="FileUpload" runat="server" Width="400px" />

</td>

</tr>

<tr>

<td valign="top">Message</td>

<td>

<asp:TextBox ID="MessageTextBox" runat="server" TextMode="MultiLine" Columns="20" Rows="10" Width="400px"></asp:TextBox></td>

</tr>

<tr>

<asp:Button ID="SendButton" runat="server" Text="Send"

onclick="SendButton_Click" /></td>

</tr>

</table>

<div>

<asp:Label ID="StatusLabel" runat="server" Text="" ForeColor="Green" Font-Size="Large" Visible="false"></asp:Label>

</div>

In ASPX.CS Page,

protected void SendButton_Click(object sender, EventArgs e)

{

this.StatusLabel.Visible = true;

string FileName = string.Empty;

MailMessage objMail = new MailMessage();

objMail.From = new MailAddress("Your Mail Address");

objMail.To.Add(new MailAddress(ToTextBox.Text.Trim()));

if (CcTextBox.Text != string.Empty)

{

objMail.CC.Add(new MailAddress(CcTextBox.Text.Trim()));

}

objMail.Subject = SubjectTextBox.Text.Trim();

objMail.Body = MessageTextBox.Text.Trim();

objMail.IsBodyHtml = true;

try

{

if (FileUpload.HasFile)

{

HttpPostedFile pf = this.FileUpload.PostedFile;

// Filepath in which the file has to be stored

FileName = Server.MapPath("~") + @"\uploads\" + FileUpload.FileName.Substring(FileUpload.FileName.LastIndexOf('\\') + 1);

if (pf.ContentLength > 0)

{

pf.SaveAs(FileName);

pf.InputStream.Flush();

pf.InputStream.Close(); // just in case any other process has the handle

}

pf.InputStream.Dispose();

Attachment attach = new Attachment(FileName);

objMail.Attachments.Add(attach);

}

SmtpClient client = new SmtpClient();

client.Credentials = new System.Net.NetworkCredential("Mail Address", "Password");

client.Port = 587; // Gmail works on this port

client.Host = "smtp.gmail.com";

client.EnableSsl = true; //Gmail works on SSL

client.Send(objMail);

objMail.Dispose();

client.Dispose();

if (FileUpload.HasFile)

{

File.Delete(FileName);

}

catch (SmtpFailedRecipientsException exp)

{

StatusLabel.Text = "Unable to send email to " + exp.FailedRecipient;

}

catch (SmtpFailedRecipientException exp)

{

StatusLabel.Text = "Unable to send email to " + exp.FailedRecipient + "<br />Error Message: " + exp.Message.Replace("'", "\'");

}

catch (SmtpException exp)

{

StatusLabel.Text = "There was a problem in sending the email to " + ToTextBox.Text.Trim() + "<br />" + exp.Message.Replace("'", "\'");

}

catch (Exception exp)

{

StatusLabel.Text = "There was an Unknown Problem in sending the email:<br />"

+ exp.Message.Replace("'", "\'");

}

if (StatusLabel.Text == string.Empty)

{

StatusLabel.Text = "Mail sent successfully";

ToTextBox.Text = string.Empty;

CcTextBox.Text = string.Empty;

SubjectTextBox.Text = string.Empty;

MessageTextBox.Text = string.Empty;

}

(SQL SERVER)TO SCRIPT AN ENTIRE DATABASE ALONG WITH THE TABLE RECORDS

2012-04-12T11:22:00.000+05:30

Steps to be followed to script an entire database

1. Start the SQL Server Management Studio

2. Select and Right Click the database you want to script

3. Select Tasks > Generate Scripts… as seen in the below snapshot.

5. Select the database

6. Choose the options you want to script. NOTE: if you want to script the tables along with the records, Under Table/View Options, set the Script Data to true.

7. Choose the object types

8. Select the tables you want to script

9. Choose the script mode and the destination where you want to store the file if you are scripting it to file.

10. Click on Finish to start scripting the database.

TO PASS THE STRING ALONG WITH THE DOUBLE QUOTES IN C#

2012-04-04T11:51:00.001+05:30

To display a string enclosed within a double quotes, we can use,

string str = "I like \"string\""; -- Output: I like "string"

string str = @"Here is my ""quoted"" text."; -- Output: Here is my "quoted" text.

To display a string enclosed within a double quotes that is assigned a control value (eg:- label), we can use,

Label1.Text = "String";

string str = "\"" + Label1.Text + "\""; -- Output: "String"

HOW TO CREATE AND DOWNLOAD A TEXT FILE USING C#

2012-04-02T12:40:00.001+05:30

To create and download a text file with some text in it,
In aspx page,

<asp:Button ID="Button1" runat="server" Text="Download" onclick="Button1_Click" />

In aspx.cs page,

protected void Button1_Click(object sender, EventArgs e)

{

string text = "ASP.NET, C#, SQL SERVER, TIPS & TRICKS AND MORE..";

string attachment = String.Format("attachment; filename=Blog.txt");

HttpContext.Current.Response.ClearHeaders();

HttpContext.Current.Response.ClearContent();

HttpContext.Current.Response.AddHeader("content-disposition", attachment);

HttpContext.Current.Response.ContentType = "application/octet-stream";

HttpContext.Current.Response.Write(text);

HttpContext.Current.Response.End();

}

As you can see in the above code, the type of the file that has to be downloaded is specified in the ContentType. Similarly, we can download files with other extensions. For reference, take a look at the below formats .

".asf" = "video/x-ms-asf"

".avi" = "video/avi"

".doc" = "application/msword"

".zip" = "application/zip"

".xls" = "application/vnd.ms-excel"

".gif" = "image/gif"

".jpg"= "image/jpeg"

".wav" = "audio/wav"

".mp3" = "audio/mpeg3"

".mpg" "mpeg" = "video/mpeg"

".rtf" = "application/rtf"

".htm", "html" = "text/html"

".asp" = "text/asp"

RESTRICT MANUAL DATE INPUT USING JAVASCRIPT EVENTS

2012-03-29T17:25:00.000+05:30

To simply restrict manual date input in a asp:textbox that shows a popup calendar use

onKeyPress = "javascript: return false;" onPaste = "javascript: return false;" onCut="javascript: return false;"

(SQL SERVER) PIVOT WITH DYNAMIC COLUMNS

2012-03-29T17:04:00.001+05:30

Pivot is generally used in creating reports that converts table row values into column names. There are two ways of creating a pivot table. One way is to manually specify the column names that we want and create the desired output. Let me explain it with an example table named Products which when executed creates an output,

Now, we need to create a table that displays the ProductName values into column names and prices of that particular product as the row values. So the query to be executed is,

SELECT [Milk],[Fresh Juice], [Horlicks], [Boost], [Complan] FROM

(SELECT ProductName, Price FROM dbo.Products) prod

PIVOT (SUM(price) FOR prod.ProductName

IN ([Milk],[Fresh Juice], [Horlicks], [Boost], [Complan])) AS pvt

GROUP BY [Milk],[Fresh Juice], [Horlicks], [Boost], [Complan]

The output for above executed query will be,

This will be useful when we want to create a table with a desired name of columns. Another way to create a pivot table is by using dynamic columns i.e., all the values of particular column should be converted into column names. Let’s create it by using two different methods.

First Method,

DECLARE @cols NVARCHAR(2000)

DECLARE @output VARCHAR(MAX)

SELECT @cols = COALESCE(@cols + ',[' + ProductName + ']','[' + ProductName + ']')

FROM dbo.Products

SET @output = N'SELECT ' + @cols + ' FROM

(SELECT ProductName, Price FROM dbo.Products) prod

PIVOT (SUM(price) FOR prod.ProductName

IN ( ' + @cols + ' )) AS pvt'

EXEC (@output)

Executing the above query produces the output,

This method uses coalesce to generate the comma separated values of ProductName column and assigns the price value to the particular column.

Second Method,

DECLARE Products CURSOR FOR

SELECT ProductName FROM dbo.Products

DECLARE @ProductName NVARCHAR(MAX),

@Prod VARCHAR(50),

@Output NVARCHAR(MAX)

SET @Prod = ''

OPEN Products

FETCH NEXT FROM Products INTO @ProductName

WHILE @@FETCH_STATUS = 0

BEGIN

SET @Prod = @Prod + '[' + @ProductName + '],'

FETCH NEXT FROM Products INTO @ProductName

END

CLOSE Products

DEALLOCATE Products

SET @Prod = SUBSTRING(@Prod, 0, LEN(@Prod))

SET @Output = 'SELECT ' + @Prod + ' FROM

(SELECT ProductName, Price FROM dbo.Products) prod

PIVOT

(SUM(Price) for ProductName in ('+ @Prod +')) AS pvt'

PRINT @Output

EXEC sp_executesql @Output

Executing the above query produces the same output as the first method. This method uses CURSOR to generate the comma separated values of ProductName column. Hope this helps. :)

(SQL SERVER) ROW_NUMBER (), RANK () AND DENSE_RANK ()

2012-03-27T16:24:00.003+05:30

Generating serial numbers is made easy by the use of in-built functions Row_number (), Rank () and Dense_Rank () in SQL SERVER. Let’s understand the use of these functions with a simple example.

Row_Number()

Row_number() is used to generate serial numbers in sequential order. It outputs the result by including the column names in the ORDER BY clause. Based upon the column, it will generate the result.

Let’s create an example table first and insert some dummy values into it,

CREATE TABLE Products

(

ProductId INT IDENTITY(1,1),

ProductName VARCHAR(50),

Price INT,

ProductRating INT

)

INSERT INTO Products

VALUES ('Milk', 15, 5 ),

('Fresh Juice', 20, 4 ),

('Horlicks', 200, 2 ),

('Boost', 200, 3 ),

('Complan', 300, 3 )

SELECT * FROM Products

When executing the select query produces the below output,

If we want to add serial numbers along with the output, the SQL statement to be used is,

SELECT ProductId,ProductName,Price,ProductRating,

ROW_NUMBER() OVER (ORDER BY ProductId) AS _Row_number FROM Products

The above SQL statement will produce an output,

It generates running serial numbers by including ProductId in the ORDER BY clause. Let’s say, if we want to generate serial numbers based upon the Price column then the output will be different. To understand it further execute the below code to view the output.

SELECT ProductId,ProductName,Price,ProductRating,

ROW_NUMBER() OVER (PARTITION BY Price ORDER BY ProductId) AS _Row_number FROM Products

As you can see, the serial numbers is changed to display according to the price column.It is achieved by including the column name price in the PARTITION BY. The PARTITION BY acts similar to the GROUP BY to generate the serial numbers.

Rank()

Rank() function is used to assign rank based on a particular column. For example, if there are two products that share the same price then the rank generated will be same let’s say 1, where in the third product with some other value will generate the rank 3 instead of 2. To understand it better execute the below SQL query and view the output.

SELECT ProductId,ProductName,Price,ProductRating,

RANK() OVER (ORDER BY Price) AS _Rank FROM Products

As you can see, the products with price 200 generates the rank 3 but the next price generates 5 instead of 4.

Dense_Rank()

Dense_Rank() function is similar to Rank() with one difference that if in rank() the number generated for two products sharing same value is 3, then the next product will have rank number 5, but Dense_Rank() generates the next number to the previous number. Lets understand this with executing the select query,

SELECT ProductId,ProductName,Price,ProductRating,

DENSE_RANK() OVER (ORDER BY Price) AS _Dense_Rank FROM Products

The above SQL statement produces an output,

The products with price 200 generates the rank 3 whereas the next product generates the next number 4. This function will be useful when trying to retrieve highest to lowest ranks as 1^st, 2^nd, 3^rd , etc. Accordingly, we can use PARTITION BY to filter the Rank() and Dense_Rank() further.

(SQL SERVER) WHAT IS NEWID()? USE OF NEWID()?

2012-03-23T18:22:00.000+05:30

SQL NEWID() is a T-SQL function that returns type “uniqueidentifier”. It is very useful in generating random numbers and random records from a sql table.

To generate random numbers,

DECLARE @myid uniqueidentifier

SET @myid = NEWID()

PRINT 'Value of @myid is: '+ CONVERT(varchar(255), @myid)

OUTPUT

Value of @myid is: E05F972A-51E3-41AF-AC08-C8009FC0BF5F

The above sql statement results in a random uniqueidentifier value whereas the sql statement,

SELECT ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT)) AS [NewID]

OUTPUT

NEWID

1737359308

Results in an integer value (note that the values will be different everytime the query is executed). To generate values with the desired no. of digits, we can use the RAND() function with the NEWID() as the seed parameter.

SELECT CAST(RAND(ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT))) * 100 AS INT) AS [Rand]

OUTPUT

Rand

To generate random records,

Random records can be retrieved from a sql table by including the NEWID() function in the ORDER BY clause in the select statement.

SELECT * FROM TABLENAME ORDER BY NEWID()

To make use of the function further, we can retrieve desired number of random records by including the TOP clause.

SELECT TOP 5 * FROM TABLENAME ORDER BY NEWID()

(SQL SERVER) CONVERT SQL DATES TO DESIRED DATE FORMAT

2012-03-23T15:53:00.000+05:30

SELECT CONVERT(VARCHAR, GETDATE(), 0) -- Mar 23 2012 3:51PM

SELECT CONVERT(VARCHAR, GETDATE(), 100) -- Mar 23 2012 3:51PM

SELECT CONVERT(VARCHAR, GETDATE(), 101) -- 03/23/2012

SELECT CONVERT(VARCHAR, GETDATE(), 102) -- 2012.03.23

SELECT CONVERT(VARCHAR, GETDATE(), 103) -- 23/03/2012

SELECT CONVERT(VARCHAR, GETDATE(), 104) -- 23.03.2012

SELECT CONVERT(VARCHAR, GETDATE(), 105) -- 23-03-2012

SELECT CONVERT(VARCHAR, GETDATE(), 106) -- 23 Mar 2012

SELECT CONVERT(VARCHAR, GETDATE(), 107) -- Mar 23, 2012

SELECT CONVERT(VARCHAR, GETDATE(), 108) -- 15:52:23

SELECT CONVERT(VARCHAR, GETDATE(), 109) -- Mar 23 2012 3:52:35:097PM

SELECT CONVERT(VARCHAR, GETDATE(), 110) -- 03-23-2012

SELECT CONVERT(VARCHAR, GETDATE(), 111) -- 2012/03/23

SELECT CONVERT(VARCHAR, GETDATE(), 112) -- 20120323

SELECT CONVERT(VARCHAR, GETDATE(), 113) -- 23 Mar 2012 15:53:23:143

SELECT CONVERT(VARCHAR, GETDATE(), 114) -- 15:53:31:690

SELECT CONVERT(VARCHAR, GETDATE(), 120) -- 2012-03-23 15:53:31

SELECT CONVERT(VARCHAR, GETDATE(), 121) -- 2012-03-23 15:53:31.690

(SQL SERVER) SIMPLE EXAMPLE OF USING A CURSOR

2012-03-22T17:35:00.000+05:30

The below example explains the retrieval of column values in single column separated by commas.

DECLARE Holiday CURSOR FOR

SELECT HolidayName FROM HolidayMaster

DECLARE @HolidayName NVARCHAR(MAX),

@Output NVARCHAR(MAX)

SET @Output = ''

OPEN Holiday

FETCH NEXT FROM Holiday INTO @HolidayName

WHILE @@FETCH_STATUS = 0

BEGIN

SET @Output = @Output + '' + @HolidayName + ','

FETCH NEXT FROM Holiday INTO @HolidayName

END

--To remove the comma at the end

SET @Output = SUBSTRING(@Output, 0, LEN(@Output))

CLOSE Holiday

DEALLOCATE Holiday

SELECT @Output AS Output

OUTPUT

Adding control to gridview cell dynamically

2012-03-21T18:39:00.000+05:30

A control can be added to a gridview using the rowdatabound event.

protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        Image img = new Image();
        img.ImageUrl = "~/images/logo.png";

        TableCell tcell = new TableCell();
        tcell.Controls.Add(img);

        //The control will be added to second cell of the gridview.
        e.Row.Cells[2].Controls.Add(img);
    }
}

Getting the ID of recently inserted record

2012-03-21T18:08:00.000+05:30

To retrieve the ID of the recently inserted record in a sqldatasource control,

<asp:SqlDataSource ID="SqlDataSource" runat="server"
            ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:DBConnectionString %>"
            InsertCommand="INSERT INTO [ClaimListing] ([UserID], [ClaimTypeCode]) VALUES (@UserID, @ClaimTypeCode); SELECT @NewClaimNo = SCOPE_IDENTITY();"
            OldValuesParameterFormatString="original_{0}"
            OnInserted="SqlDataSource_Inserted">
            <InsertParameters>
                <asp:Parameter Name="UserID" />
                <asp:Parameter Name="ClaimTypeCode" Type="Int32" />
                <asp:Parameter Direction="Output" Type="Int32" Name="NewClaimNo" />
            </InsertParameters>
        </asp:SqlDataSource>

And in the code behind,

protected void SqlDataSource_Inserted(object sender, SqlDataSourceStatusEventArgs e)
    {
        //Read the value of the @Identity OUTPUT parameter
        string ClaimNo = e.Command.Parameters["@NewClaimNo"].Value.ToString();
    }

The identity can be assigned to a hiddenfield control to be accessed from other function.

Sorting in a Repeater

2012-03-21T16:13:00.001+05:30

Even though ASP.NET Repeater control does not have sorting option as the Gridview does, it can be manually coded easily using the Dataview. To implement the sorting include in

.aspx page

<asp:Repeater ID="Repeater" runat="server" ClientIDMode="Static" OnItemCommand="Repeater_ItemCommand">
            <HeaderTemplate>
                <table cellspacing="2" cellpadding="5" >
                    <tr style="background-color: #D2B48C;">
                        <th align="center" style="width: 20px;">
                        </th>
                        <th align="center" style="width: 55px;">
                            <asp:LinkButton ID="ClaimNoLinkButton" runat="server" Text="ClaimNo" CommandName="ClaimNo"></asp:LinkButton>
                        </th>
                        <th align="left" style="width: 100px;">
                            <asp:LinkButton ID="LastUpdatedOnLinkButton" runat="server" Text="LastUpdatedOn"
                                CommandName="LastUpdatedOn"></asp:LinkButton>
                        </th>
                    </tr>
            </HeaderTemplate>
            <FooterTemplate>
                <tr>
                    { contents }
                </tr>
                </table>
            </FooterTemplate>
            <ItemTemplate>
                <tr>
                    { contents }
                </tr>
            </ItemTemplate>
            <AlternatingItemTemplate>
                <tr>
                    { contents }
                </tr>
            </AlternatingItemTemplate>
        </asp:Repeater>

.cs page

In page load, if the page is not postback,

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.Page.IsPostBack)
    {
            //Set View State Value for Initial Sort Order
            ViewState["Column"] = "ClaimNo";
            ViewState["Order"] = "DESC";

           BindRepeater();
    }
}

protected void Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
            if (e.CommandName == ViewState["Column"].ToString())
            {
                if (ViewState["Order"].ToString() == "ASC")
                    ViewState["Order"] = "DESC";
                else
                    ViewState["Order"] = "ASC";
            }
            else
            {
                ViewState["Column"] = e.CommandName;
                ViewState["Order"] = "ASC";
            }
        }

public void BindRepeater()
{
DataTable dt = new DataTable();

        dt.Columns.Add("ClaimNo", typeof(int));
        dt.Columns.Add("LastUpdatedOn", typeof(DateTime));

dt.Rows.Add(1, "2012-03-16 00:00:00.000");
dt.Rows.Add(2, "2012-02-16 00:00:00.000");

        Repeater.DataSource = dt;
        Repeater.DataBind();

        DataView dvSort = new DataView(dt);
        dvSort.Sort = ViewState["Column"].ToString() + " " + ViewState["Order"].ToString();                //Sorting columns in Repeater

        Repeater.DataSource = dvSort;
        Repeater.DataBind();
}

Auto Size the DIV based on its contents

2012-02-28T12:52:00.003+05:30

To have a <DIV> shrink and enlarge based on its content, use either,

div { margin: 0 auto; }

or

div.autosize { display: table; width: 1px; }
div.autosize > div { display: table-cell; }

FREQUENTLY ASKED ASP.NET QUESTIONS (PART-1)

2011-11-19T20:12:00.000+05:30

1. 4 main OOPS concept?

Encapsulation, Abstraction, Inheritance, Polymorphism

2. Explain Interface?

-> Interface contains only declaration of members. Classes and structures implement these interface members.

-> It has no implementation.

-> contains signature of method, properties, indexes, events.

-> declares only methods, functions and properties in interfaces.cannot declare a variable in interface.

Eg :-

public interface IOrderDetails

{

//Declare an interface member

void UpdateCustStatus();

void TakeOrder();

}

public void UpdateCustStatus()

{

--------

}

public void TakeOrder()

{

--------

}

3. Properties?

-> Attributes of an object.

eg;- a car has color as property

private string m_color;

public string color

{

get { return m-color; }

set { m_color = value; }

}

car maruti = new car();

maruti.color = "white";

console.write(maruti.color);

4. Define Encapsulation

Packing one or more components together thus preventing access to non-essential details thereby resulting in abstraction which displays only relevant information.

5. Access specifiers

Protected, internal, protected internal, public, private

6. How to prevent your class from being inherited by another class?

use sealed class

7. What is the .NET collection class that allows an element to be accessed using a unique key?

Hash table

8. Define abstract class?
1. A class that cannot be instantiated.
2. An abstract class is a class that must be inherited and have the methods overridden.
3. An abstract class is essentially a blueprint for a class without any implementation

9. Name two properties common in every validation control?

ControlToValidate property and Text property

10. What’s a bubbled event?

Events raised by child controls is handled by parent controls. Eg:- Consider datagrid as a parent control in which there are several child controls. There can be a column of link buttons. Instead of writing event routine for each link button, write one routine for parent which will handle the click events of child link buttons.

11. Define smart navigation?

Cursor position is maintained when the page gets refreshed due to server side validation and the page gets refreshed.

12. What is master page?

A single master page defines the look and feel and standard behaviour that you want for all of the pages in a n application.

SORTING AND PAGING IN A GRIDVIEW

2011-11-14T12:43:00.001+05:30

To manually allow paging and sorting in a gridview, include
AllowSorting="True" AllowPaging="True" onpageindexchanging="GridView1_PageIndexChanging" onsorting="GridView1_Sorting" in the gridview control.

The code behind is,

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {

            GridView1.PageIndex = e.NewPageIndex;
            GridView1.DataBind();
            //Bindgrid();
        }

        protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
        {
           string sortExpression = e.SortExpression;

            if (GridViewSortDirection == SortDirection.Ascending)
            {
                GridViewSortDirection = SortDirection.Descending;
                SortGridView(sortExpression, DESCENDING);
            }
            else
            {
                GridViewSortDirection = SortDirection.Ascending;
                SortGridView(sortExpression, ASCENDING);
            }
        }

        private void SortGridView(string sortExpression, string direction)
        {
            // You can cache the DataTable for improving performance
            SqlConnection con = new SqlConnection(connection);
            con.Open();
            DA = new SqlDataAdapter("Select * from table_name", con);
            DataTable dt = new DataTable();
            DA.Fill(dt);

            GridView1.DataSource = dt;
            GridView1.DataBind();
            con.Close();

            DataView dv = new DataView(dt);
            dv.Sort = sortExpression + direction;

            GridView1.DataSource = dv;
            GridView1.DataBind();
        }

        public SortDirection GridViewSortDirection
        {
            get
            {
                if (ViewState["sortDirection"] == null)
                    ViewState["sortDirection"] = SortDirection.Ascending;

                return (SortDirection)ViewState["sortDirection"];
            }
            set { ViewState["sortDirection"] = value; }
        }

display an alert box using C#

2011-11-10T16:40:00.001+05:30

As the C# language does not have an alert option, we can achieve it by including the below function and calling it where ever it is required.The code snippet is as follows,

public static class Alert
        {
            /// <summary>
            /// Shows a client-side JavaScript alert in the browser.
            /// </summary>
            /// <param name="message">The message to appear in the alert.</param>
            public static void Show(string message)
            {
                // Cleans the message to allow single quotation marks
                string cleanMessage = message.Replace("'", "\\'");
                string script = "<script type=\"text/javascript\">alert('" + cleanMessage + "');</script>";

                // Gets the executing web page
                Page page = HttpContext.Current.CurrentHandler as Page;

                // Checks if the handler is a Page and that the script isn't allready on the Page
                if (page != null && !page.ClientScript.IsClientScriptBlockRegistered("alert"))
                {
                    page.ClientScript.RegisterClientScriptBlock(typeof(Alert), "alert", script);
                }
            }
        }

Example

if (age <= 18 || age >= 65)

{

Alert.Show("Employee's age must be between 18 and 65!");

}

The above function will display an alert in a blank page whereas if we want to display an alert in the same page, include the below snippet,

Page.ClientScript.RegisterStartupScript(this.GetType(), "ErrorAlert", "alert('ALERT MESSAGE');", true);

Example

if (age <= 18 || age >= 65)

{

Page.ClientScript.RegisterStartupScript(this.GetType(), "ErrorAlert", "alert('Employee's age must be between 18 and 65!');", true);

}