Kid Code Script

' Visual Basic
Public Sub ConnectToOracle()
   Dim conn As New OracleClient.OracleConnection()
   ' TODO: Modify the connection string and include any
   ' additional required properties for your database.
   conn.ConnectionString = & _
   "Data Source=;Integrated Security=yes"
   Try
       conn.Open()
       ' Insert code to process data.
   Catch ex As Exception
       MessageBox.Show("Failed to connect to data source")
   Finally
       conn.Close()
   End Try
End Sub

// C#
public void ConnectToOracle()
{
   OracleClient.OracleConnection conn =
       new OracleClient.OracleConnection ();
   // TODO: Modify the connection string and include any
   // additional required properties for your database.
   conn.ConnectionString = "Data Source=" +
       ";Integrated Security=yes";
   try
   {
       conn.Open();
       // Insert code to process data.
   }
       catch (Exception ex)
   {
       MessageBox.Show("Failed to connect to data source");
   }
   finally
   {
       conn.Close();
   }
}

' Visual Basic
   Public Sub ConnectToOdbc()
       Dim conn As New System.Data.Odbc.OdbcConnection
       ' TODO: Modify the connection string and include any
       ' additional required properties for your database.
       conn.ConnectionString = & _
           "FIL=MS Access;DSN=valid data source name"
       Try
           conn.Open()
           ' Insert code to process data.
       Catch ex As Exception
           MessageBox.Show("Failed to connect to data source")
       Finally
           conn.Close()
       End Try
   End Sub

// C#
public void ConnectToData()
{
   System.Data.Odbc.OdbcConnection conn =
       new System.Data.Odbc.OdbcConnection ();
   // TODO: Modify the connection string and include any
   // additional required properties for your database.
   conn.ConnectionString = "FIL=MS Access;DSN=valid data source name";
   try
   {
       conn.Open();
       // Process data here.
   }
   catch (Exception ex)
   {
       MessageBox.Show("Failed to connect to data source");
   }
   finally
   {
       conn.Close();
   }
}

' Visual Basic
Public Sub ConnectToAccess()
   Dim conn As New System.Data.OleDb.OleDbConnection()
   ' TODO: Modify the connection string and include any
   ' additional required properties for your database.
   conn.ConnectionString = & _
   "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & _
   "C:\Documents and Settings\username\My Documents\dbFile.mdb"
   Try
      conn.Open()
      ' Insert code to process data.
   Catch ex As Exception
      MessageBox.Show("Failed to connect to data source")
   Finally
      conn.Close()
   End Try
End Sub

// C#
public void ConnectToAccess()
{
   System.Data.OleDb.OleDbConnection conn = new
       System.Data.OleDb.OleDbConnection();
   // TODO: Modify the connection string and include any
   // additional required properties for your database.
   conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
       @"Data source= C:\Documents and Settings\username\" +
       @"My Documents\AccessFile.mdb";
   try
   {
       conn.Open();
       // Insert code to process data.
   }
       catch (Exception ex)
   {
       MessageBox.Show("Failed to connect to data source");
   }
   finally
   {
       conn.Close();
   }
}

' Visual Basic
Public Sub ConnectToSql()
   Dim conn As New SqlClient.SqlConnection
   ' TODO: Modify the connection string and include any
   ' additional required properties for your database.
   conn.ConnectionString = & _
   "integrated security=SSPI;data source=SQL Server Name;" & _
   "persist security info=False;initial catalog=northwind"
   Try
       conn.Open()
       ' Insert code to process data.
   Catch ex As Exception
       MessageBox.Show("Failed to connect to data source")
   Finally
       conn.Close()
   End Try
End Sub

// C#
public void ConnectToSql ()
{
   System.Data.SqlClient.SqlConnection conn =
       new System.Data.SqlClient.SqlConnection ();
   // TODO: Modify the connection string and include any
   // additional required properties for your database.
   conn.ConnectionString =
    "integrated security=SSPI;data source=SQL Server Name;" +
    "persist security info=False;initial catalog=northwind";
   try
   {
       conn.Open();
       // Insert code to process data.
   }
       catch (Exception ex)
   {
       MessageBox.Show("Failed to connect to data source");
   }
   finally
   {
       conn.Close();
   }
}