Friday, June 17, 2011

Flash in HTML File

Crate a Folder Called Flash,then
open a notpad and paste this below code and save it as html like
"flash.html", and save it Flash folder,then add your flash file into Flash folder again.

<html>
<body>
<object width="400" height="100">
    <param name="movie" value="YourFlashFileName.swf">
    <embed src="YourFlashFileName.swf" width="400" height="400">
    </embed>
</object>
</body>
</html>


Posted by at No comments:

Saturday, May 28, 2011

All country name with value code in DropDownList

<asp:DropDownList ID="ddlCountry" runat="server" AppendDataBoundItems="true">
                        <asp:ListItem Value="--select--" Text="--select--"></asp:ListItem>
                        <asp:ListItem Value="AF">Afghanistan</asp:ListItem>
                        <asp:ListItem Value="AX">Åland Islands</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 Herzegovina</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="CD">Congo, The Democratic Republic of The</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</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="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="GG">Guernsey</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 Island and Mcdonald 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">Iceland</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="IM">Isle of Man</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="JE">Jersey</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, Democratic People's Republic of</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 Democratic 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">Macao</asp:ListItem>
                        <asp:ListItem Value="MK">Macedonia, The Former Yugoslav Republic of</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 of</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="ME">Montenegro</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 Antilles</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="PS">Palestinian Territory, Occupied</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="SH">Saint Helena</asp:ListItem>
                        <asp:ListItem Value="KN">Saint Kitts and Nevis</asp:ListItem>
                        <asp:ListItem Value="LC">Saint Lucia</asp:ListItem>
                        <asp:ListItem Value="PM">Saint Pierre and Miquelon</asp:ListItem>
                        <asp:ListItem Value="VC">Saint Vincent and 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="RS">Serbia</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</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 and The South Sandwich Islands</asp:ListItem>
                        <asp:ListItem Value="ES">Spain</asp:ListItem>
                        <asp:ListItem Value="LK">Sri Lanka</asp:ListItem>
                        <asp:ListItem Value="SD">Sudan</asp:ListItem>
                        <asp:ListItem Value="SR">Suriname</asp:ListItem>
                        <asp:ListItem Value="SJ">Svalbard and Jan Mayen</asp:ListItem>
                        <asp:ListItem Value="SZ">Swaziland</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, Province of China</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="TL">Timor-leste</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 Outlying Islands</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</asp:ListItem>
                        <asp:ListItem Value="EH">Western Sahara</asp:ListItem>
                        <asp:ListItem Value="YE">Yemen</asp:ListItem>
                        <asp:ListItem Value="ZM">Zambia</asp:ListItem>
                        <asp:ListItem Value="ZW">Zimbabwe</asp:ListItem>
                    </asp:DropDownList>
Posted by at No comments:

MSN Empeded Map into your application

 Design the page to get user inputs(area,city,address,etc)

<div id="divScroll" runat="server">
        <table width="490px" border="0" align="center" cellpadding="0" cellspacing="0">
            <tr>
                <td colspan="2">
                    <asp:Label ID="lblNotification" runat="server"></asp:Label>
                </td>
            </tr>
            <tr>
                <td height="45" align="right" class="login_text" style="padding-right: 5px;">
                    Locaion name :
                </td>
                <td height="45" align="left">
                    <asp:TextBox ID="txtLocationname" class="textBox" runat="server" Width="300px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td height="45" align="right" class="login_text" style="padding-right: 5px;">
                    Address :
                </td>
                <td height="45" align="left">
                    <asp:TextBox ID="txtAddress1" runat="server" class="textBox" Width="300px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td height="45" align="right" class="login_text" style="padding-right: 5px;">
                    City :
                </td>
                <td height="45" align="left">
                    <asp:TextBox ID="txtCity" runat="server" class="textBox" Width="300px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td height="45" align="right" class="login_text" style="padding-right: 5px;">
                    Postal code :
                </td>
                <td height="45" align="left">
                    <asp:TextBox ID="txtPostalcode" class="textBox" runat="server" Width="300px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td align="right" class="login_text" style="padding-right: 5px; height: 35px;">
                    Country :
                </td>
                <td align="left" style="height: 40px">
                    <asp:DropDownList ID="ddlCountry" runat="server" AppendDataBoundItems="true">
                        <asp:ListItem Value="--select--" Text="--select--"></asp:ListItem>
                        <asp:ListItem Value="AF">Afghanistan</asp:ListItem>
                        <asp:ListItem Value="AX">Åland 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">Iceland</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="VI">Virgin Islands, U.S.</asp:ListItem>
                        <asp:ListItem Value="WF">Wallis and Futuna</asp:ListItem>
                        <asp:ListItem Value="EH">Western Sahara</asp:ListItem>
                        <asp:ListItem Value="YE">Yemen</asp:ListItem>
                        <asp:ListItem Value="ZM">Zambia</asp:ListItem>
                        <asp:ListItem Value="ZW">Zimbabwe</asp:ListItem>
                    </asp:DropDownList>
                                   </td>
            </tr>
            <tr>
                <td>
                    &nbsp;
                </td>
                <td height="45" align="left">
                    <asp:Button ID="btnContinue" runat="server" Text="View Map" Width="93px" OnClick="btnContinue_Click" />
                </td>
            </tr>
            <tr>
                <td>
                </td>
                <td>
                    <div id="divIframe" runat="server" visible="false">
                        <center>
                            <iframe width="400" height="300" frameborder="0" scrolling="no" marginheight="0"
                                marginwidth="0" id="iframeMap" runat="server" />
                        </center>
                    </div>
                </td>
            </tr>
        </table>
    </div>

In Code Behind Call the MSN API to Get Location by giving the inputs
   protected void btnContinue_Click(object sender, EventArgs e)
        {
            string countrycode = ddlCountry.SelectedValue.ToString();
            string locationName = txtLocationname.Text;
            string postalCode = txtPostalcode.Text;
            string address = txtAddress1.Text;
            string latitude, longitude;
            DataSet dsLat_Langitude = new DataSet();

//Below code request the MSN Empeded MAP API by giving inputs
            string url = string.Format("http://dev.virtualearth.net/REST/v1/Locations?countryRegion={0}&locality={1}&postalCode={2}&addressLine={3}&o=xml&key=Al-zQKFj0ONajQJaPnl6DfR-BJ_X3HqbtsvyaEa63k6XUTLdOGtqa5JKFUqG4UDA", countrycode, locationName, postalCode, address);

            HttpWebRequest request
      = WebRequest.Create(url) as HttpWebRequest;

            // Get response 
            using (HttpWebResponse response = request.GetResponse() as HttpWebResponse)
            {
                // Load data into a dataset 

                dsLat_Langitude.ReadXml(response.GetResponseStream());
                // Print dataset information 
            }
            if (dsLat_Langitude.Tables.Count > 0)
            {
                if (dsLat_Langitude.Tables["Point"] != null)
                {
                    latitude = dsLat_Langitude.Tables["Point"].Rows[0]["latitude"].ToString();
                    longitude = dsLat_Langitude.Tables["Point"].Rows[0]["Longitude"].ToString();
                    divIframe.Visible = true;
                    divIframe.Focus();
                    string iframeurl = string.Format("http://dev.virtualearth.net/embeddedMap/v1/ajax/road?zoomLevel=15&center={0}_{1}&pushpins={0}_{1}", latitude, longitude);

                    iframeMap.Attributes["src"] = iframeurl;
                   
                }
                else
                {
                    lblNotification.Text = "Provide Valid Inputs for to see the maps";
                }
            }
            else
            {
                lblNotification.Text = "Provide Valid Inputs for to see the maps";
            }
        }


Posted by at No comments:

Genereate Four Digit Random Numbers

 private void btnGenerateRandomNumber(object sender, EventArgs e)
       {
            int random;
      Random objRand = new Random();// Random is Class which has function to generte random number
      random = objRand.Next(1000,9999);
      txtRandom.Text = Convert.ToString(random);
          
      }

Posted by at No comments:

Thursday, May 26, 2011

To display column name only even table has data

if u want to know the column name of table event it has data..

write this query..
set fmtonly on
select * from table_name ...
set fmtonly off

Example:
select * from student;

FMTONLY:
Returns only metadata to the client. Can be used to test the format of the response without actually running the query.











Posted by at No comments:

Wednesday, May 25, 2011

Image preiview in asp.net using javascript

        
<script language="javascript" type="text/javascript">
function PreiewImage() 
{
   var path = document.getElementById("<%=fuProductImage.ClientID%>"); // File Upload Control ID
   var extn = path.value.split(".");
   if (extn.length > 1)
  {
   if ((extn[1] == "jpg") || (extn[1] == "JPG") || (extn[1] == "png") || (extn[1] == "PNG") || (extn[1] == "gif") || (extn[1] == "GIF") || (extn[1] == "jpeg") || (extn[1] == "JPEG")) 
 {
      var img = document.getElementById("<%=imgProduct.ClientID%>"); //Image Control ID
    if (navigator.appName == "Microsoft Internet Explorer")
    {
      var _value = path.outerHTML.split("value=");
      var _value1 = _value[1].split("type");
      var s = _value1[0].replace(/"/g, '');
      var s = _value1[0].replace("\\", "/");
      s = "file:///" + extn[0] + '.' + extn[1];
     document.getElementById("<%=imgProduct.ClientID%>").src = s;
     return true;
 }
 else
 {
   img.src = decodeURIComponent(path.files[0].getAsDataURL());
   document.getElementById("<%=imgProduct.ClientID%>").value = img.src;
      return true;
   }
}
else 
{
      alert("Invalid Image Extn.");
    document.getElementById("<%=imgProduct.ClientID%>").value = "";
       return false;

        }
 }}

    </script>
 
         <table>
            <tr>
                <td>
                  <asp:Image ID="imgProduct" runat="server"  />
               </td>
               <td style="color: #C0C0C0">
                  <asp:FileUpload ID="fuProductImage" Width="190px" runat="server" onchange="PreiewImage(this);" />
                 </td>
            </tr>
        </table>
Posted by at No comments:

Run SSIS Package using Stored proceure through C# application

      create package with varrieble to accept the filename or filepath..then create stored procedure..

 CREATE PROCEDURE [dbo].[Sp_RunPackage_new]
(
    @filename varchar(1000)
    --@packagepath varchar(1000)
)
  
AS
BEGIN

    declare @packagepath varchar(250)
  
    SET @packagepath = 'D:\SSIS Workings\RunPackage\bin\csvTosql.dtsx'
  
    IF NULLIF(LTRIM(RTRIM(@filename)), '') IS NULL
    BEGIN
            RAISERROR('Invalid filename', 16 , 1)
    END
    IF NULLIF(LTRIM(RTRIM(@packagepath)), '') IS NULL
    BEGIN
        RAISERROR('Invalid package filename', 16 , 1)
    END

    DECLARE @dtsExecCmd VARCHAR(4000)

        SET @dtsExecCmd = 'dtexec /F "' + ltrim(rtrim(@packagepath)) + '"'
        SET @dtsExecCmd = @dtsExecCmd + ' /De "test"'
        SET @dtsExecCmd = @dtsExecCmd + ' /SET "\package.Variables[User::InputFileName].Properties[Value]";"' + @filename +'"'
      
    DECLARE @result INT
  
    EXEC @result = master..xp_cmdshell @dtsExecCmd
  
END


Create a form with a single button click just call the stored procedure..

button_ClickEvent
{
            string fileName;
            OpenFileDialog opnFileDlg = new OpenFileDialog();
            opnFileDlg.DefaultExt = ".csv";
            opnFileDlg.Filter = "CSV documents (.csv)|*.csv";
            Nullable<bool> result = opnFileDlg.ShowDialog();
            if (result == true && result != null)
            {
                // Open document
                fileName = opnFileDlg.FileName;
                using (SqlConnection con = new SqlConnection(@"Data Source=ILINKSYS-183\SQLSERVER2008R2;User Id=sa;Password=!QAZ1qaz;Initial Catalog=TestSSIS"))
                {
                    try
                    {
                        con.Open();
                        SqlCommand cmd = new SqlCommand("Sp_RunPackage_new", con);
                        SqlParameter par = new SqlParameter("@InputFileNameServer", fileName);
                        cmd.CommandType = System.Data.CommandType.StoredProcedure;
                        cmd.Parameters.Add(par);
                        cmd.ExecuteNonQuery();

                        con.Close();
                    }
                    catch
                    {
                        throw;
                    }
                }
                MessageBox.Show(fileName+" Executed Successfully");
            }
        }
}
Posted by at No comments:
Subscribe to: Posts (Atom)