Friday, May 31, 2013

How to download a file from Gridview using Link button in Asp.net

Introduction: In this post I try to explain how we can download the file from Gridview Data Control.
Gridview

Description:
I have created a table name DOWNLOAD_ASSIGNMENT. Here ID is primary key.
ID
int
CLASS
varchar(50)
ASSIGNMENT
varchar(MAX)

Add the Connectionstring in web.config file of website.
<configuration>
       <connectionStrings>
    <add name="con" connectionString="Data Source=SYS-1F78031ED0A;Initial Catalog=TestBlog;Integrated Security=True"/>
       </connectionStrings>
       <system.web>
        <compilation debug="true" targetFramework="4.0" />
    </system.web>
</configuration>

Add a new webform to project. Drag and drop the Gridview Data Control from Toolbox.

Thursday, May 30, 2013

How to Upload a Website via FTP using FileZilla

Introduction: In this post I try to explain how we can upload a new website and its files etc. via FTP.
Description:
1.       Firstly download the FileZilla from below given link:
After completion of download install it. After the installation double click on FileZilla icon and FileZilla will be open as you can see attached snapshot.

Wednesday, May 29, 2013

How to Bind XML file to Gridview in Asp.net


Introduction: In this post I will explain how we can bind the XML file to Gridview in Asp.net.
Description:
I have created a XML file named Student_Detail.xml and have data below mention:
<?xml version="1.0" encoding="utf-8" ?>
<Detail>
  <Student>
  <Name>Vijay</Name>
  <Address>Himachal</Address>
  <Marks>600</Marks>
  </Student>
  <Student>
    <Name>Anil</Name>
    <Address>Delhi</Address>
    <Marks>800</Marks>
  </Student>
  <Student>
    <Name>John</Name>
    <Address>Kerla</Address>
    <Marks>900</Marks>
  </Student
</Detail>

Now add a new webform to project. Drag and drop the

Tuesday, May 28, 2013

How to Bind Gridview with Datareader in asp.net


Introduction: In this post I have try to explain how to bind Gridview in Asp.net using SqlDatareader, Store Procedure.
Description:
I have created a table name STUDENT_DETAIL and insert data into table.
STUDENT_ID
int
STUDENT_NAME
varchar(50)
STUDENT_ADDRESS
varchar(50)
STUDENT_CLASS
varchar(50)

STUDENT_ID is primary key.
Now open the Visual Studio>Go to File>New>Website. Add the Connectionstring in web.config file of website.
<configuration>
       <connectionStrings>
    <add name="con" connectionString="Data Source=SYS-1F78031ED0A;Initial Catalog=TestBlog;Integrated Security=True"/>
       </connectionStrings>
       <system.web>
        <compilation debug="true" targetFramework="4.0" />
    </system.web>
</configuration>

After that add new web form to website, drag and drop the Gridview data control

Monday, May 27, 2013

How to use Fileupload control in Gridview in Asp.net


Introduction: In this post I try to explain how we can use the Fileupload control in Gridview.

Description:
I have created a table LINQ_TABLE

Sunday, May 26, 2013

Top 10 Most Corrupt Countries in World



Country Name
(Continent)
Capital
Currency
Somalia(Africa)
Mogadishu
Shilling(SOS)
North Korea(Asia)
Pyongyang
North Korean Won
Afghanistan(Asia)
Kabul
Afghani
Sudan(Africa)
Khartoum
Sudanese Pound
Myanmar(Asia)
Naypyidaw
Kyat
Uzbekistan(Asia)
Tashkent
Uzbekistan som
Turkmenistan(Asia)
Ashgabat
Turkmen new manat
Iraq(Asia)
Baghdad
Iraqi dinar
Venezuela(South America)
Caracas
Bolivar Fuerte
Haiti(North America)
Port-au-Prince
Gourde

Saturday, May 25, 2013

Top 10 Richest Countries in World (Based on GDP)


GDP: Gross Domestic Product
UAE: United Arab Emirates
US: United State
PPP: Power Purchasing Parity
Country Name
(Continent)
Capital
Currency
GDP(Approx Per capita in $)
Qatar (Asia)
Doha
Qatari Riyal
88,205
Luxembourg(Europe)
Luxembourg
Euro
81,400
Singapore (Asia)
Singapore
Singapore Dollar
56,690
Norway (Europe)
Oslo
Norwegian Krone
51,950
Brunei (Asia)
Bandar Seri Begawan
Brunei Dollar
48,300
UAE (Asia)
Abu Dhabi
UAE Dirham
47,435
United State of America(North America)
Washington
US Dollar
46,850
Hong Kong (Asia)
--(Administartive part of China)
Hong Kong Dollar
45,942
Switzerland (Europe)
Berne
Swiss Frac
41,950
Netherland (Europe)
Amsterdam
Euro
40,900


Friday, May 24, 2013

Top 10 Poorest Countries in World


GDP : Gross Domestic Product

Country Name
(Continent)
Capital
Currency
GDP(PPP in $)
Congo (Africa)
Brazzaville
CFA Franc
345
Zimbabwe (Africa)
Harare
Zimbabwe Dollar
400
Liberia (Africa)
Monrovia
Liberian Dollar
430
Niger(Africa)
Niamey
West African CFA France
475
Burundi (Africa)
Bujumbura
Burundi France
730
Central African Republic(Africa)
Bangui
Central African CFA France
774
Eritrea (Africa)
Asmara
Nakfa
795
Sierra Leone(Africa)
Freetown
Leone
845
Malawi(Africa)
Lilongwe
Kwacha
855
Togo (Africa)
Lome
CFA France
900
Madagascar(Africa)
Antananarivo
Malagasy Ariary
948