MS ACCESS
For 2003
"Provider=Microsoft.JET.OLEDB.4.0;Data Source= E:\emp.mdb"
For 2007
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\emp.accdb"
Name Space - OLEDB
ORACLE
"data source=orcl;user id=scott;password=tiger;"
Name Space - OracleClient
To Add OracleClient in project-Project(Menubar)-Add Reference-.Net-System.Data.OracleClient
SQL SERVER
"Server = AUTO_PACKING ; database = CPMS ; uid = sa ; pwd = rswm;";
Name Space - SqlClient
Select Data From Excel
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\durgesh.xls;Extended Properties=Excel 8.0;"
Dim con As New OleDbConnection(strConn)
con.Open()
Dim da As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", con)
da.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
