Tuesday 26 February 2013

Multiview Control To create Tabbed looks

Code :


<html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server"><title>Tabbed pages</title>
        <style type="text/css">
            .style1
            {
                height: 31px;
            }
        </style>
          <style type="text/css">
        .Initial
        {
            display: block;
            padding: 4px 18px 4px 18px;
            float: left;
            background: url("Images/InitialImage.png") no-repeat right top;
            color: Black;
            font-weight: bold;
        }
        .Initial:hover
        {
            color: White;
            background: url("Images/SelectedButton.png") no-repeat right top;
        }
        .Clicked
        {
            float: left;
            display: block;
            background: url("Images/SelectedButton.png") no-repeat right top;
            padding: 4px 18px 4px 18px;
            color: Black;
            font-weight: bold;
            color: White;
        }
    </style>

    </head>
    <body>
        <form id="form" runat="server">
            <table cellspacing="10">
                <tr>
                    <td class="style1"><asp:LinkButton ID="Link1" runat="server" CssClass="Initial">Package</asp:LinkButton></td>
                    <td class="style1"><asp:LinkButton ID="Link2" runat="server" CssClass="Initial">Itenary</asp:LinkButton></td>
                    <td class="style1"><asp:LinkButton ID="Link3" runat="server" CssClass="Initial">Link 3</asp:LinkButton></td>
                </tr>        
            </table>
            <asp:MultiView ID="MyMultiView" runat="server">
                <asp:View ID="View1" runat="server">
                    Tab 1 - insert your content here
       
                   
                   
                </asp:View>
                <asp:View ID="View2" runat="server">
                    Tab 2 - insert your content here
                   
           
                   
                </asp:View>
                <asp:View ID="View3" runat="server">
                    Tab 3 - insert your content here
                   
                   
                   
                </asp:View>
            </asp:MultiView>
        </form>
    </body>
</html>


Output :





Wednesday 16 January 2013

Some Frequently Used Asp.Net Code SNIPPETS


How to apply css to text box control

 How to apply css to text box control

Create Website:-
1) Open Visual Studio
2) File->New Website->Give Website name and path.
3) Choose C#

Paste below code in your aspx file.

[code]
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" %>

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

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>How to apply css to text box control</title>
<style type="text/css">

.textbox1
{
    background-color : #99FFCC;
    border: 1px solid #008000;
    width: 230px;
     font-size: 12px;
color: red;
}



</style>
  
</head>
<body>

    <form id="form1" runat="server">
    <asp:TextBox ID="TextBox1" CssClass="textbox1" runat="server"></asp:TextBox>
   
    </form>
</body>
</html>

[/code]

 


I want to write java script validation for textbox contain only numeric values and if all the values are numeric then there is one button control will get enable or else disable.

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
<script type="text/javascript">
function valNumeric(evt)
{
var charCode;
charCode = (evt.which) ? evt.which : event.keyCode;
if (charCode >= 48 && charCode <= 57 || charCode== 8 || charCode == 118 || charCode == 120 || charCode == 99 )
{
return true;
}
else
{
return false;
}
}
function EnableButton()
{
document.getElementById("Button1").style.visibility ="visible";
}
function DisableButton()
{
document.getElementById("Button1").style.visibility ="hidden";
}
</script>
</head>
<body onload="return DisableButton()">
<form id="form1" runat="server ">
<div>

<asp:TextBox ID="TextBox1" onkeypress="if(valNumeric(event)==true){EnableButton()}else{ return false}" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" />
</div>
</form>
</body>
</html>

How to get Row Number with the result of SQL select query?

How to get Row Number with the result of SQL select query?

Row Number concept not available in SQL Server 2000. It's introduced in SQL Server 2005.

The syntax of Row Number is

ROW_NUMBER () OVER ([)

Example of Row Number is
[code]
SELECT ROW_NUMBER() OVER (ORDER BY FieldName ASC) AS ROWNO, * FROM Table_Name
[/code]


Ranking Functions in SQL Server 2005

Ranking functions are introduced in sql server 2005. Ranking functions are used to creating arrays, generating sequential numbers, finding ranks, and so on, which in pre-2005 versions require more lines of code, now can be implemented easier and faster.

Let's look at the syntax of ranking functions
[code]
ROW_NUMBER () OVER ([)
RANK () OVER ([)
DENSE_RANK () OVER ([)
NTILE (integer_expression) OVER ([)
[/code]

Try the following code to get Row Number:-
[code]
SELECT ROW_NUMBER() OVER (ORDER BY FieldName ASC) AS ROWNO, * FROM Table_Name
[/code]


How to create controls using javascript

Just drag and drop one button control to page.

Just call CreateTextbox () on-click event of that button control.

In run-time if you click button the dynamic controls will display.

[code]
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

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

<html>
<head>
<title>Dynamic Form</title>
<script type="text/javascript" >
function CreateTextbox()
{
var i = 1;
createTextbox.innerHTML = createTextbox.innerHTML +"<input type=text name='mytext'+ i/>"
createTextbox.innerHTML = createTextbox.innerHTML +"<input type=button value='Dynamci Button'+ i name='mytext'+ i/>"

}
</script>
</head>
<body>

<form name="form">
<input type="button" value="clickHere" onClick="CreateTextbox()"/>
<div id="createTextbox">

</div>
</form>
</body>
</html>

[/code]

How to load all country name to dropdownlist?

This dropdownlist contains all the countries of the world.It should save you time if you need to create a dropdownlist with all the countries populated.
check the code here
[code]
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList id="ddlCountry" runat="server">
<asp:ListItem Value="" Selected="True">Select Country</asp:ListItem>
<asp:ListItem Value="AF">Afghanistan</asp:ListItem>
<asp:ListItem Value="AL">Albania</asp:ListItem>
<asp:ListItem Value="DZ">Algeria</asp:ListItem>
<asp:ListItem Value="AS">American Samoa</asp:ListItem>
<asp:ListItem Value="AD">Andorra</asp:ListItem>
<asp:ListItem Value="AO">Angola</asp:ListItem>
<asp:ListItem Value="AI">Anguilla</asp:ListItem>
<asp:ListItem Value="AQ">Antarctica</asp:ListItem>
<asp:ListItem Value="AG">Antigua And Barbuda</asp:ListItem>
<asp:ListItem Value="AR">Argentina</asp:ListItem>
<asp:ListItem Value="AM">Armenia</asp:ListItem>
<asp:ListItem Value="AW">Aruba</asp:ListItem>
<asp:ListItem Value="AU">Australia</asp:ListItem>
<asp:ListItem Value="AT">Austria</asp:ListItem>
<asp:ListItem Value="AZ">Azerbaijan</asp:ListItem>
<asp:ListItem Value="BS">Bahamas</asp:ListItem>
<asp:ListItem Value="BH">Bahrain</asp:ListItem>
<asp:ListItem Value="BD">Bangladesh</asp:ListItem>
<asp:ListItem Value="BB">Barbados</asp:ListItem>
<asp:ListItem Value="BY">Belarus</asp:ListItem>
<asp:ListItem Value="BE">Belgium</asp:ListItem>
<asp:ListItem Value="BZ">Belize</asp:ListItem>
<asp:ListItem Value="BJ">Benin</asp:ListItem>
<asp:ListItem Value="BM">Bermuda</asp:ListItem>
<asp:ListItem Value="BT">Bhutan</asp:ListItem>
<asp:ListItem Value="BO">Bolivia</asp:ListItem>
<asp:ListItem Value="BA">Bosnia And Herzegowina</asp:ListItem>
<asp:ListItem Value="BW">Botswana</asp:ListItem>
<asp:ListItem Value="BV">Bouvet Island</asp:ListItem>
<asp:ListItem Value="BR">Brazil</asp:ListItem>
<asp:ListItem Value="IO">British Indian Ocean Territory</asp:ListItem>
<asp:ListItem Value="BN">Brunei Darussalam</asp:ListItem>
<asp:ListItem Value="BG">Bulgaria</asp:ListItem>
<asp:ListItem Value="BF">Burkina Faso</asp:ListItem>
<asp:ListItem Value="BI">Burundi</asp:ListItem>
<asp:ListItem Value="KH">Cambodia</asp:ListItem>
<asp:ListItem Value="CM">Cameroon</asp:ListItem>
<asp:ListItem Value="CA">Canada</asp:ListItem>
<asp:ListItem Value="CV">Cape Verde</asp:ListItem>
<asp:ListItem Value="KY">Cayman Islands</asp:ListItem>
<asp:ListItem Value="CF">Central African Republic</asp:ListItem>
<asp:ListItem Value="TD">Chad</asp:ListItem>
<asp:ListItem Value="CL">Chile</asp:ListItem>
<asp:ListItem Value="CN">China</asp:ListItem>
<asp:ListItem Value="CX">Christmas Island</asp:ListItem>
<asp:ListItem Value="CC">Cocos (Keeling) Islands</asp:ListItem>
<asp:ListItem Value="CO">Colombia</asp:ListItem>
<asp:ListItem Value="KM">Comoros</asp:ListItem>
<asp:ListItem Value="CG">Congo</asp:ListItem>
<asp:ListItem Value="CK">Cook Islands</asp:ListItem>
<asp:ListItem Value="CR">Costa Rica</asp:ListItem>
<asp:ListItem Value="CI">Cote D'Ivoire</asp:ListItem>
<asp:ListItem Value="HR">Croatia (Local Name: Hrvatska)</asp:ListItem>
<asp:ListItem Value="CU">Cuba</asp:ListItem>
<asp:ListItem Value="CY">Cyprus</asp:ListItem>
<asp:ListItem Value="CZ">Czech Republic</asp:ListItem>
<asp:ListItem Value="DK">Denmark</asp:ListItem>
<asp:ListItem Value="DJ">Djibouti</asp:ListItem>
<asp:ListItem Value="DM">Dominica</asp:ListItem>
<asp:ListItem Value="DO">Dominican Republic</asp:ListItem>
<asp:ListItem Value="TP">East Timor</asp:ListItem>
<asp:ListItem Value="EC">Ecuador</asp:ListItem>
<asp:ListItem Value="EG">Egypt</asp:ListItem>
<asp:ListItem Value="SV">El Salvador</asp:ListItem>
<asp:ListItem Value="GQ">Equatorial Guinea</asp:ListItem>
<asp:ListItem Value="ER">Eritrea</asp:ListItem>
<asp:ListItem Value="EE">Estonia</asp:ListItem>
<asp:ListItem Value="ET">Ethiopia</asp:ListItem>
<asp:ListItem Value="FK">Falkland Islands (Malvinas)</asp:ListItem>
<asp:ListItem Value="FO">Faroe Islands</asp:ListItem>
<asp:ListItem Value="FJ">Fiji</asp:ListItem>
<asp:ListItem Value="FI">Finland</asp:ListItem>
<asp:ListItem Value="FR">France</asp:ListItem>
<asp:ListItem Value="GF">French Guiana</asp:ListItem>
<asp:ListItem Value="PF">French Polynesia</asp:ListItem>
<asp:ListItem Value="TF">French Southern Territories</asp:ListItem>
<asp:ListItem Value="GA">Gabon</asp:ListItem>
<asp:ListItem Value="GM">Gambia</asp:ListItem>
<asp:ListItem Value="GE">Georgia</asp:ListItem>
<asp:ListItem Value="DE">Germany</asp:ListItem>
<asp:ListItem Value="GH">Ghana</asp:ListItem>
<asp:ListItem Value="GI">Gibraltar</asp:ListItem>
<asp:ListItem Value="GR">Greece</asp:ListItem>
<asp:ListItem Value="GL">Greenland</asp:ListItem>
<asp:ListItem Value="GD">Grenada</asp:ListItem>
<asp:ListItem Value="GP">Guadeloupe</asp:ListItem>
<asp:ListItem Value="GU">Guam</asp:ListItem>
<asp:ListItem Value="GT">Guatemala</asp:ListItem>
<asp:ListItem Value="GN">Guinea</asp:ListItem>
<asp:ListItem Value="GW">Guinea-Bissau</asp:ListItem>
<asp:ListItem Value="GY">Guyana</asp:ListItem>
<asp:ListItem Value="HT">Haiti</asp:ListItem>
<asp:ListItem Value="HM">Heard And Mc Donald Islands</asp:ListItem>
<asp:ListItem Value="VA">Holy See (Vatican City State)</asp:ListItem>
<asp:ListItem Value="HN">Honduras</asp:ListItem>
<asp:ListItem Value="HK">Hong Kong</asp:ListItem>
<asp:ListItem Value="HU">Hungary</asp:ListItem>
<asp:ListItem Value="IS">Icel And</asp:ListItem>
<asp:ListItem Value="IN">India</asp:ListItem>
<asp:ListItem Value="ID">Indonesia</asp:ListItem>
<asp:ListItem Value="IR">Iran (Islamic Republic Of)</asp:ListItem>
<asp:ListItem Value="IQ">Iraq</asp:ListItem>
<asp:ListItem Value="IE">Ireland</asp:ListItem>
<asp:ListItem Value="IL">Israel</asp:ListItem>
<asp:ListItem Value="IT">Italy</asp:ListItem>
<asp:ListItem Value="JM">Jamaica</asp:ListItem>
<asp:ListItem Value="JP">Japan</asp:ListItem>
<asp:ListItem Value="JO">Jordan</asp:ListItem>
<asp:ListItem Value="KZ">Kazakhstan</asp:ListItem>
<asp:ListItem Value="KE">Kenya</asp:ListItem>
<asp:ListItem Value="KI">Kiribati</asp:ListItem>
<asp:ListItem Value="KP">Korea, Dem People'S Republic</asp:ListItem>
<asp:ListItem Value="KR">Korea, Republic Of</asp:ListItem>
<asp:ListItem Value="KW">Kuwait</asp:ListItem>
<asp:ListItem Value="KG">Kyrgyzstan</asp:ListItem>
<asp:ListItem Value="LA">Lao People'S Dem Republic</asp:ListItem>
<asp:ListItem Value="LV">Latvia</asp:ListItem>
<asp:ListItem Value="LB">Lebanon</asp:ListItem>
<asp:ListItem Value="LS">Lesotho</asp:ListItem>
<asp:ListItem Value="LR">Liberia</asp:ListItem>
<asp:ListItem Value="LY">Libyan Arab Jamahiriya</asp:ListItem>
<asp:ListItem Value="LI">Liechtenstein</asp:ListItem>
<asp:ListItem Value="LT">Lithuania</asp:ListItem>
<asp:ListItem Value="LU">Luxembourg</asp:ListItem>
<asp:ListItem Value="MO">Macau</asp:ListItem>
<asp:ListItem Value="MK">Macedonia</asp:ListItem>
<asp:ListItem Value="MG">Madagascar</asp:ListItem>
<asp:ListItem Value="MW">Malawi</asp:ListItem>
<asp:ListItem Value="MY">Malaysia</asp:ListItem>
<asp:ListItem Value="MV">Maldives</asp:ListItem>
<asp:ListItem Value="ML">Mali</asp:ListItem>
<asp:ListItem Value="MT">Malta</asp:ListItem>
<asp:ListItem Value="MH">Marshall Islands</asp:ListItem>
<asp:ListItem Value="MQ">Martinique</asp:ListItem>
<asp:ListItem Value="MR">Mauritania</asp:ListItem>
<asp:ListItem Value="MU">Mauritius</asp:ListItem>
<asp:ListItem Value="YT">Mayotte</asp:ListItem>
<asp:ListItem Value="MX">Mexico</asp:ListItem>
<asp:ListItem Value="FM">Micronesia, Federated States</asp:ListItem>
<asp:ListItem Value="MD">Moldova, Republic Of</asp:ListItem>
<asp:ListItem Value="MC">Monaco</asp:ListItem>
<asp:ListItem Value="MN">Mongolia</asp:ListItem>
<asp:ListItem Value="MS">Montserrat</asp:ListItem>
<asp:ListItem Value="MA">Morocco</asp:ListItem>
<asp:ListItem Value="MZ">Mozambique</asp:ListItem>
<asp:ListItem Value="MM">Myanmar</asp:ListItem>
<asp:ListItem Value="NA">Namibia</asp:ListItem>
<asp:ListItem Value="NR">Nauru</asp:ListItem>
<asp:ListItem Value="NP">Nepal</asp:ListItem>
<asp:ListItem Value="NL">Netherlands</asp:ListItem>
<asp:ListItem Value="AN">Netherlands Ant Illes</asp:ListItem>
<asp:ListItem Value="NC">New Caledonia</asp:ListItem>
<asp:ListItem Value="NZ">New Zealand</asp:ListItem>
<asp:ListItem Value="NI">Nicaragua</asp:ListItem>
<asp:ListItem Value="NE">Niger</asp:ListItem>
<asp:ListItem Value="NG">Nigeria</asp:ListItem>
<asp:ListItem Value="NU">Niue</asp:ListItem>
<asp:ListItem Value="NF">Norfolk Island</asp:ListItem>
<asp:ListItem Value="MP">Northern Mariana Islands</asp:ListItem>
<asp:ListItem Value="NO">Norway</asp:ListItem>
<asp:ListItem Value="OM">Oman</asp:ListItem>
<asp:ListItem Value="PK">Pakistan</asp:ListItem>
<asp:ListItem Value="PW">Palau</asp:ListItem>
<asp:ListItem Value="PA">Panama</asp:ListItem>
<asp:ListItem Value="PG">Papua New Guinea</asp:ListItem>
<asp:ListItem Value="PY">Paraguay</asp:ListItem>
<asp:ListItem Value="PE">Peru</asp:ListItem>
<asp:ListItem Value="PH">Philippines</asp:ListItem>
<asp:ListItem Value="PN">Pitcairn</asp:ListItem>
<asp:ListItem Value="PL">Poland</asp:ListItem>
<asp:ListItem Value="PT">Portugal</asp:ListItem>
<asp:ListItem Value="PR">Puerto Rico</asp:ListItem>
<asp:ListItem Value="QA">Qatar</asp:ListItem>
<asp:ListItem Value="RE">Reunion</asp:ListItem>
<asp:ListItem Value="RO">Romania</asp:ListItem>
<asp:ListItem Value="RU">Russian Federation</asp:ListItem>
<asp:ListItem Value="RW">Rwanda</asp:ListItem>
<asp:ListItem Value="KN">Saint K Itts And Nevis</asp:ListItem>
<asp:ListItem Value="LC">Saint Lucia</asp:ListItem>
<asp:ListItem Value="VC">Saint Vincent, The Grenadines</asp:ListItem>
<asp:ListItem Value="WS">Samoa</asp:ListItem>
<asp:ListItem Value="SM">San Marino</asp:ListItem>
<asp:ListItem Value="ST">Sao Tome And Principe</asp:ListItem>
<asp:ListItem Value="SA">Saudi Arabia</asp:ListItem>
<asp:ListItem Value="SN">Senegal</asp:ListItem>
<asp:ListItem Value="SC">Seychelles</asp:ListItem>
<asp:ListItem Value="SL">Sierra Leone</asp:ListItem>
<asp:ListItem Value="SG">Singapore</asp:ListItem>
<asp:ListItem Value="SK">Slovakia (Slovak Republic)</asp:ListItem>
<asp:ListItem Value="SI">Slovenia</asp:ListItem>
<asp:ListItem Value="SB">Solomon Islands</asp:ListItem>
<asp:ListItem Value="SO">Somalia</asp:ListItem>
<asp:ListItem Value="ZA">South Africa</asp:ListItem>
<asp:ListItem Value="GS">South Georgia , S Sandwich Is.</asp:ListItem>
<asp:ListItem Value="ES">Spain</asp:ListItem>
<asp:ListItem Value="LK">Sri Lanka</asp:ListItem>
<asp:ListItem Value="SH">St. Helena</asp:ListItem>
<asp:ListItem Value="PM">St. Pierre And Miquelon</asp:ListItem>
<asp:ListItem Value="SD">Sudan</asp:ListItem>
<asp:ListItem Value="SR">Suriname</asp:ListItem>
<asp:ListItem Value="SJ">Svalbard, Jan Mayen Islands</asp:ListItem>
<asp:ListItem Value="SZ">Sw Aziland</asp:ListItem>
<asp:ListItem Value="SE">Sweden</asp:ListItem>
<asp:ListItem Value="CH">Switzerland</asp:ListItem>
<asp:ListItem Value="SY">Syrian Arab Republic</asp:ListItem>
<asp:ListItem Value="TW">Taiwan</asp:ListItem>
<asp:ListItem Value="TJ">Tajikistan</asp:ListItem>
<asp:ListItem Value="TZ">Tanzania, United Republic Of</asp:ListItem>
<asp:ListItem Value="TH">Thailand</asp:ListItem>
<asp:ListItem Value="TG">Togo</asp:ListItem>
<asp:ListItem Value="TK">Tokelau</asp:ListItem>
<asp:ListItem Value="TO">Tonga</asp:ListItem>
<asp:ListItem Value="TT">Trinidad And Tobago</asp:ListItem>
<asp:ListItem Value="TN">Tunisia</asp:ListItem>
<asp:ListItem Value="TR">Turkey</asp:ListItem>
<asp:ListItem Value="TM">Turkmenistan</asp:ListItem>
<asp:ListItem Value="TC">Turks And Caicos Islands</asp:ListItem>
<asp:ListItem Value="TV">Tuvalu</asp:ListItem>
<asp:ListItem Value="UG">Uganda</asp:ListItem>
<asp:ListItem Value="UA">Ukraine</asp:ListItem>
<asp:ListItem Value="AE">United Arab Emirates</asp:ListItem>
<asp:ListItem Value="GB">United Kingdom</asp:ListItem>
<asp:ListItem Value="US">United States</asp:ListItem>
<asp:ListItem Value="UM">United States Minor Is.</asp:ListItem>
<asp:ListItem Value="UY">Uruguay</asp:ListItem>
<asp:ListItem Value="UZ">Uzbekistan</asp:ListItem>
<asp:ListItem Value="VU">Vanuatu</asp:ListItem>
<asp:ListItem Value="VE">Venezuela</asp:ListItem>
<asp:ListItem Value="VN">Viet Nam</asp:ListItem>
<asp:ListItem Value="VG">Virgin Islands (British)</asp:ListItem>
<asp:ListItem Value="VI">Virgin Islands (U.S.)</asp:ListItem>
<asp:ListItem Value="WF">Wallis And Futuna Islands</asp:ListItem>
<asp:ListItem Value="EH">Western Sahara</asp:ListItem>
<asp:ListItem Value="YE">Yemen</asp:ListItem>
<asp:ListItem Value="ZR">Zaire</asp:ListItem>
<asp:ListItem Value="ZM">Zambia</asp:ListItem>
<asp:ListItem Value="ZW">Zimbabwe</asp:ListItem>
</asp:DropDownList>
</div>
</form>
</body>
</html>


[/code]

How to get system ip using javascript

In page load event just call GetIPAddress().This function will return your ip address.
[code]
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<script language="JavaScript">
function GetIPAddress()
{
var obj = null;
var rslt = "";
try
{
obj = new ActiveXObject("rcbdyctl.Setting");
rslt = obj.GetIPAddress;
obj = null;
}
catch(e)
{
//
}
alert(rslt);
return rslt;
}

</script>

</head>
<body onload="return GetIPAddress()">
<form id="form1" runat="server">
<div>

</div>
</form>
</body>
</html>


[/code]

How to disable IE/Firefox remember password ?

Some time we need to disable remember password option in Firefox/i.e. In that time just set autocomplete="off" for password text box.
If you set autocomplete="off", remember password option will not display.


[code]
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:TextBox ID="TextBox1" autocomplete="off" runat="server" TextMode="Password"></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />

</div>

</form>
</body>
</html>


[/code]

Collection of Javascript validations

if user give text box as blank means,we will show a alert message throguh java script.check the below code for java script empty validation.

Text Box Empty Validation:-
[code]
function TextboxEmptyValidation()
{
var txt=document.getElementById("TextBox1");
if(txt.value=="")
{
alert("Textbox cannot be blank");
txt.focus();
return false;
}
}
You can call above function like this

<asp:TextBox ID="TextBox1" onblur="return TextboxEmptyValidation()" runat="server"></asp:TextBox>
[/code]

if you want to enter only number for particular textbox means,you will call the below function in textbox onkeypress event.

Text Box Enter only Numbers:-
[code]
function valNumeric(evt)
{

var charCode;
charCode = (evt.which) ? evt.which : event.keyCode;
if (charCode <= 48 && charCode >= 57 || charCode== 8 || charCode == 118 || charCode == 120 || charCode == 99 )
{
return true;
}
else
{
return false;
}
}

You can call above function like this

<asp:TextBox ID="TextBox2" onkeypress="return valNumeric(event)" runat="server"></asp:TextBox>

[/code]

if user does not select value from dropdownlist means,we will show a alert message throguh java script.
check the below code for java script dropdownlist empty validation.

Dropdownlist empty validation

[code]
function DropdownlistEmptyValidation()
{
var dropdown=document.getElementById("DropDownList1");
if(dropdown.value=="-1")
{
alert("dropdownlist cannot be blank");
dropdown.focus();
return false;
}
}
You can call the above function like this

<asp:DropDownList ID="DropDownList1" onblur="return DropdownlistEmptyValidation()" runat="server" AutoPostBack="True">
<asp:ListItem Value="-1">---Select--</asp:ListItem>
<asp:ListItem>Item1</asp:ListItem>
<asp:ListItem>Item2</asp:ListItem>
<asp:ListItem>Item3</asp:ListItem>
</asp:DropDownList>


[/code]

if you want to enter only char for particular textbox means,you will call the below function in textbox onkeypress event.

Enter only char
[code]
function valAlpha(evt)
{

var charCode;
charCode = (evt.which) ? evt.which : event.keyCode;
if (charCode <= 97 && charCode >= 122 || charCode <= 65 && charCode >= 90 || charCode==8)
{
return true;
}
else
{
return false;
}
}
You can call the above function like this

<asp:TextBox ID="TextBox3" onkeypress="return valAlpha(event)" runat="server"></asp:TextBox>
[/code]
if you want to check given website is valid or not,using javascript.take the below code to check valid or not

WebsiteValidation
[code]
function WebsiteValidation(ctrName)
{
var strURL=document.getElementById(ctrName).value;
if(strURL!='')
{
var tomatch= /www\.[A-Za-z0-9\.-]{2,}\.[A-Za-z]{2}/
if (tomatch.test(strURL))
{
var cnt1 = strURL.length - 1;
var cnt2 = strURL.lastIndexOf(".");
if(cnt1 == cnt2 )
{
alert("Enter valid Website");

return false;
}
return true;
}
else
{ alert("Enter valid Website");
return false;
}
}
}

You can call the above function like this

<asp:TextBox ID="TextBox4" onblur="return WebsiteValidation(this.id)" runat="server"></asp:TextBox>
[/code]

How to Get file information using C#?

How to Get file information using C#?
Just import system.Io name space in your code behind.
[code]
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string fPath = Server.MapPath("YourFileName");
FileInfo fInfo = new FileInfo(fPath);
string strFileInfo;
if (fInfo.Exists)
{
strFileInfo = "Name: " + fInfo.Name + "
";
strFileInfo += "Location: " + fInfo.FullName + "
";
strFileInfo += "Created on: " + fInfo.CreationTime + "
";
strFileInfo += "Extension: " + fInfo.Extension;

}
else
{
strFileInfo = "The file " + fPath + " was not found.";
}
Response.Write(strFileInfo);

}
}

[/code]

How to pass Listbox1 value to Listbox2

Partial Class _Default
Inherits System.Web.UI.Page


Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
ListBox2.Items.Add(ListBox1.SelectedItem.Text)
'if u want remove this item
ListBox1.Items.Remove(ListBox1.SelectedItem.Text)

End Sub

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
ListBox1.Items.Add(ListBox2.SelectedItem.Text)
'if u want remove this item
ListBox2.Items.Remove(ListBox2.SelectedItem.Text)

End Sub
End Class


Partial Class _Default
Inherits System.Web.UI.Page


Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
ListBox2.Items.Add(ListBox1.SelectedItem.Text)
'if u want remove this item
ListBox1.Items.Remove(ListBox1.SelectedItem.Text)

End Sub

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
ListBox1.Items.Add(ListBox2.SelectedItem.Text)
'if u want remove this item
ListBox2.Items.Remove(ListBox2.SelectedItem.Text)

End Sub
End Class


<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListBox ID="ListBox1" runat="server" AutoPostBack="True">
<asp:ListItem>Ajith</asp:ListItem>
<asp:ListItem>Kumar</asp:ListItem>
<asp:ListItem>Kamal</asp:ListItem>
<asp:ListItem>Rajini</asp:ListItem>
</asp:ListBox>
<asp:ListBox ID="ListBox2" runat="server" AutoPostBack="True"></asp:ListBox>
<asp:Button ID="Button1" runat="server" Text="MoveToList2" />
<asp:Button ID="Button2" runat="server" Text="MoveToList1" /></div>
</form>
</body>
</html>

How to declare variable in Javascript?

How to declare variable in Javascript?
Variables are used to store data in memory. JavaScript variables are declared with the var keyword.

var empname;

Multiple variables can be declared in a single step.
var empname, age, weight, gender;

After a variable is declared, it can be assigned a value.
empname = 'nathan';

Variable declaration and assignment can be done in a single step.
var empname = 'nathan';

Export gridview to excel within an UpdatePanel in asp.net using c#

In this article we will learn how to convert gridview to Excel using C#.
Just Drag and drop one gridview control.

In Code Behind page:-

[code]
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindData();
}

}
private void BindData()
{
string query = "select * from a1";
SqlConnection myConnection = new SqlConnection("server=servername;uid=userid;password=password;database=databasename");
SqlDataAdapter ad = new SqlDataAdapter(query, myConnection);
DataSet ds = new DataSet();
ad.Fill(ds, "TableName");
grvGridToExcel.DataSource = ds;
grvGridToExcel.DataBind();
}


public override void VerifyRenderingInServerForm(Control control)
{
/* Confirms that an HtmlForm control is rendered for the specified ASP.NET
server control at run time. */

}
protected void BtnExport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
grvGridToExcel.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}

}

[/code]

In ASPX Page:-

[code]
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div> <asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>


<asp:GridView ID="grvGridToExcel" runat="server">
</asp:GridView>
<asp:Button ID="BtnExport" OnClick="BtnExport_Click" runat="server" Text="ExportGridtoExcel" />
</ContentTemplate>
<Triggers>
<asp:PostBackTrigger ControlID="BtnExport" />
</Triggers>
</asp:UpdatePanel>
</div>
</form>
</body>
</html>


[/code]
This is very simple ASP dot Net web application project. This Application is used to convert Gridview to PDF document using itext itextsharp(Its a free tool).
Download the itextsharp from link given below and add this dll in the bin directory.
http://sourceforge.net/projects/itextsharp/
or
http://nodevice.in/dll/itextsharp_dll/item21198.html
After placing the dll in the bin directory write the below code in the aspx.vb page.

In your code-behind, try just adding

Imports iTextSharp.text.pdf
Imports iTextSharp.text

Just Drag and drop one button control and one gridivew
[code]
In ASPX.VB Page 
Imports iTextSharp.text.pdf
Imports iTextSharp.text
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Dim ds As New DataSet

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then

ShowGridview()
End If
End Sub

Sub ShowGridview()
'bind the database values to Gridveiw using dataset control
Dim con As SqlClient.SqlConnection
Dim da As SqlDataAdapter

Dim str As String
str = "USER=UserID;PASSWORD=PASSWORD;SERVER=SERVER-Name;DATABASE=DATABASE-Name"
con = New SqlConnection(str)
da = New SqlDataAdapter("select FieldName1,FieldName2 from Table_Name", con)
da.Fill(ds, "Employee")
ViewState("DataSetValue") = ds
grvGrid.DataSource = ds
grvGrid.DataBind()
con.Close()

End Sub
Private Sub ConvertGridviewToPdfDocument(ByVal dstHeader2 As DataSet)
Dim doc As Document = New Document
PdfWriter.GetInstance(doc, New FileStream(Request.PhysicalApplicationPath + "\3.pdf", FileMode.Create))
doc.Open()
Dim table As New PdfPTable(dstHeader2.Tables(0).Columns.Count)
Dim widths As Integer() = {25, 25}
table.WidthPercentage = "100"
For i As Integer = 0 To dstHeader2.Tables(0).Columns.Count - 1
Dim ColumnHeader As New Paragraph(dstHeader2.Tables(0).Columns(i).ColumnName.ToString(), FontFactory.GetFont("verdana", 11))
ColumnHeader.Font.SetStyle(Font.BOLD)
Dim cell As New PdfPCell(New Phrase(ColumnHeader))
cell.HorizontalAlignment = Element.ALIGN_CENTER
table.AddCell(cell)
Next

For k As Integer = 0 To dstHeader2.Tables(0).Rows.Count - 1
For j As Integer = 0 To dstHeader2.Tables(0).Columns.Count - 1
Dim ColumnValue As New Paragraph(dstHeader2.Tables(0).Rows(k)(j).ToString(), FontFactory.GetFont("verdana", 10))
table.AddCell(ColumnValue)
Next
Next
table.SetWidths(widths)
doc.Add(table)
doc.Add(New Paragraph(vbLf))
doc.Close()
Response.Redirect("~/3.pdf")
End Sub

Protected Sub btnConvertGridviewToPDF_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnConvertGridviewToPDF.Click
ConvertGridviewToPdfDocument(ViewState("DataSetValue"))
End Sub
End Class

[/code]
In ASPX Page:-

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>
<asp:GridView ID="grvGrid" RowStyle-Wrap="true" runat="server">
</asp:GridView>
</td>
</tr>
</table>
<asp:Button ID="btnConvertGridviewToPDF" runat="server" Text="ConvertGridviewToPDF" />

</div>
</form>
</body>
</html>

Browser Detection Using Javascript

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

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Browser Detection Using Javascript</title>
    <script type="text/javascript">
 
 function Browser()
  {
var agt=navigator.userAgent.toLowerCase();
if (agt.indexOf("opera") != -1) alert('Opera');
if (agt.indexOf("staroffice") != -1) alert('Star Office');
if (agt.indexOf("webtv") != -1) alert('WebTV');
if (agt.indexOf("beonex") != -1) alert('Beonex');
if (agt.indexOf("chimera") != -1) alert('Chimera');
if (agt.indexOf("netpositive") != -1) alert('NetPositive');
if (agt.indexOf("phoenix") != -1) alert('Phoenix');
if (agt.indexOf("firefox") != -1) alert('Firefox');
if (agt.indexOf("safari") != -1) alert('Safari');
if (agt.indexOf("skipstone") != -1) alert('SkipStone');
if (agt.indexOf("msie") != -1) alert('Internet Explorer');
if (agt.indexOf("netscape") != -1) alert('Netscape');
if (agt.indexOf("mozilla/5.0") != -1) alert('Mozilla');
if (agt.indexOf('\/') != -1) {
if (agt.substr(0,agt.indexOf('\/')) != 'mozilla') {
return navigator.userAgent.substr(0,agt.indexOf('\/'));}
else return 'Netscape';} else if (agt.indexOf(' ') != -1)
return navigator.userAgent.substr(0,agt.indexOf(' '));
else return navigator.userAgent;
}
</script>
</head>

<body onload="return Browser();">
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
</body>
</html>

C# Interview Question :-

C# Interview Question :-

1)Virtual function in c# with example?

Virtual functions implement the concept of polymorphism are the same as in C#, except that you use the override keyword with the virtual function implementaion in the child class. The parent class uses the same virtual keyword. Every class that overrides the virtual method will use the override keyword.


class Shape{    public virtual void Draw()    {        Console.WriteLine("Shape.Draw")    ;    }}class Rectangle : Shape{    public override void Draw()    {        Console.WriteLine("Rectangle.Draw");    }}

2)How to Do File Exception Handaling in C#?
Exception handling is an in built mechanism in .NET framework to detect and handle run time errors. The .NET framework contains lots of standard exceptions. The exceptions are anomalies that occur during the execution of a program. They can be because of user, logic or system errors. If a user do not provide a mechanism to handle these anomalies, the .NET run time environment provide a default mechanism, which terminates the program execution


 3)What’s the advantage of using System.Text.StringBuilder over System.String?
StringBuilder is more efficient in the cases, where a lot of manipulation is done to the text. Strings are immutable, so each time it’s being operated on, a new instance is created.

4)What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?
The first one performs a deep copy of the array, the second one is shallow.

5)What’s the C# equivalent of C++ catch (…), which was a catch-all statement for any possible exception?
 A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.


6)Why are there five tracing levels in System.Diagnostics.TraceSwitcher?
The tracing dumps can be quite verbose and for some applications that are constantly running you run the risk of overloading the machine and the hard drive there. Five levels range from None to Verbose, allowing to fine-tune the tracing activities.

7)What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft.
OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix, but it’s a .NET layer on top of OLE layer, so not the fastest thing in the world. ODBC.NET is a deprecated layer provided for backward compatibility to ODBC engines

8)What is a pre-requisite for connection pooling?
 Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.


9)What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?
The Clone() method returns a new array (a shallow copy) object containing all the elements in the original array.  The CopyTo() method copies the elements into another existing array.  Both perform a shallow copy.  A shallow copy means the contents (each array element) contains references to the same object as the elements in the original array.  A deep copy (which neither of these methods performs) would create a new instance of each element's object, resulting in a different, yet identacle object.
10) What’s the difference between an interface and abstract class?
In an interface class, all methods are abstract - there is no implementation.  In an abstract class some methods can be concrete.  In an interface class, no accessibility modifiers are allowed.  An abstract class may have accessibility modifiers




ASP.NET:-

1)How can we check if all the validation control are valid and proper?

Using the Page.IsValid () property you can check whether all the validation are done.

2)If client side validation is enabled in your Web page, does that mean server side code is not run.
When client side validation is enabled server emit’s JavaScript code for the custom validators. However, note that does not mean that server side checks on custom validators do not execute. It does this redundant check two times, as some of the validators do not support client side scripting.

3)How to disable client side script in validators?
Set ‘EnableClientScript’ to false.

4)How can we kill a user session?
Session abandon

5)Explain the differences between Server-side and Client-side code?

Server side code is executed at the server side on IIS in ASP.NET framework, while client side code is executed on the browser.

6)How do I sign out in forms authentication?
FormsAuthentication.Signout ()

7)How can we force all the validation control to run?
Page.Validate


What is the use of command objects?

In order to execute Sql commands and stored procedures we
need command objects

What are the two fundamental objects in ADO.NET?
DataSet and DataReader are the tow funadamental object in
ADO.NET

C# General Questions

C# General Questions

   1. Does C# support multiple-inheritance?
      No.
      
   2. Who is a protected class-level variable available to?
      It is available to any sub-class (a class inheriting this class).
      
   3. Are private class-level variables inherited?
      Yes, but they are not accessible.  Although they are not visible or accessible via the class interface, they are inherited.
      
   4. Describe the accessibility modifier “protected internal”.
      It is available to classes that are within the same assembly and derived from the specified base class.
      
   5. What’s the top .NET class that everything is derived from?
      System.Object.

   6)How is the DLL Hell problem solved in .NET?
     Assembly versioning allows the application to specify not only the library it needs to      run (which was available under Win32), but also the version of the assembly.

   7) Is it possible to debug java-script in .NET IDE? If yes, how?
       Yes, simply write "debugger" statement at the point where the breakpoint needs to be        set within the javascript code and also enable javascript debugging in the browser       property settings.

Interview Question

1)which statement is running fastly ie insert or delete?
Its definitely Delete.Becuase When Delete operation is being performed then Oracle
doesnot actualy permanently remove the data from data block
but rather marks that particular data block as unusable.
Whereas when concerned to Insert Oracle needs to insert the
new values into Datablocks.

2)Whats the main difference between Subquery and a Join?
Majorly subqueries  run independently and result of the
subquery used in the outer query(other than corelated subquery).
And in case of join a query only give the result when the
joining condition gets satisfied.


3)what is the difference between first normal form & second
normal form?
First Normal Form:
1.it doesnt contain the duplicate rows and null values.
2.those values can be moved into new table.
second normal form:
1.each columns are completely depend upon key

4)What does COMMIT do ?
Commit is a TCL  command which is  used to make  database
transaction parmanent.The data is commited but it can't be rollbacked.

5)difference between oracle8i and oracle9i?
merge is a command which is used to both insert and delete.
timestamp datatype is introduced.
max no of columns in 8i is 256 where as in 9i we can have
999.
on delete set null supports only in 9i.
by using this, when we delete the parent record the child
records are replaced with null values

6)What is the difference between a procedure and a function ?
Functions return a single variable by value whereas procedures do not return any variable by value.Rather they return multiple variables by passing variables by reference through their OUT parameter.

7)What is the advantage of a stored procedure over a database trigger ?
We have control over the firing of a stored procedure but we have no control over the firing of a trigger.
8)What are cascading triggers? What is the maximum no of cascading triggers at a time?
When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading.Max = 32.
9)What are the various types of queries ?
The types of queries are:
Normal Queries
Sub Queries
Co-related queries
Nested queries
Compound queries
10)What is a transaction ?
A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements.
11)What is PL/SQL?
PL/SQL is Oracle's Procedural Language extension to SQL.The language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance), and so, brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools.

What is the difference WCF and Web services?

What are the major differences between services and Web services? OR What is the difference WCF and Web services?

Web services can only be invoked by HTTP. While Service or a WCF component can be invoked by any protocol and any transport type. Second web services are not flexible. However, Services are flexible. If you make a new version of the service, then you need to just expose a new end. Therefore, services are agile and that is a very practical approach looking at the current business trends.

Loading all the tables from the DB(sql server 2005)

Sub BindData()
Dim strConn As String
strConn = "USER=xxxx;PASSWORD=yyyyy;SERVER=zzz;DATABASE=Emp"
Dim MySQL As String = "Select Column_Name From Information_Schema.Columns Where Table_name ='TableName'"
Dim MyConn As New SqlClient.SqlConnection(strConn)
Dim ds As DataSet = New DataSet()
Dim Cmd As New SqlClient.SqlDataAdapter(MySQL, MyConn)
Cmd.Fill(ds, "Emptbl")
Dim dt As New DataTable
dt = ds.Tables(0)
DropDownList1.DataSource = dt
DropDownList1.DataTextField = dt.Columns("Column_Name").ToString
DropDownList1.DataValueField = dt.Columns("Column_Name").ToString
DropDownList1.DataBind()
End Sub

Multiline property in listbox

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:ListBox ID="ListBox1" runat="server" Rows="4">
<asp:ListItem title="Tooltip1">ListItem1</asp:ListItem>
<asp:ListItem title="Tooltip2">ListItem2</asp:ListItem>
</asp:ListBox>

</div>
</form>
</body>
</html>

Explain about joins in sql

SQL Join:-
Sql Join is used to retrieve data from one or more tables joined by common fields. The most common field is Primarykey from one table and foreign key in another table.
EX:-
Select A.Empno, A.Empname, B.Salary, B. Department from Emp1 A, Emp2 B
Where A.Empno=B.Empno
There are two types of joins in SQL
1) Inner joins-Inner join select rows from both tables. Usually join condition is equality of two columns one from table A and other from table B
Syntax
SELECT
FROM
[INNER] JOIN
ON
2) Outer joins
The outer joins have two subtypes
i) Left outer join
II) right outer join
Outer join extends the functionality of inner join. It returns following rows:
The same rows as inner join i.e,. rows from both tables, which matches join condition and
Rows from one or both tables, which do not match join condition along with NULL values in place of other table's columns.
Outer join syntax is as follows: -
SELECT column list
FROM left joined table
LEFT|RIGHT|FULL [OUTER] JOIN
ON join condition
Cross Join:-
Cross join is used to return all records where each row from first table is combined with each row in second table.
Cross join is also called as Cartesian Product join.
Sql Cross Join Syntax:-
Select * FROM TABLE 1 CROSS JOIN TABLE 2
OR
Select * FROM TABLE 1, TABLE 2

How to create dynamic radio button events

[code]

Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim i As Integer
For i = 0 To 56
Dim rd As New RadioButton
rd.ID = i
rd.Text = i
rd.AutoPostBack = True
rd.GroupName = "RD"
AddHandler rd.CheckedChanged, AddressOf RadioButton1_CheckedChanged



PlaceHolder1.Controls.Add(rd)
Next


End Sub

Protected Sub RadioButton1_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs)

MsgBox("asd")
End Sub
End Class

[/code]

What is cross join

Cross Join:-

Cross join is used to return all records where each row from first table is combined with each row in second table.
cross join is also called as Cartesian Product join.

Sql Cross Join Syntax:-

Select * FROM TABLE 1 CROSS JOIN TABLE 2

OR

Select * FROM TABLE 1, TABLE 2

Dynamiclly change drop down items text in bold

Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Dim ddl As New DropDownList
ddl.Items.Add("--Select--")
ddl.Items.Add("Ultimate")
ddl.Items.Add("Rengan")
ddl.Items.Add("Rengan1")
ddl.Items.Add("Rengan2")
ddl.Items.Add("Rengan4")
ddl.AutoPostBack = True
ddl.EnableViewState = True

AddHandler ddl.SelectedIndexChanged, AddressOf DropDownList1_SelectedIndexChanged
PlaceHolder1.Controls.Add(ddl)
Dim i As Integer
For i = 0 To ddl.Items.Count - 1
If i < 3 Then
ddl.Items(i).Attributes.Add("style", "font-weight:bold")
Else
'ddl.Items(i).Attributes.Add("style", "font-weight:italic")
End If
Next

End Sub

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)

MsgBox("asd")

End Sub
End Class

TextBox Empty validation using Javascript

hi,
[code]
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Button1.Attributes.Add("onclick", "TextboxEmptyValidation();")
End Sub
[/code]
[code]
<script type ="text/javascript" >
function TextboxEmptyValidation()
{
var empty=document.getElementById("Text1").value;
if (empty=="")
{
alert("Textbox is Empty");
}
}
[/code]
[code]
<asp:Button ID="Button1" runat="server" Text="Button" />
[/code]

How to fill a combobox in vb.net using database

Dim strConn As String
strConn = "USER='" & TextBox1.Text & "';PASSWORD='" & TextBox2.Text & "';SERVER='" & ComboBox1.SelectedItem.ToString & "';"
Dim MySQL As String = "sp_databases"
Dim MyConn As New SqlClient.SqlConnection(strConn)
Dim ds As DataSet = New DataSet()
Dim Cmd As New SqlClient.SqlDataAdapter(MySQL, MyConn)
Cmd.Fill(ds, "Emptbl")
Dim dt As New DataTable
dt = ds.Tables("Emptbl")
ComboBox2.DataSource = dt
ComboBox2.DisplayMember = dt.Columns(0).ToString
ComboBox2.ValueMember = dt.Columns(0).ToString

TextBox to enter only Date

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script type="text/javascript">
function checkdate(input)
{
var validformat=/^\d{2}\/\d{2}\/\d{4}$/
var returnval=false
if (!validformat.test(input.value))
alert("Please enter valid date")
else
{ //Detailed check for valid date ranges
var monthfield=input.value.split("/")[0]
var dayfield=input.value.split("/")[1]
var yearfield=input.value.split("/")[2]
var dayobj = new Date(yearfield, monthfield-1, dayfield)
if ((dayobj.getMonth()+1!=monthfield)||(dayobj.getDate()!=dayfield)||(dayobj.getFullYear()!=yearfield))
alert("Invalid Day, Month, or Year range detected. Please correct and submit again.")
else
returnval=true
}
if (returnval==false) input.select()
return returnval
}

</script>
</head>
<body>
<form onSubmit="return checkdate(this.mydate)">
<input type="text" name="mydate" />
<b>Date Format:</b> mm/dd/yyyy<br />
<input type="submit" value="submit" />
</form>
</body>
</html>

What is candidate key

candidate Key [Primary Key] is a key which maintains the Row Unique.
it Can be defined based on the entity.
composite Key can be either Primay or Unique Key.
More then One Key columns are said to be composite keys.
Candidate Key(Primary Key) is a column in a table which has the
ability to become a primary key.But a primary key does not necessarily have to be the target of any foreign keys.
The candidate key must be unique within its domain.

Site map Control with Example

SiteMap

Create menu using SiteMap

1)Right click the Project Name
2)Choose The New Item
3)Choose "SiteMap" From Add NewItem window

Web.DotNetSiteMap Its look like,
[code]
<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode url="" title="" description="">
<siteMapNode url="" title="" description="" />
<siteMapNode url="" title="" description="" />
</siteMapNode>
</siteMap>
[/code]

In Form
1)Add the Menu controls to Form
2)Go to the Property window
3)choose New Datasource from Datasource ID of Menu control
4)DataSource Configuration Wizard window will display
5)then coose the "Site Map"

Example :-

web.SiteMap:-
[code]
<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode url="File" title="File" description="File">
<siteMapNode url="Default2.aspx" title="SecondPage" description="ThirdPage" />
<siteMapNode url="Default3.aspx" title="ThirdPage" description="ThirdPage" />
</siteMapNode>
</siteMap>
[code]
Default.aspx:-
[code]
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Menu ID="Menu1" runat="server" DataSourceID="SiteMapDataSource1">
</asp:Menu>
<asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" />


</div>
</form>
</body>
</html>

[/code]

how to check a particular table is exists /not in database

if EXISTS (select * from INFORMATION_SCHEMA.tables where table_name = 'tablename')
Select 'Table found'
ELSE SELECT 'TABLE NOT FOUND'

How many ways can read Excel file in C#.

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string path;
path = "C:\\";
DataTable grdDataSet = new DataTable();
grdDataSet= GetDataTableFromExcel(path);
GridView1.DataSource = grdDataSet;
GridView1.DataBind();
}
public static DataTable GetDataTableFromExcel(string SourceFilePath)
{
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + SourceFilePath + ";" +
"Extended Properties=\"Text;HDR=YES;\"";

using (OleDbConnection cn = new OleDbConnection(ConnectionString))
{
cn.Open();

DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dbSchema == null || dbSchema.Rows.Count < 1)
{
throw new Exception("Error: Could not determine the name of the first worksheet.");
}

string WorkSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString();
// string WorkSheetName = "ExcelData.csv";
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + WorkSheetName + "]", cn);
DataTable dt = new DataTable(WorkSheetName);
da.Fill(dt);
return dt;
}
}

}

How to hide/display a label using javascript

hi,
check this code
[code]
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<script type="text/javascript">

function expand(thistag, tag) {
styleObj=document.getElementById(thistag).style;
if (styleObj.display=='none')
{
styleObj.display='';
tag.innerHTML = "Click here to hide";
}
else {
styleObj.display='none';
tag.innerHTML = "Click here to show";
}
}
</script>

</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" onclick="expand('Label1', this);" Text="click me"></asp:Label>
</div>
</form>
</body>
</html>

[/code]

How to get the id of textbox dynamically?

Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim x As String
x = TextBox1.ID
MsgBox(x)
End Sub
End Class

Passing values from one aspx page to another aspx page in asp.net

Querystring:

Query string is used to Pass the values or information form one page to another page.
Syntax
Request.QueryString(variable)[(index)|.Count]
Parameters
variable :-
Specifies the name of the variable in the http query string to retrieve.
index :-
An optional parameter that enables you to retrieve one of multiple values for variable. It can be any integer value in the range 1 to Request.QueryString(variable).Count.

For exapmle:-
In page 1:
Drag and drop the one textbox and button control
In page 2:
Drag and drop the one textbox control from tool box and place it on form.
In page one:-
[CODE]
Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
'bind the textbox values to querystring
Response.Redirect("Default2.aspx?Textboxvalue=" & TextBox1.Text)

End Sub
End Class
[/CODE]
In page two:-
[CODE]
Partial Class Default2
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Get the values from Query string
TextBox1.Text = Request.QueryString("Textboxvalue")
End Sub
End Class

[/CODE]

Difference between sub & function in vb.net

Sub is a method.its does not return any value
Function is method and it will return any value

Primary key and unique key

Primary key and unique are Entity integrity constraints.unique key can be null but primariy key cant be null.
primariy key can be refrenced to other table as FK.We can declare only one primary key in a table but a table can have multiple unique key.

What is constructor? give an example

A constructor is a special method for initializing a new instance of a class
The constructor method is same name as the class name.A class have more than one constructor.
In this case each constructor have same name but different Parameters.

Example:-


public class A
{
public int x = 0
public int y = 0
public int radius = 0

public A(int x, int y, int radius)
{
this.x = x;
this.y = y;
this.radius = radius;
}
}



1)Copy Construtor
2)paramiterised constructor
3)Dummy constructor
4)Dynamic constructor

How to remove space for a string?

[code]
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Label2.Text = "Dynamic Remove Space";
Label1.Text = "Dynamic Remove Space";
Label1.Text=Label1.Text.Replace(" ","");
}
}

[/code]

Difference between vb and vb.net

1)VB6 does not support inheritance but VB .NET does
2)VB6 does not support polymorphism but VB .NET does

3) vb is opps based, But VB.Net is Completely supported for oops
4) In dotnet we can develop console applications, web applications, mobile apps, smart device apps,
But this was not possible in vb.
5) Lot of Advanced controls available in vb.net

6) in vb, only recordset concepts ( connection methods) are available, ex. DAO, ADO, RDO methods.
But in dotnet ado.net(disconnected Database) method is also availble.
7) Cross language integration, Cross language Debugging and cross langauge inheritance is also possible in vb.net.

How to open a notepad with maximized size using c#.net (windows application)

You can use this code both windows and web application
System.Diagnostics.ProcessStartInfo myProc = new System.Diagnostics.ProcessStartInfo();
myProc.FileName = "Notepad.exe";
myProc.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
System.Diagnostics.Process.Start(myProc);

Example for Windows Application:-

[code]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{

System.Diagnostics.ProcessStartInfo myProc = new System.Diagnostics.ProcessStartInfo();
myProc.FileName = "Notepad.exe";
myProc.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
System.Diagnostics.Process.Start(myProc);

}
}
}

[/code]

How to count or find folder in a drive?

[code]
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
Dim numberOfFiles As Integer
Dim path As String = "c:\rengan"
numberOfFiles = System.IO.Directory.GetFiles(path).Length
MsgBox(numberOfFiles)
End If
End Sub
[/code]

Add row dynamically in gridview

[code]
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Dim dtrow As DataRow
Dim dstDataSet As DataSet
Public Shared Function GetFieldType(ByVal FieldType As String) As System.Type
Select Case FieldType
Case "int"
Return Type.GetType("System.Int32")
Case "varchar"
Return Type.GetType("System.String")
Case "datetime"
Return Type.GetType("System.DateTime")
Case "float"
Return Type.GetType("System.Double")
End Select
Return Type.GetType("System.Object")
End Function

Public Shared Function DefineDataset(ByVal Field() As String, ByVal FieldType() As String, ByVal PrimaryKey As String) As DataSet
Dim dstDataset As New DataSet
Dim dtTable As New DataTable
Dim i As Integer
For i = 0 To FieldType.Length - 1
dtTable.Columns.Add(New DataColumn(Field(i), GetFieldType(FieldType(i))))
If Field(i) = PrimaryKey Then
dtTable.Constraints.Add("c" & i, dtTable.Columns(i), True)
End If
Next
dstDataset.Tables.Add(dtTable)
Return (dstDataset)
End Function
Public Property GridBindDataSet() As DataSet
Get
If Not (ViewState("GridDataset") Is Nothing) Then
dstDataSet = CType(ViewState("GridDataset"), DataSet)
End If
If dstDataSet Is Nothing Then
dstDataSet = DefineDataset(New String() {"EmpID", "EmpName"}, New String() {"varchar", "varchar"}, "")
ViewState.Add("GridDataset", dstDataSet)
End If
Return dstDataSet
End Get

Set(ByVal value As DataSet)
dstDataSet = value
If Not (ViewState("GridDataset") Is Nothing) Then
ViewState("GridDataset") = dstDataSet
Else
ViewState.Add("GridDataset", dstDataSet)
End If
End Set
End Property
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
Dim drwRow As DataRow = GridBindDataSet.Tables(0).NewRow()
drwRow("EmpID") = ""
drwRow("EmpName") = ""
GridBindDataSet.Tables(0).Rows.Add(drwRow)
GridView1.DataSource = GridBindDataSet
GridView1.DataBind()
End If
End Sub

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim drwRow As DataRow = GridBindDataSet.Tables(0).NewRow()
drwRow("EmpID") = ""
drwRow("EmpName") = ""
GridBindDataSet.Tables(0).Rows.Add(drwRow)
GridView1.DataSource = GridBindDataSet
GridView1.DataBind()
End Sub
End Class

[/code]

How to create gridview programaticlly

Just create the Datatable and bind it to Gridview control.

Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Dim dtrow As DataRow
Dim dtNewTable As New DataTable
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dtcol, dtcol1 As New DataColumn
dtcol.DataType = System.Type.GetType("System.String")
dtcol.ColumnName = "Emp ID"
dtNewTable.Columns.Add(dtcol)
dtcol1.DataType = System.Type.GetType("System.String")
dtcol1.ColumnName = "Emp Name"
dtNewTable.Columns.Add(dtcol1)
Dim i As Integer
For i = 0 To 4
dtrow = dtNewTable.NewRow()
dtrow("Emp ID") = ""
dtrow("Emp Name") = ""
dtNewTable.Rows.Add(dtrow)
Next i
GridView1.DataSource = dtNewTable
GridView1.DataBind()
End Sub
End Class


Excellent Collection from http://renganathan1984.blogspot.in/