public partial class frmNuevo : Form
{
private OleDbCommand comando;
private OleDbConnection conexion;
private DataTable datos;
private OleDbDataAdapter DA;
private OleDbConnection conexionId;
private OleDbDataReader dr;
private void frmNuevo_Load(object sender, EventArgs e)
{
cargarId();
}
public void cargarId()
{
conexionId.Open();
comando.CommandType = CommandType.Text;
comando.CommandText = "SELECT MAX(Id) AS Maximo FROM Clientes";
comando.Connection = conexionId;
dr = comando.ExecuteReader();
while (dr.Read())
{
txtId.Text = dr("Maximo");
}
dr.Close();
conexionId.Close();
}
public frmNuevo()
{
conexionId
= new OleDbConnection
(); conexion
= new OleDbConnection
(); comando
= new OleDbCommand
(); DA
= new OleDbDataAdapter
();
conexion.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|\Estados.mdb";
conexionId.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|\LeCombine.mdb";
InitializeComponent();
}