Maintenance Complete in Download Center

Hi,

We have finished migrating all thing from Previous Host to New Host. Download Center is expected to Work as same as previous days. Accounts registered with our website has been kept same and you can log in with earlier credential. Other URLs and Bookmarks you added will also remain same and working.

However, Live FM's will be down for some more hours. We are working and collecting more reliable sources of stream. Once it will be done, we will notify you here.

You can keep in touch by Adding us on Facebook page, Just hit Like and Click Show in Feed link which will appear on hovering Like Button. You can also subscribe to new songs on Download Center  via Feedburner Service by Google. Google will drop you a mail once New Song is available on Download Center.

We have shifted to Higher Configuration and Dedicated Server without any Limitations, So Website is expected to load in less time and other resources also.

Till then, enjoy New songs in Download Center and have fun.


Regards,
+John Bhatt & Team
P.Yar.B Complex

Read More

Welcome to New Google Plus

Hello Everyone,

Just before someday, I have updated you about the New Layout of Facebook. Today I am updating you about another Top most used Social Network from Google.

No, don't think about Orkut (you still remember), it is Google Plus. Google has recently changed Google Plus to Multi-column Layout. There is one Main Navigation Column as previous version but It is not Collapsible and HTML5. Google Plus is now using HTML5 and CSS3  which bring a HD display and many interesting features.

New Features:

• Main Navigation is Collapses when you Click on home Button. 
• Live Feeds are filtered according to the category you select with Post-Back which is Static when Page is Scrolled Down (Fixed position).
• Multi-Column Layout to fit Maximum content.
• New Improved Share Box with Ajax Popup. Just Zooms in Click, Lovely.

These are just some of the Graphical or UI Changes that are visible. Many more great Features are added on Events, Posting and other Security.

Hope you will switch to Google Plus if you are still Hanging on Facebook. By the way, I am also there, you can add me on your Circle, My Profile is +John Bhatt 

All the Best and enjoy.

Read More

Opening a Bank Account in India for Nepalese Citizen

Hi,

Today, I am going to tell you some different thing. This is not related to Technology but it is related to your Social Life. As a known fact, most of Nepalese People are working in India in various industries including from home workers to Higher Level Management of private companies.

Some of us are here to earn some money, some are studying and some people are used to India and started their own business. We need to send money to Nepal for our relatives (home) or for friends, This is a normal procedure and task.

You just need to have some of the documents. Documents required for opening an account are as below:

1. Passport or VISA Issued by Nepal Government.
2. Citizenship card issued by Any District of Nepal
3. Proof of Address (In India).
4. Passport Size Photographs.

Details of the documents.

1. Citizenship Card: Below is attached a sample Citizen ship card. 



2. 2. Proof of Address: You need to submit a valid address proof while asked by Bank. Such, Address proof includes, Rent Aggrement between your House Owner and you. Telephone or Electricity Bill in your name,  Employment Letter issued by a Valid Company, and other documents as per Satisfaction to Officer who is responsible for opening an Account.
3. Photographs: 3-4 Passport size Photographs taken in recent time.
4. VISA or Passport: If you have VISA or PASSPORT issued by Nepal Government, you need not to have Citizenship card.

Steps to open an account.

If you do have Passport or VISA.
Just go to Nearest Branch of Any Bank. Fill the Form and submit your documents as mentioned above. Deposit minimum amount for your account as per instruction of officer. This Amount is INR 500.00 for Rural Areas and INR 1000.00 for Semi Urban, Urban and Metro regions of Government Sector Banks like, State Bank of India, Punjab National Bank, etc. While this amount is INR 2500.00 for Rural Area, INR 5000.00 for Semi Urban and INR 10000.00for Urban and Metros of Private Sector Bank like, ICICI Bank, HDFC Bank, Axix Bank etc.

If you do not have Passport or VISA.
You need to attest your Citizenship card in case you do not have Any International ID Card (VISA or PASSPORT). Citizenship card is taken as National ID Proof.

Steps to Attest your Citizenship Card.

The one and only authority to attest your Citizenship card is the Embassy of Nepal. Embassy of Nepal is located in Central New Delhi and Map is below Embedded. 

If you are going through Metro,Nearest Metro is Mandi House Metro. Office is closed on Saturday and Sunday. Go and write an Application for attesting your Citizenship.

Sample of Application

To,
The Ambassador,
Nepal Embassy, New Delhi,

Subject: Verification of Citizenship Card

Dear Sir,

I am, .........................., resident of  Nepal having permanent address of, ............... village, .............. VDC, ward No. ......... , District ............................, Zone .....................
I am working/studing in India and need to open an Bank Account. You are requested to kindly attest and issue an ID proof. My Original Citizenship card is attached herewith.

Sincerely,
......................
........................... (Local Address)

Write application in above format and submit with your Original Citizenship card, Photocopy of Citizenship card and submit. Once you submitted the document and application, It will be attested and notified to you within 30 minutes (may take longer).
You need to pay INR 125.00 and they will give you a Letter on Letter Head of Embassy of Nepal with their stamp.
A Sample is attached below.

Now, you just need to go to bank, Submit your Letter from Embassy, photocopy of Citizenship, Address Proof and photographs.

Congratulations, if you followed these steps, you will surely get an Account opened with your ID Proofs from your own Nation. Don't support fake agents that promise to make you Voter ID Card, Rasan Card or any other Indian Identity Proof. This is illegal.

You can add me to your Circle +John Bhatt .

Read More

Run Commands Listed In Alphabetical Order-2

Hi,
Here are the remaining Run Commands for Windows Operating System listed in Alphabetic Order.

Nero ( if installed )	nero
Netmeeting	conf
Network Connections	control netconnections
Network Connections	ncpa.cpl
Network Setup Wizard	netsetup.cpl
Notepad	notepad
Nview Desktop Manager ( if installed )	nvtuicpl.cpl
Object Packager	packager
ODBC Data Source Administrator	odbccp32
ODBC Data Source Administrator	odbccp32.cpl
On Screen Keyboard	osk
Opens AC3 Filter ( if installed )	ac3filter.cpl
Outlook Express	msimn
Paint	pbrush
Password Properties	password.cpl
Performance Monitor	perfmon.msc
Performance Monitor	perfmon
Phone and Modem Options	telephon.cpl
Phone Dialer	dialer
Pinball Game	pinball
Power Configuration	powercfg.cpl
Printers and Faxes	control printers
Printers Folder	printers
Private Characters Editor	eudcedit
Quicktime ( if installed )	quicktime.cpl
Quicktime Player ( if installed )	quicktimeplayer
Real Player ( if installed )	realplay
Regional Settings	intl.cpl
Registry Editor	regedit
Registry Editor	regedit32
Remote Access Phonebook	rasphone
Remote Desktop	mstsc
Removable Storage	ntmsmgr.msc
Removable Storage Operator Requests	ntmsoprq.msc
Resultant Set of Policy ( xp pro )	rsop.msc
Scanners and Cameras	sticpl.cpl
Scheduled Tasks	control schedtasks
Security Center	wscui.cpl
Services	services.msc
Shared Folders	fsmgmt.msc
Sharing Session	rtcshare
Shuts Down Windows	shutdown
Sounds Recorder	sndrec32
Sounds and Audio	mmsys.cpl
Spider Solitare Card Game	spider
SQL Client Configuration	clicongf
System Configuration Editor	sysedit
System Configuration Utility	msconfig
System File Checker Utility ( Scan Immediately )	sfc /scannow
System File Checker Utility ( Scan Once At Next Boot )	sfc /scanonce
System File Checker Utility ( Scan On Every Boot )	sfc /scanboot
System File Checker Utility ( Return to Default Settings)	sfc /revert
System File Checker Utility ( Purge File Cache )	sfc /purgecache
System File Checker Utility ( Set Cache Size to Size x )	sfc /cachesize=x
System Information	msinfo32
System Properties	sysdm.cpl
Task Manager	taskmgr
TCP Tester	tcptest
Telnet Client	telnet
Tweak UI ( if installed )	tweakui
User Account Management	nusrmgr.cpl
Utility Manager	utilman
Volume Serial Number for C:	label
Volume Control	sndvol32
Windows Address Book	wab
Windows Address Book Import Utility	wabmig
Windows Backup Utility ( if installed )	ntbackup
Windows Explorer	explorer
Windows Firewall	firewall.cpl
Windows Installer Details	msiexec
Windows Magnifier	magnify
Windows Management Infrastructure	wmimgmt.msc
Windows Media Player	wmplayer
Windows Messenger	msnsgs
Windows Picture Import Wizard (Need camera connected)	wiaacmgr
Windows System Security Tool	syskey
Windows Script host settings	wscript
Widnows Update Launches	wupdmgr
Windows Version ( shows your windows version )	winver
Windows XP Tour Wizard	tourstart
Wordpad	write
Zoom Utility	igfxzoom

Drop a comment below to reach me or provide feedback on above post.

Happy to Help. 

Glad to Be,

John Bhatt

Read More

Run Commands Listed In Alphabetical Order

Hi,
Here are the Run Commands for Windows Operating System listed in Alphabetic Order.

Program	Run Command
Accessibility Controls	access.cpl
Accessibility Wizard	accwiz
Add Hardware Wizard	hdwwiz.cpl
Add/Remove Programs	appwiz.cpl
Administrative Tools	control admintools
Adobe Acrobat ( if installed )	acrobat
Adobe Distiller ( if installed )	acrodist
Adobe ImageReady ( if installed )	imageready
Adobe Photoshop ( if installed )	photoshop
Automatic Updates	wuaucpl.cpl
Basic Media Player	mplay32
Bluetooth Transfer Wizard	fsquirt
Calculator	calc
Ccleaner ( if installed )	ccleaner
C: Drive	c:
Certificate Manager	cdrtmgr.msc
Character Map	charmap
Check Disk Utility	chkdsk
Clipboard Viewer	clipbrd
Command Prompt	cmd
Command Prompt	command
Component Services	dcomcnfg
Computer Management	compmgmt.msc
Compare Files	comp
Control Panel	control
Create a shared folder Wizard	shrpubw
Date and Time Properties	timedate.cpl
DDE Shares	ddeshare
Device Manager	devmgmt.msc
Direct X Control Panel ( if installed )	directx.cpl
Direct X Troubleshooter	dxdiag
Disk Cleanup Utility	cleanmgr
Disk Defragment	dfrg.msc
Disk Partition Manager	diskmgmt.msc
Display Properties	control desktop
Display Properties	desk.cpl
Display Properties (w/Appearance Tab Preselected )	control color
Dr. Watson System Troubleshooting Utility	drwtsn32
Driver Verifier Utility	verifier
Ethereal ( if installed )	ethereal
Event Viewer	eventvwr.msc
Files and Settings Transfer Tool	migwiz
File Signature Verification Tool	sigverif
Findfast	findfast.cpl
Firefox	firefox
Folders Properties	control folders
Fonts	fonts
Fonts Folder	fonts
Free Cell Card Game	freecell
Game Controllers	joy.cpl
Group Policy Editor ( xp pro )	gpedit.msc
Hearts Card Game	mshearts
Help and Support	helpctr
Hyperterminal	hypertrm
Hotline Client	hotlineclient
Iexpress Wizard	iexpress
Indexing Service	ciadv.msc
Internet Connection Wizard	icwonn1
Internet Properties	inetcpl.cpl
Internet Setup Wizard	inetwiz
IP Configuration (Display Connection Configuration)	ipconfig /all
IP Configuration (Display DNS Cache Contents)	ipconfig /displaydns
IP Configuration (Delete DNS Cache Contents)	ipconfig /flushdns
IP Configuration (Release All Connections)	ipconfig /release
IP Configuration (Renew All Connections)	ipconfig /renew
IP Configuration (Refreshes DHCP & Re-Registers DNS)	ipconfig /registerdns
IP Configuration (Display DHCP Class ID)	ipconfig /showclassid
IP Configuration (Modifies DHCP Class ID)	ipconfig /setclassid
Java Control Panel ( if installed )	jpicpl32.cpl
Java Control Panel ( if installed )	javaws
Keyboard Properties	control keyboard
Local Security Settings	secpol.msc
Local Users and Groups	lusrmgr.msc
Logs You Out of Windows	logoff
Malicious Software Removal Tool	mrt
Microsoft Access ( if installed )	access.cpl
Microsoft Chat	winchat
Microsoft Excel ( if installed )	excel
Microsoft Diskpart	diskpart
Microsoft Frontpage ( if installed )	frontpg
Microsoft Movie Maker	moviemk
Microsoft Management Console	mmc
Microsoft Narrator	narrator
Microsoft Paint	mspaint
Microsoft Powerpoint	powerpnt
Microsoft Word ( if installed )	winword
Microsoft Syncronization Tool	mobsync
Minesweeper Game	winmine
Mouse Properties	control mouse
Mouse Properties	main.cpl
MS-Dos Editor	edit
MS-Dos FTP	ftp

Remaining commands on next post.
Drop a comment below to reach me or provide feedback on above post.

Happy to Help. 

Glad to Be,

John Bhatt

Read More

List All SQL Server Instances in Combo (Windows Form) - Part-2

Hello Friends,
On the Previous Post on this series, I have told you the code and procedure upto Connect Button. Hope you have been through it and enjoyed that. If not, please read below post before moving ahead. http://www.prithviraj.com.np/2012/10/list-all-sql-server-instances-in-combo_9.html
Today, I am going to share rest of the Code for Listing Database, Tables Inside Database and Columns and apply them with Operator and simply perform Select Operation from database and list the Result in DataGrid. Let's look the Design you have previously saw when making connection.



In above design,
In Database Combo, we will list all database from Connected Server. Then in Table Combo, we will list all Tables of Selected Database and in Column Combo all columns of Selected Table.

Lets Begin the Code. On Button Click and Successful Connection, we will load all database names in Database Combo. Actually we have did it earlier.
Lets have look at this Code:

comboBox2.Items.Clear();
                   if (checkBox1.Checked == true)
                   {
                       ConStr = "Data Source = " + comboBox1.Text.ToString() + ";Integrated Security = true;";
                   }
                   else
                   {
                       ConStr = "Data Source = " + comboBox1.Text.ToString() + ";UID=" + textBox1.Text + ";pwd=" + textBox2.Text + ";";
                   }
                   SqlConnection Conexion = new SqlConnection(ConStr);
                   Conexion.Open();
                   label9.Visible = false;
                   panel2.Visible = false;
                   button2.Visible = true;
                   panel1.Visible = true;
                   groupBox1.Visible = true;
                   DataTable tblDatabases = Conexion.GetSchema("Databases");
 
                   for (int i = 0; i <= tblDatabases.Rows.Count - 1; i++)
                   {
                       comboBox2.Items.Add(tblDatabases.Rows[i][0].ToString());
                   }
                   Conexion.Close();

This is code from earlier post.
Now Lets see the Code on SelectedIndex Change event of Database Combo (Combobox2).

private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            comboBox3.Items.Clear();
            SqlConnection conx = new SqlConnection(ConStr + "Database ="+comboBox2.Text.ToString()+";");
            conx.Open();
            DataTable tblTables = conx.GetSchema("Tables");
            for (int i = 0; i <= tblTables.Rows.Count - 1; i++)
            {
                comboBox3.Items.Add(tblTables.Rows[i][2].ToString());
            }
            conx.Close();
        }

Here we are creating Connection String Everytime, because, It is changing every-time. Now this code will list all the Tables inside Database in Table Combo (combobox3): Code:

private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
        {
            comboBox4.Items.Clear();
            SqlConnection conx = new SqlConnection(ConStr + "Database =" + comboBox2.Text.ToString() + ";");
            conx.Open();
            string tableName = comboBox3.SelectedItem.ToString();
            SqlDataAdapter adp = new SqlDataAdapter("select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = '"+comboBox3.SelectedItem.ToString()+"'",conx);
            DataTable tblColumns = new DataTable();
            adp.Fill(tblColumns);
            for (int i = 0; i <= tblColumns.Rows.Count - 1; i++)
            {
                comboBox4.Items.Add(tblColumns.Rows[i][3].ToString());
            }
            conx.Close();
        }

Now above code will make all Columns of Selected table from database.
Now Directly move to Keyword TextBox textchange event which will load data as you type.

private void textBox3_TextChanged(object sender, EventArgs e)
        {
            string QueryCon = ConStr;
            if (comboBox5.Text.ToString() == "like")
            {
                QueryStr = "SELECT * FROM " + comboBox3.Text.ToString() + " WHERE " + comboBox4.Text.ToString() + " " + comboBox5.Text.ToString() + " '%" + textBox3.Text + "%'";
            }
            else
            {
                QueryStr = "SELECT * FROM " + comboBox3.Text.ToString() + " WHERE " + comboBox4.Text.ToString() + " " + comboBox5.Text.ToString() + " '" + textBox3.Text + "'";
            }
            TxtQueryBox.Text = ConStr + "Database=" + comboBox2.Text.ToString() + ";"+"\n" + QueryStr;
            SqlDataAdapter adp = new SqlDataAdapter(QueryStr, ConStr+"Database="+comboBox2.Text.ToString()+";");
            DataSet ds = new DataSet();
            adp.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
        }

This will load data in GridView automatically. Lets see a snapshot once again with Result.
All the Best, Enjoy....

Read More

File Upload Control with File Type Filter

Hi,

We are going to learn how to upload a File using FileUpload Control in ASP.NET.

ASPX Code

We Placed a FileUpload Control and a button to Click.

<asp:FileUpload ID="FileUpload1" runat="server"  /> 
<asp:Button ID="BtnUpload" runat="server" Text="Upload File" onclick="BtnUpload_Click" />

Back-end Code

Now BtnUpload_Click event in .cs page.
We are going to Upload only Picture (.JPG file or .BMP file).

 
protected void BtnUpload_Click(object sender, EventArgs e)
    {
       string sSiteFolder = "ResumeFolder";
       string sRealPath = Server.MapPath(sSiteFolder);
       if (!Directory.Exists(sRealPath))
           Directory.CreateDirectory(sRealPath);
       string CompletePath = sRealPath + FileUpload1.FileName;
       string FileExt = CompletePath.Substring(CompletePath.IndexOf("."));
       switch (FileExt)
         { 
          case ".jpg":
                FileUpload1.SaveAs(sRealPath + FileUpload1.FileName);
                break;
          case ".JPG":
                FileUpload1.SaveAs(sRealPath + FileUpload1.FileName);
                break;
          case ".bmp":
                FileUpload1.SaveAs(sRealPath + FileUpload1.FileName);
                break;
          case ".BMP":
                FileUpload1.SaveAs(sRealPath + FileUpload1.FileName);
                break;
         }
     }

Enjoy...
John Bhatt

Read More

Release Date of Windows 8

Hi,


We are waiting for you so long, I think you are also waiting for... 




I am talking about Release Date of Upcoming Version of Windows. Worlds Most popular Operating System is now back with a Bang and Performance, Feature, Speed and Security Rich (Richer than MS), Windows 8.



What We Waited and When we received Publicly:

Developer Preview on : September 13, 2011

Consumer Preview on : On 29 February 2012

Release Preview on : May 31, 2012

And Now the Official announcement of Release Date of Windows 8.

Going to Buy on the First day and you........

Read More

How do I remove a tag from a picture in Facebook?

How annoying it was, if someone Tagged you in a Photo and Many people commented and each and every time you get mail or Notifications for that. Or someone Tagged you in a Cartoon or such photo and that Photo started to appear in your Profile.

You surely want to remove such Photo from your Profile or want to stop such Notifications.
Best and permanent way to do so is To remove Tag from that picture. Here is simple step by step for How to Remove Tag from Facebook.

Follow Below Simple Steps to Remove Tag from Facebook.

• Click Photo to Open.
• Click Options located in Right Bottom corner of Photo.
• Choose Report/Remove Tag option.
• Choose First Option and Continue.
• Once again Choose First Option and Continue.

You are done.

Read More

How Can I Block Some Website?

When I was answering in Community Websites and some other Web Tutorials, Most frequent question I was asked was How Can I Block particular Website in my machine/my employees machine?

(How can i block some website permanently like (facebook.com) and more social site on my employees computers.)

I have found a solution and Telling you.

Best way to block such site is using Router Setting if possible.

Prental control and Content Advisors are also Options but Are some traditional and annoying to Employee.
Best method to do so is Change some setting in Hosts File. I am going to tell you about that. To do so, You have to change some setting in individual PCs for doing so.

1. Open Notepad with Administrator Rights.

 2.   Ctrl+O to Open File. Choose File Path Below.

Windir:(C: )\Windows\System32\drivers\etc

Change File Type to All Files from Right Bottom Corner.

Choose hosts file and open it.

You Will See below Lines at Last of Page

# 127.0.0.1       localhost
# ::1             localhost

Now Just add this code to Block facebook
Using IPv4

 127.0.0.1 www.facebook.com
 127.0.0.1 facebook.com

Using IPv6

 ::1             www.facebook.com
 ::1             facebook.com

Now Just save this File. 

If you are using Antivirus, This may disinfect it, So Disable Real Time Protection for some time and After saving changes enable those Setting of Antivirus.

Hope, you enjoyed. For more Keep reading. You can add me on Google Plus.

Read More