Posts

Showing posts from July, 2013

VB.Net MySQL save datatable as CSV

Imports System
Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.Data
Imports System.Drawing
Imports System.Linq
Imports System.Text
Imports System.Windows.Forms
Imports System.Data.SqlClient
Imports System.IO
Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim Csv As New Exporter()
        Dim c As New common
        Using CsvWriter As New StreamWriter(Application.StartupPath() & "\" & "milestones.csv")
            Dim q = "SELECT m.project,projectcode1,m.unit,milestone,ext_sch_date,int_sch_date,act_ant_date FROM `Projects_ntpc` p, Units u , " & _
              " MileStones m WHERE p.projectname = u.project and u.project = m.project and u.unit = m.unit and u.completed !=0 and  u.zerodate is not null"
            CsvWriter.Write(Csv.CsvFromDatatable(c.executeDB(q)))
        End Using
        ' System.Diagnostics.Process.Start(&qu…

How To Open And Access Blocked Sites

"This website/URL has been blocked until further notice either pursuant to Court orders or on the Directions issued by the Department of Telecommunications"

Are you getting above message while opening the site which is useful and not porn or restricted.

 Internet should be Free and without restriction. Here are few methods to avoid that error message:

Solution 1: Use IP Address instead of http://vinodkotiya.blogspot.com

You can get ip address from this site www.ping.eu/ping
type there and get relevent ipaddress like 173.194.32.12


Solution2: 
You can change dns adress provided by ISP manually to google dns like 8.8.8.8 or 8.8.4.4

go to control panel > Network connection > Adapter settings > choose LAN/WIFI > right click to properties > tcp IP 4 > enter manual dns

Solution 3: use proxy site like kproxy

Solution 4 : Use browsers like ultra surf or opera turbo

- Vinod Kotiya

Google+ Followers