Monday 10 December 2012

WCF Errors and Solutions

Could not find default endpoint element that references contract 'IMySOAPWebService' in the service model client configuaration section. This might be because no configuaration file was found for your application or because no end point element matching this contract could be found in the client element

Ans : If you consuming the WCF service in console application through IIS then change the output.config file to App.config

Tuesday 25 September 2012

Duplicate Record Finding

select distinct field2,count(*) from mee_mdb group by field2 having count(*)>1

Monday 23 July 2012

CSS tutorial

A fixed background image (this image will not scroll with the rest of the page)

<!DOCTYPE html>
<html>
<head>
<style type="text/css">
body
{
background-image:url('smiley.gif');
background-repeat:no-repeat;
background-attachment:fixed;
}
</style>
</head>

<body>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
<p>The background-image is fixed. Try to scroll down the page.</p>
</body>

</html>

output:
=====

The background-image is fixed. Try to scroll down the page.

=====================================================================
Control the letters in a text
<!DOCTYPE html>
<html>
<head>
<style type="text/css">
p.uppercase {text-transform:uppercase;}
p.lowercase {text-transform:lowercase;}
p.capitalize {text-transform:capitalize;}
</style>
</head>

<body>
<p class="uppercase">This is some text.</p>
<p class="lowercase">This is some text.</p>
<p class="capitalize">This is some text.</p>
</body>
</html>

output:
======

THIS IS SOME TEXT.

this is some text.

This Is Some Text.

=========================================================================

Add different colors to visited/unvisited links

<!DOCTYPE html>
<html>
<head>
<style type="text/css">
a:link {color:#FF0000;} /* unvisited link */
a:visited {color:#00FF00;} /* visited link */
a:hover {color:#FF00FF;} /* mouse over link */
a:active {color:#0000FF;} /* selected link */
</style>
</head>

<body>
<p><b><a href="default.asp" target="_blank">This is a link</a></b></p>
<p><b>Note:</b> a:hover MUST come after a:link and a:visited in the CSS
definition in order to be effective.</p>
<p><b>Note:</b> a:active MUST come after a:hover in the CSS definition in order
to be effective.</p>
</body>
</html>

output:
======

This is a link

Note: a:hover MUST come after a:link and a:visited in the CSS definition in order to be effective.

Note: a:active MUST come after a:hover in the CSS definition in order to be effective.

=======================================================================

Use of text-decoration on links

<!DOCTYPE html>
<html>
<head>
<style type="text/css">
a:link {text-decoration:none;} /* unvisited link */
a:visited {text-decoration:none;} /* visited link */
a:hover {text-decoration:underline;} /* mouse over link */
a:active {text-decoration:underline;} /* selected link */
</style>
</head>

<body>
<p><b><a href="default.asp" target="_blank">This is a link</a></b></p>
<p><b>Note:</b> a:hover MUST come after a:link and a:visited in the CSS
definition in order to be effective.</p>
<p><b>Note:</b> a:active MUST come after a:hover in the CSS definition in order
to be effective.</p>
</body>
</html>

output:
=====

This is a link

Note: a:hover MUST come after a:link and a:visited in the CSS definition in order to be effective.

Note: a:active MUST come after a:hover in the CSS definition in order to be effective.

======================================================================

Specify a background color for links

<!DOCTYPE html>
<html>
<head>
<style type="text/css">
a:link {background-color:#B2FF99;} /* unvisited link */
a:visited {background-color:#FFFF85;} /* visited link */
a:hover {background-color:#FF704D;} /* mouse over link */
a:active {background-color:#FF704D;} /* selected link */
</style>
</head>

<body>
<p><b><a href="default.asp" target="_blank">This is a link</a></b></p>
<p><b>Note:</b> a:hover MUST come after a:link and a:visited in the CSS
definition in order to be effective.</p>
<p><b>Note:</b> a:active MUST come after a:hover in the CSS definition in order
to be effective.</p>
</body>
</html>

output:
======

This is a link

Note: a:hover MUST come after a:link and a:visited in the CSS definition in order to be effective.

Note: a:active MUST come after a:hover in the CSS definition in order to be effective.

=====================================================================

Add other styles to hyperlinks

<!DOCTYPE html>
<html>
<head>
<style type="text/css">
a.one:link {color:#ff0000;}
a.one:visited {color:#0000ff;}
a.one:hover {color:#ffcc00;}

a.two:link {color:#ff0000;}
a.two:visited {color:#0000ff;}
a.two:hover {font-size:150%;}

a.three:link {color:#ff0000;}
a.three:visited {color:#0000ff;}
a.three:hover {background:#66ff66;}

a.four:link {color:#ff0000;}
a.four:visited {color:#0000ff;}
a.four:hover {font-family:monospace;}

a.five:link {color:#ff0000;text-decoration:none;}
a.five:visited {color:#0000ff;text-decoration:none;}
a.five:hover {text-decoration:underline;}
</style>
</head>

<body>
<p>Mouse over the links to see them change layout.</p>

<p><b><a class="one" href="default.asp" target="_blank">This link changes color</a></b></p>
<p><b><a class="two" href="default.asp" target="_blank">This link changes font-size</a></b></p>
<p><b><a class="three" href="default.asp" target="_blank">This link changes background-color</a></b></p>
<p><b><a class="four" href="default.asp" target="_blank">This link changes font-family</a></b></p>
<p><b><a class="five" href="default.asp" target="_blank">This link changes text-decoration</a></b></p>
</body>

</html>

output:
=====

Mouse over the links to see them change layout.

This link changes color

This link changes font-size

This link changes background-color

This link changes font-family

This link changes text-decoration

========================================================================

Add other styles to hyperlinks

<!DOCTYPE html>
<html>
<head>
<style type="text/css">
a:link,a:visited
{
display:block;
font-weight:bold;
color:#FFFFFF;
background-color:#98bf21;
width:120px;
text-align:center;
padding:4px;
text-decoration:none;
}
a:hover,a:active
{
background-color:#7A991A;
}
</style>
</head>

<body>
<a href="default.asp" target="_blank">This is a link</a>
</body>
</html>outout:
======
This is a link

================================================================
Set an image as the list-item marker
<!DOCTYPE html>
<html>
<head>
<style type="text/css">
ul
{
list-style-image:url('sqpurple.gif');
}
</style>
</head>

<body>
<ul>
<li>Coffee</li>
<li>Tea</li>
<li>Coca Cola</li>
</ul>
</body>
</html>
===================================================================
Set an image as the list-item marker - Crossbrowser solution

<!DOCTYPE html>
<html>
<head>
<style type="text/css">
ul
{
list-style-type:none;
padding:0px;
margin:0px;
}
ul li
{
background-image:url(sqpurple.gif);
background-repeat:no-repeat;
background-position:0px 5px;
padding-left:14px;
}
</style>
</head>

<body>
<ul>
<li>Coffee</li>
<li>Tea</li>
<li>Coca Cola</li>
</ul>
</body>

</html>

======================================================================

Sunday 22 July 2012

calculating amount based on mutuallay exclusive radio buttons for gridview

   for (int i = 0; i < gvConsolidatedReport1.Rows.Count; i++)
                        {

                            RadioButtonList rbPCRC = (RadioButtonList)gvConsolidatedReport1.Rows[i].FindControl("sdf");
                            if (rbPCRC.SelectedValue == "PC")
                            {
                                dr = receipt.NewRow();

                                subjects += "PC@" + gvConsolidatedReport1.Rows[i].Cells[1].Text + ",";
                                subjectnames += "PC@" + gvConsolidatedReport1.Rows[i].Cells[0].Text + ",";

                                dr["Subjects"] = gvConsolidatedReport1.Rows[i].Cells[0].Text;
                                dr["PCRC"] = rbPCRC.SelectedValue;
                                pCount += 1;
                                dr["SNo"] = CountRecords++;
                                total += Convert.ToDecimal(PCAMOUNT);
                                receipt.Rows.Add(dr);
                            }
                            else if (rbPCRC.SelectedValue == "RC")
                            {
                                dr = receipt.NewRow();

                                subjects += "RC@" + gvConsolidatedReport1.Rows[i].Cells[1].Text + ",";
                                subjectnames += "RC@" + gvConsolidatedReport1.Rows[i].Cells[0].Text + ",";
                                dr["Subjects"] = gvConsolidatedReport1.Rows[i].Cells[0].Text;
                                dr["PCRC"] = rbPCRC.SelectedValue;
                                rCount += 1;
                                dr["SNo"] = CountRecords++;
                                total += Convert.ToDecimal(RCAMOUNT);
                                receipt.Rows.Add(dr);
                            }
                        }

                        totalAmount = total + Convert.ToDecimal(SERVICECHARGE);
                        Session["TotalAmount"] = totalAmount;
                        Session["PCCOUNT"] = pCount;
                        Session["RCCOUNT"] = rCount;

HTML Tutorial

Preformatted text (how to control line breaks and spaces)

<!DOCTYPE html>
<html>
<body>

<pre>
This is
preformatted text.
It preserves both spaces
and line breaks.
</pre>

<p>The pre tag is good for displaying computer code:</p>

<pre>
for i = 1 to 10
print i
next i
</pre>

</body>
</html>

OUTPUT:
=======

This is
preformatted text.
It preserves      both spaces
and line breaks.

The pre tag is good for displaying computer code:

for i = 1 to 10
     print i
next i

================================================================================

 Different computer-output tags

<!DOCTYPE html>
<html>
<body>

<code>Computer code</code>
<br />
<kbd>Keyboard input</kbd>
<br />
<tt>Teletype text</tt>
<br />
<samp>Sample text</samp>
<br />
<var>Computer variable</var>
<br />

<p><b>Note:</b> These tags are often used to display computer/programming code.</p>

</body>
</html>

output
======
Computer code
Keyboard input
Teletype text
Sample text
Computer variable

Note: These tags are often used to display computer/programming code.

--------------------------------------------------------------------------------------------------------

========================================================================

Insert contact information

<!DOCTYPE html>
<html>
<body>

<address>
Written by W3Schools.com<br />
<a href="mailto:us@example.org">Email us</a><br />
Address: Box 564, Disneyland<br />
Phone: +12 34 56 78
</address>

</body>
</html>

output:
=====
Written by W3Schools.com
Email us
Address: Box 564, Disneyland
Phone: +12 34 56 78
==========================================================
Abbreviations and acronyms

<!DOCTYPE html>
<html>
<body>

<p>The <abbr title="World Health Organization">WHO</abbr> was founded in 1948.</p>

<p>Can I get this <acronym title="as soon as possible">ASAP</acronym>?</p>

<p>The title attribute is used to show the spelled-out version when holding the mouse pointer over the acronym or abbreviation.</p>

</body>
</html>
output:
=====

The WHO was founded in 1948.

Can I get this ASAP?

The title attribute is used to show the spelled-out version when holding the mouse pointer over the acronym or abbreviation

=======================================================================

Text direction

<!DOCTYPE html>
<html>
<body>

<p>
If your browser supports bi-directional override (bdo), the next line will be written from the right to the left (rtl):
</p>

<bdo dir="rtl">
Here is some Hebrew text
</bdo>

</body>
</html>
output:
=====

If your browser supports bi-directional override (bdo), the next line will be written from the right to the left (rtl):

Here is some Hebrew text
=====================================================================
Long and short quotations

<!DOCTYPE html>
<html>
<body>

A long quotation:
<blockquote>
This is a long quotation. This is a long quotation. This is a long quotation. This is a long quotation. This is a long quotation.
</blockquote>

<p><b>Note:</b> The browser inserts white space before and after a blockquote element. It also inserts margins.</p>

A short quotation:
<q>This is a short quotation</q>

<p><b>Note:</b> The browser inserts quotation marks around the short quotation.</p>

</body>
</html>
output:
=====
A long quotation:

This is a long quotation. This is a long quotation. This is a long quotation. This is a long quotation. This is a long quotation.

Note: The browser inserts white space before and after a blockquote element. It also inserts margins.

A short quotation: This is a short quotation

Note: The browser inserts quotation marks around the short quotation.

======================================================================

How to mark deleted and inserted text

<!DOCTYPE html>
<html>
<body>

<p>My favorite color is <del>blue</del> <ins>red</ins>!</p>

<p>Notice that browsers will strikethrough deleted text and underline inserted text.</p>

</body>
</html>
output:
=====

My favorite color is
blue

red
!

Notice that browsers will strikethrough deleted text and underline inserted text.

========================================================================

Open link in a new browser window

<!DOCTYPE html>
<html>
<body>

<a href="http://www.w3schools.com" target="_blank">Visit W3Schools.com!</a>

<p>If you set the target attribute to "_blank", the link will open in a new browser window/tab.</p>

</body>
</html>

output:
=====
Visit W3Schools.com!

If you set the target attribute to "_blank", the link will open in a new browser window/tab.

=====================================================================

Jump to another part of a document (on the same page)

<!DOCTYPE html>
<html>
<body>

<p>
<a href="#C4">See also Chapter 4.</a>
</p>

<h2>Chapter 1</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 2</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 3</h2>
<p>This chapter explains ba bla bla</p>

<h2><a name="C4">Chapter 4</a></h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 5</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 6</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 7</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 8</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 9</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 10</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 11</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 12</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 13</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 14</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 15</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 16</h2>
<p>This chapter explains ba bla bla</p>

<h2>Chapter 17</h2>
<p>This chapter explains ba bla bla</p>

</body>
</html>

output
==========