package conexionsql;
import java.sql.*;
import java.sql.Connection;
import java.io.*;


public class conexion
{
    
    private java.sql.Connection  con = null;
    private final String url = "jdbc:microsoft:sqlserver://";
    private final String serverName= "localhost";
    private final String portNumber = "1433";
    private final String databaseName= "Mifex";
    private final String userName = "miki";
    private final String password = "123456";
    private final String selectMethod = "cursor";
    
     
    
     
     private String getConnectionUrl(){
         return url+serverName+":"+portNumber+";databaseName="+databaseName+";" + "selectMethod="+selectMethod+";";
     }
     
     private java.sql.Connection getConnection(){
         try
         {
             Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
             con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
             if(con!=null)
                System.out.println("Conexión correcta.");
         }
         catch(Exception e){
             e.printStackTrace();
             System.out.println("Error de seguimiento en getConnection() : " + e.getMessage());
         }
         return con;
     }

    
     public void displayDbProperties(){
         java.sql.DatabaseMetaData dm = null;
         java.sql.ResultSet rs = null;
         try{
             con= this.getConnection();
             if(con!=null){
                 dm = con.getMetaData();
                 System.out.println("Información del controlador");
                 System.out.println(" Nombre del controlador: "+ dm.getDriverName());
                 System.out.println(" Versión del controlador: "+ dm.getDriverVersion ());
                 System.out.println(" Información de la base de datos ");
                 System.out.println(" Nombre de la base de datos: "+ dm.getDatabaseProductName());
                 System.out.println(" Versión de la base de datos: "+ dm.getDatabaseProductVersion());
                 System.out.println("Catálogos disponibles ");
                 rs = dm.getCatalogs();
                 while(rs.next()){
                     System.out.println(" catálogo: "+ rs.getString(1));
                 } 
                 rs.close();
                 rs = null;
                 closeConnection();
             }
             
             else System.out.println("Error: No hay ninguna conexión activa");
         }
         
         catch(Exception e){
             e.printStackTrace();
         }
         dm=null;
     }     
     
     private void closeConnection(){
         try{
             if(con!=null) con.close();
             con=null;
         }
         
         catch(Exception e){
             e.printStackTrace();
         }
     }
     
     public static void main(String[] args) throws Exception {
         conexion myDbTest = new conexion();
         myDbTest.displayDbProperties();
     } 
}

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
Error de seguimiento en getConnection() : com.microsoft.jdbc.sqlserver.SQLServerDriver
Error: No hay ninguna conexión activa
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:164)
        at conexionsql.conexion.getConnection(conexion.java:28)
        at conexionsql.conexion.displayDbProperties(conexion.java:46)
        at conexionsql.conexion.main(conexion.java:87)

using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.Sql;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            
        }

        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\cajero.mdf;Integrated Security=True;Connect Timeout=10;User Instance=True");
            try
            {
                conn.Open();
                MessageBox.Show("se conecto exitosamente");
            }
            
            catch (Exception)
            {
                MessageBox.Show("no se pudo conectar error");
            }
            
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
           
        } 
    }
}

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\cajero.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

SqlConnection conn = new SqlConnection("Data Source=./SQLEXPRESS;AttachDbFilename=cajero.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");

System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at WindowsFormsApplication1.Form1.conexion() in C:\akuma\Proyectos c#\practicas\cajero automatico\cajero automatico\Form1.cs:line 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.Sql;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {            
        }

        private void button2_Click(object sender, EventArgs e)
        {
            conexion();
        }
                
        private void conexion()
        {
            SqlConnection conn = new SqlConnection("Data Source=/.SQLEXPRESS;AttachDbFilename=cajero.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
            try
            {

                conn.Open();
                MessageBox.Show("se conecto exitosamente");

            }
            catch (Exception e)
            {
                MessageBox.Show("no se pudo conectar error");
                txtus.AppendText(Convert.ToString(e));
            }             

        }
    }
}